Click to return to:
Documentation |
Dundas Dashboard Add-onsOverview
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. |
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. |
In the
New Project dialog, enter a name for your project and then click
Create.
 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. |
Click
Enable 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. |
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. |
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. |
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. |
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. |
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. |
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. |
Usage
Installing the add-on
Follow these steps to install the Google Analytics add-on:
- Start the Deployment Center on your Dundas Dashboard server.
- Install the Google Analytics add-on.
- Restart the Dundas Dashboard website.
Creating a Google Analytics data connector
To create a Google Analytics data connector, follow these steps:
- Create a new data connector from the Design Explorer.
- In the General tab of the Data Connector Designer, set the Provider dropdown to Other Data Sources.
- Click the Add button below the Data Sources grid. The Define Data Structures dialog is displayed.
- 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.

- Once you have logged in:
- Select a profile (&ie; 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.

- Click OK to close the Define Data Structures dialog.
- 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. |
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