RE: pulling search terms, for clicks and impressions (and pull the other metrics)

2024-05-20 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
Hi,

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

Kindly note that there is no report called 'SEARCH_QUERY_PERFORMANCE_REPORT' in 
the Google Ads API. You can use the below query to retrieve the search terms 
and other metrics (clicks, impressions, etc.) using the search_term_view 
resource:

SELECT search_term_view.search_term, campaign.name, ad_group.name, 
metrics.impressions, metrics.clicks, metrics.cost_micros, 
metrics.all_conversions, metrics.conversions_value, metrics.conversions, 
segments.date FROM search_term_view WHERE metrics.impressions > 0 AND 
segments.date DURING LAST_MONTH

Also, I would suggest you use the Query Builder to build your query and Query 
Validator to validate your query. you can utilize GoogleAdsService.SearchStream 
or GoogleAdsService.Search to retrieve the objects. Hope this helps. Let us 
know if you have any further queries.
This message is in relation to case "ref:!00D1U01174p.!5004Q02tJ28x:ref" 
(ADR-00235755)

Thanks,

Google Ads API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 on the web visit 
https://groups.google.com/d/msgid/adwords-api/sUYwu0SDSOIP00ET6FIUgpRzW476iQRqQnIQ%40sfdc.net.


pulling search terms, for clicks and impressions (and pull the other metrics)

2024-05-20 Thread Larry Kolinek
hello

var query = "SELECT Query, CampaignName, AdGroupName, Impressions, Clicks, 
Cost, AllConversions, ConversionValue, Conversions " +

  "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +

  "WHERE Impressions > 0 " +

  "AND CampaignName = '" + WhichCampaign + "' " +

  "AND AdGroupName = '" + WhichAdGroup + "' " +

  "DURING " + dateRange;


Is that the only way, or just "a" way to get this data?

does anyone else find it hard to figure out WHERE or WHAT table to use?




-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 on the web visit 
https://groups.google.com/d/msgid/adwords-api/189d7640-47bc-422d-aa7b-a81d4113918bn%40googlegroups.com.