How-To: Assign custom programmatic cost to display ad reports
Overview
Certified Datasources support all major programmatic display ad platforms and DSPs. However, not all of them include a connector in Alli Data. This guide explains how to add cost data from these unsupported platforms to display ads and/or CM360 placements in Certified Datasources.
Prerequisites
Certified Datasources exist for your customer
Understand how to create view-based reports in Alli
BigQuery: How-To: Create BigQuery View
Instructions
Before proceeding, run the following query to ensure that the report/datasource doesn’t already exist for your customer:
select count(*) from {alli_client}.programmatic_cost
If it exists, modify the report/datasource in Alli
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 |
⬇️ (Optional) ⬇️ | ||
| INTEGER | The number of impressions |
| INTEGER | The number of clicks |
2.) Validate that the table or view exists in the data warehouse:

Checking that the data exists in Redshift in Data Explorer
3.) Run your customer’s ADL 2.0 - Refresh
app with DEPLOYMENT
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 source like '%programmatic_cost%'
and platform = 'AdTheorent'
group by 1, 2;
Related articles
- 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