How to receive metrics of ad_group_ad from googleads API

[carela...@gmail.com]

When receiving metrics from ad_group_ad , I would like to receive an hourly report. I checked the document and it says that segments.hour cannot be used in ad_group_ad. How can I receive a report by hour?

The query below is the query being used to receive daily reports from ad_group_ad.

SELECT 

ad_group_ad.ad.responsive_display_ad.business_name, ad_group.id, ad_group_ad.ad.id, ad_group_ad.ad.name, ad_group_ad.status, ad_group_ad.policy_summary.policy_topic_entries, ad_group_ad.policy_summary.review_status, ad_group_ad.policy_summary.approval_status, ad_group_ad.ad.type, ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.final_urls, ad_group_ad.ad.url_collections, ad_group_ad.ad.video_responsive_ad.call_to_actions, ad_group_ad.ad.image_ad.mime_type, ad_group_ad.ad.responsive_display_ad.marketing_images, ad_group_ad.ad.video_responsive_ad.videos, metrics.clicks, metrics.impressions, metrics.cost_micros, segments.date 

FROM ad_group_ad 

WHERE ad_group_ad.status IN ("ENABLED","PAUSED","REMOVED") AND segments.date = "{$date}" 

[Google Ads API Forum Advisor]

Hi,

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

By reviewing your concern, I understand that you want to retrieve an hourly report from the “ad_group_ad” resource in the Google Ads API. Could you please confirm if you are able to retrieve this information on an hourly basis from the Google Ads UI? If yes, I would request you to kindly provide an uncropped UI screenshot of the Google Ads account and highlight the fields and metrics that you want 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.!5004Q02rVC7u:ref"

Thanks,
 

Google Ads API Team