416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
Dashboard v5.5

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Google Analytics - Data Provider Add-on

Hide navigation
RSS
Modified on Wed, 02 Dec 2015 04:59 PM Categorized as Add-ons, Data Connectors
Click to return to: Documentation | Dundas Dashboard Add-ons


Overview

Google Analytics is a service offered by Google that compiles statistics regarding visitors to a website.

This add-on lets you import website statistics data from your Google Analytics account.

Google Analytics account

You must have a Google Analytics account in order to use this add-on.

To sign up, go to: http://www.google.com/analytics

Google Analytics account.

Google Analytics account.


Setup

Google Developers Console project

You need to create or use an existing project in the Google Developers Console as a first step.

Go to https://console.developers.google.com/project and sign in to your Google/Gmail account.

Once signed in, you'll see a list of existing projects (if there are any) or you can click Create Project to create a new one. If you can't find the screen below because you're using the very latest console, there should be a toolbar menu option to Manage all projects.

Create a new project.

Create a new project.


In the New Project dialog, enter a name for your project and then click Create.

Enter the project name.

Enter the project name.


Enable the Analytics API

Make sure you are logged into the Google Developers Console and your project is selected as the current project.

Click APIs in the left navigation under APIs & auth to see the available Google APIs.

Click the Analytics API link under Advertising APIs.

Google APIs.

Google APIs.


Click Enable API.

Enable the API.

Enable the API.


If you're using a newer version of Google's Console UI as shown below, the steps are mostly the same. Make sure your project is the current one, and then click the menu button in the top-left corner to open the left navigation menu. Click API Manager and then click the Analytics API link.

API Manager.

API Manager.


Service Account Credentials

This section shows you how to generate Service account credentials which will be used to access your Google Analytics data.

In the Google Developers Console, click Credentials in the left navigation under APIs & auth. On the right, click Add credentials and select the Service account option.

Add Service account credentials.

Add Service account credentials.


Select the P12 option and click Create to generate a certificate file. This file will be needed later to set up a data connector in Dundas Dashboard.

Create a P12 key.

Create a P12 key.


The New public/private key pair dialog is displayed and shows the password for the private key. Copy and paste this password into Notepad for later use.

Also download the generated certificate file which has the extension p12. Then close the dialog.

P12 key file and password is generated.

P12 key file and password is generated.


Copy and paste the Service account email address into Notepad for later use. You'll need to enter this email address when setting up the data connector in Dundas Dashboard.

Service account email address.

Service account email address.


Authorization

Now that the client credentials have been generated, sign in to your Google Analytics account in order to give authorization to these credentials.

Go to the Admin area and click User Management on the left.

Sign in to Google Analytics and go to User Management screen.

Sign in to Google Analytics and go to User Management screen.


In the Add permissions for box, paste the Service account email address that you recorded earlier. Then click Add.

Add permissions for the email address.

Add permissions for the email address.


Usage

Installing the add-on

Follow these steps to install the Google Analytics add-on:

  1. Start the Deployment Center on your Dundas Dashboard server.
  2. Install the Google Analytics add-on.
  3. Restart the Dundas Dashboard website.

Creating a Google Analytics data connector

To create a Google Analytics data connector, follow these steps:

  1. Create a new data connector from the Design Explorer.
  2. In the General tab of the Data Connector Designer, set the Provider dropdown to Other Data Sources.
  3. Click the Add button below the Data Sources grid. The Define Data Structures dialog is displayed.
  4. In the Define Data Structures dialog:
    • Set the Data Source Type to Google Analytics.
    • Enter a Table name.
    • Enter the E-mail address (service account email address).
    • Enter the file name (full path) of the P12 key file that was generated earlier.
    • Type the private key password which you recorded earlier.
    • Click Login.
      Define Data Structures dialog.
  5. Once you have logged in:
    • Select a profile (i.e. a Google Analytics account).
    • Click on one or more dimensions to import.
    • Click on one or more measures to import.
    • Click Discover Table Structure. The selected dimensions and measures appear in the Columns grid.
      Define Discovered table structure.
  6. Click OK to close the Define Data Structures dialog.
  7. Click Save from the toolbar to begin importing the analytics data into the table that you specified.

When the import is complete, you can view and preview the imported data.

Google Analytics data connector.

Google Analytics data connector.


Next, you can build a virtual table, KPI, and ultimately a dashboard to visualize this data.

Interpreting the data

Some metrics are calculated using other metrics. For example, avgTimeOnPage can be calculated as:

ga:avgTimeOnPage = ga:timeOnPage / (ga:pageviews - ga:exits)

For more information on how metrics are calculated, see the Google Analytics documentation.

Release history

This add-on was first released with Dundas Dashboard 4.0.0.

Related topics


Click to return to: Documentation | Dundas Dashboard Add-ons

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2016 Dundas Data Visualization, Inc.