I need to create a sales tracking board for a few different sales people, who all have different targets and I’d love some advice.
They have four measurements we track: 1st call, 2nd call, proposals and deals won - however each person has different targets, for instance:
Linda targets: 15 1st meet, 10 2nd meet, 5 proposals, 3 deals won.
Andy targets: 10 1st meet, 8 2nd meet, 4 proposals, 2 deals won.
Pam targets: 12 1st meet, 7 2nd meet, 3 proposals, 1 deals won.
To help keep track of these targets, each column has its ‘units’ set to the number required - but the problem is that setting this once, applies it to all people which is wrong.
Is there a good way to handle this?