Number of Employees | Community
Skip to main content
Colin_Mann
Colin_Mann
New Participant
April 21, 2016
Solved

Number of Employees

  • April 21, 2016
  • 2 replies
  • 2179 views

What's the best way to show the number of employees when the data is a range (such as 100-500 for example) and this data needs to be synchronised to a CRM platform? We currently would show the data in a column in this format: "100-500" and then map it to 'Number of Employees' in Marketo but I'm unsure whether this is the best method.

What is people's best practice in this case?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Well, you can't map the string representation of "{min}-{max}" to a single number (integer), obviously, since it contains two numbers.

Unless you are planning to do some complex arithmetic on these, I would keep it as a string.

Or, assuming your ranges never overlap -- and will never change -- you could store just the minimum to signify the range.

The most precise way to do this is to use two different numbers.

2 replies

J
Julz_James
New Participant
April 27, 2016

Hi Colin!,

What I tend to do is use the middle number of the range for the number of employees, and then all form fills etc populate the 'middle number' which can then be updated in the CRM by the Business Development Team when they do some more investigation once the lead is passed to them.

You can map 100-500, for example, as long as the field is a string, but I think that getting a single figure is the better place to start.

Thanks

Juli

    SanfordWhiteman
    SanfordWhitemanAccepted solution
    New Participant
    April 22, 2016

    Well, you can't map the string representation of "{min}-{max}" to a single number (integer), obviously, since it contains two numbers.

    Unless you are planning to do some complex arithmetic on these, I would keep it as a string.

    Or, assuming your ranges never overlap -- and will never change -- you could store just the minimum to signify the range.

    The most precise way to do this is to use two different numbers.

      Terms & ConditionsAccessibility statement

      Loading footer...