| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Directions | |||||||||||||||||||
2 | 1) Starting at row 11 there are common marketing channels to input metrics as they apply to your department or that you wish to utilize in order to forecst. 2) The data you input will populate in the Master Monthly Matrixes at the bottom of the sheet, one that breaks down each channel on a granular level and the second that totals the data for the month. 3) Copy and paste the information (do not copy the format) from the Master Matrix that sums up the department totals, into the month that the projections corolate to in Sheet 2. | |||||||||||||||||||
3 | ||||||||||||||||||||
4 | ||||||||||||||||||||
5 | ||||||||||||||||||||
6 | ||||||||||||||||||||
7 | ||||||||||||||||||||
8 | ||||||||||||||||||||
9 | ||||||||||||||||||||
10 | ||||||||||||||||||||
11 | SEO | Metrics | PPC | Metrics | Field Marketing | Metrics | Referrals | Metrics | Partnerships | Metrics | Referring Domains | Metrics | Advertising | Metrics | ||||||
12 | Monthly Spend | $35,000.00 | Monthly Event Budget | $25,000.00 | Projected Opps | 5 | Projected Opps | 2 | Spend | $15,000.00 | Spend | $85,000.00 | ||||||||
13 | SEO Budget | $2,000.00 | CPC | $100.00 | Number of Registrations | 250 | Cost Per Opp | $0.00 | Cost Per Opp | $0.00 | Projected Leads | 30 | Projected Leads | 30 | ||||||
14 | Conversion Rate | 1.50% | Conversion Rate | 10% | Number of Attendee | 85 | Close Rate | 75% | Close Rate | 50% | CPC | $500.00 | CPC | $2,833.33 | ||||||
15 | Projected Leads | 100.00 | Projected Leads | 35 | Attendance Rate | 34% | Projected Deals | 3.75 | Projected Deals | 1 | Cost Per Lead | $30.00 | Cost Per Lead | $30.00 | ||||||
16 | Cost Per Lead | $20.00 | Cost Per Lead | $1,000.00 | Attrition Rate | 66% | Average Annual Deal Size | $50,000.00 | Average Annual Deal Size | $35,000.00 | Lead to Opp Rate | 60% | Lead to Opp Rate | 70% | ||||||
17 | Lead to Opp Rate | 80% | Opportunities | 16 | Projected Leads | 20 | ALTV | $45,000.00 | ALTV | $45,000.00 | Opportunities | 18 | Opportunities | 21 | ||||||
18 | Opportunities | 80 | Cost Per Opp | $15,750.00 | Cost Per Lead | $1,250 | Close Rate | 75% | Close Rate | 80% | ||||||||||
19 | Cost Per Opp | $1,600 | Lead to Opp Rate | 45% | Qualification Rate | 100% | Projected Deals | 13.5 | Projected Deals | 16.8 | ||||||||||
20 | Close Rate | 2.5% | Close Rate | 75% | Opportunities | 20 | Cost Per Deal | $1,111.11 | Cost Per Deal | $5,059.52 | ||||||||||
21 | Projected Deals | 2 | Projected Deals | 26.25 | Close Rate | 10% | Average Annual Deal Size | $45,000.00 | Average Annual Deal Size | $45,000.00 | ||||||||||
22 | Cost Per Deal | $0.00 | Cost Per Deal | $1,333.33 | Projected Deals | 2 | ALTV | $45,000.00 | ALTV | $45,000.00 | ||||||||||
23 | Average Annual Deal Size | $55,000.00 | Average Annual Deal Size | $45,000.00 | Cost Per Deal | $12,500.00 | ||||||||||||||
24 | ALTV | $55,000.00 | ALTV | $45,000.00 | Average Annual Deal Size | $70,000.00 | ||||||||||||||
25 | ALTV | $45,000.00 | ||||||||||||||||||
26 | ||||||||||||||||||||
27 | ||||||||||||||||||||
28 | Channel | Budgets | Avg. Monthly Opps per Channel | Close Rate | Avg. Deals Mo. | Average Deal Size | Monthly Revenue | Department | Opps | Deals | Revenue | |||||||||
29 | Pay Per Click | $35,000 | 16 | 75% | 12 | $45,000 | $531,563 | Pay Per Click | 16 | 12 | $531,563 | |||||||||
30 | Organic | $2,000.00 | 80 | 3% | 2 | $55,000 | $110,000 | Organic | 80 | 2 | $110,000 | |||||||||
31 | Field Marketing | $25,000.00 | 20 | 10% | 2 | $70,000 | $140,000 | Field Marketing | 20 | 2 | $140,000 | |||||||||
32 | Referrals | N/A | 5 | 75% | 4 | $50,000 | $187,500 | Referrals | 5 | 4 | $187,500 | |||||||||
33 | Partnerships | N/A | 2 | 50% | 1 | $35,000 | $35,000 | Partnerships | 2 | 1 | $35,000 | |||||||||
34 | Referring Domains | $15,000.00 | 18 | 75% | 14 | $45,000 | $607,500 | Referring Domains | 18 | 14 | $607,500 | |||||||||
35 | Advertising | $85,000.00 | 21 | 80% | 17 | $45,000 | $756,000 | Advertising | 21 | 17 | $756,000 | |||||||||
36 | Total | $162,000 | 162 | 53% | 51 | $345,000 | $2,367,563 | Total | 162 | 51 | $2,367,562.50 | |||||||||