Community Discussion
The spent column discrepancies for different dimensions (API reports)
We build a campaign reporting tool, using the Taboola API (among others).
What we are trying to do is to see daily/hourly reports that show campaign/hour breakdown for money spent on Taboola per campaign.
What is important for us for the hourly report is the ability to see campaign results in nearly real-time (let's say with a 1-hour delay - hence we would like to use the campaign_hour_breakdown dimension).
It seems to be working almost fine. However, there are some discrepancies I don't understand. Has anyone experienced such weird behavior?
We use the "Campaign Summary Report" with 3 different dimensions - day, campaign_hour_breakdown, and campaign_breakdown.
I would expect that the sum of the spent column will always be the same regardless of the dimension we use. However, the numbers are slightly different, e.g. I ran three different reports/breakdowns for the same day. Here are the spent sums per each dimension:
- campaign_hour_breakdown: $3,266.07
- day: $3,395.99
- campaign_breakdown: $3,400.41
Can you explain the discrepancy, please?
Also, I have noticed the "last-used-rawdata-update-time" attribute. What is its meaning? To me, it looks like all reports are generated with a certain delay. Does that mean we cannot rely on them for our hourly breakdowns?
Please advise. Thank you.