User Tools

Site Tools


custom_channel_grouping

Custom channel grouping

Requirements for this tutorial: Working setup of Windsor.ai multitouch attribution enabled.

In this example we're going to set up a custom channel grouping in Windsor.ai. The implementation is done using a PostgreSQL case statement.

To access your Channel Groupings head to the Dataset management section on Windsor.ai charts.

Here you will see a list of data sets.

  • Click on edit on the dataset called [user-name]_attributions_and_costs

  • Click on CALCULATED COLUMNS and expand the channelgrouping column

  • Now you can easily adjust your channel groupings. The standard setup replicates the standard channel groupings of Google Analytics:
CASE 
  WHEN 
    source = '(direct)' 
    AND 
    (medium = '(not set)' OR medium = '(none)') 
    THEN 'Direct'
  WHEN 
    medium = 'organic'
    THEN 'Organic Search'
  WHEN
    medium ~ '^(social|social-network|social-media|sm|social network|social media|paids-social)$'
    THEN 'Social'
  WHEN
    medium = 'email'
    THEN 'Email'
  WHEN
    medium = 'affiliate'
    THEN 'Affiliates'
  WHEN
    medium = 'referral'
    THEN 'Referral'
  WHEN
    medium ~ '^(cpc|ppc|paidsearch)$'
    THEN 'Paid Search'
  WHEN
    medium ~ ' ^(cpv|cpa|cpp|content-text)$'
    THEN 'Other Advertising'
  WHEN
    medium ~ '^(display|cpm|banner)$'
    THEN 'Display'
  ELSE '(Other)'
END

In this example we're going to customise the standard channel grouping to add branded and generic paid search:

CASE 
  WHEN 
    source = '(direct)' 
    AND 
    (medium = '(not set)' OR medium = '(none)') 
    THEN 'Direct'
  WHEN 
    medium = 'organic'
    THEN 'Organic Search'
  WHEN
    medium ~ '^(social|social-network|social-media|sm|social network|social media|paids-social)$'
    THEN 'Social'
  WHEN
    medium = 'email'
    THEN 'Email'
  WHEN
    medium = 'affiliate'
    THEN 'Affiliates'
  WHEN
    medium = 'referral'
    THEN 'Referral'
  WHEN
    medium ~ '^(cpc|ppc|paidsearch)$' AND campaign ~ '(brand)'
    THEN 'Branded - Paid Search'
  WHEN
    medium ~ '^(cpc|ppc|paidsearch)$' AND campaign !~ '(brand)'
    THEN 'Generic - Paid Search'
  WHEN
    medium ~ ' ^(cpv|cpa|cpp|content-text)$'
    THEN 'Other Advertising'
  WHEN
    medium ~ '^(display|cpm|banner)$'
    THEN 'Display'
  ELSE '(Other)'
END
  • Once you are finished click the SAVE button and reload and refresh your dashboard. The new channel groupings will now be active.

custom_channel_grouping.txt · Last modified: 2021/04/13 04:53 by windsor_ai