We do lightweight growth tracking just to see how things are progressing, and so any future community organisers can see the impact of their work growing Peels in local areas.

This tracking is run on a monthly schedule via a CRON job in the Supabase dashboard. Each month, on the 7th of the month, it creates a new row on the growth_tracking table. Here are the columns it creates:

1. The verified_users column counts all the users excluding those who marked as an admin.
2. The listing_count column counts all the listings excluding those by admin, whether those listings are a stub or not.
3. The host_count column counts distinct users who have at least one listing. Respects exclusions for non-admins and stub listings.
4. The donor_count column counts distinct users who have zero listings. Respects exclusions for non-admins and stub listings.
5. The chat_thread_count column counts all the threads excluding those which include an admin.

These numbers are all cumulative. Just subtract the previous month’s data to get the selected month’s unique data.

Improvements

We should have a more granular count of listings, like the growth per country. Ideally that would be even more granular, although we’d to do a lot of work to extrapolate that (from a listing’s coordinates).

We should also make chat_thread_count work the same as the other columns: exclude chats with admins (or change the other columns to be excluding stubs, not just admins).