Master Google Analytics API with Google Spreadsheets Add-on

In this post we’ll see how to add the Google Analytics Add-on to Google Spreadsheets and take advantage of all cool things you can do with GA API, no coding skills required.

First, we’ll add the Google Analytics Add-on to Google Spreadsheets. Just login to Google Drive and click Create – Spreadsheet.

step1

In your empty spreadsheet select Add-ons – Get Add-ons:

Add add-ons

A pop up will open with the available add-ons, just use the search field in the top right corner to look for google analytics and select one called Google Analytics by clicking the + Free button on the right:

Select the GA add-on

The add-on will ask you for permissions, just scroll down and click on Accept:

Accept permissions request

That’s all! Now you can build your first report with the GA API. Go to Add-ons – Google Analytics – Create new report

Get started configuring your GA report

The tool will help you with the initial setup of your report – you can enter a Name for the report, select the account, property and view you’ll be pulling data from, and choose metrics and dimensions.

Here’s how a test report configuration looks like:

Report configuration settings

By default the tool will select the last 7 days, you can also specify specific start and end dates by removing the value next to Last N Days and enter the dates you want following the YYYY-MM-DD pattern. In this example I want to see the number of sessions for 3 dimensions simultaneously: source / medium, landing page and date. You can also sort, add filters and segments, define max results, etc.

Let’s run our report and see what data we’ll get. Just click on Add-ons – Google Analytics – Run Reports:

Report configuration settings

Google Spreadsheets will think a bit and return a success message when ready:

Successfully run report

And the results (by default sorted by the first column):

GA report is ready!

Of course there’s a lot more to say for this handy tool which I’ll do in future posts.
Here are some really useful links that you should bookmark as you’ll use them a lot for reference:

1. Dimensions and Metrics Reference

2. Configuration parameter reference

3. More details how to build your filters and segments, and sometimes even the Segments Dev guide

Next time we’ll see how to get more insights of our conversion visits and different paths. Stay tuned!

P.S. Got a Google Analytics question? Send it to me and I’ll try to answer it on the blog.

is a Google Analytics fan, who also loves SEO, conversion optimization, online marketing and social media. You can follow her on Twitter and LinkedIn.

3 thoughts on “Master Google Analytics API with Google Spreadsheets Add-on

  1. Pingback: How to create conversion page path report in GA

  2. Hi I am trying to filter session greater than 1000. How would I go about doing this
    I have tried ga:sessions > 1000 in the filters section of the configuration option with no luck.

    Thank you

Leave a Reply to Margarita Evtimova Cancel reply

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