Configuring the Google Analytics Adapter

How to:

Reference:

This section describes how to configure the Google Analytics Adapter.


Top of page

x
Procedure: How to Configure the Google Analytics Adapter
  1. Clear the cookies from the web browser that will be used to start the WebFOCUS Reporting Server Web Console.
  2. Access the WebFOCUS Reporting Server Web Console using the host name and port that you specified in the AUTHORIZED JAVASCRIPT ORIGINS field of the Google project.

    For example:

    http://host.ibi.com:8121

    For more information, see How to Create a Google Project.

  3. From the WebFOCUS Reporting Server Web Console menu bar, click Adapters.

    The Adapters pane opens.

  4. Expand the Available folder, if it is not already expanded.
  5. Expand the Social Media folder.
  6. Right-click the Google Analytics node and select Configure, as shown in the following image.

    The Add Connection for Google Analytics pane opens, as shown in the following image.

  7. Enter the values for the Client ID and Client Secret as defined by the Client ID and Client secret respectively in the Google project.

    For more information, see How to Create a Google Project.

  8. Enter the value for the Web Profile ID as defined by the View ID in the Google Analytics Reporting View Settings for the selected website.

    This value is prefixed by ga. For example:

    ga:87878787

    For more information, see How to Obtain the Web Profile ID.

  9. Click the Get Access Token link.

    A Google Sign In page opens, as shown in the following image.

  10. Enter the Google Sign In credentials and then click Sign in.

    The Project Default Service Account page opens, as shown in the following image.

  11. Click Allow access.

    You are returned to the Add Connection for Google Analytics pane, where the Access Token field and Refresh Token field are now populated, as shown in the following image.

  12. Click Configure.

    The Google Analytics Adapter is added to the configured Adapters list in the navigation pane.


Top of page

x
Reference: Connection Attributes for Google Analytics

The following list describes the connection attributes for the Google Analytics Adapter.

Connection Name

Logical name used to identify this particular set of connection attributes. The default is CON01.

Google Analytics URL

The URL of the Google Analytics API request. The default value is:

https://www.googleapis.com/analytics/v3/data
Client ID

The value that identifies your application to Google Analytics.

Obtain this value using the following steps:

  1. Go to:
    https://cloud.google.com/console/project
  2. Click on the Project Name for the Google Analytics Adapter application that was previously created.
  3. Click APIs & auth in the left pane.
  4. Click Credentials in the left pane.
  5. Use Client ID in the Client ID for web application section.
Client Secret

The value which identifies your application to Google Analytics. This value is used in conjunction with Client ID.

Obtain this value using the following steps:

  1. Go to:
    https://cloud.google.com/console/project
  2. Click on the Project Name for the Google Analytics Adapter application that was previously created.
  3. Click APIs & auth in the left pane.
  4. Click Credentials in the left pane.
  5. Use Client secret in the Client ID for web application section.
Web Profile ID

The ID that identifies the view (profile) for a Google Analytics account.

Obtain this value using the following steps:

  1. Go to:
    http://www.google.com/analytics
  2. Sign in with Google credentials that have administrative rights to Google Analytics.
  3. Click on the website that is to be analyzed (for example, www.informationbuilders).
  4. Click Admin in the upper-right corner of the screen.
  5. Click View Settings.
  6. Look for View ID under Basic Settings.

    This value is prefixed by ga. For example:

    ga:87878787
Access Token

The value that identifies the user your application is acting on behalf. Click the Get Access Token link to obtain this token and the Refresh Token.

In order for the Get Access Token to complete successfully, the host name used to access the WebFOCUS Reporting Server Web Console must match the host name specified for the Redirect URI in the Google Analytics application.

A Google sign-on screen opens if you are not already logged into a Google account.

A Consent screen opens. Click Allow Access.

If an issue arises when obtaining the Access and Refresh Tokens, clear your browser cache, including cookies.

Refresh Token

The Access Token has a very short lifespan. The Refresh Token is used to obtain a new Access Token during run time.

Select profile

Select a profile from the drop-down list to indicate the level of profile in which to store the connection attributes. The global profile, edasprof.prf, is the default.

If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), select New Profile from the drop-down list and enter a name in the Profile Name field (the extension is added automatically).

Store the connection attributes in the server profile (edasprof).


Information Builders