Your Achievements
Level 1
0% to
Level 2
Next /
to gain points, level up, and earn exciting badges like the new Applaud 5 BadgeLearn more!
View All BadgesSign in to view all badges
Open Alert Bar

Use of "other" when standardizing data

Kim_Gandy1
Level 7
Level 7
‎04-18-2017 09:27 AM
‎04-18-2017 09:27 AM

Use of "other" when standardizing data

I'm working to fill holes and standardize lead info in my database, particularly "job title" and "industry." When using drop downs in a form, which of the following is a best practice?

  1. CEO, VP, Director, Other (fill in blank if "other")
    • Potential for too many people to fill in blank, negating standardization.
  2. CEO, VP, Director, Other
    • If "other" is chosen, this is of no use to me when targeting in smart lists.
  3. CEO, VP, Director
    • Potential for people to select incorrect title because correct title is not offered.
Labels:
1,166
Reply
1 REPLY 1
Darrell_Alfons2
Level 10 - Champion Alumni
Level 10 - Champion Alumni
‎04-18-2017 11:18 AM
‎04-18-2017 11:18 AM

Re: Use of "other" when standardizing data

This is a good question.

2 and 3 are definitely tough ones.

A good option would be to create another field called job function or job level (or both), and run nightly smart campaigns that fill these so you can use them in your sends. So smart campaign would be, if Title contains CEO,CXO,CMO etc then Change data value Job Level = C Suite.

Then you can get the benefit of still capturing the exact job title, which sales would appreciate.

978
Reply
Home