search_query_performance_report is only returning Search terms with 1 or more clicks

437 views
Skip to first unread message

Nellle Rickchards

unread,
Oct 9, 2018, 4:47:54 PM10/9/18
to AdWords API and Google Ads API Forum
Hello, 
I'm using the search_query_performance_report to find additional keywords for our account. I'm running into an issue as my query is only returning search terms with atleast one click.

Ideally, it should return search terms with one ore more impressions (even if it had 0 clicks). 

Here is my code:

output = io.StringIO()

report_query = {
    'reportName': 'All Time days SEARCH_QUERY_PERFORMANCE_REPORT',
    'dateRangeType': 'ALL_TIME',
    'reportType': 'SEARCH_QUERY_PERFORMANCE_REPORT',
    'downloadFormat': 'CSV',
    'selector': {
        'fields': ['Query', 'AdGroupName', 'AdGroupId', 'Impressions',
                   'Clicks', 'QueryTargetingStatus'],
        'predicates': [
            {
                'field': 'AdGroupId',
                'operator': 'IN',
                'values': adgroup_ids,
            },
            {
                'field': 'QueryTargetingStatus',
                'operator': 'IN',
                'values': 'NONE',
            },
            {
                'field': 'Impressions',
                'operator': 'GREATER_THAN',
                'values': impressions_threshold,
            }
        ]
    }
}

report_downloader.DownloadReport(
    report_query,
    output,
    skip_report_header=True,
    skip_column_header=False,
    skip_report_summary=True,
    include_zero_impressions=False)


Luis Xander Talag (AdWords API Team)

unread,
Oct 9, 2018, 6:12:56 PM10/9/18
to AdWords API and Google Ads API Forum
Hi Nellle,

Yes, you are correct, Search Query Performance Report returns data with non-zero impressions even though the search terms have zero clicks. This said, could you provide your clientCustomerId and the complete report definition you used in generating the report? Please reply via the Reply privately to author.

Best regards,
Luis
AdWordsAPI Team

Sebastian Razola

unread,
Oct 16, 2018, 5:21:22 AM10/16/18
to AdWords API and Google Ads API Forum
I have the exact same issue. Did you figure out the problem?

Thanks!

/Sebastian

Luis Xander Talag (AdWords API Team)

unread,
Oct 16, 2018, 4:02:06 PM10/16/18
to AdWords API and Google Ads API Forum
Hi Sebastian,

With regards to your issue in Search Query Performance report, could you also provide your clientCustomerId and the complete report definition you used in generating the report so I could further investigate your issue? Please reply via the Reply privately to author.

Best regards,
Luis
AdWords API Team

Reply all
Reply to author
Forward
0 new messages