Saltar al contenido principal

Domo University Videos

Domo

Google Analytics Connector

Important: When referencing this page outside of Knowledge Base, use this link: http://knowledge.domo.com?cid=googleanalytics

Intro

Google Analytics generates detailed statistics about a website's traffic and helps measure sales and conversions. Domo's Google Analytics connector integrates with Google Analytics to extract data from the Google Analytics API. To learn more about the Google Analytics API, visit their website (https://developers.google.com/analyt...rting/core/v4/).

The Google Analytics connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window.

You connect to the Google Analytics API in the Data Center. This topic discusses the fields and menus that are specific to the Google Analytics connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Primary Use Cases

  • Understanding visitor traffic patterns on your website

  • Understanding visitor behavior patterns on your website

  • Understanding the relationship between geography and user behavior on your website

  • Understanding the difference between user behavior on mobile devices vs. desktop browsers

  • Understanding how social media drives traffic to your website

  • Understanding how users interact with products on your website

Primary Metrics

  • Page Views

  • Unique Visitor Counts

  • Return Visitor Counts

  • Product Sales Numbers

  • Geographic Patterns

  • Referring Domains

  • Conversion metrics

  • Bounce Rate

  • Exit Pages

Primary Company Roles

  • Data analysts

  • Digital marketers

  • Editorial teams

  • Marketing leads

Average Implementation Time

1-3 hours. The connector is fast, but more time may be required if you want to transform the data.

Ease of Use (on a 1-to-10 scale with 1 being easiest)

3

Training Videos - Connecting to Google Analytics

This two-part video guides you through the process of connecting to Google Analytics in Domo.

Part 1 of 2

 

 Part 2 of 2

 

 

Note: The product training videos are for Domo customers and clients only.

Best Practices

Prerequisites

To connect to the Google Analytics API and create a DataSet, you must have a Google email address and password for a Google account that is set up with appropriate access in your Google Analytics implementation.

Connecting to the Google Analytics API

This section enumerates the options in the Credentials and Details panes in the Google Analytics connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

The Domo Google Analytics connector uses OAuth to connect, so there is no need to enter credentials within Domo. Click Connect (or select Add Account if you have existing Google Analytics accounts in Domo) to open the Google OAuth screen where you can enter your Google username and password. Once you have entered valid Google credentials, you can use the same account any time you go to create a new Google Analytics DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Notes: 
  • If you are already logged into Google when you connect in Domo, you are authenticated automatically and taken to the authorization screen when you click Add account. If you want to connect to an account that is different from the one you are logged into, you must first log out of Google.
  • If your credentials don't work, or if you don't see the expected account, property, or view, contact your Google Analytics administrator. He/she can make sure you have the correct permissions on your account.

Data Selection Pane

This pane contains a number of configurable sections—Select Views, Select Reports, Select Segments, Select Duration, and Test My Configuration.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Select Views

In the Select Views section, select the accounts, properties, or views you want to retrieve data for. Usually each website you maintain has one or more associated views. If you don't see an item you expect to use, see the FAQs at the end of this topic.

Select Reports

You can select a predefined report or set up your own report.

Predefined Reports

In predefined reports, such as Google Analytics Audience Reports and Curated Domo Reports, a predefined series of dimensions and metrics is selected for you.

The following table lists and describes the Google Analytics Audience Reports:

Google Analytics Audience Report

Description

Active Users

Returns data for...

  • New Users

  • Sessions

  • Users

Behavior

Returns data for...

  • % New Sessions

  • Avg. Session Duration

  • Bounce Rate

  • Goal Completions

  • Goal Conversion Rate

  • Goal Value, New Users

  • Pages / Session

  • Pageviews

  • Sessions

...broken down by Count of Sessions, Days Since Last Session, and Session Duration.

Cohort Analysis

Returns data for...

  • Goal Completions

  • Pageviews

  • Revenue

  • Session Duration

  • Sessions

  • Transactions

  • Users

...broken down by Date.

Demographics

Returns data for...

  • % New Sessions

  • Avg. Session Duration

  • Bounce Rate

  • Goal Completions

  • Goal Conversion Rate

  • Goal Value

  • New Users

  • Pages / Session

  • Sessions

...broken down by Age and Gender.

Geo

Returns data for...

  • % New Sessions

  • Avg. Session Duration

  • Bounce Rate

  • Goal Completions

  • Goal Conversion Rate

  • Goal Value

  • New Users

  • Pages / Session

  • Sessions

...broken down by City, Continent, Country, Language, Metro, Region, and Sub Continent.

Interests

Returns data for...

  • % New Sessions

  • Avg. Session Duration

  • Bounce Rate

  • Goal Completions

  • Goal Conversion Rate

  • Goal Value

  • New Users

  • Pages / Session

  • Sessions

...broken down by Affinity Category (reach), In-Market Segment, and Other Category.

Mobile

Returns data for...

  • % New Sessions

  • Avg. Session Duration

  • Bounce Rate

  • Goal Completions

  • Goal Conversion Rate

  • Goal Value

  • New Users

  • Pages / Session

  • Sessions

...broken down by Device Category, Mobile Device Branding, Mobile Device Info, Mobile Input Selector, Operating System, Screen Resolution, and Service Provider.

Overview

Returns data for...

  • % New Sessions

  • Avg. Session Duration

  • Bounce Rate

  • New Users

  • Pages / Session

  • Pageviews

  • Sessions

  • Users

...broken down by Browser, City, Country, Language, Operating System, Screen Resolution, and Service Provider.

Technology

Returns data for...

  • % New Sessions

  • Avg. Session Duration

  • Bounce Rate

  • Goal Completions

  • Goal Conversion Rate

  • Goal Value

  • New Users

  • Pages / Session

  • Pageviews

  • Sessions

The following table lists and describes Curated Domo Reports:

Curated Domo Report Report

Description

Base Metrics

Returns data for...

  • Visits

  • Page views

  • Time on site

  • Bounces

...broken down by date.

Campaign Metrics

Returns data for...

  • Visits

  • Page views

  • Time on site

  • Bounces

...broken down by date and campaign.

Location Metrics

Returns data for...

  • Visits

  • Page views

  • Time on site

  • Bounces

...broken down by date, country, and region.

Mobile Metrics

Returns data for...

  • Visits

  • Page views

  • Time on site

  • Bounces

...broken down by date and by various mobile device-related dimensions.

Product Metrics

Returns data for...

  • Visits

  • Page views

  • Time on site

  • Bounces

...broken down by date and various product-related dimensions.

Social Network

Returns data for...

  • Visits

  • Page views

  • Time on site

  • Bounces

...broken down by date and social network.

Traffic Metrics

Returns data for...

  • Visits

  • Page views

  • Time on site

  • Bounces

...broken down by date, traffic source, and medium.

Customized Reports

In customized reports, you manually select dimensions and metrics to create your own report. Access this by selecting Show details. You can also find custom-defined dimensions, metrics, and goals in the Custom Variables or Columns section.

Select Segments

In the Select Segments section, select any segments you want to include.

Note: Using segments can lead to unexpected results. Unless you’re intimately familiar with Google Analytics or why your specific implementation calls for it, we recommend you avoid using segments.

Select Duration

Select the single date or date range that you’d like to pull data for. Specific dates can be selected with the calendar dropdown, or you can select a relative number of days back from the current date.

Test My Configuration

This tests whether the report that you’ve configured is valid. If you set up incompatible dimensions and metrics, this may cause an invalid configuration.

Troubleshooting

  • Check user permission settings if you are having trouble gaining access to data.

  • Check to make sure you are using the correct set of credentials.

FAQs 

What’s the best way to start deploying Google Analytics data in my Domo instance?

The Google Analytics QuickStart created by Domo (search for Google Analytics in the Appstore) is a great starting point. It automatically creates several of the most common DataSets you might want to use and builds some useful cards based off of these DataSets. Next, look at the Base Metrics report. It has most if not all of what most users are looking for. If you identify other data that you’d like to use, create a custom-defined report that covers that.

Why isn’t my recent data recorded by Google Analytics being reported in Domo, or why am I missing data when the DataSet has been appending daily?

Google Analytics has a 24- to 48-hour data latency period. It is best to accommodate this period of latency when you’re setting up the connector. For example, it may be best to assign the connector to pull "yesterday-2" or even "yesterday-3" reports.

Google 360 accounts have a much faster processing time. Enhanced data freshness normally takes 15-20 minutes depending on some factors. Enhanced data freshness is not applied to data that results from integrations with other products (Example: AdWords or any of the DoubleClick products). Visit Restrictions on enhanced data freshness to view some other restrictions.
 
The slowest possible data latency for 360 accounts is 24 hours.
 
The fastest possible data latency for 360 accounts is 15-20 minutes.
 
The chart on this page breaks down all the possible data latency periods based on the account and based on the query. Different queries have different data latency periods.

Where can I find help for building my query?

Use Google's Query Explorer to help test and build your queries. The Query Explorer may also give more insight on why the query isn't working.

How does Domo handle Google Analytics legacy fields?

Domo uses the latest terminology that exists in the Google Analytics interface. For a list of changes that have been made, see Google’s changelog documentation: https://developers.google.com/analytics/devguides/changelog

What limits does the Google Analytics API impose?

The API limits imposed by Google are specific to your account. If you’re running into limit issues, you can look into options for increasing you limits here: https://developers.google.com/analytics/devguides/config/mgmt/v3/limits-quotas#additional_quota

What should I be aware of when pulling unique metrics? (metrics quantified as unique over a time period).

An understanding of how unique metrics work is needed in order to properly define a report with them. Unique Metrics are defined within the time frame that you specify. If you use date, it will deliver the unique metric by day. Using another time grain, such as week, month, or year, will yield the unique metric by those time periods. Daily level unique values are non-additive. Google Analytics must calculate them at a time granularity. For example, two page views by one user on two different days during a week constitute two unique page views by day but a single unique page view for the week.

What rules exist for metric and dimension compatibility?

You may receive the following error: “The selected dimensions and metrics could not be pulled together.” If you do see this error, you’re receiving it because of the compatibilities that exist between certain metrics and dimensions. Only those that can be combined in the Google Analytics interface can be pulled into Domo. Refer to the Dimensions and Metrics Explorer to understand what dimensions/metrics can actually be queried together because not all combinations are valid.

Custom metrics and dimensions are defined at the web property level. We can only display your custom metrics/dimensions if you have one web property selected. Only views within the web property can use its custom metric/dimension. You can have as many views selected as you want as long as they belong to the same web property. The custom metrics and dimensions (if there are any) will be displayed under the "Custom Variables or Columns" section under the custom report.

How do segments work?

A segment is a subset of your Analytics data. For example, of your entire set of users  one segment might be users from a particular country or city. Within Domo, when you select multiple segments, we query a report for each segment you have selected. Learn more about segments here

You can also use your custom segments with this connector.  

How does "Include all views" work?

If you select to include all views, the query is run for every view each time the connector runs. That way, whenever you add or delete a view, you won't have to update the DataSet.

How do I pull my DoubleClick Campaign Manager and AdWords data?

The data available for these systems is available through the Domo connector in the Google Analytics interface. You will see the fields available in the Select Report section.

Why am I limited to 10 metrics and 7 dimensions?

This is a limitation given by the Google Analytics API. There is no way to add more than 10 metrics and 7 dimensions to a report.

What additional resources are available?

Query Explorer (https://ga-dev-tools.appspot.com/query-explorer/) and API Documentation, which includes the Dimensions & Metrics Explorer (https://developers.google.com/analytics/devguides/reporting/core/v4/)