Is there a system/utility that calculates daily/weekly/monthly statistics based on SQL sensors?

Question

Analytics

Tell me, please, is there any online service in nature (or a downloadable set of scripts) that can build statistics on key indicators (number of registrations, number of important operations, etc.) in a database, not only daily, but also monthly, and send something like this to the mail every day?



(ATTENTION: I composed all the names in the screenshot “from the bulldozer”, there is no need to look for any meaning in them - in particular, this is NOT data from the logs, i.e. it is NOT a system for analyzing logs that is being searched, but a system that can read statistics at night on a real database.)

In this screenshot:
1. Each row is formed by a separate SQL query, which can be manually edited at any time, recalculated, tested, etc.
2. SQL queries are sent to the main database (or replica) of the project, i.e. daily consider the main indicators of the project.
3. When running an SQL query for a particular cell of a particular row, the macros "count starting from the timestamp" and "count ending with the timestamp" are passed to it.
4. All these requests are launched at night (because they can be slow), the result is stored and then it is already drawn when needed.

Who uses what in their projects?
Who monitors key metrics?

Answer 1

You can test, for example, in phpmyadmin, and collect, for example, in zabbix, it will be with graphs and all that.

Answer 2

I would pick GoogleAnalytics - most of what is drawn in the table is in their web interface.
On some events, you will have to manually hang triggers that notify GA about these events through the JS API.
They can also collect data through the API for some specific tasks / calculations

Answer 3

GoogleAnalytics or in its opensource analogue Piwik , for me it’s more adequate api, for example, there is a class for php out of the box, I
use it to track calls to my API. Dashboard is fully customizable, user access control... As long as it performs its functions, it's easier than GA seemed