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 <r...@powellgenealogy.com> 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
