Hi everybody. I have been studying the new Ads API to extract campaign and clicks related data which i will use to create internal reports.
My main interest is to segment my query by a date range and retrieve information such as campaign, location of presence (user) and cost. Something similar to a User locations report that can be generated on the interface. At first I had created the following query: SELECT customer.descriptive_name, campaign.id, campaign.name, segments.geo_target_county, segments.geo_target_city, segments.date, segments.device, customer.currency_code, metrics.clicks, metrics.cost_micros, metrics.impressions FROM geographic_view WHERE segments.date >= '2019-02-01' AND segments.date < '2019-03-01' ORDER BY metrics.clicks DESC I realized segments.geo_target_county does not represent user location. So, looking into the documentation I think i should use click_view.location_of_presence.country instead and for this I created the new query. SELECT customer.descriptive_name, campaign.id, campaign.name, click_view.location_of_presence.country, click_view.location_of_presence.city, segments.date, segments.device, customer.currency_code, metrics.clicks, * metrics.cost_micros, metrics.impressions* FROM click_view WHERE *segments.date >= '2019-02-01'* * AND segments.date < '2019-03-01'* ORDER BY metrics.clicks DESC Here I found 2 problems: 1. I cannot retrieve *metrics.cost_micros *and metrics.impressions from *click_view. (most important one)* 2. The date range should not be older than 90 days and should be segmented by day. Any ideas on how to solve or work around this? A query for the ads API capable to retrieve the data from a User locations report also would be very helpful. Thanks for the 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 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 "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ee9f4625-5a52-4a80-bb43-50b706fa3810%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.