Structure report delivers duplicates

[Materie]

Hi there,

When i request a structure reports for a campaign, it delivers a
response containing duplicates:

<report>
<table>
<columns>...</columns>
<rows>
<row campaignid="31412149" campaign="Campaign #1" budget="10000000"
campStatus="Deleted"/>
<row campaignid="34436329" campaign="Denmark DA" budget="10000000"
campStatus="Active"/>
<row campaignid="34436329" campaign="Denmark DA" budget="25000000"
campStatus="Active"/>
<row campaignid="34436329" campaign="Denmark DA" budget="50000000"
campStatus="Active"/>
<row campaignid="34436329" campaign="Denmark DA" budget="100000000"
campStatus="Active"/>
<row campaignid="34635679" campaign="Denmark EN" budget="10000000"
campStatus="Active"/>
<row campaignid="34635679" campaign="Denmark EN" budget="25000000"
campStatus="Active"/>
<row campaignid="34635679" campaign="Denmark EN" budget="50000000"
campStatus="Active"/>
</rows>
</table>
<total>...</total>
</report>

After examination it appears the duplicates propagate through to group
reports. Since the ad and keyword files are about 40 mb and 750 mb
(!!!), my guess is that these reports also contain many duplicates.

My report reader code now ignores these duplicates, however, to save
diskspace, downloadtime and serverstress we possibly better find out
where the problem is. To be complete; the Java code for building a
report-request looks like this:

DefinedReportJob ads = new DefinedReportJob();
ads.setSelectedReportType("Structure");
ads.setAggregationTypes(new String[] {"Campaign"}); //campaigns
ads.setStartDay(new Date()); //get the structure as it is today
ads.setEndDay(new Date());
ads.setName("campaign_report");

ads.setSelectedColumns(new String[] {
"Campaign", "CampaignId", "CampaignStatus",

"DailyBudget"
});

reports.validateReportJob(ads);

return reports.scheduleReportJob(ads);

If anyone wonders: the campaigns are both running a $25/day budget.

[Jonathan Betz]

Hi Materie,

I know there is an issue in the account structure report such that
each keyword gets reported multiple times for every change in the
campaign budget. So, for example, in a campaign where the budget has
been changed five times, each keyword would be reported five times.

The API team is aware of this issue, though I haven't heard an ETA for
a fix.

Cheers,
Jonathan

Jonathan Betz
Senior Director, Engineering
Clickable, Inc.
7 West 22nd St
New York, NY 10010
http://www.clickable.com