Skip to main content
Skip table of contents

Alli Data Library 1.0 (Deprecated)

This document refers the legacy version of Data Library to be deprecated in October of 2023. A newer version was launched in May of 2023. If your customer was onboarded before this date, then they are likely running on the legacy version. If your customer was onboarded on or after this date, then they are likely running on 2.0 only. However, all customers will be upgraded to 2.0 starting in June 2023.

For more information, see: Alli Data Library (ADL) 2.0

Overview

Alli Data Library provides standardized data assets that blend multiple platforms together into a single view. If you write a query for a given client, that query can be ported to any other client that has an Alli Data Library with minimal change.

Database Platforms Enabled

  • Redshift

  • BigQuery

Vendors Integrated

  • Google Ads

  • Microsoft Bing

  • Facebook

  • Twitter

  • LinkedIn

  • YouTube (via Google Ads)

  • The Trade Desk

  • Bidtellect

  • DV360

  • Verizon DSP (now Yahoo)

  • Pinterest

  • Snapchat

  • Amazon DSP

How to use Data Library

SQL
select * from [client]_core.[channel]_[report]

Available Reports

  • account

  • campaign

  • adgroup/adset

  • ad (social and display only)

  • pla (search only)

  • sqr (search only)

  • dsa (search only)

  • keyword (search only)

  • video (social only)

  • inventory (display only)

  • geo

  • placement (display only)

Examples

SQL
--moving between clients
select * from gap_core.search_keyword limit 100;
select * from michael_kors_core.search_keyword limit 100;

--moving from social to search campaign stats
select * from gap_core.social_campaign limit 100;
select * from gap_core.search_campaign limit 100

Data Explorer

We have built a data explorer dashboard, so you can see the data before you select from it. The dashboard is built in sql.pmg.com.

Screenshots

We also have detailed model/view documentation at datalibrary.pmg.com/redshift. To understand how to use these docs visit Data Library Documentation Website

FAQ

Q: What do I do if I notice that there is a data gap?

A: Send a message in the #alli-data-library channel, and someone from the Data Engineering Team will look into the issue and backfill all the necessary datasources. Tag @support-allidatalibrary in the message if the request is urgent.

Q: What will happen to the data if I change the name of an existing account/campaign/adgroup?

A: The next time Data Library refreshes, the new name will be available for all dates, and the old name will be removed. If you rename an non-active campaign, then we will have to do a Datawarehouse backfill to enable the name within Data Library

Q: What is the process of adding accounts to Data Library?

A: Submit this Alli Service Desk ticket with the client, account names, platforms, and the range of data to backfill if necessary: https://agencypmg.atlassian.net/servicedesk/customer/portal/1/group/5/create/24

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.