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.
僅公開檔案列表。將技能安裝到工作區後即可檢視檔案內容。
| 路徑 | 大小 | 類型 |
|---|---|---|
| references/dbt/dim_customer.sql | 324 B | text/plain |
| references/dbt/fct_mrr.sql | 1.9 KB | text/plain |
| references/dbt/fct_revenue_item.sql | 2.7 KB | text/plain |
| references/dbt/schema.yml | 1.1 KB | application/yaml |
| references/dbt/_sources_stripe.yml | 862 B | application/yaml |
| references/posthog/gross_revenue_by_month.sql | 595 B | text/plain |
| references/posthog/mrr_and_arr.sql | 1.1 KB | text/plain |
| references/posthog/revenue_by_customer.sql | 1.1 KB | text/plain |
| references/revenue-metric-definitions.md | 5.5 KB | text/markdown |
| SKILL.md | 7.6 KB | text/markdown |
來源與署名
來源：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
根據人力資料產出員額編制、流失率、多元性與組織健康度等人才分析報告。