Hi All, I'm attempting to migrate our Geo Performance report from AdWords -> Ads. I end up with this query:
query: "select customer.id, geographic_view.country_criterion_id, segments.geo_target_most_specific_location, metrics.cost_micros, metrics.impressions, metrics.clicks, segments.ad_network_type, segments.geo_target_city, metrics.conversions from geographic_view where segments.date DURING LAST_30_DAYS " I get lots of unique rows back, but I also get some rows back that contain the same segmentation data with different metrics. For example, for the query above I will get back some rows that contain identical: customer.id geographic_view.country_criterion_id segments.ad_network_type segments.geo_target_city I would expect the query to result in one row per unique grouping of the above. Here's an example result from the above query where I've already done an internal conversion to CSV, but the conversion was done per google_ads_row so each single line still corresponds to a single google_ads_row Customer ID,Country/Territory,Most specific location,Cost,Impressions,Clicks,Network,City,Conversions 961,2124,9000783,0,519,0,Search Network,1002334,0 961,2124,9000783,6430000,69,6,Search Network,1002334,0 I'd expect the 961, 2124, 9000783, Search Network and 1002334 to be grouped together in one row. Is there additional segmenting being done on segments.date even tho it's not a select field? If so, I would've expected more than 2 rows if segmenting by date since I'm asking for last 30 days of data. Thanks Pete -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ab14706b-9d26-4d9b-a70c-95fe55121225%40googlegroups.com.
