Skip to content

Instantly share code, notes, and snippets.

@robhammond

robhammond/Custom Medium - Data Studio.js

Created July 10, 2018 08:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save robhammond/b7537ce40eaf24d23bc1908cd58f1012 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save robhammond/b7537ce40eaf24d23bc1908cd58f1012 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. robhammond created this gist Jul 10, 2018.
    8 changes: 8 additions & 0 deletions Custom Medium - Data Studio.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    CASE
    WHEN ((Source="direct" AND Medium="(not set)") OR Medium="(none)") THEN "Direct"
    WHEN Medium="organic" THEN "Organic Search"
    WHEN (Social Source Referral="Yes" OR REGEXP_MATCH(Medium,"^(social|social-network|social-media|sm|social network|social media)$")) OR REGEXP_MATCH(Source,"(facebook|t.co|reddit|fark|linkedin|pinterest)") THEN "Social"
    WHEN Medium="email" THEN "Email"
    WHEN Medium="referral" and not(REGEXP_MATCH(Source,"(facebook|t.co|reddit|fark|linkedin|pinterest)") ) THEN "Referral"
    ELSE "(Other)"
    END