This requires Admin or Data Admin privileges for implementation.
Please Note: If you do not have the correct privileges to access Data Hub you will receive the following upon your login attempt. If you get this message and think it is an error please see your organization's iDashboards Administrator for assistance as Support is unable to give you access.
Connecting to Google Analytics API
This document goes over the process required to create an API connection to Google Analytics. This process will flow from initializing the API connection to creating a job in the ETL tool that transfers that API data into a database table/data source, to adding a chart connecting to that data source. If you don't have a developer account go here to create one.
Once you create a developer account you will see a screen like the one below. At this screen you will:
Click Select a project
This box will pop up and you will click NEW PROJECT
You will then type in the box Project Name. After choosing a project name you will then click CREATE.
Now select: +Enable APIS AND SERVICES.
At this time you will type in the search box Google Analytics API and then hit Enter.
Please check that your search matches the one below and click Google Analytics API.
Here you will click CREATE CREDENTIALS.
At this screen select Cancel
Which then brings you to the following where you click Create credentials
In the drop down menu you will select OAuth client ID
Then click Configure consent screen.
ONLY enter the Application name in the box provided, then scroll down and click Save.
Where it says Application type select Web application, then Create.
The screen will then expand to the following: where it has the box for Authorized redirect URIs you will enter the Redirect URL from your Data Hub webpage.
If you do not know where to find the Redirect URL: Please open a NEW tab in your web browser and log into Data Hub and click System to expand the drop down menu.
Then select API Accounts
Then click on Add Account
The following Add Account box will pop up and click Google Analytics and then select Next
That box will disappear and a new Add Account pop-up box will appear with OAuth2 Configuration: here you see the Redirect URL click Copy.
You will now go back to your Google Analytics tab in your web browser and in the box for Authorized redirect URIs you will enter the Redirect URL from your Data Hub website that you just copied. Now click Create at the bottom of the page.
Here you will copy your client ID, go back to to the open Data Hub tab and paste it where it says Client ID. If it has anything in the box delete it before pasting the Client ID.
Once you have the Client ID pasted into the box, then go back to the Google Analytics tab and copy the Client Secret into the box.
Your screen will now look similar to below and you can now click Log In.
It will then prompt you to log into Google Analytics: After logging into the site if you have strict network settings you may see the following message below, click where it says Advanced.
It will then expand, and click Go to iDashboards Data Hub (unsafe)
Once you see this screen you will be successfully connected to your Google Analytics account through your iDashboards Data Hub.
When that box disappears you can begin using your Google Analytics data on your dashboards. At this time you can close out of your Google Analytics tab and only use Data Hub.
Creating Data Sets from Your Connection
Now you can create a data set from your Google Analytics account by clicking on Data Sets
Then select: New Data Set
Then click: Cloud API
Now you will see the following screen, if you have other API connections they will show up here, select Google Analytics and click Add Account.
You can then configure the data, parameters and filters you would like to use.
Once you have that done click Save and move on to the next screen where you can move the columns around if they are not in the correct order, click Save As. Once you have it saved you can close out of this, as your data set is now created.
Creating an ETL Job
You will now be at the Data Hub Lobby: here you can select +NEW ETL JOB
What is an ETL job?
E - Extract Data from your data source
T - Transform Data or make changes
L - Load Data into a target table
Here are the various types of transformations available:
Looking back at the previous picture if you Click and Drag the E, T, and L you can set up your job.
Once you click on the E to Extract your data, you get the Extract Data (1) box. When you hoover your mouse over it you get the gear on the left (you can also double click on the Task to configure the task), the up arrow in the middle to send your data to be transformed (T) or loaded (L). If you do not have any transformations that need to be done, you can pull down the L and connect the E and L with the up arrow by dragging it from the E to the middle of the L.
Connecting the E and L as shown below, allows your data to be used to make: dashboards, charts, picklists and forms.
Please Note: If you are running on software at or below v9.7f please contact support for assistance in upgrading.
For More Information:
- iDashboards Data Hub Manual 8. Extract, Transform and Load
If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.