Eric. This is causing some issues when we try to replicate the structure reports functionality from v13.. For example, we are trying to download all keywords in a campaign, and it seems that including certain rows changes whether zero-impression keywords are returned or not. Could you give us some pointers on replicating the structure reports functionality. Thanks.
Alex On Dec 28 2010, 10:20 am, AdWords API Advisor <[email protected]> wrote: > Hi Reed, > > Zero-impression rows are only returned when the report doesn't have > any segmentation fields, aka fields that are properties of the > impression itself. In this case the fields Date, AdNetwork1, > AdNetwork2, and Device are all properties of the impression and not > the ad, so they will cause segmentation and prevent zero-impression > rows from being returned. Additionally, you have some fields in your > report that aren't supported by the AD_PERFORMANCE_REPORT, such as > MaxCPC and IsNegative, which are also causing problems with zero- > impression rows. > > This behavior isn't very well documented at the moment, and we are > working on improving that. > > Best, > - Eric Koleda, AdWords API Team > > On Dec 22, 4:51 pm, Reed <[email protected]> wrote: > > > Is it legitimate to have a predicate for zero impressions in an Ad > > Performance Report? I'm trying to get all of the adcopy in one CSV > > file (instead of the XML file that I get from the Ad Service) because > > the size of some of the XML files are too big to process (700+MB once > > they are unzipped). But the CSV files coming back seem to ignore the > > predicate, and only have rows for data with impressions greater than > > zero. > > > thanks, > > -reed > > > SOAP (without header) is: > > <?xml version="1.0" encoding="UTF-8"?> <soapenv:Envelope > > xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" > > xmlns:v20="https://adwords.google.com/api/adwords/cm/v201008" > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> > > <soapenv:Header> <soapenv:Body> <v20:mutate> <v20:operations > > xsi:type="v20:ReportDefinitionOperation"> <v20:operator>ADD</ > > v20:operator> <v20:operand> <v20:selector> <v20:fields>Headline</ > > v20:fields> <v20:fields>Date</v20:fields> <v20:fields>Id</v20:fields> > > <v20:fields>Impressions</v20:fields> <v20:fields>Clicks</v20:fields> > > <v20:fields>Cost</v20:fields> <v20:fields>Ctr</v20:fields> > > <v20:fields>AverageCpc</v20:fields> <v20:fields>MaxCpc</v20:fields> > > <v20:fields>Status</v20:fields> <v20:fields>IsNegative</v20:fields> > > <v20:fields>Conversions</v20:fields> <v20:fields>AdGroupName</ > > v20:fields> <v20:fields>CampaignName</v20:fields> > > <v20:fields>AdGroupId</v20:fields> <v20:fields>CampaignId</v20:fields> > > <v20:fields>Url</v20:fields> > > <v20:fields>CostPerConversionManyPerClick</v20:fields> > > <v20:fields>ConversionsManyPerClick</v20:fields> > > <v20:fields>ConversionRateManyPerClick</v20:fields> > > <v20:fields>AveragePosition</v20:fields> <v20:fields>ConversionRate</ > > v20:fields> <v20:fields>CostPerConversion</v20:fields> > > <v20:fields>AdNetworkType1</v20:fields> <v20:fields>AdNetworkType2</ > > v20:fields> <v20:fields>AdType</v20:fields> <v20:fields>AdGroupStatus</ > > v20:fields> <v20:fields>CampaignStatus</v20:fields> > > <v20:fields>Description1</v20:fields> <v20:fields>Description2</ > > v20:fields> <v20:fields>DisplayUrl</v20:fields> > > <v20:fields>ImageCreativeName</v20:fields> <v20:fields>Device</ > > v20:fields> <v20:dateRange> <v20:min>20101221</v20:min> > > <v20:max>20101221</v20:max> </v20:dateRange> <v20:predicates> > > <v20:field>Impressions</v20:field> <v20:operator>GREATER_THAN_EQUALS</ > > v20:operator> <v20:values>0</v20:values> </v20:predicates> </ > > v20:selector> <v20:reportName>Ad Perf Rpt</v20:reportName> > > <v20:reportType>AD_PERFORMANCE_REPORT</v20:reportType> > > <v20:dateRangeType>CUSTOM_DATE</v20:dateRangeType> > > <v20:downloadFormat>CSV</v20:downloadFormat> </v20:operand> </ > > v20:operations> </v20:mutate> </soapenv:Body> </soapenv:Envelope> > > > XML RESPONSE FROM REPORT DEFINITION IS > > > <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/ > > envelope/"><soap:Header><ResponseHeader xmlns="https:// > > adwords.google.com/api/adwords/cm/ > > v201008"><requestId>ff4ae0fb56679de9a20569801fea458d</ > > requestId><operations>1</operations><responseTime>273</ > > responseTime><units>400</units></ResponseHeader></ > > soap:Header><soap:Body><mutateResponse xmlns="https:// > > adwords.google.com/api/adwords/cm/v201008"><rval><id>12299295</ > > id><selector><fields>Headline</fields><fields>Date</fields><fields>Id</ > > fields><fields>Impressions</fields><fields>Clicks</ > > fields><fields>Cost</fields><fields>Ctr</fields><fields>AverageCpc</ > > fields><fields>MaxCpc</fields><fields>Status</ > > fields><fields>IsNegative</fields><fields>Conversions</ > > fields><fields>AdGroupName</fields><fields>CampaignName</ > > fields><fields>AdGroupId</fields><fields>CampaignId</ > > fields><fields>Url</fields><fields>CostPerConversionManyPerClick</ > > fields><fields>ConversionsManyPerClick</ > > fields><fields>ConversionRateManyPerClick</ > > fields><fields>AveragePosition</fields><fields>ConversionRate</ > > fields><fields>CostPerConversion</fields><fields>AdNetworkType1</ > > fields><fields>AdNetworkType2</fields><fields>AdType</ > > fields><fields>AdGroupStatus</fields><fields>CampaignStatus</ > > fields><fields>Description1</fields><fields>Description2</ > > fields><fields>DisplayUrl</fields><fields>ImageCreativeName</ > > fields><fields>Device</fields><predicates><field>Impressions</ > > field><operator>GREATER_THAN_EQUALS</operator><values>0</values></ > > predicates><dateRange><min>20101221</min><max>20101221</max></ > > dateRange></selector><reportName>Ad Perf Rpt</ > > reportName><reportType>AD_PERFORMANCE_REPORT</ > > reportType><hasAttachment>false</ > > hasAttachment><dateRangeType>CUSTOM_DATE</ > > dateRangeType><downloadFormat>CSV</ > > downloadFormat><creationTime>20101222 134026 America/Los_Angeles</ > > creationTime></rval></mutateResponse></soap:Body></soap:Envelope> -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
