DAY 13: Weekly Sales Dashboard & Targets
The metrics that actually matter for agency sales
Every agency has the same funnel. Track each stage to find bottlenecks.
Prospects → Outreach → Replies → Calls → Proposals → Closed
| Metric | Target | Good | Problem If... |
|---|---|---|---|
| Outreach sent | 500/week | 300+ | < 200 |
| Open rate | 50%+ | 40%+ | < 30% |
| Reply rate | 5%+ | 3%+ | < 2% |
| Calls booked | 5/week | 3+ | < 2 |
| Proposals sent | 3/week | 2+ | < 1 |
| Close rate | 30%+ | 25%+ | < 20% |
| Deals closed | 1/week | 2-4/month | < 1/month |
Columns: • Week (Monday date) • Outreach Sent • Opens • Replies • Positive Replies • Calls Booked • Calls Completed • Proposals Sent • Deals Closed • Revenue Closed Formulas: • Open Rate = Opens / Outreach • Reply Rate = Replies / Outreach • Call Rate = Calls / Positive Replies • Close Rate = Closed / Proposals
Work backwards from your revenue goal:
Goal: $20k/mo in new revenue Avg deal size: $2,500/mo Deals needed: 8/month (2/week) At 25% close rate → 32 proposals/month (8/week) At 50% proposal rate → 64 calls/month (16/week) At 3% reply rate → 2,133 outreach/month (533/week) Daily activity: ~75-100 outreach/day