Improved dashboard, created membership initial date - Githubissues

lobo-studio / tamarin-php

0 stars 0 forks source link

Improved dashboard, created membership initial date #31

Closed gscardine closed 8 years ago

gscardine commented 8 years ago

https://github.com/LordAlexWorks/tamarin/issues/30 Membership initial date

[x] Added an initial date to the memberships, so that statistics can be generated correctly
[x] Initial date is also sent to mailchimp

dashboard_initial_date

Database changes

Already executed in heroku's database.

ALTER TABLE `memberships` ADD `starts_on` DATE NOT NULL AFTER `member_id` ;
UPDATE `memberships` SET `starts_on`=  DATE_SUB(`expires_on`, INTERVAL 1 YEAR);

https://github.com/LordAlexWorks/tamarin/issues/24 Dashboard

[x] Finished statistics behavior to generate growth comparisons for any queries and dates
[x] Generated statistics for:
- total numbers of registered members
- new members this month (compared to last month and last year)
- soon to be expire members this month (1st call, 2nd call, 3rd call compared to last month and last year)
- new expired this month (compared to last month and last year) : list and numbers

Still missing:

[ ] re-registration rate data
[ ] link to export queries
[ ] Most common job title
[ ] Average age

dashboard_update_real_data

bolom commented 8 years ago

Good Job @gscardine !! i can't wait to see the other items done