How-To: Reclassify Media Channel

Overview

This guide explains how use to Categorizations to reclassify the media channel for your campaigns/ad groups in Certified Datasources

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}.microsoftads_insights_ad
where Network != 'Audience'

select *
from {alli_client}.microsoftads_insights_ad
where Network = 'Audience'

Instructions

1.) Determine which record(s) you intend 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}'

2.) In Alli, navigate to Reporting → Categorizations and click on the core_media_channel categorization

3.) Fill out the rules as necessary, e.g.:

3.) Click on Save and Publish to publish the categorization

3.) Run the ADL 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

After

Related articles