Proposal For MoFo Data: Difference between revisions

Line 24: Line 24:
==='''General Project Plan:'''===
==='''General Project Plan:'''===


'''Phase I:''' Mozilla Foundation members discuss internally a strategy for automating data pulling.
'''Phase I (Week 1-2):''' Mozilla Foundation members discuss internally a strategy for automating data pulling.


'''Phase II:''' Plan 2-3 meetings between the Foundation and Metrics team to determine what decisions need to be made for donations PayPal process
'''Phase II (Week 1-2):''' Plan 2-3 meetings between the Foundation and Metrics team to determine what decisions need to be made for donations PayPal process
* Discussion points for meeting: determine what questions have to be answered  
* Discussion points for meeting: determine what questions have to be answered  
* Do we direct our focus to manipulate these funds?
* Do we direct our focus to manipulate these funds?
Line 32: Line 32:
* For external use: Is our goal to present information to our donor and/or to encourage others to make the decision to donate more money along a path that we dictate (does this go against the idea of Choice for users)? i.e. are there areas that we feel donors should be encouraged to donate to in particular?  
* For external use: Is our goal to present information to our donor and/or to encourage others to make the decision to donate more money along a path that we dictate (does this go against the idea of Choice for users)? i.e. are there areas that we feel donors should be encouraged to donate to in particular?  


'''Phase III:''' Once process is determined, Metrics team would be able to use the data retrieval API to query for information from system, authenticate and retrieve account totals so there is no chance of data being misplaced. We would be able to retrieve information from the last thirty days for the web request.
'''Phase III (Week 2):''' Once process is determined, Metrics team would be able to use the data retrieval API to query for information from system, authenticate and retrieve account totals so there is no chance of data being misplaced. We would be able to retrieve information from the last thirty days for the web request.
* By creating a script, the process would be completely automated on a regular schedule (i.e. weekly or monthly); if this is not possible, there would need to be a push process so we could retrieve the latest data.
* By creating a script, the process would be completely automated on a regular schedule (i.e. weekly or monthly); if this is not possible, there would need to be a push process so we could retrieve the latest data.
* From PayPal, Metrics can sparse the spreadsheet into a CSV file  
* From PayPal, Metrics can sparse the spreadsheet into a CSV file  
* IT will have information on how much was donated, the time of day, which causes were donated to, where we get our donations.
* IT will have information on how much was donated, the time of day, which causes were donated to, where we get our donations.


'''Phase IV: Using data'''
'''Phase IV (Week 3): Using data'''
* Metrics can extract this information so MoFo can have the data for email, newsletters or general dashboard on website. Having this information would would make disseminating the information easier to deploy.  
* Metrics can extract this information so MoFo can have the data for email, newsletters or general dashboard on website. Having this information would would make disseminating the information easier to deploy.  
* Other options: use Flot to plot donation trend information privately (for the board) give MoFo access to this for long term trending.
* Other options: use Flot to plot donation trend information privately (for the board) give MoFo access to this for long term trending.
134

edits