Audience Performance Report Duplicate results

103 views
Skip to first unread message

adwor...@mercent.com

unread,
Dec 21, 2016, 7:48:16 PM12/21/16
to AdWords API Forum
We are seeing duplicate items in the audience performance report for one of our clients. Specifically, the two rows below. You can see that they differ only in the number of impressions. Note that we detect duplicates using a compound key of CampaignId, AdGroupId, CriterionId, Day, Network, ClickType, and Device.

<row adGroupID='23852541980' criterionID='131571919940' campaignID='356958260' avgPosition='0.0' impressions='3' clicks='0' cost='0' day='2016-12-19' network='Search Network' clickType='Headline' device='Mobile devices with full browsers' audience='boomuserlist::4386441'/>
<row adGroupID='23852541980' criterionID='131571919940' campaignID='356958260' avgPosition='0.0' impressions='15' clicks='0' cost='0' day='2016-12-19' network='Search Network' clickType='Headline' device='Mobile devices with full browsers' audience='boomuserlist::4386441'/>

The full list of fields that we request from the endpoint is as follows:

"AdGroupId",
"Id",
"CampaignId",
"AveragePosition",
"Impressions",
"Clicks",
"Cost",
"Date",
"AdNetworkType1",
"ClickType",
"Device",
"Criteria"


We theorize that this is because an audience was moved from the ad group level to the campaign level during the reporting period of 2016-12-19 and that one row corresponds to the tracks at the ad group level and another to the campaign level.

We would greatly appreciate any help you could provide as this is impacting ad tracking for one of our largest clients.

Regards,

Kyland Holmes
Software Engineer, CommerceHub

Peter Oliquino

unread,
Dec 22, 2016, 12:12:20 AM12/22/16
to AdWords API Forum
Hi Kyland,

The Audience Performance Report is a multiple attritbution type of report and could be the possible cause of the duplicate rows you encountered. Could you try and add the AdNetworkType2 field in the selected fields to check if the impression might have been triggered on a second level network type? If the issue persists, could you provide your customer ID and the complete report definiton so I could have a better look at the issue? Please reply using Reply privately to author for the requested information.

Thanks and regards,
Peter
AdWords API Team

Thanet Knack Praneenararat (AdWords API Team)

unread,
Dec 27, 2016, 1:43:57 AM12/27/16
to AdWords API Forum
Hello Kyland,

I've looked into your ad group and the audience ID 4386441.
What I've found is that you get two rows for this particular criterion because:
  • You've removed this criterion as an ad group-level criterion once on 19 Dec.
  • Then, you added this criterion back as a campaign-level criterion (which is recently a new feature of AdWords)
To confirm this, you can open the AdWords UI and select All remarketing lists in the Audiences tab.
You will see two rows there: one with removed status with 3 impressions and another one with enabled status (current one) with 15 impressions.
This is aligned with what you've posted here as a result from the API. It looks like the duplicate rows but if you request Status in the report definition, you will see the difference.

Hope this help.

Best,
Thanet, AdWords API Team

adwor...@mercent.com

unread,
Jan 9, 2017, 7:56:23 PM1/9/17
to AdWords API Forum
Hi Thanet,

Shouldn't those two rows still be aggregated though? Since we don't request the data to be broken out by status, I would just expect that these two items roll into one for the time period requested.

-Kyland

Thanet Knack Praneenararat (AdWords API Team)

unread,
Jan 10, 2017, 12:34:37 AM1/10/17
to AdWords API Forum
Hello Kyland,

In fact, they're not broken down by status, but rather by the level of criteria, so this works as intended.
It's a bit confusing for you because we don't have a report field in API to show which level the criteria belong to yet.
I've already given feedback to the engineering and hope to see such a field in the API in the future (no ETA yet though).

Hope this help.

Best,
Thanet, AdWords API Team
Reply all
Reply to author
Forward
0 new messages