Listing Active Memberships and filtering on expiration dates

Wondering how hard it would be to adapt the Memberpress Pro reports plugin for the following case:

We have a membership system with multiple kinds of memberships (annual, monthly and different levels).

At least once a month we want to:
– See who’s membership is about to expire and make sure their needs are being met – increasing the likelihood of renewal
– As people expire we need to ensure that they’re removed from other systems outside Memberpress/Wordpress

I can’t find a way to do this. Ideally I would stay in wordpress and make two selections:
– Which memberships to filter on -> checkbox or multi-select from a list
– Expiration date range – allowing to see people who’re about to expire and who have already expired

To do this today, I try exporting all users to a CSV however the memberships field is populated by numbers that are hard to fathom (I assume its membership types ‘or’ together i.e. “Monthly” | “Course 1”). Whatever this is, it is impossible to use for filtering.

I’ve also tried exporting “Monthly” and “Annual” members, then combining the two spreadsheets however this is also a massive kludge.