# Clicks, Unique clicks and unsubscribe in database table

**URL:** <https://forum.mautic.org/t/clicks-unique-clicks-and-unsubscribe-in-database-table/24621>\
**Category:** Product Support\
**Created:** [June 29, 2022, 8:28pm UTC](https://forum.mautic.org/t/clicks-unique-clicks-and-unsubscribe-in-database-table/24621 "2022-06-29T20:28:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zanser](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/zanser/32/7359_2.png) [@zanser](https://forum.mautic.org/u/zanser)\
**Post date:** [June 29, 2022, 8:28pm UTC](https://forum.mautic.org/t/clicks-unique-clicks-and-unsubscribe-in-database-table/24621/1 "2022-06-29T20:28:41Z")

</div>

**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

 ![clicks images](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/c347a5144fc3afb8f77eff1f469520c5c472a4ea.png)  
and also in reports  
 ![report+screen](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/9/9a64269279e6c283896bb41f065d102efe2c1731.png)  
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