Can someone help with a request I'm trying to make? I'm trying to get historical metric data for ads. Each request I make is coming in over 1 Gb.
I think I need to query a different resource but I'm not sure. At the end of the day I need the following allConversions, averageCpm, clicks, conversions, costMicros, impressions, averageCost, averageCpc, costPerConversion Here is my query SELECT segments.date, metrics.clicks, metrics.conversions, metrics.impressions, metrics.cost_micros, metrics.all_conversions, metrics.average_cpc, metrics.average_cpe, metrics.average_cpm, metrics.average_cpv, metrics.average_cost, metrics.cost_per_conversion FROM ad_group_ad WHERE segments.date >= 'start_date' AND segments.date <= 'end_date' ORDER BY segments.date ASC Ideally I could add a GROUP BY segments.date and the request would come back grouped already. Right now I loop through all the results and add to a huge array until everything is aggregated. I just need the results in a by day format for charting purposes. Can someone please help? Thanks, Ben Using: Google Ads API v6 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/df684a3b-1769-4974-a174-10a1c7b9ec71n%40googlegroups.com.
