MySQL Database Reporting and Analytics Using Google Chart/Visualization API

Need some reports and analytics generated for a membership site. We already have a reporting site/system where you can run a query and it will automatically return the result set in a JSON format that the Google Visualization API can accept. So to create a new report in the site you essentially need to create a MySQL routine/stored procedure to select the data you want to report. Then tell the Google Chart what columns you want to display in the graph. Getting the data to the Google Chart/Visualization is the easy part, the hard part will be creating at least one MySQL routine/stored procedure for each report. Since this is for a membership site and will bill customers monthly it is very similar to a SaaS (software as a service) business. We would be looking for 6 reports with different filter criteria that are found on the beginning of this document. [login to view URL] Each customer/order in our system has data like "referral source", "Trial or Paid" member, and "membership price"). The query/report needs to allow filtering and grouping so if for example we can break down the Churn/Attrition (percent of customer canceling every month) on a per "referral source" basis or by membership price. For this project you must have a BASIC understanding of the Google Chart/Visualization API and a ADVANCED understanding of MYSQL and business terms like Churn/Attrition and how memberships work in general. I will provide you the PHP code and tell you how to plug in a new stored procedure and provide a working example of that data being wired up to the Google Chart API wil a few short lines of code.