Hi. I'm currently working on a clientcenter for some customers linked to our MCC account. For each of these accounts I want to access data *per day* which I only can manage in the Account Performance Report:
SELECT Impressions, Clicks, Cost, CostPerAllConversion, AllConversionValue, > AllConversions, AllConversionRate, ConversionValue, AverageCpc, > CostPerConversion, Date > FROM ACCOUNT_PERFORMANCE_REPORT > DURING 20181112,20181115 > Which is giving me the following output (seperated by date/day and then a total aggregation of each): Array > ( > [0] => Array > ( > [Impressions] => 27183 > [Clicks] => 230 > [Cost] => 633390000 > [Cost / all conv.] => 0 > [All conv. value] => 0.00 > [All conv.] => 0.00 > [All conv. rate] => 0.00% > [Total conv. value] => 0.00 > [Avg. CPC] => 2753870 > [Cost / conv.] => 0 > [Day] => 2018-11-15 > ) > > [1] => Array > ( > [Impressions] => 96662 > [Clicks] => 716 > [Cost] => 1823060000 > [Cost / all conv.] => 397758314 > [All conv. value] => 9009.59 > [All conv.] => 4.58 > [All conv. rate] => 0.64% > [Total conv. value] => 9009.59 > [Avg. CPC] => 2546173 > [Cost / conv.] => 397758314 > [Day] => 2018-11-12 > ) > > [2] => Array > ( > [Impressions] => 71042 > [Clicks] => 576 > [Cost] => 1491020000 > [Cost / all conv.] => 382312821 > [All conv. value] => 4733.10 > [All conv.] => 3.90 > [All conv. rate] => 0.68% > [Total conv. value] => 4733.10 > [Avg. CPC] => 2588576 > [Cost / conv.] => 382312821 > [Day] => 2018-11-14 > ) > > [3] => Array > ( > [Impressions] => 77233 > [Clicks] => 633 > [Cost] => 1640190000 > [Cost / all conv.] => 529093548 > [All conv. value] => 3664.90 > [All conv.] => 3.10 > [All conv. rate] => 0.49% > [Total conv. value] => 3664.90 > [Avg. CPC] => 2591137 > [Cost / conv.] => 529093548 > [Day] => 2018-11-13 > ) > > [4] => Array > ( > [Impressions] => Total > [Clicks] => 2155 > [Cost] => 5587660000 > [Cost / all conv.] => 482387803 > [All conv. value] => 17407.59 > [All conv.] => 11.58 > [All conv. rate] => 0.54% > [Total conv. value] => 17407.59 > [Avg. CPC] => 2592882 > [Cost / conv.] => 482387803 > [Day] => -- > ) > ) > However if I run a: SELECT CampaignId, CampaignName, Impressions, Clicks, Cost, > CostPerAllConversion, AllConversionValue, AllConversions, > AllConversionRate, ConversionValue, AverageCpc, CostPerConversion, Date > FROM CAMPAIGN_PERFORMANCE_REPORT > WHERE AdvertisingChannelType = SHOPPING > DURING 20181112,20181115 It only gives me an aggregation of the metrics: Array > ( > [0] => Array > ( > [Campaign ID] => Total > [Campaign] => -- > [Impressions] => 11635906 > [Clicks] => 147026 > [Cost] => 465459960000 > [Cost / all conv.] => 407940368 > [All conv. value] => 2370922.18 > [All conv.] => 1141.00 > [All conv. rate] => 0.78% > [Total conv. value] => 2370922.18 > [Avg. CPC] => 3165834 > [Cost / conv.] => 407940368 > [Day] => -- > ) > ) > But I actually want the metrics sorted out per day. Is this possible? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/18b68c02-2510-4ee0-93f9-d94e4ee49254%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
