Duplicated rows in AUDIENCE_PERFORMANCE_REPORT

[Radosław Pociecha]

Hi,

we are sending report request like this:

         <reportDefinition>

           <selector>

             <fields>CampaignId</fields>

             <fields>AdGroupId</fields>

             <fields>Id</fields>

             <fields>Impressions</fields>

             <fields>Clicks</fields>

             <fields>Cost</fields>

             <fields>AdNetworkType1</fields>

             <fields>Date</fields>

             <fields>AveragePosition</fields>

             <fields>Device</fields>

             <fields>Conversions</fields>

             <predicates>

               <field>CampaignId</field>

               <operator>IN</operator>

               <values>CAMPAIGN_ID_1</values>

               <values>CAMPAIGN_ID_2</values>

               ...

             </predicates>

             <dateRange>

               <min>20170117</min>

               <max>20170117</max>

             </dateRange>

           </selector>

           <reportName>test report</reportName>

           <reportType>AUDIENCE_PERFORMANCE_REPORT</reportType>

           <dateRangeType>CUSTOM_DATE</dateRangeType>

           <downloadFormat>GZIPPED_XML</downloadFormat>

         </reportDefinition>

and it happens we are getting duplicated rows like this:

    <row campaignID='CAMPAIGN_ID_1' adGroupID='ADGROUP_ID_1' criterionID='CRITERION_ID_1' impressions='8' clicks='0' cost='0' network='Search Network' day='2017-01-17' avgPosition='1.4' device='Mobile devices with full browsers' conversions='0.0' />

    <row campaignID='CAMPAIGN_ID_1' adGroupID='ADGROUP_ID_1' criterionID='CRITERION_ID_1' impressions='1' clicks='1' cost='240000' network='Search Network' day='2017-01-17' avgPosition='2.0' device='Mobile devices with full browsers' conversions='0.0' />

rows has different impressions, cost, clicks and positon while campaignID, adGroupID, criterionID, network, day, and device are the same.

Is this correct behavior? We believe we should expect one row for given combination of campaignID, adGroupID, criterionID, network, day, and device.

Radosław Pociecha

[Vishal Vinayak (Adwords API Team)]

Hi Radosław,

Could you please add the fields AdNetworkType2 and Status to the report and check if you see any difference in the data? If a criterion is removed on a given date from an ad group and added to a campaign, you might see two rows of metrics, one for each targeted entity. In that case, the Status field would highlight the change. The difference might also arise if the AdNetworkType2 is different for both rows (search vs search partners). You can check the same using the Audience Report in the AdWords web interface as well. If that doesn't help, could you please provide the data with actual campaign ID, ad group ID and criterion ID information so that I can take a further look? Please click on Reply privately to author when responding.   

Regards,

Vishal, AdWords API Team

[Radosław Pociecha]

Hi

After adding AdNetworkType2 and Status fields to request i can see that these rows differ with audienceState (one has audienceState='enabled' and the other has audienceState='removed'). Thanks for exmplanation.

Radosław Pociecha