Geckboard's Point Based Lead Score

geckoboard_madkudu_points_based

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