AdsApp Report WHERE clause not working

[Pascal]

Hi,

I'm trying to run a Query Report on an account from the SEARCH_QUERY_PERFORMANCE_REPORT and retrieve all search terms that have a cost > 50 during the last 30 days. However, for some reason, it also returns search terms with a cost lower than 50. Could anyone help me out? The query I'm running is as follows:

SELECT CampaignName, CampaignId, AdGroupName, AdGroupId, Query, QueryTargetingStatus, Impressions, Clicks, Ctr, Cost, AverageCpc, Conversions, CostPerConversion, ConversionValue FROM SEARCH_QUERY_PERFORMANCE_REPORT WHERE CampaignStatus = ENABLED AND AdGroupStatus = ENABLED AND QueryTargetingStatus = NONE AND Cost > 50 DURING LAST_30_DAYS

[Google Ads Scripts Forum Advisor]

Hello,

Can you please confirm that you are running this query with Ads scripts?

If so, can you please provide your CID and script name so we can look at the issue in the account?

Thanks,
Matt 
Google Ads Scripts Team

ref:_00D1U1174p._5001UXTne4:ref

[Pascal]

Hi Matt,

Thanks for your reply. I am indeed running it from Ads Scripts. The script is running on multiple accounts from the following MCC: 566-933-2339

The script name is: 'Search terms potential negatives'

Thanks in advance!

[Google Ads Scripts Forum Advisor]

Hi Pascal,

Thank you for providing further details. I am a colleague of Matt and let me provide further support to your concern.

However, could you please provide the following details so that I can take a closer look? You can provide the requested details via Reply privately to author option.
1. Name of the script where the Search Query Performance Report has been implemented
2. The sample client accounts where you've noticed the issue
3. Screenshot of the search terms that the cost are less than 50 but have been included in the report.

Regards,
Ejay

[Nils Rooijmans]

Hi Pascal,

this is probably due to this part of your query: 'Cost > 50'

the Cost metric is in micros, see:  

https://developers.google.com/adwords/api/docs/appendix/reports/search-query-performance-report#cost 

So for $50 or €50 you would need to multiply by 1000000 and thus use 'Cost > 50000000'

Hope this helps, 

Nils Rooijmans 

https://nilsrooijmans.com 

See my Google Ads Scripts FAQ to avoid the same mistakes i made: https://nilsrooijmans.com/google-ads-scripts-faq/

[Google Ads Scripts Forum Advisor]

Hi Nils,

Thanks for your contribution, as always.

Pascal - though the report will not output the cost in terms of micros, your query is describing cost in terms of micros (e.g. 50 in terms of your currency, is 50,000,000 in micros).

Regards,
Matt

[Pascal]

Hi Nils,

Thanks for your reply, problem solved! Is there any documentation on micros? I was not aware of this multiplication factor.

[Google Ads Scripts Forum Advisor]

Hi Pascal,

I am happy to know that your script is now working.

This is the base document which you can read to have more information about the reporting on Google Ads scripts. As for your current question, this is the specific document that discussed the money fields in reports, returned in micro currency units (micros).

Let me know if you have further questions.

Regards,
Ejay

[Pascal]

Thanks a lot Ejay.