Those done I check the “follow-up due today”, and find none.
Makes sense. These past few weeks I’ve strenuously “touched” every contact and set their follow-up date to be 2 months ahead.
Now I have a sense of foreboding: Is this the calm before the storm?
I decide to check the distribution of my follow-up dates in an Excel pivot table:
| weeks | Total |
| -38 | 1 |
| -30 | 2 |
| -28 | 1 |
| -27 | 1 |
| -25 | 1 |
| -18 | 1 |
| -14 | 1 |
| -12 | 1 |
| -11 | 1 |
| -9 | 1 |
| -8 | 1 |
| -5 | 2 |
| -1 | 2 |
| 0 | 31 |
| 1 | 18 |
| 2 | 22 |
| 3 | 35 |
| 4 | 20 |
| 5 | 7 |
| 6 | 13 |
| 8 | 2 |
| 9 | 39 |
| 10 | 81 |
| 11 | 59 |
| 12 | 29 |
| 13 | 5 |
| Total | 377 |
The average number of follow-ups per week starting at today (week zero) is 27. That means if I “touch” 27 contacts per week, I’ll stay on top of things.
The follow-ups prior to this week need attention. Are they inactive records? Did they slip through the net?
Given that every day or so I receive an “immediate” update from The Prospector, I should contemplate a goal of 30 contacts per week from now on. That would be 6 envelopes, emails or phone calls per day Monday through Friday.
Talk to Me!
No comments:
Post a Comment