How to run reports on Mautic

Mautic gives users a hands on experience to analyze campaign results in different marketing channels and allow users to see which emails are queued and which segments contacts they are associated with. We can achieve these goals by filtering campaign results and analyze the datasets from the campaign results.

We can find all reporting views in the report section. Some data sources give granular details, while some give a more high-level overview. We can also view metrics on performance of individual components and channel in the context of a campaign. We can create reports to view data and the performance of a report as a whole.

Here’s how we generate a report based on filters and functions. Simply go to the report editor and input the data source, campaign value, and campaign filter.

Siagesco Campaign Points Change

Mautic report criteria

We can use filters to determine the data you wish to extract out of the campaign results. Similar to other SQL database queries, you specify a query statement using the column header and select campaign value. Our objective is to find a unique identifier for each contact record and compute the total campaign points in every contact. Using Group by “Email,” we can aggregate all the point change events of the same user email into one record in a table. The SUM function will add up all the point change events and group them together by user email.

Mautic Report Filter

In the end, we will see the cumulative points for all the contacts in the point change campaign. All contacts will be listed by email and name along with the total points. Reports can be exported into Excel, CSV, or HTML formats.