Connect Google Analytics to Google Sheets in 2020

mysql to spreadsheets Google Analytics + Google Sheets Google Spreadsheets

 =

KPIBees Google Add-on.
Install KPIBees Add-on for Google Sheets

How to connect Google Analytics to Google Sheets

Do you want to connect Google Analytics to Google Sheets in order to analyze website traffic? Or even compare it with marketing data from other tools? Without the need to write any code or Google Apps Script?

One easy way to export Google Analytics data to Google Sheets is with KPIBees. The Add-on can be installed and connected to Google Analytics in just a few clicks – no other setup needed!

The KPIBees Addon enables you to create custom Google Analytics queries inside spreadsheets. When a query is ran, the data is exported into your selected spreadsheet cell. Besides automatically importing numbers from Google Analytics to Google Sheets, you can also import other digital marketing tools or company data.

Here all the integrations to Google Sheets that KPIBees supports.

STEP 1

Go to the KPIBees Gsuite Marketplace listing and install the Google Sheets Addon.

STEP 2

You’ll be asked to give access to KPIBees on your Google account. Don’t worry, KPIBees is GDPR compliant and safe to do so.

STEP 3

Open any spreadsheet and go to Add-ons in the page menu and click on Launch. 

Google Sheet Add-on location toolbar.

STEP 4

Click on the Google Analytics integration and grant access to your Google Analytics account(s).

Authorize Google Analytics with Google Sheets

STEP 5

Create a query with your desired parameters, including  date ranges, and click save. Please be aware that some metrics and dimensions can’t be queried together. If you stumble over such an issue, remove dimensions and repeat the query until it runs.

Create a query with with GA Metrics, GA Dimensions and GA Segments

STEP 6

After clicking save, the query runs and brings the data into your selected spreadsheet cell! Even more so, the google sheet add-on remembers the position of the query and query itself. This enables you refresh at any point in time, either manually or automatically. This is great for marketing reports and it completely automates the process once you set it up!

Get Analytics data in a spreadsheet cell

STEP 7

You don’t need to create any new reports when you need this data again. KPIBees keeps track of all your queries and you can configure reports to run automatically! 

Automate marketing reporting with Google Analytics

STEP 8

The addon offers the ability to refresh your created marketing reports at any time using the Refresh All Queries. With this function, you never have to worry about your data not being up to date.

STEP 9

You can schedule refresh times for your queries. When a refresh occurs, you can send email notifications with the exported data in formats like PDF, Excel, TSV or Webpage. Besides email notifications, there’s an option to receive these Google Analytics marketing reports straight to your Slack!

Google Analytics Marketing Reporting Templates

KPIBees offers predefined Google Analytics sheet templates that you can easily use. As a result, there’s no setup needed to get started with the templates besides authorizing Google Analytics. Also the templates can be exported in other formats like PDF, Excel, TSV or Webpage. 

What Google Analytics reporting data can you get in Google Sheets

Any data that’s available in Google Analytics can be pulled into Google Spreadsheets. KPIBees integrates with all the Google Analytics core reporting APIs.

You can select any type of metrics, and dimensions – there are over 400 metrics and dimensions to select from! – and segment the query in any type of way. Let’s quickly go over what these parameters mean and mention which ones are available.

  • GA Dimensions

The Dimensions are attributes of your website visitors.
For example, let’s assume that you had a website visitor from Paris that was using Chrome. The Dimensions of this visitor would be Country=France, City = Paris, Browser = Chrome.
Here’s a list of the most commonly used Dimensions to pull Google Analytics data to sheets:

  • GA Country: The country of visitor.
  • GA City: The city of the visitor.
  • GA Browser: The browser of the visitor.
  • GA Landing Page: The first page seen in a visitors’ browsing session.
  • GA Exit Page: The last page a visitor visited in his/her browsing session.
  • GA Session Duration: How long the visitor browser session lasted.
  • GA Source: The general origin of your traffic, for example search engines or a certain domain referrer.
  • GA Medium: Defines the general category of the source of traffic such as organic search, paid search, web referral.
  • GA Keyword: The keyword that user searched in order to reach your website by clicking it.

  • GA Metrics

In Google Analytics, a Metric is a number that is used to count the characteristics of Dimensions.
For example, for the Dimension Source/Medium, there are characteristics like Session, % New Session, New Users, Bounce Rate and so on.
Here’s a list of the most commonly used Metrics to pull Google Analytics data to sheets:

  • GA Users: The overall number of visitors.
  • GA Sessions: The number of overall browsing sessions that the visitors did on your website.
  • GA Bounce Rate: The percentage of visitors that visited a single page in a browsing session.
  • GA Average Session Duration: The average duration of the visitors browsing sessions.
  • GA Pageviews: The total number of page viewed by your visitors.
  • GA Pageviews by Page: This metric represents the total number of pages viewed for a given Page.
  • GA Goal Completions: Displays the total number of Goal Completions in Google Analytics visiting sessions.
  • GA Percentage of New Sessions: The percentage of new visiting sessions.
  • GA Sessions by Channel: The number of sessions grouped by channels like organic, direct, paid, social, email, etc.
  • GA Pages Per Session: The average number of pages viewed during your visitors sessions on your website.

  • GA Dimensions

A Segment is a subset of your data and offer a way to “split” it based on certain conditions.
Examples of segments could be a subset of your users that made a successful purchase. Or a subset of your users that came to your website via paid advertising.
Here’s a list of the most commonly used Segments to pull Google Analytics data to sheets:

  • GA All Users: All your website visitors.
  • GA New Users: Show only new visitors.
  • GA Returning Users: Show only returning visitors.
  • GA Paid Traffic: Show only paid traffic visitors.
  • GA Organic Traffic: Show only visitors that came to your website through organic search.
  • GA Direct Traffic: Show visitors that came to your website through directly.
  • GA Sessions with Conversions: Show only visitors that made a conversion on your website.
  • GA Mobile Traffic: Show only visitors that visited your website on a mobile device.
  • GA Android Traffic: Show only visitors that visited your website through an Android device.
  • GA iOS Traffic: Show only visitors that visited your website through an iOS device.

Combine Google Analytics data in spreadsheet reports with:

Install KPIBees Add-on for Google Sheets