Skip to main content
Skip table of contents

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


Instructions

Before proceeding, run the following query to ensure that the report/datasource doesn’t already exist for your customer:

SQL
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

DATE

The spend date

Ensure that this matches the customer’s CM360 account timezone (typically set as America/New_York / EST)

platform

STRING

The name of the DSP, vendor, or publisher

placement_id

STRING

The associated CM360 Placement ID

cost

FLOAT

The spend amount

⬇️ (Optional) ⬇️

impressions

INTEGER

The number of impressions

clicks

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.:

SQL
select
  platform,
  source,
  sum(cost) as cost
from playground_core.ad_performance
where source like '%programmatic_cost%'
and platform = 'AdTheorent'
group by 1, 2;

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.