Catalog / Dimensions
3 custom dimensions

Custom Dimensions 3 ported

Default channel grouping

ported
Polar id: custom_internal-default-channel-grouping · Implemented as: dim_channel_grouping (seed)
WHEN
dimension.*.channel is Direct
→ THEN: Direct
WHEN
or dimension.*.channel isInList Google,Bing,Duckduckgo,Ecosia,Reddit
or dimension.*.channel contains Yahoo
or dimension.*.channel contains Yandex
or dimension.*.channel contains Baidu
or dimension.*.channel contains Duckduckgo
or dimension.*.channel contains Aol
dimension.*.channel is Organic Search
→ THEN: Organic Search
WHEN
or dimension.*.channel isInList Bing Ads,Google Ads,Amazon Ads
or dimension.*.channel contains Doubleclick
dimension.*.channel is Paid Search
→ THEN: Paid Search
WHEN
or dimension.*.channel isInList Attentive,Klaviyo,Postscript,Yotpo,Omnisend
dimension.*.channel is Email/SMS
→ THEN: Email/SMS
WHEN
and dimension.ga_main.channel is Pinterest
dimension.ga_main.medium isInList referral,social,(none),(not set)
→ THEN: Organic Social
WHEN
and dimension.ga_main.channel is Pinterest
dimension.ga_main.medium isInList cpc,paid,clickthrough
→ THEN: Paid Social
WHEN
or dimension.*.channel isInList Refersion,Tapjoy,Sweatcoin
dimension.*.campaign contains affiliate
→ THEN: Affiliates
WHEN
or dimension.*.channel isInList Facebook,Tiktok,Instagram,Pinterest
dimension.*.channel is Organic Social
→ THEN: Organic Social
WHEN
or dimension.*.channel isInList Facebook Ads,Tiktok Ads,Pinterest Ads,Snap Ads,Snapchat Ads,Criteo
dimension.*.channel is Paid Social
→ THEN: Paid Social
WHEN
dimension.*.channel contains Undefined
→ THEN: Undefined
ELSE
→ Other

Channel Group (Brian's taxonomy)

ported
Polar id: custom_5558 · Implemented as: apply_polar_channel_group() macro + dim_polar_channel_taxonomy seed
WHEN
dimension.*.channel is Direct
→ THEN: Direct
WHEN
dimension.*.channel isInList Google Ads,Youtube,Doubleclick,Googlesyndication,Android
→ THEN: Paid Search
WHEN
dimension.*.channel isInList Google,Google Search
→ THEN: Organic Search
WHEN
dimension.*.channel isInList Meta,Facebook Ads,Instagram Ads
→ THEN: Meta
WHEN
dimension.*.channel isInList Facebook,Instagram
→ THEN: Organic Social
WHEN
dimension.*.channel isInList Klaviyo,Orderlyemails
→ THEN: Email
WHEN
dimension.*.channel isInList Attentive,Mobile
→ THEN: SMS
WHEN
dimension.*.channel is Undefined
→ THEN: Undefined (Pixel Gap)
WHEN
dimension.*.channel isInList Thetechnews,Exclaim,Crowdsearch,Futurenews,Relevantsearchtool,Amazon-adsystem,Amazingfact,Purchase,Dugouthub,Dealtruck,Webnavigator,Outbrain,Bitsarchive,Searchquesto,Actualweather,Themediatrust,Softy,Pch,Limitlesstcg
→ THEN: Bot / Spam Traffic
ELSE
→ Other

Product Revenue Exclusions

ported
Polar id: custom_5302 · Implemented as: _dim_product_revenue_exclusions mart model
WHEN
or dimension.shopify_sales_main.customer_email is photoshoots@intotheam.com
or dimension.shopify_sales_main.product_titles_in_order contains Green Package Protection
or dimension.shopify_sales_main.product_titles_in_order contains Monthly Tee Club Subscription
and dimension.shopify_sales_main.sku is AM12835
dimension.shopify_sales_main.store is into-the-am.myshopify.com
→ THEN: ITAM Exclusions
WHEN
or dimension.shopify_sales_main.customer_email is photoshoots@iheartraves.com
and dimension.shopify_sales_main.product_titles_in_order contains Green Package Protection
dimension.shopify_sales_main.store is iheartraves.myshopify.com
→ THEN: iHR Exclusions
ELSE
→ Other