![Page 1: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/1.jpg)
Building a Membership Valuation Program
- Define- Case Study
- How To- Tips- Fun!
![Page 2: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/2.jpg)
Before you Go Crazy
Slides are on Slideshare here:
https://www.slideshare.net/garrypolmateer
![Page 3: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/3.jpg)
![Page 4: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/4.jpg)
![Page 5: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/5.jpg)
What is a member valuation program
Is NOT a way to see how much your members spend.
Jones Hardware spent $1875 with the association last year
Is how you can share the value that your organization gives to a member, either financial or intangible.
We Saved Jones Hardware $6790 in insurance premiums and also passed legislation lowering their administrative overhead.
![Page 6: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/6.jpg)
StoryNortheastern Retail Lumber Association
![Page 7: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/7.jpg)
Observations of Implementation at NRLA
✖ Implemented before housing crash in 2008
✖ Data helped target member communication during downturn
✖ Enhanced ability for board to make decisions
✖ Organization has continued to grow and thrive
✖ Offered many segmentation options
![Page 8: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/8.jpg)
![Page 9: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/9.jpg)
![Page 10: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/10.jpg)
![Page 11: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/11.jpg)
![Page 12: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/12.jpg)
Lessons Learned✖ Need to make it as easy as possible for
staff to maintain✖ Keep documentation up to date✖ Continue to monitor value adds that
should be included
![Page 13: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/13.jpg)
Lofty Goal - How to Get From Here to There
![Page 14: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/14.jpg)
Universal Truths ✖ Value > dues paid is a good thing✖ Should be able to get and use this
information with any AMS (or no) AMS
✖ These exercises can identify gaps in services and help with strategy for new offerings
✖ Ethical Rubric✖ Data + Staff Knowledge =
SUPERDATA
![Page 15: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/15.jpg)
Implementation Steps 1 - Get Leadership Buy-In
2 - Identify Your Value
3 - Inventory all Data Points
4 - Gather Data
5 - ETL! (The Tech Stuff, Extract/Transform/Load)
6 - Market
7 - Maintain & Document
*Bold = Annual Activity
![Page 16: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/16.jpg)
Ideas on How to Use This Information - Buy In
✖ Dues Notices✖ Email Marketing (Target high members, target low
members)✖ Board of Directors communications✖ Decisionmaking for new programs✖ Visibility in AMS✖ Board/Committee Recruitment✖ Geographical analysis (i.e. regions of low value)✖ Demographic analysis (i.e. member classes of low
value)✖ Perception vs. Value Analysis (How member feels vs.
amount of value)
![Page 17: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/17.jpg)
Identifying Value Sources
✖ What does your website say?✖ Discounted/Free publications✖ Event Registration✖ Trade Show Registration✖ Trade Show Booth Space✖ Legislative Agenda/Cost Savings✖ Grants✖ Insurance (Dividends)✖ Endorsed Program Discounts✖ Product Discount✖ Surveys✖ Subsidized Education✖ Job Placement/Job Board✖ Networking, Directories✖ Contract Negotiations✖ PR for members/job class
![Page 18: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/18.jpg)
Required Excel Tricks
Pivot Table
VLOOKUP
Concatenate
![Page 19: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/19.jpg)
Data Gathering
Distill Everything into Spreadsheets, each with 3 columns
MemberID Value Text Value Amount
123 Saved $75 on events with member discount
75
124 Saved $295 on events with member discount
295
![Page 20: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/20.jpg)
Processing
Use VLOOKUP to merge all information into one spreadsheet with two columns per benefit.
Member ID Events Text Events Value Magazine Text Magazine Value
123 Saved $75 on events with member discount
75 Saved $10 on the magazine
10
124 Saved $295 on events with member discount
295 Saved $100 on the magazine
100
![Page 21: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/21.jpg)
Compile
Use Concatenate to combine all the text into one cell ,and sum to combine all the value into one cell.
Concenate(B2 & “, ” & B4 & “, ”...)
Member ID Total Text Total Value
123 Saved $75 on events with member discount, Saved $10 on the magazine
85
124 Saved $295 on events with member discount, Saved $100 on the magazine
395
![Page 22: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/22.jpg)
![Page 23: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/23.jpg)
Load to AMS (If Applicable)
From there, you can now load the data into your AMS if it allows you to create fields and you have your Primary key set already.
![Page 24: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/24.jpg)
Think Ahead
✖ Negotiate Data Exchanges with Specific format with vendors in your contracts
✖ Make Member Value Calculation SOMEONE’S JOB
✖ Schedule/Plan each annual refresh
![Page 25: ESSAE Building a Membership Valuation Program](https://reader031.vdocuments.us/reader031/viewer/2022030307/58e84ceb1a28ab78478b48fb/html5/thumbnails/25.jpg)
Q/A
ContactGarry Polmateer
Managing Parnter - Red Argyle LLC
Twitter: @darthgarry
Linkedin: https://www.linkedin.com/in/garrypolmateer/