How to reclassify media channel data in Data Library
Overview
Each ADL-enabled customer has a core_media_channel
categorization available that enables users teams to reclassify media channel given combination of account, campaign, and ad group name(s) regardless of the ad network the platform serves to. Learn how to utilize this categorization to do so.
Default classification logic
Platform | Channel | Logic |
---|---|---|
Google Ads | SEARCH |
SQL
|
DISPLAY |
SQL
| |
Microsoft Bing | SEARCH |
SQL
|
DISPLAY |
SQL
| |
Facebook Ads | SOCIAL | N/A |
Linkedin Ads | ||
Reddit Ads | ||
Snapchat Ads | ||
TikTok Ads | ||
Twitter Ads | ||
Amazon DSP | DISPLAY | N/A |
DV360 | ||
Bidtellect | ||
The Trade Desk | ||
Yahoo DSP |
Instructions
1.) Determine which record(s) from your ADL report you would like to reclassify channel
for by running a version of the following query:
select distinct
channel, --default value
core_media_channel, --new value via categorization
platform,
account_name,
campaign_name,
adgroup_name
from {alli_client}.ad_performance
where channel = '{CHANNEL}'
Replace {CHANNEL}
with one of the following: SEARCH
, SOCIAL
, or DISPLAY
2.) In Alli, navigate to Reporting → Categorizations and click on the core_media_channel
categorization
3.) Fill out the rules as necessary, e.g.:
![image-20240109-054014.png](../../__attachments/2875687055/image-20240109-054014.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
In this example, let’s assume that the Google Ads account named Best Western (DS)
serves exclusively towards the Google Display Network (GDN), i.e., AdNetworkType = 'CONTENT'
. This manifests as DISPLAY
in ADL by default (see Default classification logic section above).
The rules provided in the core_media_channel
categorization above is meant to reclassify it to SEARCH
.
3.) Click on Save and Publish to publish the categorization
3.) Run the Alli Data Library 2.0 - Refresh app
4.) Validate your changes by re-running the query from step #1, e.g.:
select distinct
channel, --default value
core_media_channel, --new value via categorization
platform,
account_name,
campaign_name
from {alli_client}.ad_performance
where platform = 'Google Ads'
and account_name = 'Best Western (DS)'
and campaign_name = 'Install_National_X_US_Google_BW_BW_X_App_X_En_X_X'
and channel = 'SEARCH'
Before
![image-20240109-061535.png](../../__attachments/2875687055/image-20240109-061535.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
After
![image-20240109-061610.png](../../__attachments/2875687055/image-20240109-061610.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
For validation purposes, only the core_media_channel
column gets populated with the categorization output. The channel
column retains its value, and it does not get overwritten.
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