Skip to content

Instantly share code, notes, and snippets.

@chicks

chicks/gist:217e83e0fe9f848ebdd9

Created October 24, 2014 18:00
Show Gist options
  • Save chicks/217e83e0fe9f848ebdd9 to your computer and use it in GitHub Desktop.
Save chicks/217e83e0fe9f848ebdd9 to your computer and use it in GitHub Desktop.
Download ZIP
Populate Lead Score Columns in MySQL
Raw
gistfile1.txt
UPDATE contacts_cstm SET lead_score_rank_c =
ELT(1 + FLOOR(RAND()*5), 'Inquiry', 'Prospect', 'Marketing Qualified', 'Sales Accepted', 'Sales Qualified');
UPDATE contacts_cstm SET engagement_score_rank_c =
ELT(1 + FLOOR(RAND()*3), 'Passive', 'Active', 'Engaged');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment