Breadcrumbs

Certified Datasources

Alli Data Library (ADL) is now Certified Datasources.
This rebrand reflects the enhanced functionality and focus on providing a single source of truth for reliable, cross-channel data. While the name has changed, all features and capabilities remain accessible through Data Explorer.

Overview

Alli Certified Datasources simplify access to clean, cross-channel data that’s ready for action. Acting as a single source of truth, they empower teams to move faster by uncovering performance insights, identifying trends, and making smarter decisions.

Why it matters

Data only drives value when it’s actionable. Certified Datasources solve the challenges of fragmented or inconsistent data by providing a reliable, pre-validated foundation for all your workflows. From high-level campaign comparisons to keyword-level insights, Certified Datasources empower your teams to trust their data and act quickly.

Key benefits

  • Unified insights across platforms: Deliver consistent, reliable cross-channel insights with data standardized into a single format.

  • Granular analysis at every level: Analyze what matters—from broad trends to detailed campaign data—with flexible, ready-to-use datasets.

  • Built for productivity: Work smarter with pre-validated data that integrates seamlessly into tools like Ask Alli and Data Explorer.

How it works

Certified Datasources integrate seamlessly into Data Reports, enabling teams to streamline workflows and save time with pre-validated data for insights and reporting.

There are two ways to access Certified Datasources in Data Reports:

  1. Through the Report Builder UI.

  2. Using Custom SQL.

Accessing through Report Builder UI

  1. Navigate to Data > Reports.

  2. Click “Select from Datasource” followed by clicking the “Select Datasource” dropdown menu.

  3. Any report containing a blue shield with a white checkmark is a Certified Datasource and can be viewed in Data Explorer and exported as a report.

Screenshot 2025-12-29 at 12.41.39 PM.png

If no datasources are listed, they may not have been set up yet. Refer to the Tutorial: Getting started with Certified Datasources for detailed setup instructions.

Accessing through Custom SQL

  1. Navigate to Data > Reports

  2. Click on New Data Report > Edit Custom SQL

  3. Run the following query:

    SQL
    select *
from {alli_client_slug}_core.{table_name}

Supported platforms

image-20230502-185108.png
Amazon DSP
image-20250109-210751.png
Apple Search Ads
image-20230503-160055.png
Bidtellect
image-20250109-210832.png
Criteo


image-20250109-210851.png
Google Ads


image-20230502-185322.png
CM360
image-20230502-185327.png
DV360
impact_logo.jpg
Impact


image-20230502-185336.png
LinkedIn Ads
image-20250109-211102.png
Microsoft Ads


image-20230502-185345.png
Facebook Ads (Meta)
image-20250506-214827.png
Partnerize


image-20230502-185350.png
Pinterest Ads
image-20230502-185353.png
Reddit Ads
image-20250506-214744.png
ShopMy


image-20230502-185358.png
Snapchat Ads
stackadapt-logo.webp
StackAdapt


image-20250109-212119.png
Taboola
image-20250506-214628.png
Teads


image-20230502-185401.png
The Trade Desk
image-20230502-185405.png
TikTok Ads
image-20250109-211410.png
Twitter Ads (X)
image-20240429-180528.png
Vistar DSP
image-20250109-211541.png
Yahoo DSP

Available reports

REPORT

DESCRIPTION

SUPPORTED PLATFORMS

account_performance

An account-level performance report for all platforms on which a customer serves media. Each row represents daily metrics by account.

ALL

account_settings

An account-level settings-only report for all platforms on which customer serves media. Each row represents settings by account.

ALL

ad_performance

A combined performance report with ad-level data from all platforms on which the 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 row represents daily metrics by ad, ad group, campaign, account, and CM360 placement when applicable.

ALL

ad_settings

An ad-level settings-only report for all platforms on which customer serves media. Each row represents settings by adgroup.

ALL

adgroup_performance

An ad group-level performance report for all platforms on which the customer serves media. Each row represents daily metrics by ad group/line item, campaign, and account

ALL

adgroup_settings

An adgroup-level settings-only report for all platforms on which customer serves media. Each row represents settings by adgroup.

ALL

affilate_performance

An affliate performance report for supported platforms on which a customer utilizes. Each row represents daily performance metrics of affiliates segmented by platform and account.

  • Impact

  • Partnerize

  • ShopMy

audience_performance

An audience-level performance report for supported platforms on which the customer serves media. Each row represents daily performance metrics by audience, segmented by platform and ad group.

  • Google Ads

  • Microsoft Ads

budget_pacing_performance

A campaign performance report for all platforms on which the customer serves media. Each row represents daily performance and budget pacing metrics by campaign. Pacing metrics are determined by the user-inputted lifetime budget for chosen campaigns.

ALL

campaign_performance

A campaign-level performance report for all platforms on which the customer serves media. Each row represents daily metrics by campaign and account

ALL

campaign_settings

A campaign-level settings-only report for all platforms on which customer serves media. Each row represents settings by campaign.

ALL

creative_performance

A creative-level performance report for supported platforms on which the customer serves media. For CM360 creatives, platform-specific dimensions and metrics are incorporated via a LEFT JOIN on cm_placement_id and date when applicable. Each row represents daily metrics by creative, placement/ad, ad group, campaign, and account, segmented by creative size for CM360.

  • CM360

  • DV360

  • Facebook Ads

  • Google Ads (Display Network)

  • Pinterest Ads

  • Reddit Ads

  • Snapchat Ads

  • The Trade Desk

demographic_performance

A demographic-level performance report for supported platforms on which the customer serves media. Each row represents daily performance metrics segmented by demographic attributes.

  • Facebook Ads

dynamic_creative_performance

A Dynamic+ creative-level performance report for supported platforms on which the customer serves media. Each row represents daily performance metrics by creative, Dynamic+ creative, placement/ad, ad group, campaign, and account.

  • CM360

geo_country_performance

A geographic performance report for supported platforms on which the customer serves media. Each row represents daily metrics by campaign, account, segmented by country where an ad was served.

  • DV360

  • Google Ads

  • Snapchat Ads

  • The Trade Desk

  • Yahoo DSP

geo_dma_performance

A geographic DMA performance report for supported platforms on which the customer serves media. Each row represents daily metrics by campaign, account, segmented by country where an ad was served.

  • Facebook Ads

  • Google Ads

  • Microsoft Ads

  • Snapchat Ads

  • TikTok Ads

  • The Trade Desk

geo_region_performance

A geographic performance report for supported platforms on which the customer serves media. Each row represents daily metrics by campaign, account, segmented by city, region, and country where an ad was served.

  • DV360

  • Facebook Ads

  • Google Ads

  • Snapchat Ads

  • Teads

  • The Trade Desk

  • Yahoo DSP

inventory_performance

A domain-level programmatic inventory performance report for all DSPs on which the customer serves media. Each row represents daily metrics by domain, ad group, campaign, and account.

  • Amazon DSP

  • DV360

  • Google Ads (Display Network)

  • The Trade Desk

  • Teads

  • Yahoo DSP

keyword_performance

A search keyword-level performance report for supported SEM platforms on which the customer serves media. Each row represents daily metrics by search keyword, ad group, campaign, and account.

  • Apple Search Ads

  • Google Ads

  • Microsoft Ads

  • TikTok Ads

platform_device_performance

A device-level performance report for supported platforms on which the customer serves media. Each row represents performance metrics grouped by platform and device-related attributes.

  • Facebook Ads

pmax_performance

A Performance Max campaign-level performance report for Google Ads. Each row represents campaign performance metrics segmented by interaction target.

  • Google Ads

productgroup_performance

A product-level shopping campaign performance report for supported SEM platforms on which the customer serves media. Each row represents daily metrics by product group, ad group, campaign, and account.

  • Google Ads

  • Microsoft Ads

searchterm_performance

A search term-level performance report for supported SEM platforms on which the customer serves media. Each row represents daily metrics by search term, ad group, campaign, and account.

  • Apple Search Ads

  • Google Ads

  • Microsoft Ads

Tutorials

How-Tos

Reference