Google Analytics MCF
Google Analytics Multi-Channel Funnel reports the source of traffic. MCF helps users identify the user interactions from various traffic sources and also the number of sessions prior to converting.
Sprinkle now supports Google Analytics MCF as a data source. On clicking the "+sign" a list of data sources appears. In this case, Google Analytics MCF is selected. A new Google Analytics
MCF 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 need to sign in to their analytics MCF 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 date from when he wants to ingest the data. The date needs to be selected in the YYYY-MM-DD format.
After selecting the date, 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.
