Hi,
We are trying to fetch metrics for 'Audio Ads' via the ad_group_ad view, but the api is returning no data. An example query is below:
SELECT segments.date, ad_group_ad.ad.id, ad_group.id, campaign.id, metrics.active_view_cpm, metrics.active_view_ctr, metrics.active_view_impressions, metrics.active_view_measurability, metrics.active_view_measurable_cost_micros, metrics.active_view_measurable_impressions, metrics.active_view_viewability, metrics.all_conversions, metrics.all_conversions_value, metrics.clicks, metrics.conversions, metrics.conversions_value, metrics.cost_micros, metrics.cross_device_conversions, metrics.engagements, metrics.impressions, metrics.interactions, metrics.interaction_event_types, metrics.video_quartile_p100_rate, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, metrics.video_views, metrics.view_through_conversions FROM ad_group_ad WHERE segments.date BETWEEN '2021-03-23' AND '2021-03-24'Is there a different view we should be using to get this data, or is it not yet available in the api. I've tried with both v5 and v6.Thanks,
Thanks,
Don