Tell me, please, does the nature of any online service (or a downloadable set of scripts) that is able to build statistics of key indicators (number of registrations, number of important operations, etc.) on the database, not only daily, but monthly, daily and send to mail something like this?
(NOTE: all names in the screenshot I wrote "from the bulldozer", there is no sense in them do not look for — in particular, it does NOT log data, i.e. it is sought NOT system log analysis, and system that can at night to count the statistics on the real database.)
In this screenshot:
1. Each row formed a separate SQL query, which you can edit at any time, to convert, test, etc.
2. SQL queries natravlyayut to the main database (or replica) of the project, i.e. daily consider main indicators of the project.
3. When you run a SQL query for a particular cell in a particular row receives the macros "to consider starting timestamp and ending timestamp to count th".
4. All these queries are run at night (since they can be slow), the result is stored and then drawn when needed.
Who than uses in my projects?
How anyone keeps track of key performance indicators?