Annielytics.com

I make data sexy

  • About
  • Resources
  • Services
  • Blog
  • Contact
  • Log In

Feb 05 2021

Regex for Marketers: Plain English, Real World Examples [VIDEO]

I'll admit it: I used to be a regexaphobe. When I was new to analytics, I remember someone sending me a snippet of regular expressions (AKA regex) to … [Read more...]

Written by Annie Cushing · Categorized: Programming · Tagged: Google Analytics, Google Docs, Google Sheets, Regex, Regular Expressions, Screaming Frog, Tableau

May 06 2016

How To Create Histograms For Marketers In Excel [VIDEO]

Histogram charts are great tools for marketers, but unfortunately Excel doesn't make the process of creating them terribly intuitive. But I'll try to … [Read more...]

Written by Annie Cushing · Categorized: Excel · Tagged: Excel Charts, Excel Formulas, Screaming Frog

Feb 21 2014

21 Real-World Examples Of Concatenating Marketing Data In Excel

Hey! Welcome to another edition of #FunctionFriday! One of Excel’s Swiss army knives for marketers is the ability to concatenate things and stuff. Oh, … [Read more...]

Written by Annie · Categorized: Excel · Tagged: AdWords, Excel Formulas, Function Friday, Screaming Frog

Feb 03 2014

How To See If You’re Trashing Your Analytics With Campaign Tracking

Okay, I'm back from my blogging hiatus. I took a few months off from all blogging (guest blogging as well as my site) to focus on training for myself. … [Read more...]

Written by Annie · Categorized: Analytics · Tagged: Googe Anal, Google Analytics, Screaming Frog

Dec 23 2012

How To Create Pivot Tables In Excel [VIDEO]

By popular demand, I've created a video walk through of how to create and customize pivot tables. If you haven't use pivot tables, they are especially … [Read more...]

Written by Annie · Categorized: Excel · Tagged: Ahrefs, Google Analytics, Majestic, Open Site Explorer, Pivot Tables, Screaming Frog

CAN I HELP YOU FIND SOMETHING?

‘MAKING DATA SEXY’ IS LIVE ?

Want to learn how to create compelling, aesthetically pleasing charts in Excel? Learn how with Making Data Sexy.

Note: Also offered for Mac

STUFF I BLOG ABOUT

LEARN HOW TO USE ALL THE TOOLS

marketing strategy guide

DIY marketing strategy guide. This guide provides step-by-step instructions on how to perform 66 unique marketing tasks using 15 reputable marketing tools (both free and paid). Steal it for $295! Learn more.

LEARN TO DO A SITE AUDIT

site audit template

DIY site audit template. 20 sections, 215 checkpoints, 100+ explainer graphics, 218 pages, step-by-step instructions. Steal it for $295! Learn more.

LEARN TO DO AN ANALYTICS AUDIT

analytics audit template

DIY analytics audit template. 8 sections, 61 checkpoints, 100+ explainer graphics, 205 pages, step-by-step instructions. Steal it for $295! Learn more.

TO THIS DATA I DO THEE WED

dashboard course

Learn to build dynamic dashboards in Excel with Google Analytics data. 16 hours of video, 3 sample dashboards, 142-page workbook, practice Excel file, and more! Learn more.

FOLLOW ME ON TWITTER

SUBSCRIBE TO MY YOUTUBE CHANNEL

Privacy Policy
  • Email
  • LinkedIn
  • Twitter
  • YouTube

© 2022 annielytics.com