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!



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

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.

Select 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.

Select Profile

Use this drop-down menu to select one of the sites connected to your account.


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.


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.


Adjust the time period of the report.


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


Specifies a subset of all data matched in Google Analytics.

 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.

Sampling Level

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


Official Documentation

Back to top

Get help with this function in the community →