Search Query Performance Report: Metrics of each Query grouped by campaign name although Query is not in the SELECT statement

[Christian Kolb]

Hello! I would appreciate if someone from Google Support would have a look on that asap: 

I noticed a weird behaviour when fetching the Search Query Performance Report in an Google Ads script, here is my AWQL Statement:

SELECT Query, Clicks, Cost FROM SEARCH_QUERY_PERFORMANCE_REPORT 

WHERE CampaignName CONTAINS "abc" 

DURING LAST_14_DAYS 

When I run the said AWQL Statement I expect to get numbers for each Query from the Search Query Performance Report aggregated in one row. Let us assume we have the Search Query "term xyz", if I fetch said AWQL statement I expect "term xyz "to be unique in the Query column because there is no other attribute in the SELECT statement that I use for grouping, like CampaignName.

HOWEVER, my report contains multiple entries for "term xyz", one for campaign to be precise. If I remove the WHERE clause WHERE CampaignName CONTAINS "abc" from the AWQL Query, each Search Query is unique again in the report. 

Does someone have an explanation for this - in my case inconvenient behaviour - of AWQL? It is inconvenient because I need the numbers grouped only by the Query.
It does not make any sense to me to get results for each occurrence of the Search Query per campaign just because I filter for the campaign name in the WHERE clause without including the CampaignName in the SELECT statement. It does especially not make any sense to me because AWQL does not offer statements/operators like SQL's SUM or GROUP BY that would allow me to circumvent this behaviour by grouping the metrics explicitly based on the Query field only. 

Best regards

Christian

[Google Ads API Forum Advisor]

Hi Christian,

Thank you for posting your concern.

I understand the issue that you've encountered. However, since the issue was encountered in the Google Ads scripts, then I would suggest posting your concern here instead to get assistance from the Google Ads scripts experts. They are the ones that have access to Google Ads scripts inside the specific accounts where the issue occurred so they have more access to investigate the issue.

Please note also that this forum is dedicated for Google Ads API and AdWords API related concerns and issues only.

Regards,

Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2R6M3D:ref