DAY 13: Weekly Sales Dashboard & Targets

The metrics that actually matter for agency sales

The Agency Sales Funnel

Every agency has the same funnel. Track each stage to find bottlenecks.

Prospects → Outreach → Replies → Calls → Proposals → Closed

Key Metrics to Track Weekly

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

Diagnosing Problems

Simple Dashboard (Google Sheets)

Weekly Tracking Sheet

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

Monthly Revenue Math

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

Pipeline Management