- Home
- Skills
- Trading & Investing
- Newsletter LTV & CAC Calculator
Works with the AI Agents you already use
Newsletter LTV & CAC Calculator
Calculate newsletter subscriber LTV, break-even CAC, and profitable ad spend thresholds using funnel metrics.
$4.99
Newsletter LTV & CAC Calculator
Example session with this skill installed
- Current Subscriber Acquisition Cost: $2.50 per lead on Facebook Ads - Email Open Rate: 45% - Click-Through Rate (CTR): 3% - Landing Page Conversion Rate: 1.5% - Product Price / Lifetime Value: $149 one-time course
- Read your context and instructions
- Compiled the newsletter ltv
📊 Funnel Breakdown
Per 1,000 new subscribers, for one email campaign promoting the course. I treated the 3% CTR as a share of delivered emails, which is the standard definition.
| Funnel Stage | Rate | Count (per 1,000) | Cumulative Rate |
|---|---|---|---|
| Subscribers | n/a | 1,000 | 100% |
| Opens | 45% | 450 | 45% |
| Clicks | 3% of delivered | 30 | 3% |
| Purchases | 1.5% of clickers | 0.45 | 0.045% |
| Revenue | $149 × 0.45 | $67.05 | n/a |
If your 3% CTR is actually measured against opens (click-to-open rate), the cumulative rate drops to 0.02025%. Per-subscriber value then falls to $0.030, and everything below gets about 2.2x worse.
💰 Financial Projections (Per Subscriber)
| Metric | Value |
|---|---|
| Expected Value per Subscriber (LTV): $149 × 0.00045 | $0.067 |
| Break-Even Cost Per Acquisition (Max CAC) | $0.067 |
| Target CAC at 3:1 LTV:CAC | $0.022 |
| Target CAC at 2:1 LTV:CAC | $0.034 |
| Current CAC | $2.50 |
| Current LTV:CAC ratio | 0.027 : 1 |
| Loss per subscriber (single campaign) | –$2.43 |
- Spending $2,500 on 1,000 leads returns about $67 in course revenue from one campaign.
- To break even at $2.50 CAC, you'd need about 1.68% of subscribers to buy, which is roughly 37x your current 0.045% rate.
🚀 Ad Spend Strategy
On these numbers, the most you can pay per subscriber is about
$0.07 at break-even, or
$0.02–$0.03 to keep a healthy 2:1–3:1 ratio. At $2.50 per lead, you're paying about 37x the break-even cost. I'd pause scaling spend until the economics change, because every additional lead loses money on a single-offer basis.
Repeat promotion doesn't fix this on its own. If every email in a sequence converted at the same rate, you'd need about 37 sends per subscriber to recoup $2.50. Repeat sends to the same list convert worse than the first, so that's optimistic. Test these levers in order of impact:
Lower the CAC. Test lead magnets and creative aimed at $0.25–$0.75 leads, or move to cheaper channels such as newsletter swaps, referral programs and organic social.
Raise value per subscriber. Add a low-priced tripwire offer ($7–$27) and an order bump, and use a dedicated 5–7 email launch sequence instead of occasional promos. Add a back-end offer so each buyer is worth more than $149.
- Improve the funnel. A 1.5% landing page rate is low for warm email traffic, so aim for 3–5%.
Even with a 10-email launch sequence and a stronger offer, you'd likely end up around $0.50–$1.00 per subscriber. Set your ad bids with a hard ceiling near that number until your own data shows a higher LTV, and don't count on a one-time $149 course covering a $2.50 CAC.
Connects securely to your tools. The creator never sees your data.
About this skill
Newsletter growth is often a guessing game of ad spend versus returns. This skill provides a quantitative framework for newsletter operators to calculate subscriber Lifetime Value (LTV) and Customer Acquisition Cost (CAC) thresholds. It prevents overspending on ads by defining exact profitability targets based on your specific conversion funnel.
What it does
- Funnel analysis mapping the journey from subscriber to active buyer.
- LTV calculation determining the specific monetary value of a single email subscriber.
- CAC thresholding identifying the maximum allowable spend per new sign-up.
- Profitability targeting recommending ad spend goals for 2:1 or 3:1 LTV:CAC ratios.
- Bidding strategy outlining how to deploy capital based on performance metrics.
How it works
- Provide your core metrics: open rates, click-through rates, and landing page conversion rates.
- Input your product price or existing customer lifetime value data.
- Review the funnel breakdown table to identify drop-off points.
- Apply the calculated Target CAC to your Facebook, Google, or X ad campaigns.
Frameworks & tools
This skill is designed for newsletters built on Beehiiv, Substack, or ConvertKit that monetize via digital products, courses, or paid subscriptions.
Why this beats prompting it yourself
Generic AI prompts often fail to account for the multi-step conversion chain specific to email marketing. This skill enforces strict mathematical modeling across the entire funnel, ensuring your LTV isn't just a guess but a derivative of your actual engagement data.
Use cases
- Determining the maximum bid for a Meta ads campaign targeting new subscribers.
- Evaluating the ROI of a paid newsletter cross-promotion.
- Adjusting product pricing based on current acquisition costs.
- Setting monthly growth budgets for a scaling newsletter.
Known limitations
Requires pre-existing funnel data (opens, clicks, and sales) to generate accurate projections. It does not account for referral program organic growth.
Requires accurate input of open rates, CTR, and sales conversion data. Does not factor in churn rates or secondary monetization like sponsorships.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 19 days ago