Google Analytics Connector

Overview

The Google Analytics Connector helps you analyze and share insights about your website traffic. The connector is bundled with pre-built content to give you an immediate understanding of who visits your website, which pages they visit, and how they found you in the first place.

The steps below provide detailed instructions to help you get started. Steps include:

installing the Google Analytics connector;
connecting to your Google account; and,
saving your configuration and adding the prepackaged content to Yellowfin.

Install the Google Analytics connector

Start by downloading the Google Analytics connector from the Yellowfin Marketplace, then follow the steps below to get started.

When creating a new connector to Yellowfin, ensure that your Yellowfin user has enough access to complete the steps below. Their role will need some of the checkboxes checked under the Data Sources & Views role in the Yellowfin admin console. The steps below presume the user is logged in to Yellowfin with the correct access level.

From the Yellowfin burger bun menu in the top left corner, click on Administration, then Plugin Management
The Plugin Management dialog box will be displayed:

If you have already installed any other plugins or connectors, they will be listed here.
Click on the Add button to display the New Plugin dialog box
Enter a name and a description, which will be used to list the connector on the Plugin Management page, then upload the connector that you downloaded from Yellowfin Marketplace
Click on the Submit button to add the connector to your Yellowfin instance.

top

Configure Google

Yellowfin can only display Google Analytics data if the connector after some strict security checks are made. You will therefore need a Google client ID that has the Google Analytics API enabled. The process is covered in the steps below. Once complete, you will use these credentials to set up a new data source in Yellowfin via the connector.

Create a Google client ID

The instructions below are not related to Yellowfin software. They are provided here only to cover the basics of the configuration you’ll need to use Google Analytics in Yellowfin. If you need further help, please refer to any instructions provided by the third-party software provider.

Go to console.developers.google.com to open the Google APIs console
Click on the Credentials link on the left
At the top left of the screen, click on Select a project to display a dialog box, then click on NEW PROJECT in the top right corner of the dialog box
Type a name for the project, such as ‘Yellowfin’, and optionally, edit the provided project ID, then click on the Create button
On the Credentials page, click on the +CREATE CREDENTIALS link at the top of the page, then click on OAuth client ID
If you’re prompted to provide further information on the OAuth consent window, click on the CONFIGURE CONSENT SCREEN button and provide the requested information, then click on the various buttons, including the final BACK TO DASHBOARD button, then repeat step 5
From the Application type dropdown, select Desktop app, and enter any additional information required
Click on the Create button
The OAuth client created confirmation box will appear, displaying your client ID and your client secret
Click on OK in the bottom right corner.

Tip:

If you have problems with access, check that under OAuth consent screen, your publishing status is set to In production.

Enable the Google Analytics API

From the Google APIs console, click on the Library link on the left, and if you’re prompted to enable the API library, enable it
In the search bar, type google analytics api
From the search results, click on Google Analytics API
Click on the Enable button to enable the API

top

Connect your accounts

Now that your Google APIs console has been configured and your Google Analytics connector is installed within Yellowfin, you can connect the two. To complete these steps, you will:

create a new data source; and,
create a secure connection between Google and Yellowfin.

Create a new data source

In Yellowfin, click on the yellow Create button and select Data Source from the list

Now, you will see the Google Analytics connecter listed under Or choose a platform:
Click on the Google Analytics connector

Create a secure connection between Google and Yellowfin

Provide a name and a description for your connector if these fields are empty
Enter your client ID and client secret from your Google APIs console in the relevant fields
Click on the Generate Authorize URL button
Click on the Authorize Google Analytics button
Choose your Google account (the one you used to create Client ID and Client Secret)
You may see a verification warning message:

Note: To remove this warning screen, submit your data usage and server host to Google for review
If the message above appears, click on the Advanced link and any further confirmation links to go to the app, including the Allow button on the screen below:

Google will display a code:
Copy the code, then switch back to Yellowfin
Paste the code into the 3. Enter PIN field
Click on the Validate Pin button
If the pin produces an unsuccessful result (eg, Google user doesn’t have access to Analytics, incorrect code was pasted into a field etc.), a corresponding error message will be displayed, and you will need to resolve the issue before you can continue:

When the pin match is successful, the remaining fields will be filled by Yellowfin:
Click on the arrow on the right of the Launch Pre-Built Content button to see what options are available
Choose the most appropriate option (see Third Party Connectors for more info); typically, this is Launch Pre-Built Content, which will process the request and load any content that comes shipped with the connector. For Google Analytics, this is a dashboard with tabbed groups of data.