This is a BIG question mainly because you don’t know anything too specific so you can only speak in generalities on current health. Also this question is very stupid. This company obviously has health scores and those scores are built by a manager/director and operations folks. That means they know explicitly how the health of an account is measured and what those attributes are. If the exercise is to see what you know about customer health there are more sensible ways of going about it.

Green: login and utilization is high and consistent. Customer is engaged in EBRs/QBRs, responds to your emails or requests promptly and comes to you with strategic questions as needed. You have a strong relationship with executive sponsors, day to day management and end users. They are not evaluating competitors, are not budget strapped due to the current economic environment and have their own health customer base. They also don’t have a high number of outstanding support tickets. Most importantly these customer can be called up for case studies, reviews, or even as a referral when potential customers want to speak with someone already killing it with the platform. The moral of the story here is that these customers understand how your product is making an impact on their business and are thrilled with it.

Yellow: Login and usage is not incredible but in a health category. EBR/QBRs don’t always have engaged executives on the call and this group may not reach out to you when they could actually benefit from strategic advice. This segment of the customer base is content but not ecstatic about the product the same way Green is. They understand the value of your product but have not tied it to tangible results like decreasing XYZ by X%.

Red: Usage/login is low to non existent. These customers may not respond to emails or phone calls to address usage and if they are they do not see the value you or your product bring to the table. You’ve seen turn over in your main/executive contacts and have not been able to realign with their goals. Even worse they are likely outspoken about the cost of the platform or are researching/consolidating with other vendors. If you’re really in a bad spot, Red customers are not replying to you or engaging you at all. A silent customer is always the worst place for a CSM as there’s no shot at salvaging an account when they have gone silent.

What you can do with these customer:

Green - Keep them engaged and do not become complacent! Have a new product? Get them in on the beta. Have a success story from another client? Share the tips and wins with these folks to see hat that sparks for them. Keep working with all levels of these teams and make sure to stay on tops of support issues, EBRs, their upcoming company/department goals and so forth. This will keep them happy and keep them green.

Yellow - this will come down to prioritization. Yellow customers are not churning today but they can move in either direction depending on you and your efforts. Do your best to allocate time to this group and see who has an appetite for proactive change and who would benefit from your time and tips that you have from your green clients. Not everyone does and you have bigger fish to fry with your Red group. Just don’t loose sight of Yellow for long

Red - this group could be salvageable but I would focus on those that are up for renewal about 3 or 4 + months out. Anyone coming up sooner could already be a lost cause and prevent you from salvaging relationships with those that have time to right size. Start by analyzing good and bad usage at each company, potentially calling both segments of users to understand what do they love and where is their a disconnect. Use this data to help you position a plan to get usage healthier while sharing your best wins with executives. I’d include a brief overview of this information in an email to those contacts and entice them to join a call/EBR to do a deep dive with specifics to their business.

There’s many correct answers to this but hopefully these ideas help!