Agent skill

Bi Ltv Analysis

by agentscope-ai in agentscope-ai/QwenPaw-Data

评估单个用户或用户群体在生命周期内创造的收益。触发条件:当需要用户生命周期价值计算与分析时触发,如对话中涉及“LTV”、“LTV 分析”、“用户生命周期价值”、“人均收益测算”等等相近词语时调用。

Apache-2.0Auto-check passed

Install Bi Ltv Analysis

skills CLI
$ npx skills add agentscope-ai/QwenPaw-Data --skill bi-ltv-analysis -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install agentscope-ai/QwenPaw-Data bi-ltv-analysis --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/agentscope-ai/QwenPaw-Data.git skills-src && mkdir -p .claude/skills && cp -r skills-src/packages/qwenpaw-data-skills/skills/atomic/bi-ltv-analysis .claude/skills/bi-ltv-analysis && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
bi-ltv-analysis
GitHub stars
127
Token cost
~743 tokens
SKILL.md length
130 words
Files
2 (incl. scripts)
Skills in repo
29
Repo updated
First seen
Licence
Apache-2.0

At a glance

评估单个用户或用户群体在生命周期内创造的收益。触发条件:当需要用户生命周期价值计算与分析时触发,如对话中涉及“LTV”、“LTV 分析”、“用户生命周期价值”、“人均收益测算”等等相近词语时调用。

  • Works in 2 steps: :准备数据 → :计算 LTV
  • Runs Python scripts from its folder; calls python

What it does

Bi Ltv Analysis is an agent skill from agentscope-ai/QwenPaw-Data. 评估单个用户或用户群体在生命周期内创造的收益。触发条件:当需要用户生命周期价值计算与分析时触发,如对话中涉及“LTV”、“LTV 分析”、“用户生命周期价值”、“人均收益测算”等等相近词语时调用。

Its SKILL.md is about 740 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including scripts (for example `scripts/ltv_calc.py`).

The repository describes itself as: Agentic enterprise data analytics: governed facts (DataBridge), reusable methodology (Skill-Hub), and controllable execution (Host). The licence is Apache-2.0.

Example prompts

  • “LTV 分析”
  • “用户生命周期价值”
  • “人均收益测算”
  • “/bi-ltv-analysis”

Requirements

  • Python 3

Workflow steps

2 steps, taken from the step headings in SKILL.md.

  1. :准备数据
  2. :计算 LTV

What it can do on your machine

Read from SKILL.md and the folder at commit e0bae36. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 1 file in scripts/ (Python), which the agent can run.

    Shell commands in SKILL.md call:

    • python

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Bi Ltv Analysis loads about 743 tokens when it runs. Until then it costs about 29 tokens; SKILL.md has 130 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~29
When it runs · the whole SKILL.md, loaded when a task matches
~743

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from agentscope-ai/QwenPaw-Data at commit e0bae36, republished under its Apache-2.0 licence (© agentscope-ai). 130 words, ~743 tokens.

Download SKILL.mdSave it as .claude/skills/bi-ltv-analysis/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
bi-ltv-analysis
description
评估单个用户或用户群体在生命周期内创造的收益。触发条件:当需要用户生命周期价值计算与分析时触发,如对话中涉及“LTV”、“LTV 分析”、“用户生命周期价值”、“人均收益测算”等等相近词语时调用。

bi-ltv-analysis

评估单个用户或用户群体在整个生命周期内创造的收入(或利润),典型用途。

执行步骤

Step 1:准备数据

根据分析任务需求与所给数据结构,明确 LTV 分析涉及的指标,即分析粒度(用户级 / 群体级)、收益口径(如购买、升级等行为产生的收入、利润等)以及生命周期(如时间窗口、某阶段流失率等),将取数结果保存为 CSV。

整理数据为 CSV 格式,采用“分组(用户/群体) × N天(生命周期与收益数据)”,数据应至少包括分析粒度对应的对象列、收益口径对应的收入数据列以及生命周期对应的数据列。

例如,对于用户级的 LTV 分析,分析数据示例如下,

csv
用户ID,事件时间a,收入金额a,事件时间b,收入金额b
1,2025-04-25,26.0,2025-04-26,6.5
2,2025-04-25,6.5,NaN,NaN

对于群体级的 LTV 分析,数据示例如下,

csv
群体类别,a阶段流失率,a阶段收入金额,b阶段流失率,b阶段收入金额
group_1,0.366,26.0,0.121,6.5
group_2,0.253,6.5,0.754,2.0

若上游步骤已产出可用汇总表则直接使用,否则按口径从明细聚合(按用户求和、按队列求和等)。

注意:若数据包含留存率、流失率等指标可以用于 LTV 分析,则统一使用流失率进行计算,若数据中仅包含留存率,则转化为流失率进行 LTV 计算和分析,一般情况,流失率=1-留存率。

Step 2:计算 LTV

LTV 计算公式一:

(LTV = ARPU \times 生命周期)

LTV 计算公式二:

(LTV = ARPU \times \frac{1}{流失率})

ARPU(Average Revenue Per User):单位用户在指定统计范围内的平均收入。若 CSV 中收入列为阶段合计、且另有用户数列,则脚本按 (ARPU = 收入 / 用户数) 计算;若收入列已是人均口径,则无需 --users-col。

群体多阶段(含多列「阶段流失率 + 阶段收入金额」):按阶段顺序,用存活率对收入加权求和:

[ LTV = \sum_{j} 收入_j \times \prod_{k<j}(1 - 流失率_k) ]

方式一:使用脚本

使用 <skill-dir>/scripts/ltv_calc.py 计算 LTV。结果写入 --output-file 指定的 CSV:第一列为输入中的分析对象列(--object-col),第二列为 LTV(默认列名 ltv)。

用户级(观测窗口内各阶段收入累计):

bash
python <skill-dir>/scripts/ltv_calc.py \
  --input-file "<输入 CSV 路径>" \
  --object-col "用户ID" \
  --revenue-cols "收入金额a" "收入金额b" \
  --output-file "<输出 CSV 路径>"

群体级(多阶段流失率 + 收入):

bash
python <skill-dir>/scripts/ltv_calc.py \
  --input-file "<输入 CSV 路径>" \
  --object-col "群体类别" \
  --revenue-cols "a阶段收入金额" "b阶段收入金额" \
  --churn-cols "a阶段流失率" "b阶段流失率" \
  --output-file "<输出 CSV 路径>"

公式一(单列收入 + 生命周期 T):

bash
python <skill-dir>/scripts/ltv_calc.py \
  --input-file "<输入 CSV 路径>" \
  --object-col "群体类别" \
  --revenue-col "a阶段收入金额" \
  --users-col "用户数" \
  --lifecycle 12 \
  --formula lifecycle \
  --output-file "<输出 CSV 路径>"

公式二(单列收入 + 单列流失率):

bash
python <skill-dir>/scripts/ltv_calc.py \
  --input-file "<输入 CSV 路径>" \
  --object-col "群体类别" \
  --revenue-col "a阶段收入金额" \
  --churn-col "a阶段流失率" \
  --formula churn \
  --output-file "<输出 CSV 路径>"

若数据列为留存率而非流失率,增加 --rate-is-retention(按 流失率 = 1 − 留存率 转换)。

参数说明:

参数说明默认值
--input-file输入数据文件路径(CSV)(必填)
--object-col分析对象列名(用户 ID、群体类别等)(必填)
--output-file输出 CSV 路径(两列:分析对象、LTV)(必填)
--ltv-col输出中 LTV 列名ltv
--formulacumulative / lifecycle / churn / stage_weighted;省略时按其它参数自动推断自动推断
--revenue-cols多阶段收入列名(可多个)—
--churn-cols多阶段流失率列名,与 --revenue-cols 顺序一一对应—
--revenue-col单列收入(公式一、二)—
--churn-col单列流失率(公式二)—
--lifecycle生命周期数值 T(公式一)—
--users-col用户数列(收入为合计时计算 ARPU)—
--rate-is-retention将流失率列按留存率处理并转换为流失率否

© agentscope-ai, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (scripts) in packages/qwenpaw-data-skills/skills/atomic/bi-ltv-analysis of agentscope-ai/QwenPaw-Data.

  • SKILL.md
  • scripts/ltv_calc.py

Open the folder on GitHubat commit e0bae36

Compare with similar skills

Bi Ltv Analysis next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Bi Ltv Analysis compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Bi Ltv Analysis this skillagentscope-ai/QwenPaw-Data127—~743Automated safety check: PassApache-2.0
Ltv Predictorliangdabiao/claude-data-analysis-ultra-main290—~1.4kAutomated safety check: NotesNone
Biz Cac Ltvasgard-ai-platform/skills242—~1.9kAutomated safety check: PassMIT
Cac Ltv Viabilityahmadvh/octochains377—~323Automated safety check: PassCustom licence
Blueprintaffaan-m/ECC276k2 repos~604Automated safety check: PassMIT
Token Budget Advisoraffaan-m/ECC276k—~927Automated safety check: PassMIT

Similar skills

  • Ltv Predictor

    liangdabiao/claude-data-analysis-ultra-main

    基于RFM模型和回归算法的客户生命周期价值(LTV)预测分析工具,支持电商和零售业务的客户价值预测。使用时需要客户交易数据、订单历史或消费记录,自动进行RFM特征工程、回归建模和价值预测。

    290 GitHub stars~1.4k tokensUpdated 5 mo ago
    Data & AnalyticsAuto-check: notes
  • Biz Cac Ltv

    asgard-ai-platform/skills

    Calculate and analyze Customer Acquisition Cost (CAC) and Customer Lifetime Value (LTV) to evaluate unit economics and marketing efficiency.

    242 GitHub stars~1.9k tokensUpdated 4 mo ago
    Business, Finance & HRAuto-check passed
  • Cac Ltv Viability

    ahmadvh/octochains

    Audits the unit economics of customer acquisition against lifetime value.

    377 GitHub stars~323 tokensUpdated 1 mo ago
    Business, Finance & HRAuto-check passed
  • Blueprint

    affaan-m/ECC

    将单行目标转化为多会话、多代理工程项目的分步构建计划。每个步骤包含独立的上下文简介,以便新代理能直接执行。包括对抗性审查门、依赖图、并行步骤检测、反模式目录和计划突变协议。触发条件:当用户请求复杂多PR任务的计划、蓝图或路线图,或描述需要多个会话的工作时。不触发条件:任务可在单个PR或少于3个工具调用中完成,或用户说“直接执行”时。

    276k GitHub starsUsed in 2 repos~604 tokens
    DevelopmentAuto-check passed
  • 在回答前,为用户提供关于消耗多少响应深度的知情选择。当用户明确希望控制响应长度、深度或令牌预算时使用此技能。触发条件:"token budget", "token count", "token usage", "token limit", "response length", "answer depth", "short version", "brief answer", "detailed…

    276k GitHub stars~927 tokensUpdated today
    AI & LLM EngineeringAuto-check passed
  • Official

    Build reusable revenue models — MRR, ARR, gross revenue, new/expansion/contraction/churn, ARPU, LTV, and per-customer/per-account revenue — on either PostHog data-warehouse views (HogQL) or an…

    40k GitHub stars~2.1k tokensUpdated today
    Data & AnalyticsAuto-check passed

More from agentscope-ai/QwenPaw-Data

All 29 skills in this repo
  • Bi Report Generation

    agentscope-ai/QwenPaw-Data

    将 BI 数据分析结果组织成可视化 HTML 报告。当分析完成、需要生成报告时调用. An agent skill from agentscope-ai/QwenPaw-Data.

    127 GitHub stars~1.2k tokensUpdated 5 days ago
    Auto-check passed
  • Fetch Data

    agentscope-ai/QwenPaw-Data

    取数 / 查数据 / 拉数据 / 跑 SQL。把自然语言取数需求转为 SQL,经数据湖仓执行后返回查询结果供下游分析。任何需要业务数据的任务在工作区缺少对应文件时都必须先调用此技能——覆盖 BI 业务分析、留存 / 转化 / 同期群分析、数据探索 EDA、统计建模、定量计算、元数据查询、数据查询。命中任一即触发:(1) 直接索要指标或记录,如「DAU 多少」「上月销售额」「3…

    127 GitHub stars~2.5k tokensUpdated 5 days ago
    Auto-check passed
  • Bi Adaptive Threshold

    agentscope-ai/QwenPaw-Data

    通过量化历史数据的自然波动幅度,自适应计算判定阈值。当需要从数据本身确定阈值(如波动阈值、影响度阈值等)、而非使用固定值时调用。仅适用于日/周粒度阈值确定。

    127 GitHub stars~726 tokensUpdated 5 days ago
    Auto-check passed
  • Bi Anomaly Detection

    agentscope-ai/QwenPaw-Data

    基于阈值检测时间序列中的显著异常波动点。当需要找出指标异常波动日期、识别数据异动时调用. An agent skill from agentscope-ai/QwenPaw-Data.

    127 GitHub stars~637 tokensUpdated 5 days ago
    Auto-check passed
  • Bi Attribution Analysis

    agentscope-ai/QwenPaw-Data

    计算各维度(组)值对指标变动的贡献度,支持可加型量值指标和加权平均型/率值指标。当需要计算贡献度、解释指标"为什么涨/跌"时调用。

    127 GitHub stars~1.2k tokensUpdated 5 days ago
    Auto-check passed
  • Bi Causal Attribution

    agentscope-ai/QwenPaw-Data

    从运营周报、活动文档、对话输入或文档工具 API 中提取业务事件,与指标异常时间窗口对齐,生成有证据支撑的因果归因假设并排序。当已知指标存在异常波动、需要从外部文档证据中解释"为什么"时调用。

    127 GitHub stars~1.3k tokensUpdated 5 days ago
    Auto-check passed

Questions about Bi Ltv Analysis

What does Bi Ltv Analysis do?

评估单个用户或用户群体在生命周期内创造的收益。触发条件:当需要用户生命周期价值计算与分析时触发,如对话中涉及“LTV”、“LTV 分析”、“用户生命周期价值”、“人均收益测算”等等相近词语时调用。. Bi Ltv Analysis is an agent skill from agentscope-ai/QwenPaw-Data.

How do I install Bi Ltv Analysis in Claude Code?

Run `npx skills add agentscope-ai/QwenPaw-Data --skill bi-ltv-analysis -a claude-code`. Or copy the skill folder (packages/qwenpaw-data-skills/skills/atomic/bi-ltv-analysis in agentscope-ai/QwenPaw-Data) into .claude/skills/bi-ltv-analysis in your project. Claude Code loads it when a task matches its description.

How do I install Bi Ltv Analysis in Codex?

Run `npx skills add agentscope-ai/QwenPaw-Data --skill bi-ltv-analysis -a codex`. Or copy the skill folder (packages/qwenpaw-data-skills/skills/atomic/bi-ltv-analysis in agentscope-ai/QwenPaw-Data) into .agents/skills/bi-ltv-analysis in your project. Codex loads it when a task matches its description.

Can I use Bi Ltv Analysis in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add agentscope-ai/QwenPaw-Data --skill bi-ltv-analysis -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/bi-ltv-analysis, .gemini/skills/bi-ltv-analysis, .github/skills/bi-ltv-analysis and .opencode/skills/bi-ltv-analysis in your project.

What does Bi Ltv Analysis need to run?

Going by SKILL.md and its folder, Bi Ltv Analysis needs Python for the scripts in its folder and the command-line tools its instructions call (python). Our summary lists: Python 3.

Does Bi Ltv Analysis access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Bi Ltv Analysis safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Bi Ltv Analysis use?

Bi Ltv Analysis is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Bi Ltv Analysis use?

About 743 tokens (SKILL.md is roughly 3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Bi Ltv Analysis?

Skills that share tags, products or a category with Bi Ltv Analysis: Ltv Predictor (liangdabiao/claude-data-analysis-ultra-main, 290 stars), Biz Cac Ltv (asgard-ai-platform/skills, 242 stars), Cac Ltv Viability (ahmadvh/octochains, 377 stars) and Blueprint (affaan-m/ECC, 276k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Bi Ltv Analysis?

agentscope-ai (a GitHub organization) maintains it in agentscope-ai/QwenPaw-Data, which has 127 GitHub stars. The repository holds 29 skills in this directory. The repository was last updated on October 5, 2026.

Source: agentscope-ai/QwenPaw-Data on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.