Hi, Thank you for reaching out to the Google Ads API support team.
Based on the information provided, I understand that you are looking for guidance in retrieving the search term report in the Google Analytics from Google Ads with hourly data. Can you confirm whether you are trying to fetch the search term data from the Google Ads UI or the Google Analytics UI? If you are trying to fetch search terms data which is present in the Google Ads UI, I would recommend using the search_term_view report from the Google Ads API. However, I am providing you a sample GAQL query as per your requirement: SELECT search_term_view.search_term, search_term_view.resource_name, search_term_view.ad_group, search_term_view.status, ad_group.id, campaign.id, metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.average_cpv, metrics.average_cpm, metrics.conversions, metrics.conversions_value, metrics.cost_per_conversion, segments.date FROM search_term_view WHERE segments.date = 'YYYY-MM-DD' You can use the search or searchStream methods in making the API calls while retrieving the data. Additionally, you can utilize the Google Ads Query Builder and Query Validator to build and validate the queries for retrieving the data from the Google Ads API. However, if this is not what you are referring to then, I would request you to provide the uncropped UI screenshot of the Google Ads UI (with visible customer ID) by highlighting the fields and metrics for which you want to retrieve via the Google Ads 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.!5004Q02vH0T2:ref" (ADR-00287325) Thanks, Google Ads API Team Feedback How was our support today? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/aTuV_000000000000000000000000000000000000000000000SR9GWD00wr9l29mkR9-ntsgxnq8BUA%40sfdc.net.