
Model Financial Impact: CAC, LTV, and Payback Metrics
📄 Prompt Template
Build a financial success metric model tying [CampaignName] outcomes to unit economics for [ServiceLine]. Define CAC, LTV (by lane/commodity), Gross Margin per Load, Churn, and Payback Period, using assumptions for conversion rates and retention in [Region] over [Timeframe]. Show sensitivity to [Budget] allocation and pricing changes.
Output format:
Assumptions table: Variable, Base, Low, High, Source.
Unit economics table: Metric, Formula, Result, Target, Notes.
Scenario summary (Base/Conservative/Aggressive): CAC, LTV, LTV:CAC, Payback (months), ROI %.