SEARCH_QUERY_PERFORMANCE_REPORT only shows 0 click queries

[Nikolai Wiskow]

Hi everyone,

I've been trying to get a Search Query Performance Report via the Adwords API using AWQL and Python lately. However, for any reason, I only seem to get items that have 0 clicks. Here's my code:

def run_sqr_report(client):

report_service = client.GetReportDownloader(version="v201702")

 

report_query = ("SELECT Query, Impressions, Clicks  "

"FROM SEARCH_QUERY_PERFORMANCE_REPORT "

"WHERE Conversions > 0 "

"AND CostPerConversion < 4 "

" DURING LAST_30_DAYS")

 

with open("sqr.csv", "w") as myfile:

 

report_service.DownloadReportWithAwql(report_query, "CSV", myfile, skip_report_header=True, skip_column_header=False, skip_report_summary=True, include_zero_impressions=False)

I compared the report output against the same report run in the Adwords interface, with the above mentioned observation. The same seems to happen if I run that query via Adwords Scripts. Any ideas?

Thanks! 

[Ivan Bautista]

Hi Nikolai,

For us to further look into it, could you reply to us privately (using reply private to author option) with the screenshot of the Search Terms Report in the AdWords UI as well as your clientCustomerId?

Regards,

Ivan

AdWords API Team

[Ivan Bautista]

Hi Nikolai,

Do you still encounter this issue? If so, then could you please reply to us privately (using reply privately to author option) with the information requested earlier so we can investigate further?