How to use Regex in Looker Studio for SEO Reporting (Part 2) 

Regular expressions (regex) and case statements can take your SEO reporting in Looker Studio to greater heights.
In this video you'll learn how to group your Google Search Console keyword data into topics by using regex and case statements in Looker.
---Timestamps---
00:00 How to use Regex in Looker Studio for SEO Reporting (Part 2)
02:52 What is a regular expression (regex)?
03:32 Regex contains within a case statement in Looker Studio
04:04 Text matching in Regular expressions
04:56 The period (.) in regex to match any single character
05:40 The asterisk (*) in regex is a "quantifier" to match
07:10 Combining the period (.) and asterisk (*) for regex wildcard matching
08:38 Using the pipe (|) symbol for OR in regex
09:34 Using the backslash (\) to escape from special characters
This is part 2 of a Looker SEO reporting tutorial. You can find Part 1 here: • How to Use Case Statem...
Our guest instructor is Nico Brooks. Nico is the Co-CEO and Head of Analytics at Two Octobers, a Certified B Corporation based in Denver Colorado that focuses on analytics, SEO, and media. In addition to regular expressions and case statements, Nico is passionate about apprenticeship as a means for providing good jobs for good people.
You can learn more about Nico using the links below.
Website: twooctobers.com/nico-brooks/
RU-vid: / @twooctobers
LinkedIn: / nicobrx
Apprenticeship at TwoOctobers: twooctobers.com/digital-marke...
Thanks for watching.
Any ad revenue from this video is being donated to support apprenticeship programs. www.jff.org/
Root and Branch offers free digital marketing training and tips focused on Google Analytics, Google Ads, Google Tag Manager, and SEO.