# Mautic reports often produce 500... switching to Metabase :)

**URL:** <https://forum.mautic.org/t/mautic-reports-often-produce-500-switching-to-metabase/9974>\
**Category:** General Discussion\
**Created:** [November 24, 2017, 2:17pm UTC](https://forum.mautic.org/t/mautic-reports-often-produce-500-switching-to-metabase/9974 "2017-11-24T14:17:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![denispavliha](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@denispavliha](https://forum.mautic.org/u/denispavliha)\
**Post date:** [November 24, 2017, 2:17pm UTC](https://forum.mautic.org/t/mautic-reports-often-produce-500-switching-to-metabase/9974/1 "2017-11-24T14:17:02Z")

</div>

Hey guys,  
  
  
  
although I love Mautic big time, I simply hate its reporting capabilities.

- reports often produce 500 errors (e.g. “group by” is quite error-prone)  
- data are inconsistent/incomplete (although I am sure there are more entries that correspond to given criteria, there are only a few listed in a report’s table)  
- there are no fancy graphs etc (well, some managers like to see them) ![:)]( ":)")  
  
  
  
  
  
Of course, these issues I have been facing are not a showstopper and I am still recommending Mautic to everyone without hestitation. But better reporting capabilities would make Mautic even greater.  
  
  
  
While waiting for those, I have discovered Metabase which opened a new world to me:  
  
  
- you can hook it up directly to Mautic’s MySQL database (I have a self-hosted instance)  
- it reads the database structures/model, tries to generate friendly table names, …  
- you can make questions about your data, visualize Mautic form results, make fancy graphs  
- reports can be sent out as “pulses” daily/weekly/… to your email  
- making custom dashboard using real-time data from Mautic is simple  
- …  
  
  
  
  
  
I am writing this post for you guys who have self-hosted Mautic instances to give Metabase a try. It helped me a lot and provided me with insights I have not had before.  
  
  
  
Best,  
  
Denis  
  
  
  
  
  
\*disclaimer: I don’t work for Metabase, don’t have any personal interests there, etc… just wanted to help those Mautic users who want better reporting capabilities.

---

<div class="post-metadata">

**Author:** ![denispavliha](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@denispavliha](https://forum.mautic.org/u/denispavliha)\
**Post date:** [November 24, 2017, 2:17pm UTC](https://forum.mautic.org/t/mautic-reports-often-produce-500-switching-to-metabase/9974/2 "2017-11-24T14:17:02Z")

</div>

Hey guys,

although I love Mautic big time, I simply hate its reporting capabilities.

- reports often produce 500 errors (e.g. “group by” is quite error-prone)
- data are inconsistent/incomplete (although I am sure there are more entries that correspond to given criteria, there are only a few listed in a report’s table)
- there are no fancy graphs etc (well, some managers like to see them) 🙂

Of course, these issues I have been facing are not a showstopper and I am still recommending Mautic to everyone without hestitation. But better reporting capabilities would make Mautic even greater.

While waiting for those, I have discovered Metabase which opened a new world to me:

- you can hook it up directly to Mautic’s MySQL database (I have a self-hosted instance)
- it reads the database structures/model, tries to generate friendly table names, …
- you can make questions about your data, visualize Mautic form results, make fancy graphs
- reports can be sent out as “pulses” daily/weekly/… to your email
- making custom dashboard using real-time data from Mautic is simple
- …

I am writing this post for you guys who have self-hosted Mautic instances to give Metabase a try. It helped me a lot and provided me with insights I have not had before.

Best,  
Denis

\*disclaimer: I don’t work for Metabase, don’t have any personal interests there, etc… just wanted to help those Mautic users who want better reporting capabilities.