What's the best way to take a 'snapshot' of membership counts at a point in time?
This is a tricky one - see these questions for a variety of approaches:

Is it possible to get point-in-time membership data?

How can I see the number of memberships at a given date in the past?

Membership Status Report