Regex for Marketers in Plain English with Real World Examples [VIDEO] @Annielytics

Annielytics 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

updated 5 years ago

Regex for Marketers in Plain English with Real World Examples [VIDEO]

Annielytics 2021-02-05 | 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

How to Rock Regex Functions in Google Sheets

Annielytics 2023-05-08 | Based on: bit.ly/regex-sheets. Are you tired of manually editing your spreadsheets to extract or replace specific text patterns? Then it's time to learn about using regular expressions—aka regex—in Google Sheets! In this video tutorial, we'll take a deep dive into how to use the REGEXMATCH(), REGEXEXTRACT(), and REGEXREPLACE() functions in Google Sheets with real-world marketing examples.

You can also click/tap a minute mark to skip to that section of the video:

00:09 - Using REGEXMATCH() to classify URLs by subdomain
11:04 - Using REGEXEXTRACT() to extract the subdomain
15:29 - Using our new contrived columns in a pivot table and slicer
18:54 - Using REGEXMATCH() to classify keywords as brand or generic
25:12 - Using REGEXREPLACE to switch first and last name and ditch the comma
28:30 - Using REGEXREPLACE to change the formatting of phone numbers

A Marketer’s Guide to Using Regex in the Search Console

Annielytics 2021-12-06 | Based on this post: bit.ly/gsc-regex. Learn how to filter Google Search Console Search Performance report using regular expressions (aka regex) to get the data you need.

JUMP AHEAD
00:10 - Google’s announcements
01:48 - How the Search Results performance report works
03:48 - How to access the regex option
08:15 - How to filter by exact match using regex
08:50 - Make query case sensitive
09:47 - Get keywords that contain a digit using \d
10:23 - Return question queries (how, what, when, where, why)
12:17 - How to build out a more sophisticated regex expression in phases
17:06 - Filter pages to certain directories and evaluate queries by site section

LINKS
Google’s regex announcement: bit.ly/3DrK3JL
Google announces negative match capability: bit.ly/3DovQ01
Google’s regex help page: bit.ly/3oqy6jf
My regex for marketers post: bit.ly/regex4marketers
My regex for Google Analytics post: bit.ly/regex-in-ga
All of my regex posts: http://bit.ly/regex-tag
My YouTube regex playlist: http://bit.ly/regex-playlist

6 Real-World Uses of Regex in Google Analytics

Annielytics 2021-11-08 | Based on this post: http://bit.ly/regex-in-ga. Learn how to use regular expressions—aka regex—in Google Analytics. I break it down in simple English.

PRIMER
Not familiar with regex? Start with this intro video: youtu.be/4BXD6iWmkCA

JUMP AHEAD
02:59 - Group content on the fly
08:23 - Create a content group using the rule option
09:58 - Create a content group using the extract option
19:04 - Use regex to re/define channels
25:50 - Generate regex from a list using Google Sheets
30:24 - Generate regex from a list using Word
33:50 - Test your channel regex with a custom channel grouping
35:42 - Create a new channel
36:59 - Create advanced segments
40:11 - Create a filter

TECH NOTE
My video editor had a Mac bug that caused my cursor to go MIA. I tried to compensate with lots of annotations.

Friend: Lori Vallow Said She Paid Alex Cox to Murder Joe Ryan

Annielytics 2021-11-07 | Chandler Police interviewed Lori Vallow's friend from Hawaii, Anne. At the 1:48 min mark of the video, she said that Lori bragged that she paid her brother to murder my brother, Joseph Ryan.

I take a deep dive into possible signs of foul play using the pics from the welfare check for Joe in this video: youtube.com/watch?v=6MyXqsIdfG8.

VINELink Setup Instructions for Cool Cats

Annielytics 2021-08-15 | Learn how to follow to get notifications for hearings for Lori Vallow and Chad Daybell. I created this for my Cool Cats and Criminals Facebook Group but decided to make it public for others trying to navigate the iCourt Portal and VINELink.

LINKS
Cool Cats and Criminals Facebook group: bit.ly/ccc-fb-group
Google Workbook: bit.ly/vd-cases
iCourt Portal: bit.ly/case-lookup

TIP
The name search for VINELink is intuitive. But for the iCourt Portal, you must enter the defendant's name as follows:
vallow, lori norene
daybell, chad guy

Do the Pics from Joseph Ryans Welfare Check Indicate Murder?

Annielytics 2021-04-17 | Joseph Ryan, Lori Vallow's third husband, was found dead in his apartment April 3, 2018. Six months later Lori is recorded in her first meeting with the Preparing a People group saying she wanted to murder him. Newly released photos from the day of his welfare check indicate he may have been lured out of fortress.

I'm Joe's sister, and I'll make a case for murder from the pics.

MINUTE MARKS
1:27 - The impetus for this revived advocacy effort
3:47 - Shout out to Garna Mejia
7:09 - Please sign the petition for PPD to investigate Joe’s death (bit.ly/jr-petition)
7:39 - My Facebook group I started to share these pics (bit.ly/ccc-fb-group)
13:34 - Why do I want Joe’s death investigated?
25:39 - When did Joe last see Tylee?
35:24 - Was Joe preparing to see Tylee?
41:52 - Note: Found out this was an iPad cover
49:07 - Where was Joe’s phone?
52:47 - Why was Lori deceptive in notes from PPD?
55:52 - Was Joe’s apartment ransacked?
1:05:09 - Note: Joe gave Akos a shout out on LinkedIn - he was a customer
1:25:04 - Why was Joe’s window open?
1:29:54 - Why is there no mold on the food?
1:31:44 - Why are women’s sunglasses in his bathroom?
1:33:09 - Why are there no pics of the garage?
1:34:34 - Let’s revisit 2007.
1:43:44 - Where are the files and albums?
1:58:55 - Does a person who hates his sister include her as a beneficiary?
2:13:34 - Q&A

LINKS
Petition: http://bit.ly/jr-petition
Cool Cats and Criminals Facebook Group: http://bit.ly/cool-cats-crims

13 Times Melanie Gibb Enabled Lori Vallow Daybell

Annielytics 2020-12-05 | Lori's extroversion created a need for a sidekick. Melanie Gibb fit the bill. In this Live we'll dive into some of the ways Melanie enabled Lori in her reign of terror. Melanie's role of enabler started the first week they met and continues to this day.

NOTE:
I had an allergic reaction to something I ate, and it set in partway through my Live. And my only mic with a mute button had issues during the last Live and had to be switched out. 🙄 So apologies in advance for the struggle I had at times to talk. If I had planned to keep going with Lives I would have invested in a new 🎙. I hate that if you edit anything in a Live video, the chat disappears...something I've learned the hard way. Hopefully the juice is worth the squeeze.

VIDEO BREAKDOWN:
Note: You can click on the timestamp to advance to that part of the video.

6:12 -: 1) Gave Lori a platform within days of meeting her
22:17 - 2) Introduced Lori and Chad
39:58 - 3) Met Jason Mow before meeting Lori at Gilbert PD
46:52 - 4) Was deceptive at GPD to vouch for Lori
55:50 - 6) Helped Lori evade the psych eval
1:06:26 - 6) Asked the wrong question re: Charles’ accident
1:13:12 - Examples of duping delight in Melanie’s interviews
1:19:29 - 7) Validated Lori’s motive for reuniting with Charles
1:23:02 - 8) Planned a meeting in Lori’s home 7 days after Charles was murdered (with surprising guest appearance)
1:37:27 - 9) Didn’t ask about Tylee
1:55:31 - 10) Didn’t order a welfare check when Lori called JJ a zombie
2:06:15 - 11) Didn’t try to save Tammy
2:11:21 - 12) Dodged RPD’s calls and then lied for Lori about JJ’s whereabouts
2:27:49 - 13) [Potentially] covered for Lori re: trip to look at property in Rexburg

Note: I take a deep dive into Melanie and David’s frustratingly vague and guarded (and contradictory) testimonies re: the events that transpired Sunday and make a case for the possibility that JJ had already been murdered when they went on this trip.

3:00:45 - Q&A
3:01:17 - Wish someone would do a video about Melani P.
3:02:00.- How do I feel about Chad’s adult children?
3:09:05 - Will I be in Idaho for the trial?
3:10:10 - Why wouldn’t JJ interact with Melanie and David?
3:17:14 - What do I think about other YouTube coverage of the case?
3:21:05 - Why am I leaving the true crime community?
3:24:09 - Am I doing any more Lives with other YouTubers?
3:24:56 - Do you suppose Alex Cox was murdered?
3:27:21 - I mention a neighbor of Chad's who died five days after JJ was buried who I hope LE investigates. His name was Eldon Clawson. Someone wrote in the TCU group: "He a rancher/farmer and was known to walk the ditch that ran by the Daybell home every morning. His cause of death was a sudden pulmonary embolism." This was the same COD as Alex Cox, btw. Link to obit: flammfh.com/obituary/eldon-clawson.
3:28:18 - More on duping delight.
3:30:35 - Did Alex die before Melanie Gibb came clean?

Note: I was wrong about Alex’s date of death. I said 12/19/19 and it was 12/12/19. I was going on memory.

3:31:27 - Will I be involved in the trial?
3:32:12 - Doesn’t Melanie still maintain Lori was misled by the dark?
3:34:37 - What scares me the most is there are not more charges.

Note: I meant to say “conspiracy to commit murder” not “accessory to commit murder." It was 12:40am and I was running on fumes.

Lets Talk Joseph Ryan

Annielytics 2020-10-31 | In this YouTube Live I delve into the life of my brother, Joseph Ryan. This is not a memorial or tribute. This is an honest, raw accounting of my complicated relationship with Joe. I round out the Live with my take on the allegations that have been made against him about sexual abuse, as well as why I believe Lori Vallow murdered him. The impetus that pushed me over the edge in addressing this issue was a recording someone sent me where Lori spoke openly about wanting to murder him.

TIMESTAMPS
The audio recording of Lori talking about wanting to murder Joe is at the 2:12:26 minute mark. Q&A starts at 2:57:12 minute mark. We just hang out the rest of the video.

Miscarriage of Justice in the Shooting Death of Charles Vallow

Annielytics 2020-09-19 | UPDATED VIDEO
I did another video digging into the joke of an investigation into Charles Vallow's murder on 2/25/22 on my A Murderous Heart YouTube channel using information from the Chandler Police Report that was released after I recorded this video. You can view it here: bit.ly/cv-murder.

I'm Tylee Ryan's aunt, and I dive into the role Chandler Police Department played in Lori Vallow's reign of terror. I will point to signs of what appears to have been an incomplete investigation at best and a coverup by CPD at worst. You decide.

PRESENTATION
Google Slides File:: bit.ly/charles-case

BREAKDOWN
00:3:58 - The timeline issue between Charles’ time of arrival and the 911 call
00:10:28 - Serious discrepancies in the number of shots fired
00:13:14 - Why is an officer picking up shell casings?
00:16:22 - Lack of blood spatter? (And yes, I know it should be ‘spatter’ not ‘splatter’.)
00:17:58 - Blood photographed but not sampled
00:19:14 - This officer made the decision to clean the large…what? Pool of blood?
00:21:14 - Question about the small cut on Alex’s head in comparison to his claim
00:21:53 - Approach to tackling the contradictions in claims explained
00:24:21 - Contradiction 1: Who had custody of JJ?
00:27:44 - Contradiction 2: Why did Tylee come out with the bat?
00:39:43 - Contradiction 3: How many times did Charles hit Alex with the bat?
00:53:51 - Contradiction 4: When did Alex enter the conflict?
00:57:38 - Contradiction 5: When did Charles [allegedly] attack Alex?
00:59:50 - Contradiction 6: How did Tylee fall down?
01:03:26 - Contradiction 7: Where were Lori and the kids when Alex shot Charles?
01:15:08 - Contradiction 8: Why did Charles [allegedly] attack Alex with a bat?
01:28:35 - LE’s generosity and gentleness toward Alex
01:30:54 - Lori and Alex’s glib affect and LE’s response to it
01:33:08 - Q&A

PLEASE LET PHOENIX POLICE KNOW JOE DESERVES JUSTICE TOO 🙏
Petition : bit.ly/jstc4joe

CASE RESOURCES
Case playlist from Annielytics channel: http://bit.ly/family-case
My timeline: http://bit.ly/jt-timeline
Case dashboard: http://bit.ly/jjt-video-dashboard
GoFundMe accountability: bit.ly/rexburg-kids-gfm

FACEBOOK GROUP
Cool Cats and Criminals: bit.ly/ccc-fb-group
Booted from Cool Cats: http://bit.ly/arctic-feline

Method to Her Madness: Events Leading to Charles Vallows Shooting

Annielytics 2020-08-28 | TECHNICAL NOTE:
There was a technical issue with the streaming tool I used, and it required me to start Chrome, but I had everything saved in 28 open tabs. I would jump to the 15:23 minute mark. YouTube won't allow you to edit a video with a copyright claim, and NBC submits copyright claims for any snippet from their show automatically (even though they fall within Fair Use).

VIDEO DESCRIPTION:
Charles Vallow wasn't shot by Lori Vallow's brother, Alex Cox, on impulse. I believe a lot of planning and negotiating went into preparing the way for Charles to be murdered. We'll take a deep dive into the people she used to this end.

VIDEO BREAKDOWN:
15:23 - I jump in talking about the Vallows' move to Gilbert 1/1/19. (Being Type A, I would skip past the introduction and my time of wrestling with a technical issue with the broadcast app.)
17:53 - Introduce Melanie Gibb (Lori Vallow Daybell’s bestie)
30:32 - Introduce David Warwick (Melanie Gibb’s boyfriend)
57:04 - Introduce Gabe Bonilla (Lori and Charles' bishop)
58:09 - Introduce Jason Mow (Talked about him in the last video at the 24 min mark: youtu.be/7RxV3FnSnhI?t=1453)
1:01:38 - D Day: Lori engages in campaign to isolate Charles from friends and family
1:16:14 - My theory that Lori didn’t catch Charles cheating but found porn
1:20:10 - Lori launches full frontal assault against Charles
1:35:46 - Gabe Bonilla’s betrayal of Charles
1:56:31 - My theory on why Charles stole Lori’s purse
1:59:17 - Gilbert PD’s incompetence and the role they played in Lori’s diabolical plan
2:11:34 - How to record a conversation (a tip that could have potentially saved Charles’ life)
2:15:32 - My case that Melanie Gibb lied about Lori going to Community Bridges for the psych eval
2:23:29 - Open Q&A

LINKS:
How Lori Vallow and Chad Daybell Justified Murder (last video): bit.ly/cult-murders
Dashboard: bit.ly/jjt-video-dashboard
Timeline: bit.ly/jt-timeline
How to use dashboard: http://bit.ly/db-intro
True Crime Underground Facebook group: bit.ly/tcu-fb
Reddit Email: bit.ly/insider-email
David Warwick's visions: bit.ly/dw-visions

Events Leading Up to Charles Vallows Death

Annielytics 2020-08-24 | Charles Vallow tried desperately to get help months before he was killed by Lori Vallow's brother, Alex Cox. Learn how a former Gilbert Police Department officer, Charles' bishop, and the Gilbert Police Department made it possible for Lori Vallow to go unchecked in her murderous agenda.

How Lori Vallow and Chad Daybell Justified Murder

Annielytics 2020-07-31 | Lori Vallow, Chad Daybell, and Alex Cox justified murdering by classifying their targets as evil spirits/zombies. I explain this group's "doctrine" of zombies, as well as explain where I believe this facet of their group's beliefs originated. (Spoiler alert: My money's on former police officer Jason Mow.) I take liberties in some of my analogies, but this story needs comic relief.

VIDEO BREAKDOWN:
0:08 - Intro
0:34 - Theory 1 of how Lori Vallow and Chad Daybell met: Sep 23
4:22 - Theory 2 of how Lori Vallow and Chad Daybell met: Oct 26
8:51 - I call BS on both of their accounts
9:46 - Chad rates Lori’s family members on a light/dark scale
14:22 - Chad and friends stay in Lori and Charles’ home for a Preparing a People event
15:36 - Lori and Charles’ mansion in Queen Creek
16:05 - Chad and Lori’s relationship deepens
17:23 - Melani Pawlowski’s take on Chad’s ratings
18:53 - Chad told Lori Charles was overtaken by a demon
21:34 - Parks & Rec reference (because this story needs comic relief)
23:09 - Deep dive into why the name Nick Schneider
24:12 - Introduce Jason Mow
25:49 - Jason, Lori, and Melanie Gibb’s weird love fest podcast
29:00 - Hat tip to Jason introducing Lori and Chad in the temple on 9/23?
29:44 - Jason Mow’s passive-aggressive social posts throughout the tragedy
32:26 - FBI investigated Jason Mow
38:30 - Melanie Gibb’s bizarre explanation for how she thought Charles would die
39:16 - My theory of how zombies were introduced into this group’s ethos / Speak No Evil trailer
41:40 - Jason Mow’s interview about the movie
44:44 - Fate of being labeled a zombie: death
47:27 - Ian Pawlowski’s documentation of Chad and Lori’s beliefs about zombies
55:46 - How Tammy Daybell reportedly became a zombie
57:45 - How Tylee Ryan became a zombie
59:19 - How JJ Vallow became a zombie
1:00:02 - David Warwick’s account of Lori’s crazy story about JJ’s final “zombie moment”
1:01:20 - Consistent theme: All Lori and Chad had to do to justify murder was call someone a demon

RELEVEANT LINKS:
Method to Her Madness: Events Leading to Charles Vallow's Shooting (the next video and my first YouTube Live): bit.ly/lori-method
Dashboard: bit.ly/jjt-video-dashboard
Timeline: bit.ly/jt-timeline
Intro Video: bit.ly/db-intro
True Crime Underground Facebook group: bit.ly/tcu-fb
Reddit Email: bit.ly/reddit-email
Ian Pawlowski’s Documents: bit.ly/ian-docs
Dateline: What Happened to JJ and Tylee: bit.ly/dateline-ep3
FBI Emails: https://fbi-emails
All of Me Takeover Scene: bit.ly/steve-martin-host

Using Data to Inform the Exploration into the Lori Vallow / Chad Daybell Case

Annielytics 2020-07-24 | Link to dashboard: http://bit.ly/jjt-video-dashboard. I embarked on a project to create transcripts from 15 interview and bodycam videos and a variety of legal documents around the Lori Vallow / Chad Daybell case. As an analyst, I structured those transcripts into a database format and built a searchable dashboard with lots of filters. I will be taking deep dives into this this case, using the dashboard to inform the exploration.

Rexburg Case Video Transcript Dashboard and GoFundMe Campaign to Support It

Annielytics 2020-06-02 | My niece is one of the missing kids from Rexburg, ID. I've been following the case closely and documenting key events, along with citations, in a timeline on my site. (Warning: as of date of publication, the timeline alone is 15k words.) If you'd like to support this GoFundMe to raise money for transcriptions of the videos (my services are obviously pro bono), you can go to this page: bit.ly/rexburg-video-gfm. Link to prototype dashboard: bit.ly/jjt-video-dashboard. Hell hath no fury like an analyst aunt scorned.

How to Create a Video Meme in Camtasia

Annielytics 2018-03-16 | Based on this post: http://bit.ly/video-meme. In this video I'll show you how to create a cool video meme in Camtasia.

Annielytics Live - October Edition

Annielytics 2016-10-22 | ...

Annielytics Live - August Edition

Annielytics 2016-08-11 | ...

Analytics Edge Tutorial - Annielytics Dashboard Course

Annielytics 2016-07-07 | Analytics Edge is a free Google Analytics API tool. Tori Cushing of Annielytics walks-through how to use this tool to import Google Analytics data into a custom reporting dashboard.

Annie Cushing uses to create interactive dashboard in the Annielytics Dashboard and API course: http://www.annielytics.com/annielytics-dashboard-course

Annielytics Live Hangout - Jun 2016

Annielytics 2016-06-15 | Bring your burning questions about Google Analytics to this monthly hangout.

Submit your questions here: http://bit.ly/hangout-questions .

Annielytics Live Hangout Explained - Jun 2016

Annielytics 2016-06-13 | Tori explains the ins-and-outs of Google Hangouts On Air. She covers your options with attending an Annielytics Q&A session.

You can be a presenter or an attendee. Both allow you to ask questions, but you have the option to share your screen and join the conversation as a presenter!

We encourage you to submit questions beforehand and let us know what you need help with: http://bit.ly/hangout-questions

The Worst Setting In Google Analytics

Annielytics 2016-06-02 | Based on this post: http://www.annielytics.com/?p=8605. Learn why the Default Page setting is the worst setting in Google Analytics and how to avoid its data-detonating powers.

Annielytics Live Hangout - May 2016

Annielytics 2016-05-18 | ...

How To Test Google Analytics Using Real-Time Reports

Annielytics 2016-05-16 | Based on this post: . One of the best ways to test your Google Analytics implementation is with GA's Real-Time reports. I show you some tips and tricks for how to do that.

Demystifying Social Reports In Google Analytics

Annielytics 2016-05-13 | Based on this post: http://www.annielytics.com/?p=8595. In this video I go through all of Google Analytics' social reports and disclose the good, the ugly, and the WTF.

How To Create Histograms For Marketers In Excel

Annielytics 2016-05-06 | Based on this post: http://www.annielytics.com/?p=8558. Histograms in Excel are tricky. I show you how to use the FREQUENCY function to create categories for your data and then build a histogram chart. All in plain English. (Because I know how scary Excel is for most marketers!)

How To Track Social Ads In Google Analytics

Annielytics 2016-04-29 | Based on this post: http://www.annielytics.com/?p=8501. Google Analytics doesn't provide a good default channel for social ads. I demonstrate why I think tagging social ads with a medium of cpc is a bad idea and proffer an alternative that will allocate all of your paid social into one, neat custom channel.

Annielytics Live Hangout - Apr 2016

Annielytics 2016-04-20 | Apr 20, 11:00 AM - 12:00 PM
http://www.annielytics.com

Bring your burning questions about Google Analytics to this monthly hangout.

Submit your questions here: http://bit.ly/hangout-questions.

FCFS: Questions submitted ahead of time will be answered first. If there are too many to answer in one hangout, we might just have to make this a regular thing. :)

Annielytics Live Announcement

Annielytics 2016-04-07 | Bring your burning questions about Google Analytics to this monthly hangout.

Where: http://bit.ly/annielytics-live

When: April 20th, 2016 2pm EST

Submit your questions here: http://bit.ly/hangout-questions.

FCFS: Questions submitted ahead of time will be answered first. If there are too many to answer in one hangout, we might just have to make this a regular thing. :)

Analytics Audit Template Promo

Annielytics 2015-12-07 | ...

How to Dynamically Generate URLs on the Fly in Excel or Google Sheets

Annielytics 2015-10-05 | Learn how to augment your marketing dashboards with links to reports within your table. I demonstrate two examples using SEMRush (a popular marketing tool) and Google Analytics.

Rand Fishkins Testimonial About the Annielytics Site Audit Template

Annielytics 2015-08-04 | See how Moz is using the Annielytics DIY Site Audit Template for internal training. You can use it to learn to do site audits or as a training doc.

How to Copy Cool Formatting from Someone Elses Site

Annielytics 2015-07-31 | Based on this post: http://www.annielytics.com/?p=6111 Have you ever come across something cool on a site but have CSS skills that are kind of hacked (like mine)? This tip will show you how to replicate any cool formatting you find across the web using Chrome Developer Tools.

Annielytics Dashboard Course for Marketers Overview

Annielytics 2015-07-26 | Learn more: http://www.annielytics.com/?p=5944. The Annielytics Dashboard Course is a 16-hour online course that teaches marketers how to make Google Analytics data sexy in Excel with interactive dashboards. You will learn how to use some of Google Analytics' advanced features (in preparation for the certification exam), rock the Google Analytics API, and build compelling visualizations that update dynamically each month when new data is imported from the API. 4 starter dashboards, 1 practice Excel file, illustrated workbook, office hours, and more!

Annielytics Site Audit Template

Annielytics 2015-07-26 | Based on: http://bit.ly/site-checklist. Learn how to do a site audit with my DIY template. I took my $20k audit and distilled it down to 156 checkpoints, covering 18 sections, with intro text for each section, step-by-step instructions, 90+ explainer graphics. No stone unturned. Also offered in Spanish. A steal at $195.

A Sneak Peek at Google Webmaster Tools New Sexy Search Analytics Report

Annielytics 2015-04-13 | Based on this post: http://www.annielytics.com/?p=5254. Google just released a new report that's still in beta but coming soon to Webmaster Tools accounts, and it's super sexy. It will replace the current Search Queries report. I highlight some of the new features in this video.

How to Copy Another Sites CSS Using Chrome Developer Tools

Annielytics 2015-04-12 | Have you ever come across some cooly formatted nugget on the Web and wondered how they did that? Well, you can find out exactly how anything was formatted by using Chrome Developer Tools to not only view the site's CSS but also modify it AND then save the CSS to use on your own site.

Create Full URLs from Google Analytics in Excel or Google Sheets

Annielytics 2015-04-11 | Google Analytics uses URIs instead of URLs by default. But that makes it difficult to marry your data with data from other marketing tools. This video will show you how to create full URLs from Google Analytics content reports, whether your site uses one subdomain or multiple subdomains. This process is called concatenation and could also be accomplished with the CONCATENATE function, but I find it clunky. Although I demonstrate how to do this in Excel, the steps are exactly the same in Google Sheets.

How To Use Chromes Mobile Emulation Feature To Get Your Site Mobile Friendly

Annielytics 2015-04-05 | Based on this post: http://www.annielytics.com/?p=5223. Google turned up the dial on mobile as a ranking signal in April 2015. The purpose of this video is to demonstrate, in simple terms, how marketers can use the Mobile Emulation Tool in Chrome Developer Tools to preview their site on any mobile device. (I really try to avoid geek speak as much as possible in these demos.)

How to Create Hyperlinks in Google Sheets Using the HYPERLINK Function

Annielytics 2015-04-03 | My site: http://www.annielytics.com. This video demonstrates how to use the HYPERLINK function in Google Sheets to create live links inside your spreadsheet.

How To Use Google Fusion Tables: A Simple Guide In Plain English For Marketers

Annielytics 2015-03-30 | In this video I demonstrate how to analyze your site’s backlinks using a network graph powered by a fusion table. To reduce the intimidation level of working with fusion tables (and they are a bit intimidating at first), I did a signature Annielytics take-you-by-the-hand approach to walking you through how to not only set up a fusion table but also how to massage the data once it’s in there and cull out the insights you can actually take action on.

How to Use the Mozbar to View Deleted Content on the Web

Annielytics 2015-03-28 | My site: http://www.annielytics.com. I demonstrate how I used the free Mozbar Chrome plugin to view an article that was deleted from the Search Engine Watch site after being debunked by Google.

How I Used the Mozbar to Discover We Were About to Launch New Site Without Facebook Markup

Annielytics 2015-03-28 | My site: http://www.annielytics.com. I work as the VP of Marketing for YourTango, and we're preparing to launch a Drupal migration. In checking out our new Twitter Cards markup I noticed, using Moz's free Mozbar that somehow our Facebook markup didn't get ported over. I show you how it saved us.

How to Detect and Debug Facebook Preview Issues Using the Mozbar

Annielytics 2015-03-28 | I noticed that TIME Magazine had a misspelling in the headline of one of their articles they shared on Twitter. After alerting them (but before they fixed it), I did a screencast of how to update your Facebook update after changing anything in the title or description of a shared article.

How to Fetch as Google to Index or Reindex a Page

Annielytics 2015-03-27 | This video will show how to submit a page to Google to get it crawled quickly or recrawled after making changes that yo want to show up in Google.

Monitor Marketing Updates with This Marketing Google Calendar

Annielytics 2015-03-25 | I keep a public Marketing News Google calendar to monitor updates with top sites, such as Google, Facebook, Twitter, etc. You can monitor these updates, correlate dips and spikes in your website traffic, and learn more about each update by adding it to your Google Calendar.

How to Disable Ad Blocker for Sites You Manage

Annielytics 2015-03-20 | This video demonstrates how to disable ad blocker for some sites. This can be important for marketers responsible for ads on a site who may want to see ads on the site(s) they manager (and possibly their competitors) without having ads run on every site they visit.

How to Replace Special Characters Using Find and Replace in Word

Annielytics 2015-03-17 | In this video I demonstrate how to find and replace special characters in MIcrosoft Word, like carriage returns, to convert columns of values from Excel into comma-separated lists.

How to Format Using the Format Painter in Excel, Word, and Google Docs

Annielytics 2015-03-16 | This video covers how to simplify formatting your content in Microsoft Excel, Word, and Google Docs using format painters.

How to Use Comments in Google Docs

Annielytics 2015-03-16 | This video demonstrates how to use comments in a Google Doc, recognize Google Docs that have comments, edit a comment, and delete a comment.