Uploaded August 2013 | Updated September 2026, 4 minutes ago
Based on this post: annielytics.com/?p=1575. If you're an Internet marketer working with competitive analysis data, a common task in data preparation is creating a separate column for domains, which you extract from a list of URLs (e.g., backlinks). I show you how.
Based on this post: annielytics.com/?p=1575. If you're an Internet marketer working with competitive analysis data, a common task in data preparation is creating a separate column for domains, which you extract from a list of URLs (e.g., backlinks). I show you how.
![Regex for Marketers in Plain English with Real World Examples [VIDEO]](https://i.ytimg.com/vi/4BXD6iWmkCA/mqdefault.jpg "Regex for Marketers in Plain English with Real World Examples [VIDEO]
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 Ill 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")
![The INDEX Function: Excels More Stable Alternative to OFFSET [VIDEO]](https://i.ytimg.com/vi/6coBN0gyZKY/mqdefault.jpg "The INDEX Function: Excels More Stable Alternative to OFFSET [VIDEO]
From this post: http://www.annielytics.com/?p=4069. The OFFSET function is terribly volatile and can bring Excel to its knees. This video shows three marketing uses for the INDEX function.")
