I have generated a SEARCH_QUERY_PERFORMANCE_REPORT (SQPR) as well as a KEYWORDS_PERFORMANCE_REPORT (KWPR).
In both reports, I have deleted all data except for a single KeywordId. My problem is, that the Impressions from the SQPR do not match with the Impressions in the KWPR. I have fiddled around with the columns generated in both reports, and here's what I am grabbing: For the KEYWORDS_PERFORMANCE_REPORT: 'AccountCurrencyCode', 'AccountDescriptiveName', 'AccountTimeZoneId', 'AdGroupId', 'AdGroupName', 'AdGroupStatus', 'AdNetworkType1', 'AdNetworkType2', 'ApprovalStatus', 'AverageCpc', 'AverageCpm', 'AveragePosition', 'BottomPosition', 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', 'ClickSignificance', 'ConversionManyPerClickSignificance', 'ConversionRate', 'ConversionRateManyPerClick', 'ConversionRateManyPerClickSignificance', 'ConversionRateSignificance', 'Conversions', 'ConversionSignificance', 'ConversionsManyPerClick', 'ConversionValue', 'Cost', 'CostPerConversion', 'CostPerConversionManyPerClick', 'CostPerConversionManyPerClickSignificance', 'CostPerConversionSignificance', 'CostSignificance', 'CpcBidSource', 'CpcSignificance', 'CpmSignificance', 'CriteriaDestinationUrl', 'Ctr', 'CtrSignificance', 'CustomerDescriptiveName', 'Date', 'DayOfWeek', 'DestinationUrl', 'Device', 'ExternalCustomerId', 'FirstPageCpc', 'Id', 'Impressions', 'ImpressionSignificance', 'IsNegative', 'KeywordMatchType', 'KeywordText', 'MaxCpc', 'MaxCpm', 'Month', 'MonthOfYear', 'OriginalMaxCpc', 'PercentCpa', 'PositionSignificance', 'PreferredPosition', 'PrimaryCompanyName', 'PrimaryUserLogin', 'ProxyMaxCpc', 'QualityScore', 'Quarter', 'Slot', 'Status', 'TotalConvValue', 'ValuePerConv', 'ValuePerConversion', 'ValuePerConversionManyPerClick', 'ValuePerConvManyPerClick', 'ViewThroughConversions', 'ViewThroughConversionsSignificance', 'Week', 'Year', For the SEARCH_QUERY_PERFORMANCE_REPORT: 'AccountCurrencyCode', 'AccountDescriptiveName', 'AccountTimeZoneId', 'AdGroupId', 'AdGroupName', 'AdGroupStatus', 'AdNetworkType1', 'AdNetworkType2', 'AverageCpc', 'AverageCpm', 'AveragePosition', 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', 'ConversionRate', 'ConversionRateManyPerClick', 'Conversions', 'ConversionsManyPerClick', 'ConversionValue', 'Cost', 'CostPerConversion', 'CostPerConversionManyPerClick', 'CreativeId', 'Ctr', 'CustomerDescriptiveName', 'Date', 'DayOfWeek', 'DestinationUrl', 'Device', 'ExternalCustomerId', 'Impressions', 'KeywordId', 'MatchType', 'MatchTypeWithVariant', 'Month', 'MonthOfYear', 'PrimaryCompanyName', 'PrimaryUserLogin', 'Quarter', 'Query', 'TotalConvValue', 'ValuePerConv', 'ValuePerConversion', 'ValuePerConversionManyPerClick', 'ValuePerConvManyPerClick', 'ViewThroughConversions', 'Week', 'Year' Any help or ideas are more then welcome... -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
