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

Lite Member

The Lite Membership really isn’t all that lite. You will receive quite a few benefits:

16+ Hours of Videos

Because we recorded a live seminar, these videos were designed to give you the feeling of actually attending the seminar. Except, you know, you can go to the bathroom whenever you want and attend in your pajamas. With a beer in hand. We supplemented the video with copious screencasts though so that you can see finer details than those who attended and were watching a screen in the front of a meeting room.

Below is a preview a video from Day 1.

buy-now-button

142-Page Workbook

This workbook is pure gold. It’s chock full of screenshots, links, and valuable notes. You can also access a Bitly bundle with all of the links included in the workbook.

Below is a smattering of screenshots from the workbook.

Google Analytics dashboards in Excel
Google Analytics dashboards in Excel
Google Analytics dashboards in Excel
Google Analytics dashboards in Excel
Google Analytics dashboards in Excel
Google Analytics dashboards in Excel
Google Analytics dashboards in Excel
Google Analytics dashboards in Excel
Google Analytics dashboards in Excel

2 Excel Dashboards

Excellent Analytics Dashboard

This dashboard uses the free Excel plugin Excellent Analytics. I go into a lot of detail in the course why this plugin isn’t good for businesses (because it hasn’t been updated in years and is missing access to the Multi-Channel Funnels). Because it uses pivot tables, there are things that need to be updated each month. But it has a macro that dynamically makes all the updates when you click on the update button.

Analytics Canvas Dashboard

Analytics Canvas is, hands down, my favorite Google Analytics API tool. And I believe I’ve tried all of them at this point. This dashboard uses AC and is completely automated because I show you how to pivot your data in Analytics Canvas, so you don’t need to use pivot tables in Excel (which have to be manually updated). You will learn in the course how to connect it with your own data, such as your goals, dimensions, views, etc. The entire dashboard updates with the click of a single button in Analytics Canvas, making reporting a breeze.

Analytics Canvas doesn’t offer an affiliate program. It would be more financially beneficial for me to promote other API tools. But, being a purist, it’s my favorite because I believe it’s the best. And, unlike Tableau, it stays on top of Google Analytics new features and many changes.

More Dashboards

To provide more examples of the kind of power you can achieve with marketing dashboards, I created a couple additional examples for members:

Excel dashboard for analytics data
Click for larger image and to reanimate

 

Click for larger image and to reanimate image
Click for larger image and to reanimate image

You will be able to download these files and apply them to your Google Analytics account.

Charting Practice File

Day 2 is all data visualization, and I go through a practice file I created for attendees to follow along with. You’ll see finished visualizations and will be recreating them as you follow along.

There are four tabs:

  • Table Formatting Practice
  • Conditional Formatting Practice
  • Chart Practice
  • Pivot Table Practice
Data visualization in Excel

buy-now-button

Analytics Canvas Template

Analytics Canvas allows you to bring Google Analytics API data right into Excel. It has a UI that’s easy to work with. But, for analytics aficionados, it provides a lot of advanced functionalities, such as renaming mistagged campaigns, pivoting, applying Excel-esque formulas to your data, grouping that the Google Analytics interface doesn’t allow, joining Google Analytics data with data from other sources (Google Spreadsheets, Excel files, other databases, etc.), and much more.

The template I created many demonstrates many advanced techniques that you can look at and learn from. For example, I recreate the new(ish) and super-awesome Channels report. This isn’t currently possible to do in the interface or the API. I was able to reverse engineer the Channels report so that you can do things like separate out social referral traffic from non-social referral traffic. (Google Analytics should give us this ability in all reports!)

Updating the template is made easier by the annotations I included throughout that let you know what elements need to be updated or modified to match your needs.

Below are a handful of screenshots from Analytics Canvas.

Google Analytics API tool
Google Analytics API tool
Google Analytics API tool
Google Analytics API tool
Google Analytics API tool
Google Analytics API tool

buy-now-button

Terms of Service

Please look over the Terms of Service to read all the scintillating fine print. At least check out the pic of my attorney after writing up this exhausting piece of legalese! 🙂

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