Note: Bad news — All the cool API Excel extensions are PC swim only.
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.
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.
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.
This dashboard has a tons of complex calculations that pull together this beautiful final product. Here is just one example:
And here’s a look at the full dashboard.
You can download it here.