SELECT campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros, campaign.final_url_suffix, location_view.resource_name FROM location_view I have tried this query, but its not giving any values in campaign.final_url_suffix column, all other columns are okey, why this happened?
On Friday, September 6, 2024 at 2:51:17 PM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > > I suggest you to use the below sample query. > > > SELECT campaign.name, metrics.clicks, metrics.impressions, > metrics.cost_micros, campaign.final_url_suffix, location_view.resource_name > FROM location_view > > As informed earlier, you can construct your own customized query using the > location_view > query builder > <https://developers.google.com/google-ads/api/fields/v17/location_view_query_builder>. > Before > that, take a look at the Fields/Segments/Metrics > <https://developers.google.com/google-ads/api/fields/v17/location_view#fieldssegmentsmetrics> > that > can be used with the location_view resource. > > The provided screenshots are the cropped one, So highly recommend you to > check this Query Cookbook > <https://developers.google.com/google-ads/api/docs/query/cookbook?hl=en> > documentation, > to know how the UI reports look like and how to retrieve that data via the > API. > > > > This message is in relation to case > "ref:!00D1U01174p.!5004Q02vFYNO:ref" (ADR-00265708) > > 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/9b512293-9a5d-4a45-9b6d-0616c7502286n%40googlegroups.com.
