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