Proving Data Strategies ANALYZING MEMBER GROWTH AND COMPOSITION - - PowerPoint PPT Presentation
Proving Data Strategies ANALYZING MEMBER GROWTH AND COMPOSITION Contact us at: ai@cuanswers.com How to count members? Philosophy vs Data Is a member the account or the person/entity? Membership = Account Base Individual = Social
ANALYZING MEMBER GROWTH AND COMPOSITION
Contact us at: ai@cuanswers.com
Philosophy vs Data – Is a member the account or the person/entity? Membership = Account Base Individual = Social Security/Tax ID Number
Primary Individual SSN/TIN = MASTER table Secondary Individual SSN/TIN = SECNAMES table
‘Active’ = No written off loan(s) ‘In Good Standing’ = Criteria varies per credit union and purpose
Philosophy must meet data somewhere. Someone has to set a definition or make a call. It’s the data analyst’s job to be aware of the potential philosophies, determine the relevant philosophy, then translate that to the system and practicality of data. CUSO Magazine Article - cusomag.com/2019/11/20/how-many-members- does-my-credit-union-have
Know the 2 ways CU*Answers tools count a member. CU*Answers counts members as any membership (account base in MASTER) CU*Answers bills for members as active memberships (subtracts account bases with written off loans)
Then…
Marketing needs members ‘in good standing’ memberships Eligible to vote for board is often any individual*
* Details are typically dictated by bylaws - Primary or joint? Do businesses get one vote per Tax ID number or does each person on the business account get a vote?
Every month you win some and you lose some. Be wary of focusing too closely on new members. It’s risky to minimize data
New = Opened a new membership Closed = Closed an existing membership Net = New – Closed