Just like in Google Sheets, LEFT_TEXT() & RIGHT_TEXT() are another text functions that allows us to extract a part of a text field according to the number of characters we indicate in the formula.
These text functions are valuable when grouping campaigns or other dimension categories.
<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>
