An enterprise IWMS system I worked on solved this by charging only for enabled accounts. An admin could enable or disable accounts, and every month a report would show how many unique accounts were enabled that month and determined the billing. That shouldn’t be that hard to implement for airtable or any other SaaS, so it is puzzling why that option isn’t offered.
I remember Qlikview (reporting/data discovery software) had a per minute license for this.
There are a lot of inactive users in reporting apps. A lot of people just log in once a month to see a single report and this was a useful way to get more users onboard.
It looked scary at first because you didn't knew beforehand how many minutes you should buy.
Mising standard and by minute license worked great, though