How To Establish RAG Statuses For Your KPIs

Understanding both your organization’s strong points and pain points is one of the most important strategy management steps a company can take—and key performance indicators (KPIs) allow you to do so. But combing through your reports and relying on a “gut feeling” to tell you whether or not your KPIs are on target isn’t a good plan. Rather, you need to be able to quickly and expertly evaluate whether your goals are being met without any emotion or error.

This is where ClearPoint Strategy comes in. Our software helps you efficiently manage and track your KPIs, providing clear, objective insights into your performance.

See ClearPoint Strategy in action! Click here to watch a quick DEMO on the software

What Does a RAG Status Mean?

In project management RAG—or red, amber, green—statuses act as a KPI traffic light: red is an alert, amber (or yellow) signals caution, and green means you’re in the clear.

Within this article, we’ll walk through how you can establish your RAG statuses and tolerances. We’ll also explore how to know if you need to revise those tolerances and what circumstances might call for this editing.

How Do I Get Started With Setting My RAG Statuses?

You’ll have to determine what you’re measuring or evaluating first—which should be pulled from your scorecard. Following that, you’ll need to determine a measure owner and a KPI target.

You’ll also have to decide whether you’re going to evaluate more than one series in a measure. A series is a way of displaying information in a measure, like a “target” and an “actual.” Many organizations only evaluate their KPIs based on actuals, but some also look at the year-to-date actual or the end-of-year forecast.

Regardless of what you decide on, you need to think about whether your target will change from one quarter to the next or if it will stay the same. For example, if you’re examining changes in revenue with a goal of one million dollars in net profit, it may change drastically each quarter: $250,000 in quarter one, $500,000 in quarter two, and so on. On the flip side, you might be trying to keep the employee retention rate at 90%, which would not and should not shift over each quarter.

If you’re not sure how to get started with this process, don’t worry—we’ve created a step-by-step toolkit, which you can download for free. (You’ll find it at the end of this article.)

What Should My Tolerance Range Be?

It’s important to have a starting place for your tolerance ranges. This is a good place to begin:

• Green: At or above your target.
• Amber: Within 10% of your target.
• Red: Less than 10% of your target.

But keep in mind that this is only a guideline. There are many situations where you will need to modify this to make your RAG statuses fit better in line with the KPI you’re measuring—which leads us to our next question.

Should My Tolerances Be More Forgiving or More Tightly Controlled?

Your amber status might need to be tighter—perhaps within 3-5% of your target (instead of 10%)—in the following situations:

1. If you are very familiar with the element you are measuring and your results are highly predictable. This may be the case for an activity that you repeat frequently, like answering the phone in your call center.
2. If it is critical to act quickly when the measure goes off track. For instance, any safety, uptime, and call response time measures are going to need to have a tighter tolerance. This is critical to the vitality of your business, so being 10% off of something like safety should likely be indicated as red.

Your amber RAG statuses might need to be looser—perhaps within 20% of your target (instead of 10%)—for these reasons:

1. If there’s not a lot of volume for the activity. Consider a situation where you are tracking renewal rates and you have a very small percentage of customers who are renewing. If your tolerance is set too tight, you might trigger a red status when it should be yellow.
2. If you’re not as familiar with an activity. Let’s say you are integrating a new innovation at your company, or you’re trying to reduce waste and become more green. If you haven’t done something like this before, you’re probably not sure what to expect. In response, consider loosening your RAG statuses, so you don’t trigger red when you should still be amber.

Claim your FREE Project Management Field Guide for project success

Improve Your KPI Management with ClearPoint Strategy

Ready to take control of your KPI management and eliminate guesswork? ClearPoint Strategy is here to streamline your process. Our comprehensive software solution helps you set, track, and adjust your RAG statuses effortlessly, ensuring your KPIs are always aligned with your strategic goals.

Book a personalized demo with our experts and see how our software can help you achieve precise, data-driven insights.

Book your FREE 1-on-1 DEMO with ClearPoint Strategy

FAQ:

How do you add RAG status in Excel?

To add RAG status in Excel:

- Create a new column for RAG status.
- Use Conditional Formatting: Select the cells in the RAG status column, go to the Home tab, click on Conditional Formatting, and choose 'New Rule.'
- Set the Rules: Define rules based on your criteria (e.g., Green for values >= 90%, Amber for 70%-89%, Red for < 70%).
- Apply Formatting: Choose the appropriate color fill for each condition (Red, Amber, Green) and click OK.

How do you determine RAG status?

RAG status is determined by:

- Setting Criteria: Define specific thresholds for Red, Amber, and Green based on performance metrics.
- Evaluating Performance: Compare actual performance against these thresholds.
- Green: Indicates performance is on or above target.
- Amber: Indicates performance is slightly below target and may need attention.
- Red: Indicates performance is significantly below target and requires immediate action.

What does RAG status mean in project management?

In project management, RAG status is a color-coded system used to indicate the health of a project:

- Red: Significant issues or delays; immediate action required.
- Amber: Potential issues that need monitoring; some corrective actions may be needed.
- Green: On track; no immediate issues or risks.

How do you show RAG status in PowerPoint?

To show RAG status in PowerPoint:

- Insert a Table or Shapes: Use a table or shapes to represent different status indicators.
- Color Coding: Manually fill the cells or shapes with Red, Amber, or Green colors based on the status.
- Add Labels: Include labels or legends to explain the meaning of each color.
- Use Icons: Alternatively, use color-coded icons (traffic lights) to represent each status.

What is a RAG status report?

A RAG status report is a visual tool used in project management to provide a quick overview of the project’s health:

- Red: Highlights areas with significant issues or high risks.
- Amber: Indicates areas with potential issues or moderate risks.
- Green: Shows areas that are on track and performing well.
The report helps stakeholders quickly assess project status and identify areas needing attention.

‍