ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAU
1
Goal Tracking Sheet
2
3
Name:
4
Company Name:
5
Year:
6
7
NOTE: cells with blue text have embedded formulas to save you time in making the calculations.
8
9
Baseline Performance Stats
10
Lead-to-Agency-Agreement Ratio - Warm Lead (%)50
11
Lead-to-Agency-Agreement Ratio - Cold Lead (%)20
12
Agency-Agreement-to-Closed Deal Ratio (%)80
13
Average commission per deal$7,000
14
Average closed deals per month3
15
16
Annual Income Goal$500,000
17
18
Monthly Suggested Targets (based on your annual income goal and baseline performance stats)
19
Leads 37
20
Agency Agreements7
21
Closed Deals6
22
23
Key Metrics January February March April May June July
August
September
October
November
December
Year End Totals
24
TargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActual
25
Leads00000000000000000000000000
26
Agency Agreements00000000000000000000000000
27
Closed Deals00000000000000000000000000
28
Average Commission/Deal7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!7,000#DIV/0!N/A#DIV/0!
29
30
Total Commission$0$0$0$0$0$0$0$0$0$0$0$0$0$0
31
32
Leads By Source January February March April May June July
August
September
October
November
December
Year End Totals
33
TargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActual
34
Repeat Clients00000000000000
35
Client Referrals00000000000000
36
Accountants00000000000000
37
Personal Networking00000000000000
38
Website - PPC (paid)00000000000000
39
Website - Organic (free)00000000000000
40
Google Places00000000000000
41
Corporate Benefits Marketing00000000000000
42
Accountants00000000000000
43
Relocation Agencies00000000000000
44
Financial Planners00000000000000
45
Other 1:00000000000000
46
Other 2:00000000000000
47
48
Total Leads00000000000000000000000000
49
Agency Agreements by Source January February March April May June July
August
September
October
November
December
Year End Totals
50
TargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActual
51
Repeat Clients00000000000000
52
Client Referrals00000000000000
53
Accountants00000000000000
54
Personal Networking00000000000000
55
Website - PPC (paid)00000000000000
56
Website - Organic (free)00000000000000
57
Google Places00000000000000
58
Corporate Benefits Marketing00000000000000
59
Accountants00000000000000
60
Relocation Agencies00000000000000
61
Financial Planners00000000000000
62
Other 1:00000000000000
63
Other 2:00000000000000
64
65
Total Applications00000000000000000000000000
66
67
Closed Deals By Source January February March April May June July
August
September
October
November
December
Year End Totals
68
TargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActualTargetActual
69
Repeat Clients00
70
Client Referrals00
71
Accountants00
72
Personal Networking00
73
Website - PPC (paid)00
74
Website - Organic (free)00
75
Google Places00
76
Corporate Benefits Marketing00
77
Accountants00
78
Relocation Agencies00
79
Financial Planners00
80
Other 1:00
81
Other 2:00
82
83
Total Closed Deals00000000000000000000000000
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100