Step 2: Get the data
The task below will be automatically checked off once you complete watching the video.
[progressally_objectives]
[progressally_media media_id='1']
The main goal for this step is to organize the data using the metrics you identified step one. You can create the spreadsheet on your own, or work with a vendor or your association’s IT department to get the data.
Choose a representative timeframe where the outcome (that is, whether someone has left or not) is known; get as close to the current date as possible, especially in times of uncertainty.
Organize the data in an Excel spreadsheet in the following format:
- Each row is a unique member
- A column to identify member
- A column to identify if the member did not renew (0 = renewed,1 = did not review)
- One column for each metric from step one
Sample
Additional Tools
Open or download the Predicting Member Churn Spreadsheet to view the sample data tab.
[accessally_course_navigation prev_button='Previous' next_button='Next']
[progressally_note note_id='1' allow_attachment='no']
Share your progress!
[progressally_social_share type='facebook' share_id='1' post_id='42'][/progressally_social_share][progressally_social_share type='twitter' share_id='1' post_id='42'][/progressally_social_share][progressally_social_share type='email' share_id='1' post_id='42'][/progressally_social_share]
[progressally_progress_bar post_id="6437" width="100%" height="25"]