This website or its third-party tools use cookies which are necessary to its functioning and required to improve your experience. By clicking the consent button, you agree to allow the site to use, collect and/or store cookies.
The platform this site runs on doesn't have the option to turn off cookies server side, but you can do that in your browser and then return to the site.
I accept
Deny cookies Go Back

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

© 2023 annielytics.com