Link to blog post: http://bit.ly/regex4marketers. Breakdown of video with links to each section (regex character) 👇.
Are you intimidated by regular expressions? Just think of them as filters on that would fail a blood test. No but seriously, regex enables you to filter using patterns. For each one I share gotchas, easy ways to understand what they do, and practical examples of tasks you can accomplish with regex. Make sure you pull the lists from my blog post if you want to follow along! Over the next few videos I'll show examples for how you can use regex in Google Analytics, Google Docs, Google Sheets, Tableau, SQL, and Screaming Frog.
Breakdown of Regex Characters in Order of Appearance:
00:34 - |
04:00 - .
04:00 - *
04:00 - +
06:18 - [ ]
06:18 - \
09:37 - \d
10:55 - ?
14:09 - { }
15:50 - ^
15:50 - \w
19:20 - ( )
22:08 - $
24:51 - [^ ]
29:26 - \s
Additional Exercises
34:21 - Britney Spears Misspellings
38:21 - URIs with Query Parameters in GA
41:23 - Filter for Search Terms with 3 Words in GA
43:08 - Identify Staging Servers in GA
44:14 - Extract Zip Codes