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


Contents


Connect

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.


Select Profile

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


Metrics

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


Dimensions

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


Interval

Adjust the time period of the report.

Setting the time period


Segment

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


Filter

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

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

Sorting

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


See

Official Documentation

Back to top


Get help with this function in the community →