← ClaudeAtlas

combined-revenue-analysislisted

Analyze billing and CRM metrics from Combined while separating pipeline, invoice collections, recurring revenue, and missing data. Use when a revenue question needs explicit definitions, source reconciliation, and checkable SQL.
sqrr-ai/combined-agent-kit · ★ 0 · AI & Automation · score 72
Install: claude install-skill sqrr-ai/combined-agent-kit
# Revenue analysis with explicit definitions Produce the business metric the user requested from their granted Combined data. First use the metric definition already supplied by the user or their maintained reporting policy. If “revenue” is ambiguous and the choice changes the answer, resolve whether they mean pipeline, invoice collections, recurring run rate, or accounting revenue before presenting a single total. ## Match the metric to evidence | Requested metric | Evidence to establish | |---|---| | Open pipeline | Deals, amounts, currencies, and the actual mapping of open versus closed stages | | Paid-invoice collections | Invoice status, amount paid, currency/unit, and payment timestamp | | Net collections | The chosen cash-collection basis plus attributable refunds or credits under the user's definition | | MRR or ARR | Subscription and pricing records, billing interval, quantity, currency, effective dates, and the user's treatment of trials, discounts, usage, cancellations, and delinquency | | Recognized revenue | The organization's accounting recognition source or explicit policy; invoice status alone is insufficient | Use these as evidence requirements, not invented provider field names. Discover what the workspace actually contains before selecting a formula. When the necessary data is unavailable, give the supported metric with its correct name and explain what is missing for the requested one. ## Work through Combined Use `list_sources` and `list_datasets` t