I’ve managed to accurately (albeit untidily) create a growth accounting model that flags football players based on their activity. E.g. if a player didn’t have a record last year and they do this year ‘new’. Other flags include ‘churned’, ‘retained’, ‘resurrected’, ‘stale’ and ‘inactive’.