Configuring Google Analytics

Overview

Google Analytics provides valuable insights into your website's traffic and user behavior. By connecting your Analytics properties, you can export this data to Google Sheets for further analysis, reporting, and visualization.

Prerequisites

Before you can configure Google Analytics exports, make sure you have:

• Connected your Google account (see Connecting Your Google Account)
• Granted Google Analytics access permissions to your account
• At least one property set up in Google Analytics
• Connected at least one Google Sheet (see Configuring Google Sheets)

Adding Analytics Properties

To export data from Google Analytics, you first need to select which properties you want to connect:

1. Access the Google Integration Dashboard

   From your account dashboard, navigate to Connections > Google Integration.

2. Find the Analytics Section

   In the Google Integration dashboard, locate the Google Analytics section.

   

   The Analytics section in the Google Integration dashboard

3. Add an Analytics Property

   Click the "Add Property" button to open the property selection dialog.

4. Select a Property

   From the dropdown menu, select the Analytics property you want to connect. The list shows all properties you have access to in Google Analytics.

   

   The property selection dialog showing available Analytics properties

5. Confirm Your Selection

   Click the "Add Property" button to connect the selected property to your account.

Managing Connected Properties

After connecting Analytics properties, you can manage them from the Google Integration dashboard:

Creating Analytics Exports

Once you've connected your Analytics properties, you can create exports to send data to Google Sheets:

1. Navigate to the Export Builder from your dashboard
2. Click "Create New Export"
3. Select "Google Analytics" as the data source
4. Choose the Analytics property you want to export data from
5. Select a Google Sheet as the destination
6. Configure the export settings (see below)
7. Set up a schedule for the export
8. Click "Create Export" to save your configuration

For detailed instructions on creating exporters, see our Creating Data Exporters guide.

Analytics Export Settings

When configuring an Analytics export, you'll have several options to customize what data is exported:

Basic Settings

Configure the fundamental settings for your export:

• Export Name: A descriptive name to identify your export
• Date Range: Select how much historical data to include:
  • Last day
  • Last 7 days
  • Last 30 days
  • Last 90 days

Dimension Tabs

Analytics exports are organized by dimensions, with each dimension creating a separate tab in your Google Sheet. The interface uses a tab-based layout where you can configure each dimension independently:

The tab interface for configuring different dimensions

Common dimensions include:

• Date: Performance data broken down by day
• Source/Medium: Traffic sources and mediums (e.g., google/organic, facebook/referral)
• Country: Geographic locations of your users
• Device Category: Types of devices used (desktop, mobile, tablet)
• Landing Page: The first pages users visit on your site
• Campaign: Marketing campaign data

For each dimension tab, you can:

• Enable/Disable: Choose whether to include this dimension in your export by selecting metrics
• Set Data Handling: Choose whether to append new data or replace existing data
• Select Metrics: Choose which performance metrics to include for this dimension

Metrics Selection

For each dimension, you can select which metrics to include in your export:

The metrics selection interface for a dimension

Available metrics include:

• Sessions: Total number of sessions
• Users: Number of unique users
• Pageviews: Total number of page views
• Pages/Session: Average number of pages viewed per session
• Avg. Session Duration: Average length of a session
• Bounce Rate: Percentage of single-page sessions
• Goal Completions: Number of goal completions
• Conversion Rate: Percentage of sessions that resulted in goal completions

You can use the "Select All" and "Deselect All" buttons to quickly manage your metric selections.

Data Handling

For each dimension tab, you can choose how to handle the exported data:

• Replace (default): Each export run will clear existing data and replace it with new data
• Append: Each export run will add new data rows without removing existing data

The append option is particularly useful for building historical datasets. When enabled, new data will be added to existing rows rather than replacing them.

Best Practices

• Focus on Key Metrics: Select only the metrics that are most relevant to your analysis to keep your exports manageable
• Use Multiple Dimensions: Create exports with different dimensions to analyze your data from various angles
• Regular Scheduling: Set up daily or weekly exports to build a comprehensive historical dataset
• Combine with Other Data: Use Google Sheets to combine your Analytics data with data from other sources like Search Console or Ads
• Create Custom Reports: Use Google Sheets' charting and pivot table features to create custom reports from your exported data

Troubleshooting