Getting daily metrics in Campaign Performance Report - how?

[Sune Christiansen]

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?

[Bharani Cherukuri (AdWords API Team)]

Hello Sune, 

That's right. Since Date is a segment field, the values returned and number of segmented rows reflect the performance over the timespan of the report. I was able to get the results similarly while testing with my test account. However, from the results shared, it is possible that the results are displayed based on the WHERE clause in the query. Could you share us the client customer Id against which you're running this report so I can take a look? You can reply back via Reply privately to author option. 

Thanks,

Bharani, AdWords API Team