← Back to Skills Marketplace
leooooooow

Ltv Cac Calculator

by LeroyCreates · GitHub ↗ · v1.0.1 · MIT-0
cross-platform ✓ Security Clean
247
Downloads
0
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install ltv-cac-calculator
Description
Compare ecommerce LTV and CAC using realistic order, margin, and retention assumptions. Use when teams need to know whether acquisition is compounding value...
README (SKILL.md)

LTV CAC Calculator

增长不是把人买进来就结束,关键是这些客户值不值这个获客成本。

先交互,再计算

开始前必须先问:

  1. 你的 LTV 想按什么窗口算?
    • 30 天?
    • 90 天?
    • 12 个月?
    • 生命周期?
  2. LTV 用 revenue、gross profit,还是 contribution profit?
  3. CAC 是否包含:
    • 广告费
    • 渠道服务费
    • 团队/代理成本
    • 折扣补贴
  4. 你们现在有没有自己的 LTV/CAC 口径?
  5. 你是希望沿用现有口径,还是让我给一套推荐框架?

Python script guidance

当用户给出结构化数据后:

  • 生成 Python 脚本完成 LTV/CAC 计算
  • 展示假设、生命周期窗口和口径
  • 返回结果和风险点评
  • 同时返回可复用脚本

如果用户口径不清晰,先给推荐框架,再等用户确认后计算。

解决的问题

很多团队会说“这个渠道还在赚钱”,但没真正算清:

  • 用户是否会复购;
  • 毛利能否覆盖获客成本;
  • 看起来跑得动,其实 payback 太慢;
  • 如果 retention 变差,整个模型会不会瞬间失效。

这个 skill 的目标是: 用一套可解释的方式,估算 LTV / CAC 关系,并给出增长是否健康的判断。

何时使用

  • 评估新渠道或新 campaign;
  • 复盘某类客户是否值得继续加预算;
  • 比较不同商品、不同人群的 acquisition quality。

输入要求

  • 客单价
  • 毛利结构
  • 复购频次 / 生命周期窗口
  • 当前 CAC
  • 可选:退款率、客服成本、履约成本、会员贡献

工作流

  1. 明确用户的 LTV 与 CAC 口径。
  2. 估算单客户生命周期贡献。
  3. 计算 LTV / CAC 比率。
  4. 判断 payback 是否健康。
  5. 提示最弱的环节:留存、毛利、价格、CAC 等。
  6. 输出可复用 Python 脚本。

输出格式

  1. 假设表
  2. LTV / CAC 结果
  3. 风险点评
  4. 建议动作
  5. Python 脚本

质量标准

  • 不假装精确,必须说明生命周期假设。
  • 区分“看起来合理”和“真正稳健”。
  • 输出要服务于预算和 retention 决策。
  • 建议动作要明确。
  • 用户未确认口径前,不应直接下结论。

资源

参考 references/output-template.md

Usage Guidance
This skill appears coherent and low-risk: it only asks for business metrics and produces a Python script and analysis. Before using, avoid pasting sensitive PII or raw customer-identifying data into the chat; review any generated Python code before executing it in your environment (run it in a sandbox or inspect for unintended operations). If you plan to run the script on production data, validate assumptions and test on a safe sample first. If you need the agent to actually execute code or access your datasets, expect that would require additional permissions or connectors not described here.
Capability Analysis
Type: OpenClaw Skill Name: ltv-cac-calculator Version: 1.0.1 The skill bundle is a standard business tool designed to calculate LTV/CAC ratios for ecommerce. It contains no executable code, no network requests, and no instructions to access sensitive system data or environment variables. The logic in SKILL.md is focused entirely on user interaction, data gathering for business metrics, and generating calculation scripts for the user's reference.
Capability Assessment
Purpose & Capability
The name/description match the SKILL.md: it requests ecommerce metrics (AOV, margin, frequency, CAC, optional costs) and promises to compute LTV/CAC and produce a reusable Python script. There are no unrelated environment variables, binaries, or installs.
Instruction Scope
Instructions stay within scope: ask clarifying questions, accept structured user data, compute LTV/CAC, show assumptions, produce risk commentary and a reusable Python script. The instructions do not direct the agent to read system files, access credentials, or send data to external endpoints.
Install Mechanism
No install spec and no code files beyond the instruction template — nothing is written to disk or downloaded by the skill itself. This is the lowest-risk install profile.
Credentials
The skill requires no environment variables, credentials, or config paths. All required inputs are user-supplied numerical/assumption data appropriate to the task.
Persistence & Privilege
always is false and the skill does not request persistent privileges or modify other skills or system settings. Autonomous invocation is allowed (platform default) but combined with no extra privileges, this is proportionate.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install ltv-cac-calculator
  3. After installation, invoke the skill by name or use /ltv-cac-calculator
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.1
Add browser-first guidance or interactive Python workflow improvements
v1.0.0
Initial release
Metadata
Slug ltv-cac-calculator
Version 1.0.1
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 2
Frequently Asked Questions

What is Ltv Cac Calculator?

Compare ecommerce LTV and CAC using realistic order, margin, and retention assumptions. Use when teams need to know whether acquisition is compounding value... It is an AI Agent Skill for Claude Code / OpenClaw, with 247 downloads so far.

How do I install Ltv Cac Calculator?

Run "/install ltv-cac-calculator" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Ltv Cac Calculator free?

Yes, Ltv Cac Calculator is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Ltv Cac Calculator support?

Ltv Cac Calculator is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Ltv Cac Calculator?

It is built and maintained by LeroyCreates (@leooooooow); the current version is v1.0.1.

💬 Comments