# Best Practices: 3rd party reporting / business intelligence tool **URL:** \ **Category:** 3rd Party Addons\ **Created:** [March 25, 2022, 1:27pm UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295 "2022-03-25T13:27:50Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![smc\_iris](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/smc_iris/32/6888_2.png) [@smc\_iris](https://forum.mautic.org/u/smc_iris)\ **Post date:** [March 25, 2022, 1:27pm UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/1 "2022-03-25T13:27:50Z")
Hi guys The reporting functionalities in Mautic at the moment are a bit basic. I know they’ll be worked this or next year, but I was wondering if any of you have some best practices for integrating Reporting / Business Intelligence tools (preferably opensource), for example PowerBI or Grafana? A specific case that the tool should be able to handle: We have a form that asks unsubscribers for their reason to unsubscribe. I would like to display that information in a pie chart on a dashboard, possibly along with a bar chart of the open / click-rates of the last 12 Segment E-Mails (Newsletters). Thanks very much for your inputs. ---
**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:** [March 26, 2022, 3:29pm UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/2 "2022-03-26T15:29:35Z")
Hi, I mean you can easily create a widget via custom plugin that shows any kind of data you like. And all the necessary libraries to display the graph on the dashboard are already provided by Mautic. That being said its more of a question how you get data from form to Mautic (if its non Mautic form) and how data is stored in database. What you are asking can certainly be done. Not sure about one aspect though… where external reporting tool comes to play? If you already have data in Mautic why would you need to integrate it with external tools? In general Mautic has something called Integration framework which tries to simplify integration with external tools ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [March 29, 2022, 4:52am UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/3 "2022-03-29T04:52:35Z")
Many people create dashboards in Google Data Studio or Metabase. You get the best results if you can create sql queries and get really what you want. ---
**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:** [March 29, 2022, 7:26am UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/4 "2022-03-29T07:26:27Z")
we are heavy Metabase users, very powerful tool and quite self intuitive. ---
**Author:** ![smc\_iris](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/smc_iris/32/6888_2.png) [@smc\_iris](https://forum.mautic.org/u/smc_iris)\ **Post date:** [March 30, 2022, 12:43pm UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/5 "2022-03-30T12:43:09Z")
Thanks for the suggestions! I’ve looked at Metabase and it really does look quite powerful and seems like the right solution for my problem. ---
**Author:** ![isadorehage](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/isadorehage/32/7516_2.png) [@isadorehage](https://forum.mautic.org/u/isadorehage)\ **Post date:** [October 4, 2022, 4:24pm UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/6 "2022-10-04T16:24:06Z")
Hi there! There are a few different options for integrating reporting and business intelligence tools with Mautic. One option is to use the Mautic API to pull data into a tool like PowerBI or Grafana. Another option is to use one of the many Mautic plugins that add reporting functionality, such as the Mautic Reporting Plugin or the Mautic Advanced Segment Plugin. You can find more info about Power BI integration here at [https://community.servicenow.com/community?id=community\_article&sys\_id=cfbca6631bb38154fc3233bc1d4bcbec](https://community.servicenow.com/community?id=community_article&sys_id=cfbca6631bb38154fc3233bc1d4bcbec). If you’re looking for specific advice on how to best display data from a form that asks unsubscribers for their reason to unsubscribe, I would recommend using a tool like Grafana. Grafana has a wide range of visualization options that should be able to meet your needs. ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 4, 2022, 5:28pm UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/7 "2022-10-04T17:28:10Z")
Why are you posting affiliate links? They are bad karma. ---
**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:** [December 25, 2022, 7:41am UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/9 "2022-12-25T07:41:40Z")
I think that we really nailed it with [this one](https://forum.mautic.org/t/surge-mautic-dashboard-into-something-amazing/23864). ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [December 26, 2022, 1:48pm UTC](https://forum.mautic.org/t/best-practices-3rd-party-reporting-business-intelligence-tool/23295/11 "2022-12-26T13:48:26Z")
Tell me in one sentence why this post is not spam.