I am querying campaigns by hour, but the report stops when the moment there is no data.
Take this query: SELECT customer.currency_code, campaign.id, campaign.name, segments.date, segments.hour, metrics.average_cpc, metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.search_absolute_top_impression_share, metrics.search_top_impression_share, metrics.search_impression_share FROM campaign WHERE segments.date DURING YESTERDAY AND campaign.id = 123 It will produce data similar to this: Date HourOfDay Impressions Clicks Cost 2021-05-01 0 0 0 £0.00 2021-05-01 1 0 0 £0.00 2021-05-01 2 0 0 £0.00 2021-05-01 3 0 0 £0.00 2021-05-01 4 0 0 £0.00 2021-05-01 5 0 0 £0.00 2021-05-01 6 0 0 £0.00 2021-05-01 7 0 0 £0.00 2021-05-01 8 124 27 £33.68 2021-05-01 9 158 19 £25.51 2021-05-01 10 229 38 £50.97 2021-05-01 11 232 34 £50.62 2021-05-01 12 225 47 £58.16 2021-05-01 13 208 37 £44.62 2021-05-01 14 226 36 £50.79 2021-05-01 15 187 34 £45.05 2021-05-01 16 150 31 £43.15 2021-05-01 17 147 22 £30.53 2021-05-01 18 124 23 £29.30 2021-05-01 19 102 16 £25.25 2021-05-01 20 75 11 £17.86 2021-05-01 21 34 4 £7.27 There is no data after hour 21, even though hours 0 - 7 are also empty. My expectation is that hours 22 and 23 should be included even though they are zeros. I have used 2 different client libraries and they both produce the same results. Therefore, I think this is happening at the API level. Daniel -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/7d8a128b-b702-415b-a835-57f32c9b85ban%40googlegroups.com.
