CONTAINS_TEXT() function is useful when we are aggregating data based on different categories and we just want to use or present a keyword or a part of a string of text.

It gives out a Boolean expression (true/false). This function can help us prevent fractured categories (e.g., web traffic source)  into different rows.

Similar to CONTAINS_TEXT(), we have STARTS_WITH() and ENDS_WITH() functions which return a Boolean expression (true/false) when a dimension contains the value we’re searching for immediately at the beginning or immediately at the end of the text.