Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    customer lifetime value analyzer

    1

    - **Analyze retention** through survival curves at the horizon, including Gross Revenue Retention (GRR) and Net Revenue Retention (NRR).

    $10

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    customer lifetime value analyzer

    customer lifetime value analyzer

    Example session with this skill installed

    Analyze the attached cohort data for Q3. We spent $50k on Facebook and $30k on Google. I need to know the LTV/CAC over a 24-month horizon and the payback period. Retention data is in the sheet.

    • Read your context and instructions
    • Compiled the customer lifetime value
    • Generated the data export

    The cohort analysis for Q3 acquisition spend is complete. Data was processed using a 24-month finite horizon with a 10% annual discount rate.

    Customer Lifetime Value and Acquisition Economics — Q3 Analysis, 2023-10-27

    1. Scope, sources and assumptions

    • Sources: Q3_Marketing_Data.xlsx (E1), Retention_Export.csv (E2)
    • Currency: USD | Scale: 1 | Period Unit: Month
    • Horizon: 24 Periods | Discount Rate: 10% (User-supplied)

    2. CAC and LTV by cohort

    CohortSourceNew customersSpendCACLTVLTV/CACNet valueVerdict
    2023-07Facebook50050,000100.00285.502.86185.50Pass
    2023-07Google20030,000150.00410.202.73260.20Pass

    3. Retention and payback

    CohortAvg churnLatest churnSurvival at horizonSimple paybackPaybackDiscounted paybackGRRNRR
    2023-07 (FB)5.0%4.8%29.2%8.010.511.288%92%
    2023-07 (GOOG)3.5%3.2%42.4%9.011.212.191%105%

    4. Acquisition sources

    SourceCustomersSpendCACWeighted LTVLTV/CACNet valueVerdict
    Facebook50050,000100.00285.502.8692,750Pass
    Google20030,000150.00410.202.7352,040Pass
    Overall70080,000114.28321.132.81144,790Pass

    6. Undefined metrics and data gaps

    Information gap — organizational validation required: Service cost per customer was not provided for the Google cohort; LTV reflects gross margin only.

    8. Interpretation and items for human review

    • The Facebook cohort shows higher capital efficiency with a shorter payback period despite lower ARPU.
    • Google acquisition exhibits 105% NRR, suggesting strong expansion revenue that offsets the higher CAC.

    Analytical estimate — validation required: Churn sensitivity indicates that a 20% increase in churn would drop Google LTV/CAC below the 2.0x threshold.

    This analysis supports, and does not replace, professional judgment and management's decision. Any change to marketing spend, pricing or channel mix is marked

    Management decision required.

    Next steps

    • Provide service cost data to refine the Google cohort's net margin.
    • Run a 36-month horizon comparison to see long-term expansion impact.
    • Validate Facebook's expansion revenue assumptions to confirm NRR accuracy.

    Q3_Marketing_Data.xlsx

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Stop guessing if your marketing spend is actually working. Most lifetime value calculations rely on dangerous infinite-horizon shortcuts that hide real churn risks. This skill provides a deterministic engine to compute unit economics with surgical precision.

    What it does

    • Calculate CAC and LTV by cohort and acquisition source using contribution-adjusted margins.
    • Analyze retention through survival curves at the horizon, including Gross Revenue Retention (GRR) and Net Revenue Retention (NRR).
    • Determine payback periods including simple, contribution-based, and discounted payback metrics.
    • Run sensitivity testing to show how shifts in churn rates or margins impact your LTV/CAC ratios.
    • Identify source profitability by aggregating performance across different acquisition channels.

    How it works

    1. The agent extracts cohort data, spend, customer counts, and revenue movements from your documents.
    2. It generates a structured request.json file following a strict schema to ensure data integrity.
    3. A deterministic Python script processes the arithmetic using exact decimals to prevent rounding errors.
    4. The agent generates a comprehensive report with specific sections for CAC, retention, sensitivity, and data gaps.

    Frameworks & tools

    The skill uses a self-contained Python engine for all calculations. It adheres to a strict input schema for JSON-based data validation and supports multi-language analysis in English and French.

    Why this beats prompting it yourself

    LLMs frequently hallucinate financial arithmetic and struggle with complex cohort decay. This skill offloads the math to a specialized script, ensuring that LTV is always calculated over a realistic finite horizon rather than a vague perpetuity.

    Use cases

    • Auditing unit economics for subscription or e-commerce businesses before budget planning.
    • Comparing the true payback period of paid social versus organic acquisition channels.
    • Stress-testing a business model by seeing where LTV/CAC falls if churn doubles.
    • Identifying specific cohorts where high service costs are eroding lifetime value.

    Known limitations

    Does not support company valuation, DCF modeling, or IFRS/GAAP accounting claims. Only processes one currency and scale per request and requires explicit user targets for benchmarking.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    No company valuations or GAAP compliance. Single currency/scale per run. No industry benchmarks provided. Requires finite horizon parameters.

    How to use

    1. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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 5 days ago

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed5 days ago

    What's inside

    Frequently Asked Questions

    Unlike standard LLMs that often hallucinate financial math, this skill uses a deterministic Python engine to calculate LTV over a fixed time horizon, preventing the "infinite growth" errors that lead to overestimating profitability.

    The skill requires cohort-level data, including customer counts, acquisition spend, and revenue movements (upgrades, downgrades, churn) over time, ideally provided in a structured document or spreadsheet format.

    Yes, the skill is designed to handle multi-channel analysis, allowing you to compare LTV/CAC ratios and payback periods between paid social, organic, and other specific acquisition sources.

    The skill is compatible with major AI agent platforms that support Python code execution and JSON data handling, including OpenAI's GPT-4o and Claude 3.5 Sonnet.

    You receive the full skill configuration, the proprietary deterministic calculation script, the JSON input schema, and comprehensive documentation for deployment.

    While the analyzer is highly precise for unit economics, it does not support multi-currency conversion in a single request or provide full-scale GAAP/IFRS financial reporting.

    New in Finance & Accounting