How to integrate Source of Truth data in Alli Data Library
Overview
This doc walks through how to include your client’s source of truth data – i.e., Google/Adobe Analytics – in Data Library
Prerequisites
Understand how to create a view in Redshift and BigQuery using Alli.
Redshift:
How to explore your data and create a report or data view
BigQuery:
Instructions
1. Create a view named sourceoftruth_insights_ad with the following schema:
Column Name | Data Type | Description |
|---|---|---|
date | TIMESTAMP | The performance date |
dimension_level | STRING | The granularity of the metrics to be included. This determines which Cross Channel view metrics are appended to. Accepted values:
|
dimension_type | STRING | Whether the dimension is a name or an ID. Accepted values: |
dimension_value | STRING | The ID or name value of based on the corresponding dimension_type |
tracking_code | STRING | Tracking code from the platform |
revenue | FLOAT | Revenue amount |
orders | FLOAT | Number of orders |
page_views | FLOAT | Number of page views |
bounces | INTEGER | Number of bounces |
users | INTEGER | Number of unique users |
sessions | INTEGER | Number of sessions |
visits | FLOAT | 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 crosschannel_[level] view