Invalid query when selecting metrics.average_impression_frequency_per_user

[Gal Keren]

I have a query

SELECT metrics.average_cpc, metrics.average_cpm, metrics.average_cpv, metrics.average_impression_frequency_per_user, metrics.ctr, metrics.engagement_rate, metrics.engagements, metrics.interaction_rate, metrics.interactions, metrics.video_quartile_p100_rate, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, metrics.video_view_rate, metrics.video_views, metrics.impressions, metrics.clicks, metrics.cost_micros, ad_group.id, ad_group.name, ad_group.status, ad_group_ad.ad.id, ad_group_ad.ad.type, ad_group_ad.ad_group, segments.date
 FROM ad_group_ad
WHERE segments.date  = '2024-12-29'

Using the query validator I get

• 'metrics.average_impression_frequency_per_user' is not a valid field in the SELECT clause when 'ad_group_ad' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'.

See attached image - the field is Selectable

Taken from 

Documentation
Please advise

Gal

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

From the provided information, I understand that you are not able to retrieve the metrics.average_impression_frequency_per_user from the Google Ads API. Kindly note that metrics.average_impression_frequency_per_user is not compatible with the ad_group_ad resource.

In order to assist further, kindly provide us the uncropped UI screenshot of the Google Ads account and also highlight the metrics  with segmentation that you require to retrieve via the API.

You can send the details via Reply privately to the author option, or direct private reply to this email.

This message is in relation to case "ref:!00D1U01174p.!5004Q02vGqnq:ref" (ADR-00280048)

Thanks,
 

Google Ads API Team

Feedback
How was our support today?