Data Integration GoogleAnalytics processor collects the data about your blog/website and return it in JSON Format. To fetch the data about your websites/ blog, you must configure the Google analytics account with service account mail id and should set the permission for the account. The steps to create account in Google analytics account and developer console is given below.
Create the account with Google developer console
Step 1: Sign up with Google mail account (Gmail username and password) to the Google Developer Console.
Step 2: Then create the project and enable the required API.
For example, if you want to fetch data from Google analytics, it is mandatory to enable analytics API (Application Program Interface)
Create the service account for your website:
Step 1: Under IAM and admin panel select the service account. It is essential to create service account.
Step 2: We can retrieve the data from the Google analytics, only if we have OAuth credentials or service account keys. Service account key can be obtained in two ways. They are
Step 3: To create service account key credentials -> Manage service account (under OAuth 2.0 Client IDs) ->Create service account.
Step 4: Enter the name of the service account and select the furnish new private key.Select, the format of the file that you want to download and keep safely.-
Register the website in Google analytics account:
Step 1: Then sign up with Google analytics account with Google mail account (Gmail id username and password) to the Google Analytics Account.
Step 2: Under Admin tab create an account by giving account name, website name, website URL and click on get tracking id.
Add the permission for the service account:
Add the service account mail, which can be generated while creating service account in the developer console window to the created account. The following are the steps required to add service account mail to the created account:
Step 1: From the admin panel of Google analytics account, add the service account mail under user management as shown in the image.
Step2: Add the mail and set the permission limit for the created account.
Get the value of profile ID in Google analytics account:
The Profile ID is taken from the analytics account by clicking HOME option and copying the URL. In that URL select the nine digits number from last between P and slash. Please refer to the following image:
Data Integration flow to fetch the data from Google analytics account.
In Data Integration Platform use “GoogleAnalytics” Processor to fetch data from Google Analytics account. Here is the overview image for Google analytics data integration template which gets the input data from google analytics account, process the data, convert into json and finally move the json data into Microsoft SQL server.
List of processors used in this sample:
Steps to Configure the Data Integration Processor:
Step 1: Drag “GoogleAnalytics” processor in canvas page and configure the required properties.
Step 2: Add SplitJson processor and add connection from GoogleAnalytics to SplitJson with Success relationship. It splits the input json data.
Step 3: Add ReplaceText processor and add connection from SplitJson processor to ReplaceText processor with split relationship.
Step 4: Add ExtractText processor and add connection from ReplaceText processor to ExtractText processor with Success relationship.
Step 5: Add ReplaceText processor and add connection from ExtractText processor to ReplaceText processor with matched relationship.
Step 6: Add ConvertJSONToSQL processor and add connection from ReplaceText processor to ConvertJSONToSQL processor with Success relationship.
Step 7: Add PutSQL processor and add connection from ConvertJSONToSQL processor to PutSQL processor with Sql relationship.
Step 8: Add PublishDataSource processor and add connection from PutSQL processor to PublishDataSource processor with Success relationship.
View the data in Syncfusion Dashboard Designer
Refer to the Import data source to designer. Import the data source from data integration server into designer, and create useful view in the designer to evaluate the data.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|
|8235||12/14/2017||12/15/2017||Big Data Platform||General|