search term query is also unproductive. SELECT search_term_view.search_term, segments.keyword.info.match_type, search_term_view.status, campaign.name, ad_group.name, metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros, campaign.advertising_channel_type FROM search_term_view WHERE segments.date DURING LAST_7_DAYS
On Thursday, June 22, 2023 at 1:09:36 PM UTC-7 Jim wrote: > additional information sent. my UI was incorrect. Keyword UI supplied > > On Thursday, June 22, 2023 at 7:19:31 AM UTC-7 Google Ads API Forum > Advisor wrote: > >> Hi, >> >> Thanks for getting back to us. >> >> Upon checking your UI screenshot, I can see that you are in the >> *Campaigns* UI screen. You may refer to the *Query Cookbook *guide in >> replicating Google Ads UI screens. For the *Campaigns* screen in your >> screenshot, you may refer to the *Campaigns screen query cookbook*. You >> can use these queries as is or as starting points for constructing your own >> customized queries. >> >> I tried to query the same data via API using the *Campaign report* and I >> was able to pull the same data and metrics with that of the UI. >> >> *Sample query.* >> >> >> SELECT >> campaign.name, >> campaign_budget.amount_micros, >> campaign.status, >> campaign.optimization_score, >> campaign.advertising_channel_type, >> metrics.clicks, >> metrics.impressions, >> metrics.ctr, >> metrics.average_cpc, >> metrics.cost_micros, >> campaign.bidding_strategy_type >> FROM campaign >> WHERE >> campaign.status != 'REMOVED' >> AND campaign.id = {ID of the Campaign} >> AND segments.date BETWEEN '2023-06-01' AND '2023-06-20' >> >> >> Let us know how it goes on your end. >> >> Reference links included in this email: >> >> - Query Cookbook: >> *https://developers.google.com/google-ads/api/docs/query/cookbook* >> <https://developers.google.com/google-ads/api/docs/query/cookbook> >> - Campaigns screen query cookbook: >> >> *https://developers.google.com/google-ads/api/docs/query/cookbook#campaigns* >> >> <https://developers.google.com/google-ads/api/docs/query/cookbook#campaigns> >> - Campaign report: >> *https://developers.google.com/google-ads/api/fields/v13/campaign* >> <https://developers.google.com/google-ads/api/fields/v13/campaign> >> - Campaign report query builder - >> >> *https://developers.google.com/google-ads/api/fields/v13/campaign_query_builder* >> >> >> <https://developers.google.com/google-ads/api/fields/v13/campaign_query_builder> >> >> >> >> This message is in relation to case "ref:_00D1U1174p._5004Q2mUlYT:ref" >> >> Thanks, >> >> [image: Google Logo] 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/65621f0d-bfec-42a8-999c-9a9f58a92b87n%40googlegroups.com.