Report service returning duplicate performance data for creative?

[partnerekos5]

Hello, I am having an issue with the creative performance report. We
are expecting 2 rows per creative (Content, Search), but many times we
are getting two Search rows, and sometimes 1 Content row, and 2 Search
rows - all for the same date. Here is our XML request (I have erased
the user/pass/tokens):

<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Header>
<userAgent env:mustUnderstand="0">adwords4r: </userAgent>
<useragent env:mustUnderstand="0">adwords4r: </useragent>
<developerToken env:mustUnderstand="0">--------------</
developerToken>
<applicationToken env:mustUnderstand="0">--------------</
applicationToken>
<password env:mustUnderstand="0">--------------</password>
<clientEmail env:mustUnderstand="0"></clientEmail>
<email env:mustUnderstand="0">--------------</email>
</env:Header>
<env:Body>
<n1:scheduleReportJob xmlns:n1="https://adwords.google.com/api/
adwords/v13">
<n1:job xsi:type="n1:DefinedReportJob">
<n1:endDay>2009-08-30</n1:endDay>
<n1:name>adword08312009010036_119</n1:name>
<n1:startDay>2009-08-27</n1:startDay>
<n1:aggregationTypes>Daily</n1:aggregationTypes>
<n1:campaigns>22828357</n1:campaigns>
<n1:campaigns>24806467</n1:campaigns>
<n1:campaigns>24807007</n1:campaigns>
<n1:campaigns>24904297</n1:campaigns>
<n1:campaigns>24904927</n1:campaigns>
<n1:campaigns>24905107</n1:campaigns>
<n1:campaigns>24905197</n1:campaigns>
<n1:campaigns>25617907</n1:campaigns>
<n1:campaigns>30252367</n1:campaigns>
<n1:campaigns>30252457</n1:campaigns>
<n1:campaigns>30252547</n1:campaigns>
<n1:campaigns>30285487</n1:campaigns>
<n1:campaigns>30285577</n1:campaigns>
<n1:campaigns>30285757</n1:campaigns>
<n1:campaigns>30285847</n1:campaigns>
<n1:campaigns>30285937</n1:campaigns>
<n1:campaigns>30286027</n1:campaigns>
<n1:campaigns>30415177</n1:campaigns>
<n1:campaigns>30415357</n1:campaigns>
<n1:campaigns>30415537</n1:campaigns>
<n1:campaigns>30415627</n1:campaigns>
<n1:selectedColumns>Impressions</n1:selectedColumns>
<n1:selectedColumns>Clicks</n1:selectedColumns>
<n1:selectedColumns>CPC</n1:selectedColumns>
<n1:selectedColumns>Cost</n1:selectedColumns>
<n1:selectedColumns>Conversions</n1:selectedColumns>
<n1:selectedColumns>LeadCount</n1:selectedColumns>
<n1:selectedColumns>LeadValue</n1:selectedColumns>
<n1:selectedColumns>AdWordsType</n1:selectedColumns>
<n1:selectedColumns>AveragePosition</n1:selectedColumns>
<n1:selectedColumns>DailyBudget</n1:selectedColumns>
<n1:selectedColumns>CampaignId</n1:selectedColumns>
<n1:selectedColumns>AdGroupId</n1:selectedColumns>
<n1:selectedColumns>MaxContentCPC</n1:selectedColumns>
<n1:selectedColumns>MaximumCPC</n1:selectedColumns>
<n1:selectedColumns>Campaign</n1:selectedColumns>
<n1:selectedColumns>CampaignId</n1:selectedColumns>
<n1:selectedColumns>CampaignStatus</n1:selectedColumns>
<n1:selectedColumns>AdGroup</n1:selectedColumns>
<n1:selectedColumns>AdGroupId</n1:selectedColumns>
<n1:selectedColumns>AdGroupStatus</n1:selectedColumns>
<n1:selectedColumns>CreativeId</n1:selectedColumns>
<n1:selectedColumns>AdStatus</n1:selectedColumns>
<n1:selectedColumns>DescriptionLine1</n1:selectedColumns>
<n1:selectedColumns>DescriptionLine2</n1:selectedColumns>
<n1:selectedColumns>DescriptionLine3</n1:selectedColumns>
<n1:selectedColumns>DestinationURL</n1:selectedColumns>
<n1:selectedColumns>VisibleUrl</n1:selectedColumns>
<n1:selectedReportType>Creative</n1:selectedReportType>
</n1:job>
</n1:scheduleReportJob>
</env:Body>
</env:Envelope>


***Here is an excerpt from the XML response. Any ideas anyone??:


<row date="2009-08-27" campaignid="24806467" campaign="CA: SAP Generic
in hours" adgroupid="640440307" adgroup="Generic SAP Test"
headline="SAP Software Solutions" desc1="Discover how Sapphire can
help you" desc2="increase business productivity"
creativeVisUrl="www.sapphiresystems.us.com/SAP" destUrl="http://
www.sapphiresystems.us.com/solutions/SAP.htm" creativeid="2720287207"
creativeStatus="Enabled" adwordsType="Content Only" budget="50000000"
maxCpc="" maxContentCpc="4000000" agStatus="Enabled"
campStatus="Active" imps="489" clicks="0" cpc="0" cost="0"
pos="3.0102249489" conv="0" leads="0" leadValue="0.0" />

<row date="2009-08-27" campaignid="24806467" campaign="CA: SAP Generic
in hours" adgroupid="640440307" adgroup="Generic SAP Test"
headline="SAP Software Solutions" desc1="Discover how Sapphire can
help you" desc2="increase business productivity"
creativeVisUrl="www.sapphiresystems.us.com/SAP" destUrl="http://
www.sapphiresystems.us.com/solutions/SAP.htm" creativeid="2720287207"
creativeStatus="Enabled" adwordsType="Search Only" budget="50000000"
maxCpc="5000000" maxContentCpc="4000000" agStatus="Enabled"
campStatus="Active" imps="2" clicks="0" cpc="0" cost="0" pos="3.5"
conv="0" leads="0" leadValue="0.0" />

<row date="2009-08-27" campaignid="24806467" campaign="CA: SAP Generic
in hours" adgroupid="640440307" adgroup="Generic SAP Test"
headline="SAP Software Solutions" desc1="Discover how Sapphire can
help you" desc2="increase business productivity"
creativeVisUrl="www.sapphiresystems.us.com/SAP" destUrl="http://
www.sapphiresystems.us.com/solutions/SAP.htm" creativeid="2720287207"
creativeStatus="Enabled" adwordsType="Search Only" budget="50000000"
maxCpc="5500000" maxContentCpc="4000000" agStatus="Enabled"
campStatus="Active" imps="1" clicks="0" cpc="0" cost="0" pos="1.0"
conv="0" leads="0" leadValue="0.0" />

<row date="2009-08-27" campaignid="24806467" campaign="CA: SAP Generic
in hours" adgroupid="640440307" adgroup="Generic SAP Test"
headline="SAP Software Solutions" desc1="SAP solution for Great
companies" desc2="not just Great big companies"
creativeVisUrl="www.sapphiresystems.us.com/SAP" destUrl="http://
www.sapphiresystems.us.com/solutions/SAP.htm" creativeid="2720276317"
creativeStatus="Enabled" adwordsType="Content Only" budget="50000000"
maxCpc="" maxContentCpc="4000000" agStatus="Enabled"
campStatus="Active" imps="4817" clicks="2" cpc="2535000"
cost="5070000" pos="3.1434502803" conv="0" leads="0" leadValue="0.0" /
>

<row date="2009-08-27" campaignid="24806467" campaign="CA: SAP Generic
in hours" adgroupid="640440307" adgroup="Generic SAP Test"
headline="SAP Software Solutions" desc1="SAP solution for Great
companies" desc2="not just Great big companies"
creativeVisUrl="www.sapphiresystems.us.com/SAP" destUrl="http://
www.sapphiresystems.us.com/solutions/SAP.htm" creativeid="2720276317"
creativeStatus="Enabled" adwordsType="Search Only" budget="50000000"
maxCpc="5000000" maxContentCpc="4000000" agStatus="Enabled"
campStatus="Active" imps="38" clicks="0" cpc="0" cost="0"
pos="2.3947368421" conv="0" leads="0" leadValue="0.0" />

<row date="2009-08-27" campaignid="24806467" campaign="CA: SAP Generic
in hours" adgroupid="640440307" adgroup="Generic SAP Test"
headline="SAP Software Solutions" desc1="SAP solution for Great
companies" desc2="not just Great big companies"
creativeVisUrl="www.sapphiresystems.us.com/SAP" destUrl="http://
www.sapphiresystems.us.com/solutions/SAP.htm" creativeid="2720276317"
creativeStatus="Enabled" adwordsType="Search Only" budget="50000000"
maxCpc="5500000" maxContentCpc="4000000" agStatus="Enabled"
campStatus="Active" imps="47" clicks="0" cpc="0" cost="0"
pos="2.0425531915" conv="0" leads="0" leadValue="0.0" />

[Zweitze]

Try leaving out columns MaximumCPC and MaxContentCPC.
A short explanation is that these columns are keyword attributes, by
introducing these attributes the report will get aggregations on those
attributes. To see what I mean, include column Keyword and see the
results: you'll get an aggregation on keywords.

Having said that, this won't solve your problem for any circumstance.
Once I got duplicate records because the budget was changed in the
middle of the day - I got records with old and new budget. That was
two or three years ago, but then I realized I should never make
assumptions on column uniqueness.

[AdWords API Advisor]

Hi,

Zweitze's explanation is correct, introducing the MaximumCPC column is
causing the report to return a row for each possible maxCpc, which in
that example is 5000000 and 5500000.

Best,
- Eric Koleda, AdWords API Team

[SOHAIR AHMAD]

Date in CAMPAIGN_PERFORMANCE_REPORT  also have the same issue 

if I need the Date (Day)  then what should I do of these multiple records ?

[Vishal Vinayak (Adwords API Team)]

Hi Sohair,

Do you mean you see duplicates when you add the Date field to the report? Could you please provide the SOAP XML report definition and the downloaded report where you see this issue? Please click on Reply privately to author when responding.

Regards,
Vishal Vinayak, AdWords API Team

[Zweitze]

Like I said eight years (!) ago: Never asume row uniqueness.