Alli Data Library 2.0

Alli Data Library (ADL) aggregates data from Alli’s popular advertising platform connectors, creating a unified report view that shows daily ad spend and performance metrics by platform and media channel. With this holistic view of your ads' performance, you can assess the effectiveness of your campaigns across various platforms and optimize your ad spend accordingly.

This documentation refers to a newest version of Data Library (ADL 2.0) rolled out in 2023. If a customer was onboarded onto Alli before May 2023, they’re likely running on both this version and the legacy version (ADL 1.0) of the product. If they were onboarded on or after May 2023, they’re like running on this new version only.

As of May 2023, ADL 1.0 has been sunsetted and will be in maintenance mode only – meaning no new features will be added, and only business impacting bugs will be resolved. It will be retired and completely removed from the platform in Q1 2024.

For more information on what’s changing and how you can prepare, see Data Library 2.0 Migration Guide

Key benefits

Simplified reporting structure 🆕

ADL 2.0’s new Ad Account Hierarchy-based reports are channel-agnostic, meaning your ad campaign data will no longer be separated into channel-specific views (e.g., search_ad vs. social_ad vs. display_ad) based on an ad's media channel, but instead will exist in a singular view aggregated based on the corresponding Ad Account Hierarchy level (e.g., ad_performance).

See Alli Data Library 2.0 | Available-reports section below for more information.

Self service capabilities 🆕

New to ADL 2.0, you can now execute common tasks via Alli Marketplace such as onboarding a new platform, backfilling data, and refreshing a report view, all without submitting an Alli support request.

See Getting started with Data Library 2.0 for more information.

Query portability

With ADL 2.0, all customers utilize the same methodology for processing data, so recreating a query from one customer to another is as simple as a copy and pasting SQL with very minimal change.

See Alli Data Library 2.0 | Example-use-cases section below for more information.

Supported platforms

Amazon DSP	Bidtellect	Microsoft Bing
Google Ads	Campaign Manager 360	DV360
LinkedIn Ads	Facebook Ads	Pinterest Ads
Reddit Ads	Snapchat Ads	The Trade Desk
TikTok Ads	Twitter Ads	Yahoo DSP
Criteo	Apple Search Ads	Vistar DSP
Taboola / Yahoo Native Network

How to use Data Library

To query a Data Library report, simply run:

SQL

select *
from {alli_client_slug}_core.{report_name}

..with alli_client_slug being the client’s “slug” name found in Alli Central, and report_name being the report name found in Alli Data Library 2.0 | Available-reports section below.

Available reports

REPORT	DESCRIPTION	SUPPORTED PLATFORMS
`account_performance`	An account-level performance report for all platforms on which customer serves media. Each record represents daily metrics by account.	ALL
`campaign_performance`	A campaign-level performance report for all platforms on which customer serves media. Each record represents daily metrics by campaign and account	ALL
`adgroup_performance`	An ad group-level performance report for all platforms on which customer serves media. Each record represents daily metrics by ad group/line item, campaign, and account	ALL
`ad_performance`	A combined performance report with ad-level data from all platforms on which customer serves media and placement-level data from CM360 when applicable. The two datasets are combined using a `FULL OUTER JOIN` on `cm_placement_id` and `date` when applicable. Each record represents daily metrics by ad, ad group, campaign, account, and CM360 placement when applicable.	ALL
`creative_performance`	A creative-level data from all platforms on which customer serves media. For CM360 creatives: dimensions and metrics from a given platform are brought in using a `LEFT JOIN` on `cm_placement_id` and `date` when applicable. Each record represents daily metrics by creative, placement/ad, ad group, campaign, and account, segmented by creative_size for CM360.	CM360 DV360 The Trade Desk Yahoo DSP Amazon DSP Bidtellect Google Ads (Display Network) Microsoft Bing (Audience Network) Facebook Ads Snapchat Ads Taboola
`keyword_performance`	A search keyword-level performance report for all SEM platforms on which customer serves media. Each record represents daily metrics by search keyword, ad group, campaign, and account.	Google Ads Microsoft Bing
`searchterm_performance`	A search term-level performance report for all SEM platforms on which customer serves media. Each record represents daily metrics by search term, ad group, campaign, and account.	Google Ads Microsoft Bing
`inventory_performance`	A domain-level programmatic inventory performance report for all DSPs on which customer serves media. Each record represents daily metrics by domain, ad group, campaign, and account.	Google Ads (Display Network) DV360 The Trade Desk Yahoo DSP Amazon DSP
`productgroup_performance`	A product-level shopping campaign performance report for all SEM platforms on which customer serves media. Each record represents daily metrics by product group, ad group, campaign, and account.	Google Ads Microsoft Bing
`geo_region_performance`	A geographic performance report for all platforms on which customer serves media. Each record represents daily metrics by campaign, account, segmented by city, region, and country where ad was served.	Google Ads DV360 The Trade Desk Yahoo DSP
`geo_country_performance`	A geographic performance report for all platforms on which customer serves media. Each record represents daily metrics by campaign, account, segmented by country where ad was served.	Google Ads DV360 The Trade Desk Yahoo DSP
`geo_dma_performance`	A geographic DMA performance report for all platforms on which customer serves media. Each record represents daily metrics by campaign, account, segmented by country where ad was served.	Google Ads Facebook Ads Snapchat Ads TikTok Ads
`budget_pacing_performance`	A campaign performance report for all platforms on which customer serves media. Each record represents daily performance and budget pacing metrics by campaign. Pacing metrics are determined by user-inputted lifetime budget for chosen campaigns.	ALL

Example use cases

See campaign performance from the last seven days

SQL

select *
from {alli_client_slug}_core.campaign_performance
where cast(date as date) >= current_date - 7

See ad group performance for Google Ads and Facebook Ads only

SQL

select *
from {alli_client_slug}_core.adgroup_performance
where platform in ('Google Ads', 'Facebook Ads')

Running the same report between different customers

SQL

-- Ad performance report for Gap
select * from gap_core.ad_performance;

-- The same report for Omni Hotels
select * from omni_hotels_core.ad_performance;

Alli Data Library 2.0

Key benefits

Simplified reporting structure 🆕

Self service capabilities 🆕

Query portability

Supported platforms

How to use Data Library

Available reports

`account_performance`

`campaign_performance`

`adgroup_performance`

`ad_performance`

`creative_performance`

`keyword_performance`

`searchterm_performance`

`inventory_performance`

`productgroup_performance`

`geo_region_performance`

`geo_country_performance`

`geo_dma_performance`

`budget_pacing_performance`

Example use cases

See campaign performance from the last seven days

See ad group performance for Google Ads and Facebook Ads only

Running the same report between different customers

🚀 Tutorials

How-tos

🔍 Reference