How does the two Progress calculations for the Control KPI key result work in Profit.co?

Category: KPIs

Profit.co has progress calculation methods for the control KPI. Successful check-ins(target achieved) divided by total number of check-ins and Distance from the target, as of the check-in date.

Why this feature?

By using this feature the key result can be progressed based on the successful or unsuccessful check-in values and for Distance from the target, as of the check-in date based on the distance of the successful check-in and here all the check-in will be considered.


Successful check-ins(target achieved) divided by total number of check-ins

In this type of progression, the successful check-ins will be taken into consideration. The Progress will happen and the final calculation will be based on the number of successful check-ins .

The progress Calculation formula is,

“Successful check-ins(target achieved) / total no. of check-ins for the given target period”

For example, We have a Key result to Maintain Customer Engagement Score in between 4 to 5

key-result-to-maintain-customer-engagement

If the key result is created in a quarter with the check-in frequency of Every Friday. The total number of check-ins will be 13.

So each successful weekly check-in will hold 7.69% progress.

Let's consider the check-ins happening in the table below

 

Week

Control type

Lower Limit

Upper Limit

Actual

Met Target?

Calculation

Progress %

Week 1

In between

4

5

4.8

Yes

1/13=8

8

Week 2

In between

4

5

4.2

Yes

2/13=15

15

Week 3

In between

4

5

4.5

Yes 

3/13=23

23

Week 4

In between

4

5

3.5

No

3/13=23

23 

Week 5

In between

4

5

4.25

Yes

4/13=31

31

Week 6

In between

4

5

- 

No

4/13=31

31

Week 7

In between

4

5

4.5

Yes

5/13=38

38

Week 8

In between

4

5

2

No

5/13=38

38

Week 9

In between

4

5

3

No

5/13=38

38

Week 10

In between

4

5

4.5

Yes

6/13=46

46

Week 11

In between

4

5

4.6

Yes

7/13=54

54

Week 12

In between

4

5

5

Yes

8/13=62

62

Week 13

In between

4

5

4.5

Yes

9/13=69

69

check-ins happening

Distance from the target, as of the check-in date.

check-in-date

In this type of progression, All the check-ins will be taken into consideration whether the check-in is successful or unsuccessful. The Progress will happen based on the distance from the target value.

Note: In this case, the 13th week progress will be the final Progress.

Scenario 1 for value type ‘at most’

The progress Calculation formula is,

100 + ( Target Value - Check-in Value) / Target value * 100

For example, We have a Key result to Maintain the Cost Per Click at most at $1

scenario1

Assuming this scenario, the following table shows how the progress calculation works in the scenario. As said earlier, here the 13th week progress will be the final Progress.

 

Week

KPI

Control type

Start Value

Target ($)

Actual

Progress %

Week 1

Cost per Click

At Most

0

1

0.8

120

Week 2

Cost per Click

At Most

0

1

1

100

Week 3

Cost per Click

At Most

0

1

0.5

150

Week 4

Cost per Click

At Most

0

1

0.75

125

Week 5

Cost per Click

At Most

0

1

0.25

175

Week 6

Cost per Click

At Most

0

1

1

100

Week 7

Cost per Click

At Most

0

1

1.5

50

Week 8

Cost per Click

At Most

0

1

1.2

80

Week 9

Cost per Click

At Most

0

1

1.35

65

Week 10

Cost per Click

At Most

0

1

1.5

50

Week 11

Cost per Click

At Most

0

1

1.75

25

Week 12

Cost per Click

At Most

0

1

1

100

Scenario 2 for value type ‘at least’

The progress Calculation formula is,

100 - ( Target Value - Check-in Value) / Target value * 100

For example, We have a Key result to Publish 5 blog post every week

scenario2

Assuming this scenario, the following table shows how the progress calculation works

 

Week

KPI

Control type

Start Value

Target ($)

Actual

Progress %

Week 1

# of blogs

At least

0

5

4

80

Week 2

# of blogs

At least

0

5

6

120

Week 3

# of blogs

At least

0

5

5

100

Week 4

# of blogs

At least

0

5

2

40

Week 5

# of blogs

At least

0

5

0

0

Week 6

# of blogs

At least

0

5

1

20

Week 7

# of blogs

At least

0

5

2

40

Week 8

# of blogs

At least

0

5

4

80

Week 9

# of blogs

At least

0

5

7

140

Week 10

# of blogs

At least

0

5

5

100

Week 11

# of blogs

At least

0

5

2

40

Week 12

# of blogs

At least

0

5

1

20

Week 13

# of blogs

At least

0

5

6

120

Related Answer Post:

To learn more about how to calculate the Average/Sum cumulative value for the Control KPI Key Result, click here.

Related Questions