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,
  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 the platform, account, campaign, and ad group names:

• Google Ads

• Ideas Collide Marketing Communications

• Indie Films 2020

• Ashok Patel

are set to serve exclusively to Google’s YouTube Ads ad network, designated by the ad_network_type field in the raw API data. This is classified as SOCIAL for channel in ADL be default.

The core_media_channel categorization above overwrites this field as SEARCH in ADL.

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 querying your ADL report:

Related articles