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.*'