I found the problem: if in WHERE string is customer.id = 000000 ..... it will return always 0 in metrics .... when I removed this condition, it is working fine
On Monday, February 17, 2025 at 9:13:43 AM UTC+1 Alexandre Airvault wrote: > Have you tried with the following trying to get data on last 7 days and > remove search_term_view.status='NONE. This filter was likely the main > reason you weren't getting results. Search terms with impressions are > rarely going to have a status other than NONE. > > SELECT search_term_view.search_term, campaign.id, campaign.name, > ad_group.id, ad_group.name, metrics.clicks, metrics.impressions FROM > search_term_view WHERE campaign.status = 'ENABLED' AND ad_group.status = > 'ENABLED' AND ad_group.type = 'SEARCH_STANDARD' -- Or consider removing if > you have Performance Max and want to include its search terms. AND > metrics.impressions > 2 -- Your original condition AND segments.date DURING > LAST_7_DAYS -- Try a broader date range for testing AND customer.id = > 0000000000 > > Blobr - AI agents to optimise Google Ads spending > https://www.blobr.io/ > On Friday, 14 February 2025 at 00:29:17 UTC+1 Viktor Zeman wrote: > >> Here is the Query: >> >> SELECT >> search_term_view.search_term, >> campaign.id, >> campaign.name, >> ad_group.id, >> ad_group.name, >> metrics.clicks, >> metrics.impressions >> FROM search_term_view >> WHERE >> search_term_view.status='NONE' AND >> campaign.status='ENABLED' AND >> ad_group.status='ENABLED' AND >> ad_group.type='SEARCH_STANDARD' AND >> >> customer.id = 1795092665 AND metrics.impressions > 1 AND >> segments.date DURING TODAY >> >> >> This is the screen from Google Ads for today, there are 3 rows with more >> than one impression: >> [image: Screenshot 2025-02-13 at 16.30.21.jpg] >> This is link to the report: >> https://ads.google.com/aw/keywords/searchterms?ocid=132289452&workspaceId=0&euid=409863730&__u=6671956770&uscid=132289452&__c=9620604748&authuser=2&subid=sk-sk-awhp-g-aw-c-home-sso%21o2 >> If I remove AND metrics.impressions > 1 >> from the query, it returns rows, but metrics columns are zero (always and >> all metrics) >> >> Thank you >> >> Regards, >> >> Viktor Zeman >> >> >> On Thu, Feb 13, 2025 at 11:55 AM Google Ads API Forum Advisor < >> ads...@forumsupport.google> wrote: >> >>> Hi, >>> >>> Thank you for reaching out to the Google Ads API support team. >>> >>> In order to assist you further, please provide us with the uncropped UI >>> screenshot of the report by highlighting the data that you're trying 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.!5004Q02vH1ho:ref" (ADR-00288205) >>> >>> Thanks, >>> >>> [image: Google Logo] Google Ads API Team >>> Feedback >>> How was our support today? >>> >>> [image: rating1] >>> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=5004Q00002vH1hoQAC> >>> >>> [image: rating2] >>> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=5004Q00002vH1hoQAC> >>> >>> [image: rating3] >>> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=5004Q00002vH1hoQAC> >>> >>> [image: rating4] >>> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=4&entry.295079254=5004Q00002vH1hoQAC> >>> >>> [image: rating5] >>> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=5&entry.295079254=5004Q00002vH1hoQAC> >>> >>> >>> >>> >>> >>> >>> >>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/aaf9d54e-c43f-48ee-8db9-e8f4026cab3cn%40googlegroups.com.
