Hi,
We are currently trying to integrate a Piwik Pro into our system and had a question regarding why we’re seeing different total revenue values between 2 api calls. The first call includes pulling revenue (sum) and sessions. The second call includes pulling the same columns + source and medium. My assumption would be that the total accumulated revenue for both calls would be the same, the only difference being that the 2nd is grouped by source/medium, but we are seeing that the total revenue for the second call is slightly lesser than that of the first. Is there some data that’s being left out due to it not being able to attribute revenue to source/medium?
We were also wondering if we could get more clarification on the difference between revenue and revenue__sum.
For context, these are the relevant columns (dimensions/metrics) we are pulling
- revenue, source, medium, campaign id, campaign name, campaign content, sessions, timestamp, keyword
Thank you!
