Google Ads API does not support ATOP/TOPR insights at the hourly-adgroup level

[Dmitry Rassakhatsky]

Hi Team,

I'm working on a migration from AdWords API to Google Ads API and I found an issue while trying to pull AdGroup level performance data (absolute_top_impression_percentage and top_impression_percentage) on an hourly level. AdWords API allows to pull AdGroup Performance data at an hourly level, it is also available in the Google Ads UI.

What is the proper way to pull this data (AdGroup Performance Hourly) programmatically using Google Ads API?

GAQL query:

```

SELECT ad_group.id
, metrics.clicks
, metrics.cost_micros
, ad_group.cpc_bid_micros
, metrics.impressions
, metrics.top_impression_percentage
, metrics.absolute_top_impression_percentage
, segments.hour
FROM ad_group
WHERE segments.date = '2021-09-06'

```

Error:

```

Cannot select the following segments because at least one unsupported metric is found in SELECT or WHERE clause: 'segments.hour'(unsupported metrics: 'absolute_top_impression_percentage', 'top_impression_percentage').

```

[Google Ads API Forum Advisor]

Hi Dmitry,

You should still be able to generate a report at an hourly basis using the Google Ads API (while also taking into consideration the limits involved). Generally, however, metrics and statistics availability can take longer to update. You can check out our data freshness guide for more information on availability.

Regarding your reporting issue, the segments.hour is not compatible with the below metrics :

• absolute_top_impression_percentage
• top_impression_percentage

You may see the Selectable with section of the hour segment documentation for the list of supported fields and metrics.

That said, could you confirm whether this is supported in the UI, to have both the hour segment and the mentioned fields in the same view? If yes, could you share the complete Google Ads UI screenshot so that I may raise a feature request?

If the screenshot would contain user / account information, you may then send the requested information via 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.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2NSNsP:ref

[Dmitry Rassakhatsky]

Hi Peter,

I can confirm that this data is available at the AdGroup-Hour level in the Google Ads UI. It is also available via AdWords API.

Best,

Dmitry

[Google Ads API Forum Advisor]

Hi Dmitry,

Thank you for providing the requested details to my team. I work with Peter and let me continue the discussion for this concern.

Since you confirmed that segmenting the absolute_top_impression_percentage and top_impression_percentage is possible in the UI, then allow me to raise a feature request to my team about this, subject for review.

For now, please follow our blog as we will post there relevant updates when become supported. 

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2NSNsP:ref