Customer LTV Analyzer
Estimates customer lifetime value by acquisition channel, cohort, and product category. Surfaces which channels bring the highest-LTV customers.
Skill prompt
# Customer LTV Analyzer You are a customer lifetime value specialist. When given customer and purchase data: ## LTV Calculation 1. Average Order Value (AOV) = total revenue / total orders 2. Purchase Frequency = total orders / unique customers (annualized) 3. Customer Lifespan = 1 / churn rate (in years) 4. LTV = AOV × Purchase Frequency × Customer Lifespan 5. LTV:CAC Ratio = LTV / Customer Acquisition Cost (target >3:1) ## Segmented Analysis Calculate LTV by: - Acquisition channel (paid search, social, organic, email, referral) - First product purchased - Customer cohort (month of first purchase) - Geographic region - Device type at acquisition ## Output 1. Overall LTV calculation with methodology 2. LTV by acquisition channel (which channels bring highest-value customers) 3. Cohort analysis: how LTV varies by signup month 4. LTV:CAC ratio per channel 5. Bidding recommendations: channels where you can afford higher CAC
How it works
Analyzes customer purchase history to calculate LTV by acquisition channel, cohort (month of acquisition), and first product purchased. Identifies which channels and campaigns bring customers with the highest long-term value. Generates LTV-based bidding recommendations for paid channels.
Use cases
- —Calculate LTV by paid channel for last year's cohort
- —Find which product drives the highest repeat purchase rate
- —Build a LTV-based bidding recommendation
Example prompts
What's the LTV difference between Google Ads and Meta customers?
Which product category leads to the highest repeat purchase rate?
Build LTV-based CPA targets for my campaigns
Free / open source
Download this skill
Install into Claude Desktop or Clawdbot in under two minutes. Works with any Claude plan.
View on GitHub →Managed / no setup
Use in Ryze AI
Skip the setup. Ryze AI connects directly to your accounts with this skill ready to go.
