๐Ÿ“‹
How to Read These Reports โ€” National Coaching Alliance ยท Complete Member Intelligence Journey
These four connected reports follow the National Coaching Alliance's annual member intelligence cycle โ€” from chapter data intake to board-ready network report. Start here (Step 1) and follow the navigation to see how context compounds across cycles. Every report is a live Sopact Sense output your team receives automatically โ€” no manual assembly, no context rebuilt between steps. This is the differentiator: persistent member intelligence, not annual snapshot surveys.
1Chapter Intake โ€บ 2Data Agreement โ€บ 3Annual Cycle Report โ€บ 4Network Intelligence
National Coaching Alliance โ€” Member Intelligence Platform 58,000+ Members ยท 140 Chapters ยท 92 Countries ยท Annual Cycle 2025
Step 1
Chapter Data Intake Intelligence
You are here
Step 2
Shared Data Agreement
Next
Step 3
Annual Cycle Report
Upcoming
Step 4
Network Intelligence
Upcoming
Sopact Sense ยท Chapter Data Intake Intelligence ยท National Coaching Alliance

Chapter Intake: 140 Chapters. One Unified Picture.

Sopact Sense ingested annual member data from all 140 NCA chapters โ€” surveys, spreadsheets, PDFs, Google Forms โ€” and normalized them into a single structure. Four definition conflicts detected automatically before any reporting began.

140 Chapters Processed 58,240 Member Records 4 Flags Auto-Detected 4.2 Hours vs. 3 Months Manual
Network Health Score
74
out of 100
NCA 2025 Rubric Applied
Across All 140 Chapters
Why This Is Different From Every Other Membership Platform
Sopact Sense reads all 140 chapter submissions and applies NCA's rubric uniformly โ€” every score is cited to a specific chapter record, not a staff member's memory. Definition conflicts across chapter surveys, dues records, and engagement forms are flagged automatically before the board sees anything. And all context โ€” every flag, every definition resolved โ€” carries forward to Step 2 without a single re-read. Your team stops reconciling spreadsheets. It starts using them.
Other platforms do this instead: Each chapter re-introduces itself
Staff spends 3 months reconciling formats
"Active member" means different things
in every chapter's spreadsheet
Conflicts surface after the board report
not before it
CHAPTER DATA SOURCES INGESTED140 Chapters ยท 12 Formats ยท All Normalized
Format Type 1
Google Forms Annual Survey
62 chapters ยท 28,400 member responses
โœ“ Normalized
Format Type 2
Excel Membership Rosters
38 chapters ยท 17,200 member records
โš‘ 3 Definition Conflicts
Format Type 3
PDF Chapter Reports
24 chapters ยท summary data extracted
โœ“ Normalized
Format Type 4
Other / Mixed Formats
16 chapters ยท CSV, Airtable, Typeform
โš‘ 1 Missing Segment
FIVE DIMENSIONS ASSESSMENTNCA Network Health Rubric Applied ยท Every Score Cited to Source Chapter Data
Dimension Score AI Assessment Evidence Citation
Member Retention
Are members renewing year over year?
 72 / 100 NCA-wide renewal rate at 68% on comparable definitions, below the 75% threshold. However, definition inconsistency across 38 Excel-submitting chapters means true rate is unconfirmed โ€” requires Step 2 agreement.
Excel rosters from APAC and EMEA chapters use "paid invoice date" vs. "engagement date" as renewal trigger โ€” producing rate variance of 8โ€“14 percentage points across same member cohort.
Chapter Engagement
Are chapter members actively participating?
 81 / 100 Strong event participation rates in 92 of 140 chapters (65%). Engagement data missing or stale for 22 chapters โ€” primarily smaller chapters in Latin America and Southeast Asia.
Google Forms data shows 82% event participation for chapters with 200+ members; PDF-only submitters lack event-level data entirely, requiring proxy metric agreement in Step 2.
Credential Pipeline
Are members progressing through ACC โ†’ PCC โ†’ MCC?
 78 / 100 ACC-to-PCC progression rate strong at 34% over 3-year window. MCC pipeline thin โ€” only 2.3% of PCC holders have initiated MCC application. No chapter-level tracking exists for members in education pathway.
Credential data from NCA global database cross-referenced against chapter rosters. 14% of chapter members not matched to credential record โ€” suggests either lapsed members retained in roster or data gap.
Chapter Health
Are chapters financially and operationally stable?
 69 / 100 18 chapters flagged as at-risk based on dues payment delays, low submission completeness, or leadership turnover signals. 7 chapters have not submitted any data in 14+ months.
At-risk classification derived from: dues arrears in NCA finance system (11 chapters), no 2024 annual report submitted (7 chapters), leadership contact email bounced (4 chapters โ€” 3 overlap with prior groups).
Network Equity
Is membership growth reaching underrepresented regions and segments?
 61 / 100 Global South chapters represent 22% of membership but only 11% of credential holders. Gender representation data collected inconsistently โ€” 47% of chapters use optional vs. required demographic fields.
Demographic gap flagged from Google Forms chapters only. Excel and PDF-submitting chapters do not collect demographic data in standardized format โ€” equity analysis incomplete until Step 2 data standard locked.
โš‘ AUTO-DETECTED FLAGS4 Conflicts Flagged Before Board Reporting ยท All Carried to Step 2
Definition & Data Conflicts โ€” Requires Step 2 ResolutionAll 4 flags pre-loaded into Step 2 agenda
1
Active Member Definition Conflict โ€” 3 Different Interpretations Across 140 Chapters
APAC chapters define "active" as dues paid in last 12 months. EMEA chapters use event attendance in last 12 months. North America chapters use login to ICF Engage platform in last 6 months. This produces NCA-wide retention variance of up to 19 percentage points depending on which definition is applied. A single definition must be locked in Step 2 before any retention metric is reported to the board.
Source: Cross-chapter data normalization ยท Excel rosters (38 chapters) ยท Google Forms export headers (62 chapters)
โ†’ Carried to Step 2, Question 1
2
Lapsed Member Count Inconsistency โ€” 4,200 vs. 6,800 Depending on Roster Source
NCA HQ finance system shows 4,200 lapsed members (dues unpaid 13+ months). Chapter self-reported rosters aggregate to 6,800 lapsed โ€” a 62% discrepancy. Neither number is wrong; they measure different things. Until the denominator is agreed upon, lapsed member outreach campaigns will target either under or over the true population by thousands of contacts.
Source: NCA Finance System export (Jan 2025) vs. aggregated chapter roster submissions (Dec 2024)
โ†’ Carried to Step 2, Question 2
3
Credential Progression Tracking Gap โ€” 14% of Chapter Members Not Matched to Credential Record
8,154 members appear in chapter rosters but have no matching record in NCA's global credential database. These could be: non-credentialed members, members who lapsed their credential but not their chapter membership, or data entry errors in chapter-maintained rosters. The gap inflates chapter membership counts and deflates credential penetration rates. A matching protocol must be agreed in Step 2.
Source: NCA Credential Database (March 2025) cross-referenced against aggregated chapter roster data
โ†’ Carried to Step 2, Question 3
4
Demographic Data Collection Inconsistency โ€” Equity Analysis Incomplete for 47% of Chapters
NCA's equity goals require demographic reporting by gender, region, and coaching specialty. 53% of chapters collect this via required Google Forms fields. The remaining 47% use optional fields, collect in unstructured PDF sections, or do not collect at all. Any equity report published before Step 2 standardization will be based on a self-selected sample โ€” producing misleading conclusions about network representation.
Source: Google Forms field-level export analysis ยท PDF chapter report content extraction ยท Excel roster column audit
โ†’ Carried to Step 2, Question 4
CHAPTER BENCHMARKTop 10 Chapters vs. NCA Network Median ยท 5 Dimensions
DIMENSION
Top 10 Chapter Average NCA Network Median (140 chapters)
SCORE
Member Retention
88 vs. 68
Chapter Engagement
91 vs. 72
Credential Pipeline
84 vs. 65
Chapter Health
87 vs. 58
Network Equity
79 vs. 52
PERSISTENT MEMBER IDEvery Member Gets a Unique Record That Follows Them Across Every Cycle
Sopact assigns a Persistent Member UUID at first enrollment โ€” before any survey, form, or chapter report is collected. This UUID connects every data point across the member's entire NCA lifecycle.
Persistent UUID
โ†’
Enrollment
โ†’
Chapter Activity
โ†’
Annual Survey
โ†’
Credential Record
โ†’
Renewal / Lapse
Why this matters: When your 2026 annual survey goes out, Sopact already knows who this member is โ€” their chapter, their credential level, their engagement history, their unresolved flags. You're continuing a conversation, not starting from scratch. This is what eliminates the 3-month reconciliation cycle every year.
SOPACT DIFFERENTIATOR PROOF6 Intelligence Outputs From This Single Intake Cycle
Cell Analysis
Chapter Intake Report
All 140 chapters scored against NCA rubric. Every score cited to specific chapter data โ€” not staff interpretation. Delivered in 4.2 hours, not 3 months.
Row Analysis
Missing Chapter Alert
7 chapters with no 2024 submission, 4 with bounced leadership contacts, 22 with stale engagement data โ€” all surfaced automatically before anyone asks.
Column Analysis
Zero Context Rebuild
All 4 flags pre-loaded into Step 2 agenda. No analyst re-reads 140 chapter reports to remember what was flagged. Context persists automatically.
Grid Analysis
Network Benchmark
Top 10 chapter performance vs. NCA median across all 5 dimensions โ€” produced automatically from the same data flow, no separate analysis project.
Row + Column
Equity Audit
47% of chapters missing demographic data flagged before any equity report is published. No misleading conclusions reach the board from incomplete data.
Grid Analysis
Board Pre-Brief
Network health summary with top flags, chapter risk tiers, and Step 2 agenda โ€” auto-generated and ready before the first meeting. No prep time required.