How to use Regular Expressions on Google Looker Studio for marketing use cases?: Intro to REGEX
Understand what regular expressions (REGEX) are and how you can use them to analyze your marketing data.
📊 Connect your data using Porter (14-day free trial): https://bit.ly/connect-data-to-looker
🎁 Start with a Looker Studio Template: https://bit.ly/looker-studio-templates
Summary:
00:00 - Regular expressions (regex) on Google Looker Studio are explained to be simple and useful for non-engineers.
00:23 - Regular expressions are like mathematical formulas for operating text and dimensions. They are used to create new dimensions and operate text data.
01:45 - Marketing use cases for regular expressions on Google Looker Studio are presented, such as cleaning acquisition reports and grouping data by categories.
02:31 - Examples are given on how regular expressions can be used to clean and group data, including cleaning traffic source data, breaking down SEO reports, grouping website content, and categorizing social media posts.
03:43 - Regular expressions can be used to group and clean data, tag campaigns, and analyze data based on campaign types or products.
04:42 - The video serves as an introduction to regular expressions on Google Looker Studio for marketing purposes.
