Large Discrepancy With Search Query Performance Report

[Brad Ruderman]

I am having huge discrepancy issues with the "SEARCH_QUERY_PERFORMANCE_REPORT"

The query I am using is:

  report_query = ('''SELECT KeywordId,

                            AccountCurrencyCode,

                            AccountDescriptiveName,

                            AccountTimeZoneId,

                            AdFormat,

                            AdGroupId,

                            AdGroupName,

                            AdGroupStatus,

                            AdNetworkType1,

                            AdNetworkType2,

                            CampaignId,

                            CampaignName,

                            CampaignStatus,

                            Clicks,

                            ConversionValue,

                            ConvertedClicks,

                            Cost,

                            CostPerConvertedClick,

                            CreativeId,

                            CustomerDescriptiveName,

                            Date,

                            DayOfWeek,

                            DestinationUrl,

                            Device,

                            ExternalCustomerId,

                            FinalUrl,

                            Impressions,

                            KeywordTextMatchingQuery,

                            QueryMatchTypeWithVariant,

                            Month,

                            MonthOfYear,

                            PrimaryCompanyName,

                            Quarter,

                            Query,

                            ValuePerConvertedClick,

                            ViewThroughConversions,

                            Conversions,

                            AveragePosition,

                            Week,

                            Year

       FROM SEARCH_QUERY_PERFORMANCE_REPORT

       DURING {0},{0}''').format(report_dt)

However when I check the impression for 1 day it's off significantly (1000 vs 60000). I haven't been able to figure out why. I also import the keyword performance report, but have no issues there. What could cause the discrepancy? 

[Umesh Dengale]

Hello,

Could you provide the clientCustomerId and date range values used in the SEARCH_QUERY_PERFORMANCE_REPORT query? Just click Reply privately to author in the forum when responding.

Thanks,

Umesh, AdWords API Team.

[Umesh Dengale]

Hello,

Could you please compare your SEARCH_QUERY_PERFORMANCE API report to the Search Terms report in the AdWords user interface? Please attach the screenshot from the AdWords UI where the stats doesn't match. Just click Reply privately to author in the forum when responding.

Regards,

Umesh, AdWords API Team.