Saltar al contenido principal
waffle.svg
Domo

Google Analytics Advanced Connector

Version 2

 

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

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 to extract data from the Google Analytics API. To learn more about the Google Analytics API, visit their website (https://developers.google.com/analytics/).

Note: The user interface for building this connector is not yet available in our Connectors listing in the Data Center, meaning you will not be able to configure the connector on your own. However, we at Domo are more than happy to configure the connector for you so you can begin using it to pull your data into Domo. Please don't hesitate to reach out to your CSM or Domo Support. For contact information, see Getting Help.

You connect to your Google account in the Data Center. This topic discusses the fields and menus that are specific to the Google 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

If choosing the basic reporting functions you can plan on about an hour depending on how many reports you are pulling. However, if choosing the custom route, the time may be up to 2 hours. Also, depending on how much data you are pulling, it may take several hours for the data to be available in Domo.

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

5

Best Practices

  • It's important to note that when the report uses sample data, the sampled data is optimal. This can cause output discrepancies when comparing the Google API data to the reports available in the Google Analytics reporting tool. The sampling is designed to help the API perform optimally while still providing representative data.
  • When starting out, consider deploying the Google Analytics QuickStart App. The Base Metrics report has many of the fundamental metrics that are key to a Google Analytics dashboard.

Prerequisites

To connect to the Google Analytics API and create a DataSet, you must have a Google email address and password.

Connecting to Your Google Account

This section enumerates the options in the Credentials and Details panes in the Google 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 Advanced 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 accounts in Domo) to open the Google OAuth screen where you can enter your Google email address 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 Advanced 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.

Note: If you are already logged into Google when you connect in Domo, you are authenticated automatically 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.

Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the Google Analytics report you want to run. The following reports are available:

Base Metrics Returns data for visits, page views, time on site, bounces, etc., broken down by date.
Campaign Metrics Returns data for visits, page views, time on site, bounces, etc., broken down by date and campaign.
Custom Lets you build a custom report in which you select the dimensions and metrics you want to appear.
Custom MCF (Multi-Channel
Funnels)

Lets you build a custom Multi-Channel Funnel report in which you select the dimensions and metrics you want to appear.

For information about Multi-Channel Funnel reports in Google Analytics, see https://support.google.com/analytics.../1191180?hl=en.

Location Metrics Returns data for visits, page views, time on site, bounces, etc., broken down by date, country, and region.
Mobile Metrics Returns data for visits, page views, time on site, bounces, etc., broken down by date and by various mobile device-related dimensions.
Product Metrics Returns data for visits, page views, time on site, bounces, etc., broken down by date and by various product-related dimensions.
Social Network Returns data for visits, page views, time on site, bounces, etc., broken down by date and social network.
Traffic Metrics Returns data for visits, page views, time on site, bounces, etc., broken down by date, traffic source, and medium.
View (Profile) Select all profiles you want to retrieve data for. Usually each website you maintain has one or more associated profiles.
Sampling Level

Select the sampling level for the report. (This only applies if the report is forced to use sampled data.)

For more information about sampling in Google Analytics, see https://developers.google.com/analyt...nceptsSampling.

Filters

Enter any dimension and metric filters you want to apply to your report. Use commas (,) for OR cases and semicolons (;) for AND cases.

For more information about utilizing Google Analytics filters, see https://developers.google.com/analyt...erence#filters.

Start Date

Enter the start date for your report using the date format yyyy-MM-dd. You can also use the relative keywords today or yesterday or specify offsets such as yesterday-3. This would set the start date to three days in the past, starting from yesterday's date.

If you do not specify a start date, your report uses a default start date of 30 days (or 397 days for the Base Metrics report).

End Date

Enter the end date for your report using the date format yyyy-MM-dd. You can also use the relative keywords today or yesterday or specify offsets such as yesterday-3. This would set the end date to three days in the past, starting from yesterday's date.

If you do not specify an end date, your report uses a default start date of 30 days (or 397 days for the Base Metrics report).

Backfill Enter the number of past days you want to retrieve data for on the first run (based on the End Date value). Subsequent runs do not backfill data.  
Dimensions Select up to 7 dimensions for your report.
Metrics Select at least one metric for your report. You can select up to 10.

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.

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.

  • When validating data between the API data and the front end reporting tool, always check to see if the data was sampled or not.