subscription-usage-contextlisted

# Subscription Usage — Context Skill (example) > **This file is a map, not an encyclopedia.** It points at files; it doesn't explain things. > If you're tempted to explain a metric here, it belongs in `data_context/metrics.yml`. > **Keep this file under ~90 lines.** ## Status: 🟡 example — definitions draft, pending sign-off · see `POPULATING.md` | Piece | State | | --- | --- | | `data_context/verified_queries/` | 🟢 3 queries (T1, A1, C1), signed 2026-07-18 by dana@lumenfit.example | | `data_context/metrics.yml` | 🟡 4 metrics, all decisions captured — pending flip `draft` → `agreed` | | `data_context/caveats.md` | 🟢 6 caveats (C-01–C-06), measured 2026-07-17 | | `data_context/semantic_layer/` | 🟢 3 tables mapped — `_index.md` + one `.yml` per table | | `data_context/table_profiling/` | 🟡 index + per-table stubs — run `scripts/profile_table.sql` to fill | ## What this domain owns - **Metrics:** `trial_conversion_rate`, `active_subscribers`, `active_minutes`, `monthly_churn_rate` — defined in `data_context/metrics.yml`. - **Tables:** `FACT_MEMBER_SESSION`, `FACT_SUBSCRIPTION_CYCLE`, `DIM_MEMBER` — mapped in `data_context/semantic_layer/_index.md`. - **Boundary:** owns subscription status, trial conversion, in-app engagement, and churn. Does **not** own **revenue/MRR** (Finance domain), **acquisition/ad spend** (Growth domain), or **content performance** (Content domain). For "did engagement drive revenue?", route to Finance. ## Non-negotiables 1. **Check `da