Access Google Analytics in Excel

Google Analytics is one of our most popular Connectors. It offers user-friendly methods of extracting custom metrics straight into Excel. The days of messing around with exported text files and manual filtering are over!

Example of Google Analytics Connector inside Excel



Click on the Google Analytics icon in the SeoTools menu bar, followed by the Login button:
Connecting your account

Select Account

SeoTools uses an Oauth 2 solution which means users are able to chose from a list of all accounts connected to Google, or add new accounts.
Selecting your account

Select View

Selecting the view * Core Reporting - Gives you access to most of the report data in Google Analytics.

  • Multi-Channel Funnels Reporting - Enables you to request Multi-Channel Funnels data for an authenticated user. Data is derived from conversion path data, which shows user interactions with various traffic sources over multiple sessions prior to converting.

  • Profiles - Allows you to extract a list of all sites connected to your account, including profile id, profile name, property id and property name.

  • Custom Dimensions - Allows you to extract a list of all custom dimensions in a profile

  • Custom Metrics - Allows you to extract a list of all custom metrics in a profile.

Select Profile

Use this profile selection window to select a profile in your account.
Selecting your profile


SeoTools implementations the Google Analytics Query Explorer which makes it easy to search and select the right metrics. The explorer also provides a description for every metric that is clicked.
Choosing the metrics

Custom Metrics

Custom metrics have the code ga:dimension with a unique number at the end (ga:metric1). Too identify which code represents your custom metric, use the connector Custom Metrics to extract a list of all metrics for a profile:


The Query Explorer handles dimensions in the same way as metrics. Select the dimensions that are suitable for the metrics and SeoTools takes care of the rest.
Choosing the dimensions

Custom Dimensions

Custom dimensions have the code ga:dimension with a unique number at the end (ga:dimension1). Too identify which code represents your custom dimension, use the connector Custom Dimensions to extract a list of all dimensions for a profile:

The custom dimensions also shows up in the selection list directly:


Adjust the time period of the report.

Setting the time period


Allows the user to create a report that are limited to a particular segment such as traffic type, source type, and user type.

Defining the segments


Specifies a subset of all data matched in Google Analytics.
Settings filters to use

 Equals: ga:country==Sweden
 Regular expressions: ga:city=~^New.*


The Query Explorer also makes it easy to sort the results according to your preferences. Select a metric and the sorting direction.
Sorting the results

Sampling Level

Use this parameter to set the sampling level (the number of sessions used to calculate the results) for a reporting query.

Choose a sampling  level


Official Documentation

Back to top

Get help with this function in the community →