Lapsed Member Report

Stefanie Gallagher

Is there anyway to run a report to show all memberships that lapsed on a particular date (including rejoins and renewals)? We need to know how many memberships lapsed in July.

Alan French

You could query for all memberships where the "history" (not the current membership transaction) has an expiry date in July. I think that should pick up everyone regardless of whether they've since renewed/rejoined or not.

JoBeth Marihugh

I struggle to report on Membership in general.... I tend to create a query list and then create a statistical pivot table in excel for the answers like rate of renewal, lapsed vs dropped, etc.

Mark Guncheon 2

That's a nice report, JoBeth.