Modeling Revenue Metrics
作者 PostHog469d1773e9cb无许可证88 个星标收录于 2026年10月8日更新于 2026年10月8日仓库今天更新
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 external dbt project. Use when the user wants to model, define, or compute recurring revenue, monthly/annual recurring revenue, churn or retention of revenue, lifetime value, average revenue per user, or revenue by customer, cohort, product, or currency. On PostHog, build on the managed revenue_analytics_* views (revenue_item, mrr, customer, subscription, charge, product) fed by Stripe or custom revenue events — not raw Stripe tables — and normalize money with convertCurrency(). In dbt, stage the payment source and compute fct_mrr / fct_revenue_item / dim_customer marts with tests. Covers picking the right source, the subscription-config gotcha that leaves MRR empty, currency handling, and linking revenue to persons/groups. Read modeling-warehouse-foundations first for the view-vs-dbt mechanics.
- 469d1773e9cb当前提交 469d177发布于 2026年10月8日
来源与署名
来源：PostHog/ai-plugin位于skills/modeling-revenue-metrics提交469d177
许可证： 无许可证
内容归原作者所有。SourceWeft 从公开仓库中收录这些内容。
更多来自 PostHog/ai-plugin 的技能
Writing Simplified Technical English
PostHog
应用 ASD-STE100 简化技术英语规则，让智能体撰写的文字含义明确、便于执行。
Working With Task Comments
PostHog
通过 PostHog MCP exec 调度器读取并解读 PostHog 任务、产物和画布上的评论。
Working With Skills
PostHog
指导智能体使用 PostHog 的 skill-* MCP 工具来发现、读取、创建、更新和重构技能。
Working With Scouts
PostHog
关于如何把监控任务委派给 PostHog Signals 侦察代理、处理其报告并长期调校整个代理集群的操作手册。
Validating And Publishing Canvases
PostHog
Validate and publish a canvas source project safely: the source-project shape, declared capabilities, reading the current version pointer, iterating on validation diagnostics, guarded publishing with expected_current_version_id, staging a draft build and promoting it, waiting out the queued build, and recovering from a 409 version_conflict or a 429 capacity limit without overwriting concurrent work. Use whenever a canvas edit is ready to save, a draft build is wanted, a canvas publish or build returns diagnostics or a conflict, or a task needs to understand canvas version history.
Understanding Billing Usage
PostHog
Explains PostHog billing usage and spend from the customer's visible Billing MCP tools. Use when the user asks why usage or spend is high, which product or project is driving usage, what a usage type means, how to reduce usage, what changed over time, why they got a usage change alert, or whether a spike/drop alert was real or noisy. Also use before product-specific analytics skills when the user names a billable PostHog product metric such as events, recordings, feature flag requests, exceptions, survey responses, synced rows, logs, AI events, AI credits, or Inbox credits. Starts from Billing usage/spend tools, then routes to customer-visible product MCP surfaces for deeper investigation.
更多Data & Analytics技能
Content Strategy
anthropics
将 PayPal、QuickBooks 或 Square 的销售数据转化为按优先级排序的 30 天内容简报。
Cash Flow Snapshot
anthropics
根据账簿、支付平台或 CSV 数据生成 30/60/90 天现金流预测，含置信区间和具名风险提示。
Pipeline Review
anthropics
按阶段审查 CRM 销售管道健康状况，标记老化、停滞和高风险商机并检查覆盖率。
Metrics Review
anthropics
审阅产品指标，分析趋势并与目标对比，输出带建议行动的指标记分卡。
Performance Report
anthropics
生成营销表现报告，包含关键指标、趋势分析、成败总结以及按优先级排序的优化建议。
People Report
anthropics
根据人力数据生成人员编制、流失率、多元化和组织健康度等人才分析报告。