Your software
My Mautic version is: 4.2.0
My PHP version is: 7.4.28
Your problem
My problem is:
In which table in the database can I find the values of total clicks, Unique clicks and unsubscribe?
I’ve looked through several tables and the schema and can’t figure out where they are.
They are displayed in every mail stats
and also in reports
so they are somewhere in the database.
I will be very grateful if you can help finding these fields in the database.
I want to pull this data automatically from database to use in 3rd party dashboard