Preview:
CASE
WHEN REGEXP_MATCH(Landing Page,'https://example.com|https://example.com/') THEN 'Homepage'
WHEN REGEXP_CONTAINS(Landing Page,'larry|sergei') THEN 'Google'
WHEN REGEXP_CONTAINS(Landing Page,'steve') THEN 'Apple'
WHEN REGEXP_CONTAINS(Landing Page,'xavier') THEN 'Free'
ELSE 'Articles and Other'
END
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter