I am trying to figure out how to run a mysql query that will return the number of current active members per product. Additionally, I would like to also run a query that tells me the cash amount of completed transactions for a given day. I have several sites with aMember and it is annoying to have to do this per site for the number of active users per product and the completed cash amounts. I currently can only do this inside of amember. So, I want to create one page in my master domain that can run this mysql query in a php page for each of my sites and retrieve the info. Any help would be appreciated.
You may have some luck with Ken Gary's Member Analytics: http://membershipsiteanalytics.com/ Contact him and he can probably make some adjustments to do what you're looking for.