We have a problem when we query for some of our customers (not all of them) a specific endpoint in the Google Ads API.
Endpoint: ad_group_ad_asset_view
Query: “SELECT segments.date,
campaign.id,
campaign.name, customer.currency_code, campaign.app_campaign_setting.app_id, campaign.app_campaign_setting.app_store, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, metrics.impressions, metrics.clicks, metrics.cost_micros, campaign.final_url_suffix, campaign.tracking_url_template,
ad_group.name,
ad_group.id,
segments.ad_network_type,
ad_group_ad.ad.id,
ad_group_ad.ad.name,
ad_group_ad.ad.type,
asset.id,
asset.name, asset.type, ad_group_ad.ad.final_urls, ad_group_ad.ad.final_url_suffix, ad_group_ad.ad.tracking_url_template, asset.youtube_video_asset.youtube_video_title FROM ad_group_ad_asset_view WHERE segments.date >= ‘2022-02-07’ AND segments.date <= ‘2022-02-07’ AND
campaign.name IS NOT NULL ORDER BY segments.date”
We don’t get any data for ‘metrics.clicks’ and ‘metrics.cost_micros’ (not even empty data).
Although we expect to get some data (even empty data) as seen in other endpoints (like - ad_group_ad).
We would appreciate your help.