How to automate Google Analytics data in your excel document

Mike Grindy 06/05/2015 2 minutes

Automation

Tired of manually copying data from Google Analytics to your client friendly excel dashboard? I was!

I stumbled upon this great Microsoft Excel Addin called “Analytics Edge” which allows you to automate the whole process, with just a few clicks!

This guide and sample will show you how to automate Google Analytics data in your excel document, no longer will there be mistakes or hours spent tediously copy and pasting data.

What is Analytics Edge

https://www.youtube.com/watch?v=pNs9olDdjVQ

The Analytics Edge Basic Add-in lets you place query results anywhere on a worksheet, and you can have as many queries as you want. They all refresh with a single click!

There is the free and paid version of the addin. The free Google Analytics connector has all of the features and capabilities as the paid version, but lacks access to multichannel funnel data. No login limit, no profile limit, no query limit.

All the latest dimensions and metrics, dynamic date ranges, custom segments and filters, download more than 10,000 rows, and minimize data sampling errors. Dates are downloaded as Excel dates, percentages ready to be formatted as % in Excel, and numeric dimensions can be downloaded as either text or numbers.

Analytics Edge takes the pain out of working with the Google Analytics API. For users of Excellent Analytics, the connector also includes an in-place query converter.

Free Sample

I have created a “Starter Dashboard” with the use of the Analytics Edge Addin, the dashboard will allow you to automatically pull data and generate reports.

  1. Download and Install the Analytics Edge excel Addin.
  2. Download and open the Starter Dashboard.
  3. Connect your Google Analytics account in Excel by going to “Analytics Edge” > “Accounts” > Following the instructions and ensuring to select the appropriate view.
  4. Click “Refresh all” under “Analytics Edge” Ribbon.
  5. Watch the data pull in automatically.

A few notes

  • The “Auto Data” tab can be hidden and data can be refreshed as required, it’s sole purpose is for creating the queries, and linking them to the other tabs.
  • The dates under the “Auto Data” tab are automatically generated based on formulas. If these are removed or moved elsewhere it will affect the functionality of queries.
  • Changing the “Auto Data” tab name will cause current queries to break.
  • Current queries can be edited by selecting the cells with the red triangle ribbon and under the “Analytics Edge” ribbon clicking on “Edit Query”.