Skip to main content

Data Dashboard

Retention

Overall Goal

We will build a diverse, cohesive, and vibrant membership community that supports MakeHaven’s long-term sustainability.

Objectives

  • Improve Member Retention
  • Strengthen the New Member Experience
  • Build Member Connections, Belonging and Inclusive Representation
  • Continuous Improvement, Feedback, and Transparency
Edit notes

Key Performance Indicators

Wired KPIs

KPI Name Current Details Goal 2026 Goal 2030 Trend
Total # Active Members
The count of all members currently in active status across all membership categories.
827
98% of goal
BIPOC: 31.8%Female/NB: 22.2%
 845 1,000
First Year Member Retention %
Percentage of new members who remain active for at least 12 months after joining.
52%
94% of goal
BIPOC: 40.0%Female/NB: 28.6%
 55% 65%
Member (Post-12mo) Retention %
Retention from month 12 to month 24 among members who made it through their first year.
62%
112% of goal
BIPOC: 74.9%Female/NB: 66.7%
 55% 70%
Retention POC %
The 12-month survival rate specifically for members identifying as Black, Indigenous, or People of Color.
42%
77% of goal
 — 55% 70%
Member Net Promoter Score (NPS)
Overall member satisfaction and likelihood to recommend MakeHaven to others.
88.0
117% of goal
 — 75.0 80.0
Active Participation %
Percentage of active members who have utilized the space (recorded a card read) in the last quarter.
62%
Trailing 90 days as of month-end
103% of goal
BIPOC: 70.5%Female/NB: 65.0%Visited: 510Roster: 827
 60% 65%
Last 12 months
Active Participation % (BIPOC)
Percentage of active BIPOC members who have utilized the space in the last quarter.
71%
Trailing 90 days as of month-end
118% of goal
Visited: 153Roster: 217
 60% 65%
Last 12 months
Active Participation % (Female/Non-binary)
Percentage of active Female and Non-binary members who have utilized the space in the last quarter.
65%
Trailing 90 days as of month-end
108% of goal
Visited: 180Roster: 277
 60% 65%
Last 12 months
New Member First Badge (28 days) %
Share of new members who successfully complete their first badge/orientation within 28 days of joining.
71%
109% of goal
 — 65% 80%
Membership Diversity (% BIPOC)
Percentage of the overall membership identifying as Black, Indigenous, or People of Color.
32%
91% of goal
 — 35% 50%

KPIs In Development

KPI Name Current Details Goal 2026 Goal 2030 Trend
No in-development KPIs currently listed.
KPI Name 2023 2024 2025 2026 2027 2028 2029 2030
Total # Active Members n/a n/a 795 845 875 930 975 1,000
First Year Member Retention % n/a n/a 55% 55% 58% 60% 62% 65%
Member (Post-12mo) Retention % 76% 62% 55% 55% 60% 63% 67% 70%
Retention POC % 15% 20% 42% 55% 60% 63% 67% 70%
Member Net Promoter Score (NPS) n/a n/a 82.0 88.0 80.0 80.0 80.0 80.0
Active Participation % n/a n/a 60% 60% 62% 63% 64% 65%
Active Participation % (BIPOC) n/a n/a 60% 60% 62% 63% 64% 65%
Active Participation % (Female/Non-binary) n/a n/a 60% 60% 62% 63% 64% 65%
New Member First Badge (28 days) % n/a n/a 60% 71% 65% 70% 75% 80%
Membership Diversity (% BIPOC) n/a n/a 30% 35% 40% 45% 50% 50%
  • Total # Active Members: The count of all members currently in active status across all membership categories. Last snapshot: 2026-05-01
  • First Year Member Retention %: Percentage of new members who remain active for at least 12 months after joining. Last snapshot: 2026-05-01
  • Member (Post-12mo) Retention %: Retention from month 12 to month 24 among members who made it through their first year. Last snapshot: 2026-05-01
  • Retention POC %: The 12-month survival rate specifically for members identifying as Black, Indigenous, or People of Color. Last snapshot: 2025-12-31 Source: Automated: Cohort retention filtered by BIPOC ethnicity.
  • Member Net Promoter Score (NPS): Overall member satisfaction and likelihood to recommend MakeHaven to others. Last snapshot: 2026-05-01
  • Active Participation %: Percentage of active members who have utilized the space (recorded a card read) in the last quarter. Last snapshot: 2026-05-01 Source: Snapshot-backed: unique members with at least one card read in the trailing 90-day window ending at each month-end, divided by the active-member roster.
  • Active Participation % (BIPOC): Percentage of active BIPOC members who have utilized the space in the last quarter. Last snapshot: 2026-05-01 Source: Snapshot-backed: unique BIPOC members with at least one card read in the trailing 90-day window, divided by the active BIPOC roster at each month-end.
  • Active Participation % (Female/Non-binary): Percentage of active Female and Non-binary members who have utilized the space in the last quarter. Last snapshot: 2026-05-01 Source: Snapshot-backed: unique Female/NB members with at least one card read in the trailing 90-day window, divided by the active Female/NB roster at each month-end.
  • New Member First Badge (28 days) %: Share of new members who successfully complete their first badge/orientation within 28 days of joining. Last snapshot: 2026-05-01 Source: Automated: Member success daily snapshots (join cohort reaching ~28 days).
  • Membership Diversity (% BIPOC): Percentage of the overall membership identifying as Black, Indigenous, or People of Color. Last snapshot: 2026-05-01
Active members by home region

Prefer a heatmap? Open the standalone heatmap.

Key insights

Total Active Members

Active membership headcount over time.

Loading chart…
  • Source: makerspace_snapshot membership_totals snapshots joined with ms_fact_org_snapshot (members_active).
  • Processing: snapshots flagged as tests are excluded before aggregation.
  • Coverage: May 1, 2025 — May 1, 2026 (13 snapshots).
Download CSV

Annualized Retention Rate by Cohort

Annualized retention rate estimating the average share of members retained each year since joining.

Loading chart…
  • Source: Same cohort dataset as the composition chart, using join dates from profile__field_member_join_date.
  • Processing: Geometric mean of active/total per cohort, normalised for cohort age. Line shows 3-year centered rolling average; hover for per-cohort value.
  • Definitions: Active roles default to current_member/member; cohorts without active members report 0% annualized retention.
Download CSV

Net Membership Change

Joined minus ended members per month with join/end overlays for context.

Loading chart…
  • Source: Derived from monthly totals returned by MembershipMetricsService::getFlow.
  • Processing: Calculates joined minus ended counts for each month and overlays the underlying join/end totals.
  • Definitions: Positive values indicate headcount growth; negative values indicate net attrition.
Download CSV

Active Participation Rate

Share of members who accessed the space at least once per quarter, by demographic segment.

Loading chart…
  • Source: Door-access logs from access_control_log via UtilizationDataService.
  • Processing: Each bar covers one completed calendar quarter. Members with at least one door-access event count as "active".
  • Denominator: Active member roster at query time for each segment.
  • Definitions: BIPOC = members with non-white racial/ethnic identity; Female/NB = members with female or non-binary gender identity.
Download CSV

Members at Risk

Share of active members flagged as at-risk each month — an early-warning signal for churn.

Loading chart…
  • Source: ms_member_success_snapshot daily snapshots, latest date per month.
  • Definition: At-risk = risk_score ≥ 20. Threshold can be adjusted in service parameters.
  • Coverage: Feb 2026 – May 2026 (4 months).
Download CSV

Monthly Cohort Retention (Heatmap)

Detailed view of member retention over time, grouped by join date.

Expand section to load chart.
  • Cohorts are grouped by join month.
  • Columns represent months elapsed since joining (Month 0 = Join Month).
  • Month 0 is the join-month baseline; later months are measured at each month end.

Cohort Composition by Join Year

Active vs inactive members for each join year cohort.

Expand section to load chart.
  • Source: Members with join dates in profile__field_member_join_date grouped by calendar year.
  • Processing: Counts total members per cohort and marks a member as active when they hold an active membership role today.
  • Definitions: "Still active" reflects active role assignment today; "No longer active" covers members without those roles.
Download CSV

Ending Memberships by Reason

Monthly churn totals stacked by recorded end reason (latest 6 months).

Expand section to load chart.
  • Source: Membership end-date events joined to field_member_end_reason values.
  • Processing: Distinct members per reason per month; stacked bars show each reason’s contribution to total churn.
  • Definitions: Reasons reflect list-string options configured on member profiles when ending access.
  • Reason key mapping: Time = time; Relocation = relocation; Unknown = unknown; Other = other; Cost = cost; 3rdparty = 3rdparty; Unknown = Unknown; Predefined = predefined; Engagement = engagement; Orientation = orientation; Equipment = equipment; Community = community; Removed = removed; Management = management
Download CSV

Member Success Lifecycle Stage Mix

Month-end counts by lifecycle stage (onboarding, engagement, retention, recovery).

Expand section to load chart.
  • Source: `ms_member_success_snapshot` daily snapshots grouped by stage.
  • Processing: uses the latest snapshot date available in each month.
Download CSV

Onboarding Completion Funnel

Recent join cohort progress through orientation, badge activation, and serial setup.

Expand section to load chart.
  • Source: latest daily row set in `ms_member_success_snapshot`.
  • Cohort: members with join_date in the last 90 days at snapshot 2026-05-01.
  • Current cohort size: 103
Download CSV

Intervention ROI Summary

Key performance indicators for member outreach program.

Expand section to load chart.
  • Annual Value Saved: Sum of monthly payments × 12 for resolved members.
  • Resolution Rate: (Resolved ÷ Contacted) × 100.
  • Avg Days: Time from first contact to resolution.

28-Day Activation Rate

Share of new members who earned at least one badge within 28 days of joining.

Expand section to load chart.
  • Source: ms_member_success_snapshot daily snapshots, latest date per month.
  • Cohort window: members whose join_date falls 28–58 days before the snapshot date (badge_count_total ≥ 1 = activated).
  • Cohort size (dashed) shows how many members were in scope for each month — low counts make the rate more volatile.
  • Activation = first badge earned, a proxy for meaningful first engagement with the space.
Download CSV

Risk Reason Breakdown

Why are members currently flagged as at-risk? Sorted by prevalence.

Expand section to load chart.
  • Snapshot: latest member state (is_latest = 1, risk_score ≥ 20).
  • A single member can carry multiple risk flags; totals may exceed 427.
  • Total members at risk: 427.
Download CSV

Monthly Recruitment vs Churn

Total members who joined or ended each month (all membership types).

Expand section to load chart.
  • Source: MembershipMetricsService::getFlow aggregates member profile creation timestamps (join dates) and recorded end dates.
  • Processing: Distinct members per month; expands to 24 months when the most recent 12 months have no data.
  • Definitions: "Joined" counts users whose default member profile was created during the month; "Ended" uses field_member_end_date.
Download CSV

Active Members (Monthly Snapshot Cadence)

Latest 13 monthly snapshots of active membership headcount.

Expand section to load chart.
  • Source: makerspace_snapshot membership_totals snapshots joined with ms_fact_org_snapshot (members_active).
  • Processing: snapshots flagged as tests are excluded before aggregation.
  • Coverage: May 1, 2025 — May 1, 2026 (13 snapshots).
  • Daily snapshot rows are not currently available; this chart is currently showing the monthly cadence.
Download CSV

Active Members (Monthly Snapshot Anchor)

Collapses snapshots to one point per month using the latest capture inside each month (max 13 months).

Expand section to load chart.
  • Source: makerspace_snapshot membership_totals snapshots joined with ms_fact_org_snapshot (members_active).
  • Processing: Groups snapshots by calendar month and keeps the most recent capture in each month to smooth overlapping runs.
  • Coverage: May 1, 2025 — May 1, 2026 (13 snapshots).
Download CSV

Active Members (Year-End Snapshot Anchor)

Uses the latest snapshot per calendar year to show longitudinal membership scale.

Expand section to load chart.
  • Source: makerspace_snapshot membership_totals snapshots joined with ms_fact_org_snapshot (members_active).
  • Processing: Keeps the last snapshot logged in each calendar year to highlight long-term growth.
  • Coverage: Dec 1, 2025 — May 1, 2026 (2 snapshots).
Download CSV

Monthly Appointment Volume

Trend in total member appointments over time.

Expand section to load chart.
  • Window: May 1, 2025 – May 1, 2026
  • Source: appointment nodes, excluding records with canceled status.
  • Processing: counts all qualifying appointments by month based on appointment date.
  • Total appointments in window: 1,399 (avg 116.6 per month).
Download CSV

First-Year Retention by Membership Type

Share of Standard and Sliding Scale members still active 12 months after joining. Terminal Program excluded.

Expand section to load chart.
  • Source: profile records with field_membership_type matching Standard (tid 716) or Sliding Scale (tid 718).
  • Terminal Program (tid 842) members are excluded — time-bounded memberships not expected to renew.
  • A month appears only after its 12-month evaluation window has elapsed; the most recent 12 months are excluded.
  • Unpreventable attrition (relocation, etc.) is excluded from both numerator and denominator.
  • Null points indicate fewer than 1 members of that type joined in that month (too small to show).
Download CSV

Cohort Retention by Ethnicity

Annualized retention rate for the largest self-reported ethnicity groups, using the same cohort window as the overall metric.

Expand section to load chart.
  • Source: Member profile demographics joined to the cohort dataset defined by profile__field_member_join_date.
  • Processing: Same annualized retention calculation as the overall cohort chart, filtered to the selected demographic group.
  • Includes the top 5 ethnicity selections (by total members with a main profile).
  • Members can select multiple ethnicities; each group is analyzed independently.
Download CSV

Membership Mix by Snapshot

Shows how many active members are recorded in each membership type snapshot over time.

Expand section to load chart.
  • Source: makerspace_snapshot membership_types snapshots joined with ms_fact_membership_type_snapshot data.
  • Processing: Keeps the most recent membership_types snapshot per calendar month (max 13 months) and stacks active counts per membership type.
  • Coverage: May 1, 2025 — May 1, 2026 (13 snapshots).
Download CSV

Membership Mix Share by Snapshot

Shows how the membership mix shifts over time by converting each stacked bar to 100%.

Expand section to load chart.
  • Source: makerspace_snapshot membership_types snapshots joined with ms_fact_membership_type_snapshot data.
  • Processing: Converts the latest membership_types snapshot in each month into share-of-total percentages so each bar equals 100%.
  • Tooltips list both the percentage share and raw member count per type.
  • Coverage: May 1, 2025 — May 1, 2026 (13 snapshots).
Download CSV

Ending Memberships by Reason (100% Stacked)

Each month sums to 100% to compare reason share even when total churn volume changes.

Expand section to load chart.
  • Source: Membership end-date events joined to field_member_end_reason values.
  • Processing: Distinct members per reason per month converted to percent-of-month totals.
  • Tooltips show percentage and raw member counts.
  • Reason key mapping: Time = time; Relocation = relocation; Unknown = unknown; Other = other; Cost = cost; 3rdparty = 3rdparty; Unknown = Unknown; Predefined = predefined; Engagement = engagement; Orientation = orientation; Equipment = equipment; Community = community; Removed = removed; Management = management
Download CSV

Intervention Resolution Rate

Success rate of member outreach efforts over time.

Expand section to load chart.
  • Source: `ms_member_outreach_log` table.
  • Resolution: payment_updated or confirmed_cancel outcomes.
  • Rate: (resolved members ÷ contacted members) × 100.
Download CSV

Intervention Channel Effectiveness

Comparison of success rates by contact method.

Expand section to load chart.
  • Source: `ms_member_outreach_log` table grouped by contact_method.
  • Higher bars indicate more effective outreach channels.
  • Use this to optimize staff time allocation.
Download CSV

Recruitment by Membership Type

Breakdown by membership type across the selected periods.

Expand section to load chart.
  • Source: Same join-date dataset as the recruitment totals, segmented by membership type taxonomy terms.
  • Processing: Counts distinct members per type per month based on the taxonomy term active at join time.
  • Definitions: Type names come from taxonomy terms; unknown or missing terms appear as "Unclassified".
Download CSV

Appointments During Onboarding

Tracks the share of members who schedule their first appointment within 30, 90, and 365 days of joining.

Expand section to load chart.
  • Source: appointment nodes joined to member profiles (excluding cancellations) and bucketed by days after the profile was created.
  • Processing: Each member is counted once based on when their first appointment occurs; line markers show cumulative engagement vs. those still unengaged.
  • Cohort size: 3,669 members, 1,151 engaged within one year (31.4%).
  • 2,518 members have not booked an appointment within their first year.
  • First 30 days top purpose: Badge checkout (390 members)
  • Days 31-90 top purpose: Badge checkout (100 members)
  • Days 91-365 top purpose: Unspecified (66 members)
Download CSV

Appointment Outcomes & Feedback

Track facilitator outcomes and how often members leave feedback on appointments.

Expand section to load chart.
  • Window: May 1, 2025 – May 1, 2026
  • Source: appointment nodes (excluding canceled) with facilitator-entered results and optional feedback fields.
  • Processing: Shows stacked appointment outcomes per month and overlays how many of those visits received written feedback.
  • Overall feedback rate: 5.4% (75/1,400 appointments)
Download CSV

Cohort Retention by Gender Identity

Annualized retention rate across members’ self-selected gender identities, highlighting the most common responses.

Expand section to load chart.
  • Source: Member profile demographics joined to the cohort dataset defined by profile__field_member_join_date.
  • Processing: Same annualized retention calculation as the overall cohort chart, filtered to the selected demographic group.
  • Limited to members who provided a gender value in their main profile.
Download CSV

Cohort Retention by Membership Type

Compares annualized retention rates across the top membership plans (based on members with a main profile).

Expand section to load chart.
  • Source: Member profile demographics joined to the cohort dataset defined by profile__field_member_join_date.
  • Processing: Same annualized retention calculation as the overall cohort chart, filtered to the selected demographic group.
  • Membership type labels come from the field_member_membership_type taxonomy on the main profile.
Download CSV

Badges vs. Membership Tenure

Average membership length for members grouped by the total number of badges they have earned.

Expand section to load chart.
  • Badge counts include all active badge requests linked to a member profile (orientation + tool badges).
  • Tenure is measured from join date to the most recent end date, or to today for currently active members.
  • Hover a bar to see how many members fall into that badge bucket.
Download CSV

Members by Badges Earned

How many badges members have earned, grouped into buckets.

Expand section to load chart.
  • Counts the total number of active or completed badge requests linked to each member profile.
  • Buckets members into the same ranges used by the tenure correlation chart for easier comparison.
Download CSV
  • Last 6 months recruitment: 228
  • Last 6 months churn: 219
  • Net change: 9
All metrics shown are aggregated to protect member privacy. Use configuration to adjust minimum counts and data sources.