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 Materie wrote: > 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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en -~----------~----~----~----~------~----~------~--~---