An input refers to an account-level field that contribute to its group's score.
Catalyst applies a scoring formula based on the properties provided for the input within the health profile configuration.
Input scoring for non-numeric fields
Inputs that rely on fields with non-numeric data types (e.g., picklists, boolean, etc) use the following calculation:
- Score of
1if the input matches the "At Risk" rule - Score of
5if the input does not match any rule - Score of
10if the input matches the "Healthy" rule
Input scoring for numeric fields
Inputs that rely on fields with numeric data types ( e.g., integer, currency, decimal) use a series of calculations, based on the numeric values you provide for each condition:
- Score of
1-3if the input matches the "At Risk" rule - Score of
4-7if the input does not match any rule - Score of
8-10if the input matches the "Healthy" rule
From there, Catalyst determines final score based on mathematical increments according to the range of values between conditions.
For example, let's say our input was Average Hours in App. We defined the following relations/values for "Health" and "At Risk:"
- Healthy is more than 25
-
At Risk is less than 5
Catalyst knows that a Neutral value will be between 5 and 25.
| Score | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Field value | 5 | 25 |
From there, Catalyst identifies the top value for At Risk and starting value for Healthy by subtracting or adding 0.1 from the neutral end points.
| Score | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Field value | 4.9 | 5 | 25 | 25.1 |
Next, Catalyst determines the increments by dividing the values by the number of possible scores for each category: 1-3 (3 possible values), 4-7 (4 possible values), 8-10 (3 possible values).
-
At Riskincrements: 5 / 3 = 1.7 -
Neutralincrements: (25 - 5) / 4 = 5 -
Healthyincrements: 25 / 3 = 8.3
Finally, Catalyst determines the range of values for each score:
| Score | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Field value | <=1.5 | 1.6– 3.2 | 3.3–4.9 | 5–10 | 10.1–15 | 15.1–20 | 20.1–25 | 25.1–33.3 | 33.4–41.6 | >=41.7 |
If a data point used in the health score calculation is null or missing, it will be included in the final calculation as neutral, unless specifically defined to be healthy or at risk.
Exceptions
If Catalyst doesn't have two numbers in the input, the calculation relies on increments based on known values.
For example, let's say our input was Averag Hours in App. We defined the following relations/values for "Health" and "At Risk:"
- Healthy is more than 25
-
At Risk is blank
Catalyst knows that the top Neutral value will be 25.
| Score | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Field value | 25 |
Catalyst identifies the bottom value for At Risk as "is blank." Catalyst identifies the starting value for Healthy by adding 0.1 from the neutral end point.
| Score | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Field value | is blank | 25 | 25.1 |
Next, Catalyst determines the increments by dividing the values by the number of possible scores for each applicable category: 4-7 (4 possible values), 8-10 (3 possible values).
-
At Riskincrements: none (N/A) -
Neutralincrements: 25 / 4 = 6.25 -
Healthyincrements: 25 / 3 = 8.3
Finally, Catalyst determines the range of values for each score:
| Score | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Field value | is blank | N/A | N/A | 0–6.2 | 6.3–12.4 | 12.5–18.7 | 18.8–25 | 25.1–33.3 | 33.4–41.6 | >=41.7 |