CiviCRM Community Forums (archive)

I have a need to create a report given a scenario like this:

Out of 40 memberships that expired 30-60 days ago, 32 have renewed and are still current members. The other 8 we've never heard from again or have no interest in renewing. So we have an 80% retention rate (32/40).

Looking at the data, I don't see a way to glean this information. Is there a table I can use to get information on each renewal? The civicrm_membership_payment table is a simple linking table to connect money to the membership, but I don't see where the membership links to a membership transaction for each renewal/upgrade/downgrade. Am I missing a table or is there no way to get this information?  Thanks!

Thank you; I will use this as a start! Are you aware of any plans on the roadmap to enhance CiviMember to record membership transactions as children of a membership record? This would allow much more robust reporting on join/lapse/renew/rejoin/upgrade/downgrade and an easy way to view a patron's membership history.