Reporting by hour

[Daniel Platt]

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

[Google Ads API Forum Advisor]

Hi Daniel,

Thanks for reaching out. Can you please provide us with the complete request and response logs, including the request ID, so that we can have a closer look?

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2IvGKh:ref

[Google Ads API Forum Advisor]

Hi Daniel,

Thank you for sharing additional information regarding your concern.

Upon checking your 3266544319 account and the 12642662800 campaign in the Google Ads UI 's Ad schedule > Hour view and applying the June 13, 2021 date filter, I can see that not all hours are currently being used :

The 12 am to 1 am (0), 6 am to 7 am (6),  2 pm to 3 pm (14), and the 9 pm to 10 pm (21) schedules does not appear to be currently targeted by the said campaign. That said, the API's results should be consistent on what is currently seen via the Google Ads UI.

In addition, could you confirm if the API's responses did not include information that can be viewed via the UI? If yes, could you share any more examples in the form of the request and response logs (with the request-id), so our team can take a closer look?

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2IvGKh:ref

[Google Ads API Forum Advisor]

Hi Daniel,

I also had to delete your recent posts as it contained information from your logs such as the request-id. For sharing your logs information, you may send it to our team using the Reply privately to author option.

If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.