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

Understand how to create a view in Redshift and BigQuery using Alli.

Redshift:

Getting started with Explorer Reports

BigQuery:

Create BigQuery View

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: `ad`, `creative`, `keyword` `adgroup`, `adset`, `placement` `campaign`
dimension_type	STRING	Whether the dimension is a name or an ID. Accepted values: `name`, `id`
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