Placement ID methodology in Data Library 2.0
Overview
The ad_performance
report combines (1) ad-level data from DSPs on which customer serves media, and (2) placement-level data from CM360 using a join on cm_placement_id
and date
.
This guide walks through where Placement ID comes from and how it is parsed from the respective DSPs.
Methodology by platform
The following SQL examples are for Redshift.
To see the BigQuery version, (1) replace the function regexp_substr
with regexp_extract
, and (2) add an r
before the opening quotation mark in the 2nd argument, e.g.: regexp_substr(arg1, 'arg2')
→ regexp_extract(arg1, r'arg2')
Platform | Placement ID Source Column | Logic for Placement Id Extraction | Example SQL |
---|---|---|---|
Amazon DSP | Creative Name | 8 to 9 digit at the end or beginning of the Creative Name. e.g.
|
SQL
|
Bidtellect | Creative Name | 8 to 9 digit at the end or beginning of the Creative Name. e.g.
|
SQL
|
DV360 | CM360 Placement ID | IF |
SQL
|
DV360 Trueview (Youtube) | Trueview Ad Group Name | 8 to 9 digit at the end or beginning of the YouTube Ad Group Name. e.g.
|
SQL
|
Google Ads | Ad Group Name | 8 to 9 digit at the end or beginning of the Ad Group Name. e.g.
|
SQL
|
Ad Name | 8 to 9 digit at the end of the Ad Name. e.g.
|
SQL
| |
Ad Tracking URL Template | 8 to 9 digit starting with a e.g. |
SQL
| |
Microsoft Bing | Ad Group Name | 8 to 9 digit at the end or beginning of the Ad Group Name. e.g.
|
SQL
|
Ad Group Tracking URL Template | 8 to 9 digit starting with a e.g. |
SQL
| |
Ad Tracking URL Template | 8 to 9 digit starting with a e.g. |
SQL
| |
The Trade Desk | Ad Server Creative Placement ID | direct mapping of the |
SQL
|
Vistar DSP | Creative Name | 8 to 9 digit at the end or beginning of the Creative Name. e.g.
|
SQL
|
Yahoo DSP | Creative Custom ID | Direct Pull from the |
SQL
|
Creative Name | 8 to 9 digit at the end or beginning of the Creative Name. e.g.
|
SQL
| |
Taboola / Yahoo Native Network | Custom ID | Direct Pull from the |
SQL
|
URL | 8 to 9 digit starting with a e.g. |
Related articles
- Report Migration Guide
- Column Migration Guide
- Tablestakes Migration Guide
- Data Library 2.0 Migration Guide
- Data Library 2.0 Field Mapping
- Data Library 2.0 Report DAGs
- Core Categorizations in Data Library 2.0
- Placement ID methodology in Data Library 2.0
- Data Library Platform dbt Packages
- Data Library 2.0 FAQs