ClientRev. TargetCycleMultiReq. PipelineSQL RateMarginMax CPLRisk
Acme Agency$250,00045 days4×=B2*D212%40%$85Moderate
Velocity Co.$180,00030 days3×=B3*D318%45%$65Aggressive
Apex Partners$420,00075 days5×=B4*D48%35%$120Low
NorthStar Mkt$95,00021 days3×=B5*D522%50%$45Aggressive
Meridian Grp$310,00060 days4×=B6*D611%38%$95Moderate
Are revenue targets based on last 90 days actuals?Pass
Is required pipeline aligned to sales cycle length?Pass
Are SQL targets based on trailing 90 day average?Review
Does max CPL protect margin after sales cost?Pass
Would a 15% revenue dip trigger intervention early enough?—
1Pull last 90 days actuals — revenue, pipeline, SQL rate, and CPL for each client.
2Enter targets and baselines — populate the Calibration Worksheet from actuals, not projections.
3Set pipeline multiplier by sales cycle — 3× for short cycles (under 30 days), 5× for long cycles (60+ days).
4Set CPL max based on margin target — work backward from margin floor to establish the absolute CPL ceiling.
5Lock thresholds for 90 days — pass the Stress Test checklist before committing. No moving targets.
6Revisit quarterly — or immediately after any ICP change, offer change, or significant market shift.