They are not supposed to match. A keyword in the KWPR could have triggered search queries that don't get listed in the SQPR.
Not every search query gets listed in the SQPR. You can see these scenarios in the web interface when you look at search queries and scroll down to the bottom of the table to the "Other search terms". These are terms that triggered a keyword but not fully visible to the marketer and presumably not listed in the report either. Oliver On Friday, August 31, 2012 11:07:29 AM UTC+1, Tjeerd Kramer wrote: > > 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
