Google Data Studio > Custom Field Formula > Google Analytics Connector > Custom Channel Grouping

gds-custom-channel-grouping.sql

CASE
WHEN ( CONTAINS_TEXT(Source / Medium, "(direct) / (none)") OR CONTAINS_TEXT(Source / Medium, "none")  ) THEN "Direct"
WHEN ( CONTAINS_TEXT(Campaign,"email") OR CONTAINS_TEXT(Source / Medium, "email") ) THEN "Email"
WHEN ( CONTAINS_TEXT(Source / Medium,"affiliate") OR CONTAINS_TEXT(Source / Medium, "shareasale") ) THEN "Affiliates"
WHEN ( CONTAINS_TEXT(Source / Medium,"display") OR CONTAINS_TEXT(Source / Medium, "taboola") ) THEN "Display Ads"
WHEN ( CONTAINS_TEXT(Source / Medium,"organic") OR CONTAINS_TEXT(Source / Medium, "baidu") ) THEN "Organic Search"
WHEN ( CONTAINS_TEXT(Source / Medium,"google / cpc") OR 
	CONTAINS_TEXT(Source / Medium, "adwords") OR
    CONTAINS_TEXT(Source / Medium, "googleadservices.com / referral") OR 
    CONTAINS_TEXT(Source / Medium, "Google / Ad") 
    ) THEN "Paid Search"
WHEN ( 
	CONTAINS_TEXT(Source / Medium,"Pinterest / Pinterest Ad") OR
    CONTAINS_TEXT(Source / Medium, "Facebook / Ad") OR 
    CONTAINS_TEXT(Source / Medium, "Facebook / Facebook Ad") OR 
    CONTAINS_TEXT(Source / Medium, "ads.pinterest.com / referral") OR 
    CONTAINS_TEXT(Source / Medium, "facebook / cpc") OR 
    CONTAINS_TEXT(Source / Medium, "Pinterest / Pinterest_Ad") OR 
    CONTAINS_TEXT(Source / Medium, "Facebook / Ad") OR
    CONTAINS_TEXT(Source / Medium, "IGShopping") 
    ) THEN "Social Ads"
WHEN (
		( CONTAINS_TEXT(Source / Medium,"pinterest") OR
		  CONTAINS_TEXT(Source / Medium,"smart.bio") OR 
          CONTAINS_TEXT(Source / Medium,"linktr") OR 
		  CONTAINS_TEXT(Source / Medium, "facebook") OR 
          CONTAINS_TEXT(Source / Medium,"t.co") OR 
          CONTAINS_TEXT(Source / Medium, "instagram") OR 
          CONTAINS_TEXT(Source / Medium, "twitter")
        ) AND NOT (
          CONTAINS_TEXT(Source / Medium, " ad")
        ) AND NOT (
          CONTAINS_TEXT(Source / Medium, "cpc" )
        ) AND NOT (  
          CONTAINS_TEXT(Source / Medium, "shopping")
        )
    ) THEN "Organic Social"
WHEN (
		( CONTAINS_TEXT(Source / Medium,"referral") )
        AND NOT (
          REGEXP_MATCH(Source / Medium, "smart.bio|shareasale|shopping|baidu|facebook|t.co|pinterest|twitter|instagram|taboola|google")
        )
    ) THEN "Referral"
END