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:
Through the Report Builder UI.
Using Custom SQL.
Accessing through Report Builder UI
Navigate to Data > Explorer.
Ensure the Certified toggle is selected to display a list of available Certified Datasources.
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.
Select a specific datasource and click View this data to start exploring and analyzing pre-validated data across platforms.
Accessing through Custom SQL
Navigate to Data > Explorer
Click on New Data Report > Edit Custom SQL
Run the following query:
SQLselect * from {alli_client_slug}_core.{table_name}Replace
{alli_client_slug}with the client’s slug name found in Alli Central.Replace
{table_name}with the report name found in the https://agencypmg.atlassian.net/wiki/spaces/PTD/pages/edit-v2/2869329951#Available-reports section below.
Supported platforms
 Amazon DSP |  Apple Search Ads |  Bidtellect |  Criteo |
 Google Ads |  CM360 |  DV360 |  LinkedIn Ads |
 Microsoft Ads |  Facebook Ads (Meta) |  Pinterest Ads |  Reddit Ads |
 Snapchat Ads |  Taboola |  The Trade Desk |  TikTok Ads |
 Twitter Ads (X) |  Vistar DSP |  Yahoo DSP |
Available reports
REPORT | DESCRIPTION | SUPPORTED PLATFORMS |
|---|---|---|
| An account-level performance report for all platforms on which customer serves media. Each record represents daily metrics by account. | ALL |
| A campaign-level performance report for all platforms on which customer serves media. Each record represents daily metrics by campaign and account | ALL |
| 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 |
| 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 Each record represents daily metrics by ad, ad group, campaign, account, and CM360 placement when applicable. | ALL |
| 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 Each record represents daily metrics by creative, placement/ad, ad group, campaign, and account, segmented by creative_size for CM360. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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 |
Tutorials
How-Tos
- How-To: Create hourly reports
- Advanced Guide: Creating a budget pacing report
- How-To: Add new accounts for an existing platform
- How-To: Add new dimensions to an existing datasource without losing historical data
- How-To: Categorize CM360 conversions
- How-To: Find which platforms and reports are enabled
- How-To: Locate datasources that feed into a Certified Datasource
- How-To: Assign custom programmatic cost to display ad reports
- How-To: Reclassify media channel