Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Geckboard's Point Based Lead Score
CASE
WHEN employees >= 500 THEN 50
WHEN employees >= 100 THEN 40
WHEN employees >= 50 THEN 10
WHEN employees >= 25 THEN 5
WHEN employees >= 10 THEN 3
ELSE -2
END
+
CASE
WHEN is_edu = true AND is_student = false THEN -10
WHEN is_student = true THEN -200
WHEN email like '%.edu' THEN -200
WHEN email like '%.edu.%' THEN -200
ELSE 0
END
+
CASE
WHEN is_spam = true THEN -200
ELSE 0
END
+
CASE
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%business%' THEN 3
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%sales%' THEN 3
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%manager%' THEN 3
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%marketing%' THEN 3
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%chief%' THEN 10
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%founder%' THEN 10
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%owner%' THEN 10
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%director%' THEN 10
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%vp%' THEN 10
WHEN LOWER(COALESCE(employment__title, employment__role)) LIKE '%president%' THEN 10
WHEN COALESCE(employment__title, employment__role) IS NOT NULL THEN 1
ELSE 0
END
+
CASE
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%software%' THEN 10
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%media%' THEN 2
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%education%' THEN -200
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%services%' THEN 7
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%health care%' THEN 5
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%real estate%' THEN -10
WHEN COALESCE(category__industry, category__industrygroup, category__sector) IS NOT NULL THEN 1
ELSE 0
END
+
CASE
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%united states%' THEN 3
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%canada%' THEN 3
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%australia%' THEN 3
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%new zealand%' THEN 3
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%sweden%' THEN 2
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%denmark%' THEN 2
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%finland%' THEN 2
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%norway%' THEN 2
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%holland%' THEN 2
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%switzerland%' THEN 1
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%france%' THEN 1
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%germany%' THEN 1
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%austria%' THEN 1
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%belgium%' THEN 1
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%united kingdom%' THEN 3
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%india%' THEN -4
WHEN LOWER(COALESCE(geo__country, geo__country)) LIKE '%brazil%' THEN -4
WHEN COALESCE(geo__country, geo__country) IS NOT NULL THEN 0
ELSE -2
END
+
CASE
-- Tech
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE 'software' THEN 5
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%internet software & services%' THEN 5
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%media%' THEN 5
WHEN LOWER(COALESCE(category__industry, category__industrygroup, category__sector)) LIKE '%communications equipment%' THEN 5
END
+
CASE
WHEN LOWER(type) LIKE '%private%' THEN 5
WHEN LOWER(type) LIKE '%public%' THEN 4
WHEN LOWER(type) LIKE '%government%' THEN 3
WHEN LOWER(type) LIKE '%education%' THEN 2
WHEN LOWER(type) LIKE '%personal%' THEN 1
WHEN LOWER(type) IS NOT NULL THEN 1
ELSE 0
END
+
CASE
WHEN alexa__globalrank >= 1000000 THEN 0
WHEN alexa__globalrank >= 100000 THEN 1
WHEN alexa__globalrank >= 10000 THEN 3
WHEN alexa__globalrank >= 1000 THEN 5
WHEN alexa__globalrank >= 100 THEN 7
WHEN alexa__globalrank >= 1 THEN 10
ELSE 0
END
+
CASE
WHEN metrics__raised >= 10000000 THEN 10
WHEN metrics__raised >= 5000000 THEN 7
WHEN metrics__raised >= 1000000 THEN 5
WHEN metrics__raised >= 500000 THEN 3
WHEN metrics__raised >= 100000 THEN 1
ELSE 0
END
+
CASE
WHEN metrics__marketcap >= 1000000000 THEN 10
WHEN metrics__marketcap >= 100000000 THEN 7
WHEN metrics__marketcap >= 10000000 THEN 5
WHEN metrics__marketcap >= 1000000 THEN 3
WHEN metrics__marketcap >= 100000 THEN 1
ELSE 0
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.