duplicate rows in AD PERFORMANCE REPORT

[nir.be...@naturalint.com]

Hello,

I am retrieving ad performance report using java SDK. 

for some ads I recieve duplicate rows, all the data is exactly the same. In order to investigate the issue, I have removed the field I request, one by one and came to realize that Date field is causing the problem, without it the data is received fine

This is my request:

Selector selector = new Selector();
//set fields
selector.getFields().addAll(Lists.newArrayList(
        "AccountCurrencyCode",
        "AdGroupId",
        "AdType",
        "AveragePageviews",
        "AveragePosition",
        "CampaignId",
        "Labels",
        "Id",
        "Clicks",
        "Cost",
        "CreativeDestinationUrl",
        "CreativeFinalUrls",
        "CreativeTrackingUrlTemplate",
        "Date",
        "DisplayUrl",
        "Headline",
        "Impressions"


));

//set dates
DateRange dateRange = new DateRange();
dateRange.setMin(startDate.toString());
dateRange.setMax(endDate.toString());
selector.setDateRange(dateRange);

// Create report definition.
ReportDefinition reportDefinition = new ReportDefinition();
reportDefinition.setReportName("Ad performance report #" + System.currentTimeMillis());
reportDefinition.setDateRangeType(ReportDefinitionDateRangeType.CUSTOM_DATE);
reportDefinition.setReportType(ReportDefinitionReportType.AD_PERFORMANCE_REPORT);
reportDefinition.setDownloadFormat(DownloadFormat.XML);
reportDefinition.setSelector(selector);

startDate and endDate are of type LocalDate

Any thing I am doing wrong?

Thanks

Nir

[Vishal Vinayak (Adwords API Team)]

Hi Nir,

Date field in the Ad Performance Report is a segment field, which helps break down the statistics per day. However, these records cannot be considered duplicates as these are per day numbers which get grouped into a single row when the date field is removed. If you are looking to download data for a particular day, you can specify same date (both as the start date and the end date) in your date range predicate. Please revert if you have additional questions or concerns.  

Regards,
Vishal, AdWords API Team

[nir.be...@naturalint.com]

Hi,

thank you for the prompt response

I am currently running on one day, as you specified and am getting duplicate rows (exactly the same on all fields). below is an example

Please advice

Thanks, Nir

<row currency='USD' adGroupID='15498866411' adType='Expanded text ad' pagesSession='2.06' avgPosition='2.1' campaignID='196833371' clicks='726' cost='244160000' destinationURL='' finalURL='[&quot;http://www.Top10BestVPN.com&quot;]' trackingTemplate='--' day='2017-03-15' displayURL='' ad='' adID='182850649640' impressions='5611' labels='[&quot;LinkChecker_Done&quot;]'/>

<row currency='USD' adGroupID='15498866411' adType='Expanded text ad' pagesSession='2.06' avgPosition='2.1' campaignID='196833371' clicks='726' cost='244160000' destinationURL='' finalURL='[&quot;http://www.Top10BestVPN.com&quot;]' trackingTemplate='--' day='2017-03-15' displayURL='' ad='' adID='182850649640' impressions='5611' labels='[&quot;LinkChecker_Done&quot;]'/>

[nir.be...@naturalint.com]

[nir.be...@naturalint.com]

On Wednesday, March 29, 2017 at 5:27:57 PM UTC+3, nir.be...@naturalint.com wrote:

[Vishal Vinayak (Adwords API Team)]

Hi,

Could you please add the fields CriterionId (KeywordId) and CriterionType to the report and check if there is any difference? Ad Performance Report is a single attribution report when the field CriterionId is added. I checked in the web interface and I do see 726 clicks for the ad id 182850649640 for 15th March 2017 (with and without the keyword segment) and no duplicates. 

[nir.be...@naturalint.com]

Hi,

When I add CriteriaId & CriterionType, for this ad I receive 156 rows, segmented by keywords

[Vishal Vinayak (Adwords API Team)]

Hi,

If you do not see duplicates and the sum of clicks for all CriteriaIds is the same as the web interface (i.e. 726), chances are, the API report being a multi-attribution report without the CriteriaId field is displaying one row for each triggering criterion. To confirm, could you please generate the same report by using the CriterionType field and removing CriteriaId field from the report? If you still see issues, please send me the report definition and the downloaded report and I'll check with my team to see if we can dig deeper on this issue. 

Regards,

Vishal Vinayak, AdWords API Team