The same question but can not slove

[chunwei xia]

I have the same question  like this topic ; I can not solve the problem by use that recommend .

From the apis we need realtime get metics cost_micros、impressions、clicks by dimension country_criterion_id、campaign、date、hour  ；but from below query  I can not fetch the data.

My query like this :

SELECT campaign.id,

campaign.name,

segments.date,

segments.hour, -- Tip:from the recommend way ,this query error info is segments.hour could not support requested resources:geographic_view

geographic_view.country_criterion_id,

metrics.impressions,

metrics.clicks,

metrics.ctr,

metrics.cost_micros,

metrics.average_cpc,

metrics.average_cpm,

metrics.conversions

FROM geographic_view

WHERE segments.date BETWEEN '2020-08-13' AND '2020-08-13'

[Google Ads API Forum Advisor Prod]

Hi Chunwei,

Thank you for reaching out. The segments.hour is not provided by the geographic_view resource so it could not be segmented by hour.

Thanks and regards,
Xiaoming, Google Ads API Team

ref:_00D1U1174p._5004Q23Jsud:ref

[chunwei xia]

can has any other way to get this data?

在 2020年8月14日星期五 UTC+8上午2:59:19，adsapiforumadvisor写道：

[Google Ads API Forum Advisor Prod]

Hi Chunwei,

Thank you for reaching out. There is no other workaround to get this data. There is already a feature request to support the segments.hour for the geographic_view resource. Please keep an eye on our blog for the announcements and updates on new releases.

Thanks and regards,
Xiaoming, Google Ads API Team

ref:_00D1U1174p._5004Q23Jsud:ref