Community Discussion

Ask a Question
Back to All

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.