How do I follow up with my non-renewed members​?

Owned by Ann Turner
Last updated: Aug 13, 2021 by Dawn TerminellaVersion comment
2 min read



Data privacy

The majority of the fields on the Non-Renewed Members report constitute Personally Identifiable Information (PII) for our membership.  PII is confidential information and should only be shared with leadership and staff that have a business need to know the specific information in a report.  Please edit reports and remove the columns of data that are not needed for a business purpose before you share any data file.  NEVER share a data file with someone outside of component staff or leadership.

Step-by-step guide

  1. Login to the Chapter Portal and select the chapter you want to access.
  2. You will be taken to the Membership tab (the default tab for a Chapter's Portal page).
  3. Click on the Retention tab.
  4. Scroll to Non-Renewed Members section.
  5. Click Download Report.
  6. A .csv file will be automatically downloaded to your computer.
  7. Open the file in Excel.
  8. Filter list to find an email list (make sure to omit members who have marked Do Not Contact by Email as 'TRUE") or a phone list (make sure to omit members who have marked Do Not Contact by Phone as 'TRUE;) for outreach to members.





Get more out of your report

There are very simple things you can do with Excel that can help you look at your data differently. 
Check out our wiki article on Using a pivot table on your member roster!

Video tutorial: Watch this tutorial on how to download and filter a report


Report columns

The Non-Renewed Members report has more than 50 columns of information. A separate wiki page, "Report Columns - What do the different columns mean?" is available for what the specific columns mean and any business rules associated with them.