The new Search Ads 360 Reporting API is now available. Join the
searchads-api-announcements Google group to stay up to date on upcoming enhancements and releases.
Send feedback
FAQ
Stay organized with collections
Save and categorize content based on your preferences.
This page collects some tips that could be useful when creating your first
queries.
Problem: A metric does not appear in results
Currency related metrics (e.g. metrics.cost_micros) need to include
segments.date
in the SELECT clause and in the WHERE clause.
Problem: CONTAINS operator does not work with a string field
When you need to check if a string field contains a substring, don't use the
CONTAINS
(or CONTAINS NOT
) operator.
CONTAINS
is meant to be used with fields that keep lists of values and you
want to check if the list contains one or more specific values.
To check the presence of a substring you can use REGEXP_MATCH
, for example
SELECT
customer.descriptive_name,
... // other fields
FROM
campaign
WHERE customer.descriptive_name REGEXEP_MATCH 'Customer.*'
Learn more
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-28 UTC.
[{
"type": "thumb-down",
"id": "missingTheInformationINeed",
"label":"Missing the information I need"
},{
"type": "thumb-down",
"id": "tooComplicatedTooManySteps",
"label":"Too complicated / too many steps"
},{
"type": "thumb-down",
"id": "outOfDate",
"label":"Out of date"
},{
"type": "thumb-down",
"id": "samplesCodeIssue",
"label":"Samples / code issue"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-09-28 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-28 UTC."]]