Data Studio is now Looker Studio. Looker Studio is still free, with the same features you already know. Looker Studio Pro offers improved asset management for enterprises, new team collaboration capabilities, and access to technical support. Learn more.

CONTAINS_TEXT

Returns true if the specified text is found in the field or expression, otherwise returns false.

Sample usage

CONTAINS_TEXT(Campaign, "Sale")

Syntax

CONTAINS_TEXT(X, text)

Parameters

  • X - a field or expression of any type.
  • text - the text to find within X. text can be a field, expression, or literal value. text is case-sensitive.

Examples

Example formula Input Output
CONTAINS_TEXT(Campaign, "Sale") Summer Sale true
CONTAINS_TEXT(Campaign, "discount") Summer Sale false

Related resources

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
102097
false
false