Hi Taco, Thank you for the feedback, and I'll let the core engineering team know about the importance of exposing as much information as possible via reports.
As for the duplicate rows, there can be multiple rows for the same item if one of the columns you are selecting has had it's value changed during the time frame of the report. In your example, the firstPageCpc value changed, which is why there is a row returned with the stats for each of the two values. Best, - Eric On Sep 25, 4:43 pm, Taco <[email protected]> wrote: > Hi Eric, > > Thanks for your quick reply. > > Would you please consider adding this to the list of user requests for > a new version of the API? It would be real useful to get all the > information that we can get from the API via the reports functionality > too. If only to cut back on API calls. > > I have another question about this same report. When I schedule a > Creative Performance Report - Summary (see soap body below), I'd > expect every Creative to show up just once in the report. In my case I > find some of the Creatives two or even more times in the Xml. > > For instance: > > ------------------- > <row campaignid="15447853" campaign="*****" adgroupid="1352779663" > adgroup="*****" firstPageCpc="10000" headline="*****" desc1="*****" > desc2="*****" creativeVisUrl="*****" destUrl="*****" > creativeid="3977424643" creativeType="text" creativeStatus="Enabled" > adwordsType="Search Only" adDistributionWithSearchPartners="Google > Search" maxCpc="60000" maxCpm="0" maxContentCpc="0" topPosition="" > bottomPosition="" agStatus="Enabled" hostingKey="" imgCreativeName="" > creativeDestUrl="*****" campStatus="Active" imps="1" clicks="0" > ctr="0.0" cpc="0" cpm="0" cost="0" pos="1.0" conv="0" costPerConv="0" / > > > > <row campaignid="15447853" campaign="*****" adgroupid="1352779663" > adgroup="*****" firstPageCpc="40000" headline="*****" desc1="*****" > desc2="*****" creativeVisUrl="*****" destUrl="*****" > creativeid="3977424643" creativeType="text" creativeStatus="Enabled" > adwordsType="Search Only" adDistributionWithSearchPartners="Google > Search" maxCpc="60000" maxCpm="0" maxContentCpc="0" topPosition="" > bottomPosition="" agStatus="Enabled" hostingKey="" imgCreativeName="" > creativeDestUrl="*****" campStatus="Active" imps="138" clicks="2" > ctr="0.014492753623188406" cpc="60000" cpm="869565" cost="120000" > pos="4.268115942" conv="1" costPerConv="120000" /> > > <row campaignid="15447853" campaign="*****" adgroupid="1352779663" > adgroup="*****" firstPageCpc="40000" headline="*****" desc1="*****" > desc2="*****" creativeVisUrl="*****" destUrl="*****" > creativeid="3977424643" creativeType="text" creativeStatus="Enabled" > adwordsType="Search Only" adDistributionWithSearchPartners="Search > Partners" maxCpc="60000" maxCpm="0" maxContentCpc="0" topPosition="" > bottomPosition="" agStatus="Enabled" hostingKey="" imgCreativeName="" > creativeDestUrl="*****" campStatus="Active" imps="16" clicks="2" > ctr="0.125" cpc="50000" cpm="6250000" cost="100000" pos="4.625" > conv="2" costPerConv="50000" /> > ------------------- > > I'd understand it if they represented three different versions of > adDistributionWithSearchPartners, but two of them list "Google > Search". > Do you have any idea how I should interpret this data? > Is there any reason why it is listed several times? > > Should I just take all three of them and add up the values for imps > and clicks? > > Thanks in advance, > Taco > > ------------------- > > <scheduleReportJob xmlns="https://adwords.google.com/api/adwords/ > v13"> > <job xsi:type="DefinedReportJob"> > <endDay>2009-09-25</endDay> > <name>Creative Report</name> > <startDay>2009-09-25</startDay> > <adGroupStatuses>Enabled</adGroupStatuses> > <aggregationTypes>Summary</aggregationTypes> > <campaignStatuses>Active</campaignStatuses> > <selectedColumns>CreativeId</selectedColumns> > <selectedColumns>AdDistributionWithSearchPartners</ > selectedColumns> > <selectedColumns>AdGroup</selectedColumns> > <selectedColumns>AdGroupId</selectedColumns> > <selectedColumns>AdGroupStatus</selectedColumns> > <selectedColumns>AdStatus</selectedColumns> > <selectedColumns>AdWordsType</selectedColumns> > <selectedColumns>AveragePosition</selectedColumns> > <selectedColumns>BottomPosition</selectedColumns> > <selectedColumns>CPC</selectedColumns> > <selectedColumns>CPM</selectedColumns> > <selectedColumns>CTR</selectedColumns> > <selectedColumns>Campaign</selectedColumns> > <selectedColumns>CampaignId</selectedColumns> > <selectedColumns>CampaignStatus</selectedColumns> > <selectedColumns>Clicks</selectedColumns> > <selectedColumns>Conversions</selectedColumns> > <selectedColumns>Cost</selectedColumns> > <selectedColumns>CostPerConverstion</selectedColumns> > <selectedColumns>CreativeDestUrl</selectedColumns> > <selectedColumns>CreativeType</selectedColumns> > <selectedColumns>DescriptionLine1</selectedColumns> > <selectedColumns>DescriptionLine2</selectedColumns> > <selectedColumns>DescriptionLine3</selectedColumns> > <selectedColumns>DestinationURL</selectedColumns> > <selectedColumns>FirstPageCpc</selectedColumns> > <selectedColumns>ImageAdName</selectedColumns> > <selectedColumns>ImageHostingKey</selectedColumns> > <selectedColumns>Impressions</selectedColumns> > <selectedColumns>MaxContentCPC</selectedColumns> > <selectedColumns>MaximumCPC</selectedColumns> > <selectedColumns>MaximumCPM</selectedColumns> > <selectedColumns>TopPosition</selectedColumns> > <selectedColumns>VisibleUrl</selectedColumns> > <selectedReportType>Creative</selectedReportType> > </job> > </scheduleReportJob> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
