Uploaded February 2014 | Updated September 2026, 2 hours ago
Based on this post: annielytics.com/?p=1993. This is a promotional video for my three-day Annielytics Dasbhboard Seminar. Although it's promotional, there are some dashboard best practices that I cover in the video, as well as an intro to Google Analytics API data.
Based on this post: annielytics.com/?p=1993. This is a promotional video for my three-day Annielytics Dasbhboard Seminar. Although it's promotional, there are some dashboard best practices that I cover in the video, as well as an intro to Google Analytics API data.
![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.")
