How to add custom Programmatic cost in Data Library
Overview
ADL 2.0 supports the most popular advertising platforms including the biggest DSPs used in programmatic advertising. However, not all DSPs currently have a datasource connect within Alli Data. In these cases, customer teams often build custom e-mail or SFTP datasources to ingest data from various programmatic vendors/publishers.
Learn how to add this data to the ad_performance
and creative_performance
report with just a few steps.
Prerequisites
ADL 2.0 reports exist for your customer (see Getting started with Data Library 2.0)
Understand how to create a view in Alli (see next section)
How to create a view…
in Redshift (using Custom SQL option)
Getting started with Explorer Reports
in BigQuery
Instructions
Before proceeding, ensure that view or datasource doesn’t already exist for your customer. You can do this by querying select count(*) from {alli_client}.programmatic_cost
in the data warehouse environment of your choice. If it already exists, you can modify the view as necessary.
1.) Create a datasource or view named programmatic_cost
within the data warehouse environment of your choice with the following schema:
Field name | Data type | Description |
---|---|---|
| DATE | The spend date Ensure that this matches the customer’s CM360 account timezone (typically set as |
| STRING | The name of the DSP, vendor, or publisher |
| STRING | The associated CM360 Placement ID |
| FLOAT | The spend amount |
2.) Validate that the table or view exists in the data warehouse:
![](../../__attachments/2876178628/image-20230629-212836.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
e.g., checking that the data exists in Redshift via Alli Data Explorer
3.) Run your customer’s Alli Data Library 2.0 - Refresh
app with HISTORICAL_LOAD
set to True
4.) Validate that the cost associated with the corresponding platform
is properly added to ad_performance
as expected, e.g.:
select
platform,
source,
sum(cost) as cost
from playground_core.ad_performance
where platform = 'AdTheorent'
group by 1, 2;
Related articles
- How to add fields to a datasource without losing historical data
- How to categorize CM360 conversions in Data Library
- How to find which platforms and reports are enabled in Data Library
- How to find your Data Library datasources in Alli Data
- How to add custom Programmatic cost in Data Library
- How to add source of truth data in Data Library
- How to reclassify media channel data in Data Library