# Reset and clear all stats in v4.4.8

**URL:** <https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937>\
**Category:** Product Support\
**Created:** [May 7, 2023, 9:59pm UTC](https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937 "2023-05-07T21:59:23Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![pro-emailer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/pro-emailer/32/12615_2.png) [@pro-emailer](https://forum.mautic.org/u/pro-emailer)\
**Post date:** [May 7, 2023, 9:59pm UTC](https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937/1 "2023-05-07T21:59:23Z")

</div>

After installing and making many tests, my Mautic instance is full of my own stats.  
Is there a way to initialize all the statistics like sent, open, clicks, … from emails, campaigns, …  
I want to restore the initial state of the reports but keep my properties like emails, segments, campaigns, …

---

<div class="post-metadata">

**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\
**Post date:** [May 7, 2023, 10:56pm UTC](https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937/2 "2023-05-07T22:56:53Z")

</div>

You would have to delete records from email\_stats table, but I am sure this is not the only table you have to pay attention to.

Caution is in order when doing these things and before you delete any records make a backup of entire database just in case.

---

<div class="post-metadata">

**Author:** ![IonutOjicaDe](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ionutojicade/32/7383_2.png) [@IonutOjicaDe](https://forum.mautic.org/u/IonutOjicaDe)\
**Post date:** [May 8, 2023, 7:38pm UTC](https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937/3 "2023-05-08T19:38:59Z")

</div>

For Campaigns I duplicate them.  
For Emails the same.  
For Forms the same.  
Inside the Segments there are not so many statistics, so I let these as they are.

Would be a good feature to have a “reset” button for the statistic-numbers.

---

<div class="post-metadata">

**Author:** ![pro-emailer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/pro-emailer/32/12615_2.png) [@pro-emailer](https://forum.mautic.org/u/pro-emailer)\
**Post date:** [May 8, 2023, 8:29pm UTC](https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937/4 "2023-05-08T20:29:18Z")

</div>

Yes, it will be definitely a good feature.  
Or if someone can give us the MySQL query or the tables to purge to run.  
The structure of the database is a little bit complex, so I don’t know exactly what tables to purge.

---

<div class="post-metadata">

**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\
**Post date:** [May 8, 2023, 10:06pm UTC](https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937/5 "2023-05-08T22:06:09Z")

</div>

I usually recommend this: [The great Mautic weight control – Joey Keller](https://joeykeller.com/the-great-mautic-weight-control/) by @joeyk 😉

---

<div class="post-metadata">

**Author:** ![pro-emailer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/pro-emailer/32/12615_2.png) [@pro-emailer](https://forum.mautic.org/u/pro-emailer)\
**Post date:** [May 8, 2023, 11:24pm UTC](https://forum.mautic.org/t/reset-and-clear-all-stats-in-v4-4-8/27937/6 "2023-05-08T23:24:51Z")

</div>

Thanks, it will help to get rid of some stats.