FAQ

AI-generated Key Takeaways

outlined_flag

• Currency metrics like metrics.cost_micros require including segments.date in both the SELECT and WHERE clauses to appear in results.

• Avoid using the CONTAINS operator for substring checks in string fields; utilize REGEX_MATCH instead for this purpose.

• The CONTAINS operator is designed for verifying if a list-type field contains specific values.

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

• Sample queries