Ask the Brain

27 decisions · 26 governed
4
PN
Ask the Enterprise Brain anything...
Query code, metric definitions, schemas, lineage, or system architecture
The churn dashboard is 12% off from last quarter's board report and the pipeline owner is on leave. Where is churn calculated and what changed?
09:12 AM
PN
Enterprise Brain Answered in 3.4s · 9 sources consulted
Metric Definition
churn_rate is defined in the semantic layer (metric spec v2.4): churned_accounts / active_accounts_start_of_period, monthly grain, trial accounts excluded. The spec was updated on 18 Jul 2026 — a 'paused ≠ churned' exclusion was added.
Where It's Calculated
Layer Location Last changed
Semantic layermetric spec churn_rate v2.418 Jul 2026
Warehouseanalytics-dbt/models/marts/churn_daily.sql18 Jul 2026
Dashboard"Executive Churn" (Looker)12 Feb 2026
Board reportreports repo — q_board_churn.sql (embedded SQL)3 Apr 2026
What Changed
18 Jul 2026 — metric spec v2.4 added the paused-account exclusion; churn_daily.sql updated the same day (PR #1482)
The board report extract still embeds v2.3 logic — it counts paused accounts as churned. This accounts for an 11.7% divergence; the remaining 0.3% is a reporting-window boundary.
Recommended Fix
Update the board extract to consume the semantic-layer metric instead of embedded SQL. Draft PR prepared — backfill validation requires masked access to accounts_dim.
Ask a follow-up...

Governance

Domain concepts resolved:
churn → resolved per semantic-layer metric spec churn_rate v2.4
'board report' → resolved to reports repo extract q_board_churn.sql
'last quarter' → Q2 2026 fiscal window
Semantic model v3.4.1
3 concepts resolved · model v3.4.1
6 steps · 3.4 seconds
1Parsed query & intent
2Resolved metric — churn_rate v2.4
3Located definitions across 4 layers
4Retrieved 9 sources across 5 systems
5Compared spec vs board extract logic
6Composed governed answer
Completed in 3.4 seconds
9 sources from 5 systems
Semantic layer — metric spec churn_rate v2.4 (1)
Warehouse — dbt models & compiled SQL (3)
BI platform — Executive Churn dashboard (1)
Reports repo — q_board_churn.sql extract (2)
Version control — PR #1482 & spec change log (2)
EB-2026-0809-TD-03102
EB-2026-0809-TD-03102
Immutable decision log · SHA-256 anchored
Recorded 09 Aug 2026 · 09:12 AM