This doc walks through how to include your client’s source of truth data – i.e., Google/Adobe Analytics – in Data Library
Understand how to create a view in Redshift and BigQuery using Alli.
1. Create a view named
sourceoftruth_insights_ad with the following schema:
The performance date
The granularity of the metrics to be included. This determines which Cross Channel view metrics are appended to.
Whether the dimension is a name or an ID.
The ID or name value of based on the corresponding dimension_type
Tracking code from the platform
Number of orders
Number of page views
Number of bounces
Number of unique users
Number of sessions
Number of visits
You must create the view on both Redshift and BigQuery to avoid errors in ADL
2. Submit an ASD ticket to enable source of truth for your client
3. Re-run ADL and validate that the
sot metrics are populated in the corresponding