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