Get total metrics of all shopping campaigns per each day

[lukasz....@gmail.com]

Hello,

I'm involved in developing application which generates monthly reports with AdWords Reporting API. One of primary parts of that report is a chart which presents values of particular metrics for each day over month period.

Here is sample picture below for Search Network:


I'm using Account Performance Report with segmentation set over Date and AdNetworkType fields to obtain accumulated metric values for each day and each network type.

Our goal we'd like to achieve, is to create similar chart which will consider only Shopping Campaigns.
Unfortunately Account Performance Report doesn't contain field which we could use to distinguish Shopping Campaigns from network which they belong to.

In Campaign Performance Report we have AdvertisingChannelType field which can be used to filter out only relevant campaigns, but this report doesn't allow to get accumulated (over all campaigns) metrics per each day.
Of course that report has accumulated values in the last row, but downloading 30-31 Campaign Performance Reports just to extract totals for each day doesn't sounds like reliable solution...

Is there any other way to extract those metrics easily for Shopping Campaigns?

Thanks In Advance,
Lukasz

[Josh Radcliff (AdWords API Team)]

Hi Lukasz,

An AdWords account can have a combination of Shopping and non-Shopping campaigns, so the concept of a "Shopping account" doesn't really exist. In order to only get shopping data you'll have to filter by AdvertisingChannelType in the CAMPAIGN_PERFORMANCE_REPORT, as you mentioned.

Also, since each report request can only be for one account (not an MCC), I don't think you'll wind up with any more reporting requests than if the ACCOUNT_PERFORMANCE_REPORT somehow supported shopping-only requests. Either way, you'll have to issue one request per account, whether that request is for the Campaign or the Account report.

Cheers,

Josh, AdWords API Team

[lukasz....@gmail.com]

Hey Josh,

Thanks for your answer.
All things you mentioned are clear to me.
I'm fully aware of that all requests are done against one account.

But as far as I know CAMPAIGN_PERFORMANCE_REPORT with filter applied: AdvertisingChannelType=SHOPPING will contain one row per each campaign for a requirested period of time which is not exacly what I'm looking for.
My wish is to obtain report, where each row contains accumulated values from one day and all campaigns within AdvertisingChannelType:

Date, AdvertisingChannelType, Clicks, [maybe more metrics]
-
2014-10-01, SHOPPING, 1000
2014-10-01, SEARCH, 1000
2014-10-01, DISPLAY, 1000
2014-10-02, SHOPPING, 950
2014-10-02, SEARCH, 1000
2014-10-02, DISPLAY, 1000
...
and so on.

For very similiar output like above, I'm using ACCOUNT_PERFORMANCE_REPORT as mentioned, but since that report doesn't offers AdvertisingChannelType field,
I can only distinguish rows between AdNetworkType1 (SEARCH, CONTENT).

I hope you get my point and what I'd like to achieve.


BR,
Lukasz

[Josh Radcliff (AdWords API Team)]

Hi Lukasz,

Thanks for clarifying -- unfortunately, you'll have to perform the aggregation yourself on the CAMPAIGN_PERFORMANCE_REPORT output. You can only filter reports by fields that are present on the report, and AdvertisingChannelType is not on the ACCOUNT_PERFORMANCE_REPORT because that's a campaign-level attribute, not an account-level attribute.

The only option I can think of besides that is if you have accounts that you know only have shopping campaigns, you could just grab the totals for those accounts from their respective run of the ACCOUNT_PERFORMANCE_REPORT. This obviously won't work, however, if your accounts have a combination of shopping and non-shopping campaigns.

Cheers,

Josh, AdWords API Team