Skip to main content
Skip table of contents

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

image-20240409-194316.png

Criteo

Apple Search Ads

image-20240429-180528.png

Vistar DSP

image-20240429-180355.png

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


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;

🚀 Tutorials

(lightbulb) How-tos

🔍 Reference

JavaScript errors detected

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

If this problem persists, please contact our support.