Google Analytics is a free service provided by Google that provides detailed statistics about the number of visitors to a website. This product has been specially designed for marketers as opposed to the webmasters and technologists who led the web analytics industry.
Sprinkle now supports Google Analytics as a data source. On clicking the "+sign" a list of data sources appears. In this case, Google Analytics is selected. A new Google Analytics data source is named and created.
To create a connection, the user needs to click on "Connect to Google" which leads to a sign in page.Next, The users needs to sign in to their analytics account.
Post login, users will be prompted to allow permissions required for sprinkle to read data further. Once a user provides consent by clicking on ‘Allow’, the connection can be created from Sprinkle.
Next, in the datasets tab, users need to name the table and select the “Account Id”from which the data needs to be ingested.
Once the Account Id is selected, the user needs to select the Project or the View ID.
In the Analytics tracking code, the property for a reporting view has a unique ID, which is a combination of the account ID and additional digits. This property ID links a property to one or more views in an Analytics account.
Next, the user needs to select the “Metrics” and “Dimensions”. Please note that a maximum of 10 Metrics can be selected and a maximum of 7 Dimensions can be selected. Lastly, the user needs to select the data from when he wants to ingest the data. The date needs to be selected in the YYYY-MM-DD format.
After selecting the data, the user needs to click on “Create”. From the second ingestion job onwards, all data will be ingested on a incremental basis, i.e. from the point the last job was completed.
In the Ingestion Jobs tab, the concurrency (number of tables that can run in parallel, a maximum of 7) can be set preferentially before running the job. The status of the job will be updated in the tab below once it’s complete. The jobs can also be set to run automatically by enabling autorun. Frequency can be changed by clicking on More --> Autorun-->Change Frequency.