# Email reading time

**URL:** <https://forum.mautic.org/t/email-reading-time/32868>\
**Category:** Mautic 4 Install/Upgrade Support\
**Created:** [July 24, 2024, 10:46pm UTC](https://forum.mautic.org/t/email-reading-time/32868 "2024-07-24T22:46:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![laclac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/laclac/32/13366_2.png) [@laclac](https://forum.mautic.org/u/laclac)\
**Post date:** [July 24, 2024, 10:46pm UTC](https://forum.mautic.org/t/email-reading-time/32868/1 "2024-07-24T22:46:17Z")

</div>

Hello,  
I want to know at what time my emails are most read. But I do not know how. If you could tell me how to do it that would be great.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![rcarabelli](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rcarabelli/32/6807_2.png) [@rcarabelli](https://forum.mautic.org/u/rcarabelli)\
**Post date:** [July 25, 2024, 5:02am UTC](https://forum.mautic.org/t/email-reading-time/32868/2 "2024-07-25T05:02:04Z")

</div>

I can’t remember mautic Reports be capable of aggregating data on days or hours basis.

But you have this table: “\*prefix\_\ ***email\_stats** ” where everything that happens to your leads is recorded.  
Table looks like this.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/7/7b86672429fb9ab1e750cb0608101cccefb969e7.png)

As you can see there is in a readable format of all what happens to emails (when it was read, open, who did it, etc)

So you can create a report directly from MySQL or via a view or connecting this to something like Google Looker Studio or similar.  
Or even downloading all this table and processing it on Excel/Google Sheets

---

<div class="post-metadata">

**Author:** ![laclac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/laclac/32/13366_2.png) [@laclac](https://forum.mautic.org/u/laclac)\
**Post date:** [July 25, 2024, 9:26am UTC](https://forum.mautic.org/t/email-reading-time/32868/3 "2024-07-25T09:26:26Z")

</div>

Thanks a lot for your answer.  
It’s a shame that it’s not integrated because it seems to me that this is very often requested data, particularly to determine the best sending time.  
In any case, your solution suits me very well. Even if it is not simple and rather technical, it poses no problem for me.  
I’m not going to do it every day, and sometimes, it’s better to work with the data yourself to manipulate it according to your desires.

Thank you so much anyway.

---

<div class="post-metadata">

**Author:** ![rcarabelli](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rcarabelli/32/6807_2.png) [@rcarabelli](https://forum.mautic.org/u/rcarabelli)\
**Post date:** [July 25, 2024, 3:55pm UTC](https://forum.mautic.org/t/email-reading-time/32868/4 "2024-07-25T15:55:48Z")

</div>

Well, maybe a simple plugin for this types of reports?

I guess mautic report’s code can be upgraded to include more things, but we need volunteers…

---

<div class="post-metadata">

**Author:** ![peter\_k](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/peter_k/32/511_2.png) [@peter\_k](https://forum.mautic.org/u/peter_k)\
**Post date:** [August 4, 2024, 11:35pm UTC](https://forum.mautic.org/t/email-reading-time/32868/5 "2024-08-04T23:35:05Z")

</div>

This is possible:

1. Go to your main dashboard

2. Add a new widget  

3. Save the widget

4. This is what it looks like:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/9/9261355a6dc9be8911728e8a8924257d3f0d6184.png)