data-dictionary

Maps analytics questions to Swayzio OS tools and defines every revenue metric.

Updated Jun 22, 2026
One-click install
npx skills add https://github.com/mylesfranklin/swayzio-admin-dashboard --skill data-dictionary-mylesfranklin
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-dictionary
Source: https://github.com/mylesfranklin/swayzio-admin-dashboard/tree/main/agent/skills/data-dictionary
Command: npx skills add https://github.com/mylesfranklin/swayzio-admin-dashboard --skill data-dictionary-mylesfranklin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? When querying a unified company database that merges Stripe, HubSpot, and app data, it is hard to know which tool answers which question or what metrics like MRR and collection rate actually mean. This Skill provides the data map and definitions so every analytics question lands on the right tool with the right interpretation. ## Core Features & Use Cases - Tool-to-question mapping: A lookup table routes questions about revenue health, churn, contacts, identities, and freshness to the correct curated api.* view tool such as stripe_snapshot, identity_360, or mrr_trend. - Canonical metric definitions: Precise wording for MRR, paying subs, collection rate, MRR at risk, churn, and tagged tracks so answers stay consistent. - Revenue caveat enforcement: Always distinguishes booked MRR from collected revenue, surfacing the gap as the real revenue-health story. - Use Case: A founder asks "are we healthy this month?" — the Skill routes to revenue_health, leads with the tool's plain-English summary, and frames booked MRR against collected cash. ## Quick Start Ask what MRR means and which tool to use for checking whether revenue is healthy this month.

Frequently Asked Questions about data-dictionary

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find which tool answers a revenue question?

Use the tool-to-question map: revenue health and cash-versus-MRR questions go to revenue_health, MRR and churn go to stripe_snapshot, and collected revenue by month goes to revenue_monthly. Each tool returns a plain-English summary to lead with.

What is the difference between MRR and collected revenue?

MRR is the booked monthly run-rate from active subscriptions at list price, not cash. Collected revenue is what was actually paid, measured via revenue_monthly or collected_last_full_month, and the gap between them is the real revenue-health signal.

How is the collection rate defined?

Collection rate is collected revenue from the last full month divided by MRR. It is the truest revenue-health indicator because many active subscriptions have void invoices, meaning broken billing that booked MRR alone hides.

Can I query raw Stripe or HubSpot tables directly?

No. All access goes through curated api.* views exposed as tools; raw tables are never touched. Identity across Stripe, HubSpot, and the app is resolved by email, and identity_360 shows which systems a person appears in.

How do I check if the analytics data is current?

Call the freshness tool to verify data currency before reporting numbers. If the data is stale, trigger_sync can refresh it, but that action requires approval before running.