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.
<aside> <img src="/icons/arrow-down-basic_blue.svg" alt="/icons/arrow-down-basic_blue.svg" width="40px" />
<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" width="40px" /> Enroll in Looker Studio Masterclass →
</aside>
📩 Receive my weekly Looker Studio tips
🖇 Connect with me on LinkedIn
</aside>
