Community Discussion
Use of by_hour_of_day to match UTC revenue do not work
Our revenue data are provided on UTC timezone. To perform our analysis with our Taboola expenses we use the by_hour_of_day dimension to get expenses from day
1/ To get expenses by campaign for day
/reports/campaign-summary/dimensions/by_hour_of_day?campaign=
/reports/campaign-summary/dimensions/by_hour_of_day?campaign=
2/ To get expenses by site for day
2.a/ we get all idsite for day
/reports/campaign-summary/dimensions/site_breakdown?campaign=
/reports/campaign-summary/dimensions/site_breakdown?campaign=
2.b/ for each idsite:
/reports/campaign-summary/dimensions/by_hour_of_day?site=<site_name>&campaign=
/reports/campaign-summary/dimensions/by_hour_of_day?site=<site_name>&campaign=
--
But it doesn't work as expected, the total of expenses for an "UTC day" is far (always less) from our estimations (based on an average for few days).
What is wrong?
Thank you!
