Annielytics.com

I make data sexy

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

Aug 24 2016

Analytics Edge: Free, Reliable, Everything Excellent Analytics Wasn’t [VIDEO]

Analytics Edge intro

Note: Bad news — All the cool API Excel extensions are PC swim only. 

Backstory

When the Annielytics’ Dashboard Course was first released, Excellent Analytics was the best option for a free Google Analytics API tool. But now Excellent Analytics is no longer available, so we’re providing training on a new-and-improved option: Analytics Edge.

Video

This excellent tool (never heard that one before, I’m sure) allows you to pull data from the Google Analytics’ API into fancy reports each month.

The setup process can be a bit tricky, so I created a five-minute video walkthrough of the the user interface and the account connection process.

Trying to set up new tools without video tutorials.

Analytics Edge has extensive number, date, filtering, and sorting options that are all covered in the tutorial below. I also demo how to dynamically add dimensions and metrics into your dashboard.

Free Dashboard

This dashboard is one of the dashboards available in the Annielytics Dashboard Course and mini-course. But we’re giving you this dashboard with Analytics Edge integration for free.

This dashboard has a tons of complex calculations that pull together this beautiful final product. Here is just one example:

dashboard

And here’s a look at the full dashboard.

analytics-edge-dashboard

You can download it here.

Written by Tori Cushing · Categorized: Analytics · Tagged: Analytics Edge, Excel Dashboards, Excellent Analytics, Google Analytics API, Google Analytics Dashboards

Comments

  1. David says

    August 31, 2016 at 1:14 PM

    Can’t wait to try this ! I’ve used similar tools in Google sheets, but this looks like it might be a little more comprehensive, but still well laid out.

    Reply
    • Annie Cushing says

      September 1, 2016 at 2:40 PM

      Yeah! It’s an impressive tool!

      Reply
  2. Simon James says

    September 6, 2016 at 1:29 PM

    I started using it last month.
    It’s great, but it took a long time to get working with Excel 2010, due to remnants of other deleted add-ins clogging up my registry. (And the Office Help function stopped working…)

    I bought Annie’s Analytics Audit Template yesterday and decided that if I’m going to customise a near 200 pages document I should probably ditch my old fuddy duddy Office and get a shiny new subscription to Office 365.
    But my concern is that with the automatic updates to 365, I might experience “downtime” with Analytics Edge whilst Mike is incorporating changes (although judging by the speediness of responses to my support questions , I suspect that he is an insomniac).

    Reply
    • Annie Cushing says

      September 6, 2016 at 7:46 PM

      Lol! I suspect you might be right about Mike! Good luck! I’d love to hear how it goes!

      Reply
      • Simon James says

        September 7, 2016 at 6:58 AM

        Many thanks.
        I have a quick question, if you get a spare moment… but I’ll send it via your contact form just in case it’s not the sort of answer you wand visible to the public.

        Best
        Simon

        Reply
  3. Fulfillment Logistics UK says

    October 15, 2016 at 5:48 AM

    Google Analytics is a great tool, if you take the time to use it correctly. What get’s me is Google’s constant need to update their algorithms. My latest annoyance with Google is the inability to use the Keyword Planner for free, the need to run a campaign purely to get keywords!

    Reply
    • Tori Cushing says

      October 17, 2016 at 5:26 AM

      I agree! GA can be so powerful. But it’s also very easy to mess up a lot of your data in small settings.

      My go-to for keywords is SEMRush.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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