Your database is lying to you
A membership director told me recently that her renewal rate was "about 82%, give or take." Give or take. That phrase stuck with me, because it wasn't her fault. She genuinely couldn't tell me. The number moved every time finance ran it one way