# Clicks Reporting Help!

**URL:** <https://forum.mautic.org/t/clicks-reporting-help/18070>\
**Category:** Product Support\
**Created:** [February 7, 2021, 4:08pm UTC](https://forum.mautic.org/t/clicks-reporting-help/18070 "2021-02-07T16:08:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [February 7, 2021, 4:08pm UTC](https://forum.mautic.org/t/clicks-reporting-help/18070/1 "2021-02-07T16:08:13Z")

</div>

Hi all,

I am trying my hardest to hack my way to getting daily click report. I have managed to generate nice reports through mysql for sent, opened, unsubscribed but for the life of me cannot find how I can extract this from mysql.

Any ideas what tables/fields would hold this data ?

Thanks in advance.

Mike

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [February 8, 2021, 12:55pm UTC](https://forum.mautic.org/t/clicks-reporting-help/18070/2 "2021-02-08T12:55:26Z")

</div>

![screenshot-mautic32.ddev.site-2021.02.08-12_28_01](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/f/f65146e1a8199c0a3c9cbd8f4928294d1a09aead.png)

You could start with some thing like this maybe, filtered to one day?

 ![screenshot-mautic32.ddev.site-2021.02.08-12_53_31](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/5/526bbc7313c310dc0681beaeaa16e51e54da7f21.png)

In terms of the database here are the queries for that report, found by using dev mode:

 ![screenshot-mautic32.ddev.site-2021.02.08-12_54_29](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/5/5d57dd880236bfc27ebc0c6c27b431b2d7a1ca3a.png)

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [February 8, 2021, 1:43pm UTC](https://forum.mautic.org/t/clicks-reporting-help/18070/3 "2021-02-08T13:43:45Z")

</div>

Amazing Ruth!! Thank you.

For anyone reading this, to start with you must choose Email Stats as data source.

@silavapi - how do I get to debug mode ?

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [February 8, 2021, 2:39pm UTC](https://forum.mautic.org/t/clicks-reporting-help/18070/4 "2021-02-08T14:39:33Z")

</div>

If you install locally by cloning from Github you will have the index\_dev.php file - you just append that to the site - you can check on [Mautibox.com](http://Mautibox.com) also.

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [February 9, 2021, 7:05am UTC](https://forum.mautic.org/t/clicks-reporting-help/18070/5 "2021-02-09T07:05:17Z")

</div>

To give a bit more light on this thread after Ruth showed me some magic to see queries reports are generating I played a bit with the DB, I am not 100% sure that my query is correct but I have checked it with a number of mailers and I seem to be getting correlating number of clicks and unique clicks.

My queries were as follows:

clicks: select count(tracking\_id) from page\_hits where date\_hit like “2021-02-08%” and email\_id is not NULL;

uniq\_clicks: select count(distinct tracking\_id) from page\_hits where date\_hit like “2021-02-08%” and email\_id is not NULL;