Data Map

Page → mart → field lineage for every route in this dashboard. Switch between Page view (select a route to see its marts) and Mart view (select a mart to see every page that queries it).

17 pages

Accounts

/

Query file

account-queries.ts

Full customer list with health, ARR, risk signals, and module filters. Toggle between Top 75 by ARR and all customers.

Marts queried (3)

PrimaryEnrichmentLookupLegacy

mart_account_360Primary

One row per account · Salesforce · Gainsight · Pendo

Every account row — ARR, health score, renewal date, lifecycle stage, NOC/at-risk flags, usage signals

Join key

account_id

account_idaccount_nametotal_arrgs_health_scoregs_health_labeldays_until_renewalowner_namesegmentgs_notice_of_cancellationgs_at_riskhas_vip_support

⚠total_arr is OSS-only — Greetly (~1,223) and Dojo (~21) customers show $0 ARR.

⚠Some accounts have duplicate rows; queries must QUALIFY or GROUP BY account_id.

⚠gs_health_score caps at ~81 org-wide — the ≥80 'healthy' threshold is almost never reached.

⚠open_se_escalation_count is unreliable (counts se_status != Closed without is_closed guard).

mart_accounts_at_riskEnrichment

One row per fired signal per account · Gainsight CTAs · Salesforce

Risk score and risk tier overlay on each account card

Join key

account_id

account_idrisk_scorerisk_tierrisk_context

→Aggregated via ANY_VALUE(risk_score) before join

⚠One row per signal, not per account. Always aggregate (ANY_VALUE, ARRAY_AGG) before joining.

mart_eci_health_inputsEnrichment

One row per account · Gainsight ECI model

RAG health signal breakdown (replaces raw gs_health_score in health band display)

Join key

account_id

account_ideci_model_typegs_health_labelgs_health_color

Data quality notes

•Top 75 = top 75 by total_arr DESC — always OSS customers (Greetly/Dojo show $0 ARR).
•Warning banner shown when Greetly/Dojo platform filter is active.

Data Map

Page → mart → field lineage for every route in this dashboard. Switch between Page view (select a route to see its marts) and Mart view (select a mart to see every page that queries it).

17 pages

Accounts

/

Query file

account-queries.ts

Full customer list with health, ARR, risk signals, and module filters. Toggle between Top 75 by ARR and all customers.

Marts queried (3)

PrimaryEnrichmentLookupLegacy

mart_account_360Primary

One row per account · Salesforce · Gainsight · Pendo

Every account row — ARR, health score, renewal date, lifecycle stage, NOC/at-risk flags, usage signals

Join key

account_id

account_idaccount_nametotal_arrgs_health_scoregs_health_labeldays_until_renewalowner_namesegmentgs_notice_of_cancellationgs_at_riskhas_vip_support

⚠total_arr is OSS-only — Greetly (~1,223) and Dojo (~21) customers show $0 ARR.

⚠Some accounts have duplicate rows; queries must QUALIFY or GROUP BY account_id.

⚠gs_health_score caps at ~81 org-wide — the ≥80 'healthy' threshold is almost never reached.

⚠open_se_escalation_count is unreliable (counts se_status != Closed without is_closed guard).

mart_accounts_at_riskEnrichment

One row per fired signal per account · Gainsight CTAs · Salesforce

Risk score and risk tier overlay on each account card

Join key

account_id

account_idrisk_scorerisk_tierrisk_context

→Aggregated via ANY_VALUE(risk_score) before join

⚠One row per signal, not per account. Always aggregate (ANY_VALUE, ARRAY_AGG) before joining.

mart_eci_health_inputsEnrichment

One row per account · Gainsight ECI model

RAG health signal breakdown (replaces raw gs_health_score in health band display)

Join key

account_id

account_ideci_model_typegs_health_labelgs_health_color

Data quality notes

•Top 75 = top 75 by total_arr DESC — always OSS customers (Greetly/Dojo show $0 ARR).
•Warning banner shown when Greetly/Dojo platform filter is active.