I am building a social networking website in Drupal. As users complete their profile, they are awarded different roles. Now that I have launched the site and have some members, I would like to track the number of users by role over time so that I can see how my site is growing.
I built a view to do this and it shows me the information I want. However, since I want to measure membership growth I would like to do this over time. So, currently I simply log into my site and then type the numbers I need into Excel.
Is there a better way to do this? Ideally, I would like to automatically save an Excel-ready snapshot every week (or in a dream world, have a graph automatically prepared). Is there some other way (even without views) to track the number of users by role over time?