wiki:membership-tracking

Membership Tracking

This page is a quick look at our membership numbers over time:

Active Members by Date

Members that are still active sorted by the year the membership was activated.

mysql> select count(*) AS '# of members', YEAR(member_start_date) AS 'Start Year' from red_member where member_status = "active" group by YEAR(member_start_date);
+--------------+------------+
| # of members | Start Year |
+--------------+------------+
|           32 |       2005 |
|           73 |       2006 |
|           59 |       2007 |
|           55 |       2008 |
|           93 |       2009 |
|           78 |       2010 |
|          167 |       2011 |
|          195 |       2012 |
|           40 |       2013 |
+--------------+------------+
9 rows in set (0.00 sec)

mysql> 

Total Memberships Created By Year

mysql> select count(*) AS '# of members', YEAR(member_start_date) AS 'Start Year' from red_member group by YEAR(member_start_date);
+--------------+------------+
| # of members | Start Year |
+--------------+------------+
|           79 |       2005 |
|          169 |       2006 |
|          103 |       2007 |
|           80 |       2008 |
|          138 |       2009 |
|          113 |       2010 |
|          194 |       2011 |
|          207 |       2012 |
|           42 |       2013 |
+--------------+------------+
9 rows in set (0.00 sec)

mysql> 
Last modified 6 years ago Last modified on Jun 5, 2013, 7:10:36 PM