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

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

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

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

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

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

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'

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