Skip to main content
Skip table of contents

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
select *
from {alli_client}.googleads_insights_ad
where AdNetworkType != 'CONTENT'

DISPLAY

SQL
select *
from {alli_client}.googleads_insights_ad
where AdNetworkType = 'CONTENT'

Microsoft Bing

SEARCH

SQL
select *
from {alli_client}.bing_insights_ad
where AdDistribution = 'Search'

DISPLAY

SQL
select *
from {alli_client}.bing_insights_ad
where AdDistribution = 'Audience'

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:

SQL
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

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

SQL
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

After

image-20240109-061610.png
JavaScript errors detected

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

If this problem persists, please contact our support.