I am trying to retrieve data from search_term_view

I want to get keywords with more than 2 impressions not added to group  or 
negative keywords

Example of query  (real customer_id was replaced with 0000...):

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
metrics.impressions > 0 AND
customer.id = 0000000000 AND segments.date DURING TODAY 


PROBLEM: it never returns any row, even I see keywords with more than 2 
impressions in the live google ads. Even if I execute query like this, I 
get always all metrics data with 0

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 = 0000000000 AND segments.date DURING TODAY



Does my developer token needs different permissions to access metrics data?

Thank you for your help


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
To view this discussion visit 
https://groups.google.com/d/msgid/adwords-api/0b0f888e-8368-4125-9ecd-1c14c035a226n%40googlegroups.com.
  • me... Viktor Zeman
    • ... 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
      • ... 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
      • ... Alexandre Airvault
        • ... Viktor Zeman

Reply via email to