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 Explorer, 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 Explorer:

  1. Through the Report Builder UI.

  2. Using Custom SQL.

Accessing through Report Builder UI

  1. Navigate to Data > Explorer.

  2. Ensure the Certified toggle is selected to display a list of available Certified Datasources.

image-20250109-212340.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.

  1. Select a specific datasource and click View this data to start exploring and analyzing pre-validated data across platforms.

Accessing through Custom SQL

  1. Navigate to Data > Explorer

  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
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
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 the customer serves media. Each record represents daily metrics by account.

ALL

account_settings

An account-level settings-only report on which customer serves media. Each record represents settings by account.

ALL

campaign_performance

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

ALL

campaign_settings

A campaign-level settings-only report on which customer serves media. Each record represents settings by campaign.

ALL

adgroup_performance

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

ALL

adgroup_settings

An adgroup-level settings-only report on which customer serves media. Each record represents settings by adgroup.

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 record represents daily metrics by ad, ad group, campaign, account, and CM360 placement when applicable.

ALL

ad_settings

An ad-level settings-only report on which customer serves media. Each record represents settings by adgroup.

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 Ads (Audience Network)

  • Facebook Ads

  • Snapchat Ads

  • Taboola

  • Reddit Ads

keyword_performance

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

  • Google Ads

  • Microsoft Ads

  • Apple Search Ads

searchterm_performance

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

  • Google Ads

  • Microsoft Ads

  • Apple Search Ads

inventory_performance

A domain-level programmatic inventory performance report for all DSPs on which the 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

  • Teads

productgroup_performance

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

  • Google Ads

  • Microsoft Ads

geo_region_performance

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

  • Google Ads

  • DV360

  • The Trade Desk

  • Yahoo DSP

  • Snapchat Ads

  • Teads

geo_country_performance

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

  • Google Ads

  • DV360

  • The Trade Desk

  • Yahoo DSP

  • Snapchat Ads

geo_dma_performance

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

  • Google Ads

  • Facebook Ads

  • Snapchat Ads

  • TikTok Ads

budget_pacing_performance

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

ALL

affilate_performance

An Affliate Performance Report for all platforms on which a customer utilizes. Each record represents daily performance metrics of affiliates segmented by platform and account.

  • ShopMy

  • Partnerize

Tutorials

How-Tos

Reference