Google Analytics Logo Short Google Analytics + Google Sheets Logo Short Google Spreadsheets =

How to import Google Analytics to Google Sheets

Do you need to import Google Analytics data into an Excel format in order to analyze website traffic or even compare it with marketing data from other tools?

One easy way to accomplish this is with the Google Sheets Addon KPIBees. The Addon can be installed and connected to Google Analytics in just a few clicks – no other setup needed! 

Using the KPIBees Addon, you can select a predefined template from our Template Gallery or you can create a custom query and bring the data into your selected cell in the spreadsheet! It has never been easier to create your own business kpi report to compare Google Analytics data with all your digital marketing tools and 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 Google Analytics integration and grant access to your Google Analytics account.

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: Refresh your created marketing reports at any time using the Refresh All Queries – you’ll never have to worry about your data not being up to date.

Step 9. Whenever a reports refresh happens in your kpi dashboard, you can set email notifications and receive the exported data by in the following formats PDF, Excel, TSV or Webpage. Besides email, you’re a heavy Slack user like we are, 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. . We are just getting started with adding templates, so if you have a brilliant dashboard idea, feel free to share it us and we’ll partner up.

Here’s our ready to use templates:

Google Analytics Metrics Marketing Reporting Dashboard

Google Analytics Key Metrics Worldmap

What Google Analytics reporting data can you get in Google Sheets

There’s really no limit to what Google Analytics data can be pulled into Google Spreadsheets as KPIBees integrates the Google Analytics core reporting APIs fully. 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 someone from Paris, using Chrome, searched on Google for the keyword "marketing spreadsheets templates" and clicked on your website in the search results. The Dimensions of this visitor would be Country=France, City = Paris, Browser = Chrome, Keyword = marketing spreadsheets templates.
    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: The general category of the source of traffic, for example organic search (organic), cost-per-click paid search (cpc), web referral (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", you have the following characteristics: 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 after which they didn't visit any other pages anymore.
    • 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: Pageviews is the total number of pages viewed with the repeated views of a single page are counted.
    • 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 Segments
    A Segment is a subset of your data and offer a way to "split" it based on certain conditions. For example, let's assume that you could have a segment of users that made a successful purchase or a segment of 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: