Advanced Reports Subscription

The Advanced Reports for Magento 2 is a powerful tool for comprehensive analytics of your online store, providing key insights into its performance metrics. With the Advanced Reports module, you can monitor sales trends and analyze customer behavior, enabling you to make more informed business decisions.

Our extension can pull data from any table in your store, including third-party extensions, allowing existing reports to be enriched with additional data. With its built-in report builder, you can also create custom reports of any complexity.

With this solution, you can export any report data to a CSV or Excel XML file and download it to your computer for further analysis. Advanced Reports for Magento is ideal for retailers looking to optimize their store’s performance, providing detailed metrics to enhance operational strategies.

Account & Pricing

• A separate account is not required for this extension.
• No additional fees apply to use this extension.

Features

• 20+ ready-to-use reports covering sales, customers, products, geography, coupons, tax, abandoned carts, etc. 
• Custom Report Builder to duplicate, edit, or create entirely new reports 
• Add or remove columns, reorder columns, filter by any column or attribute 
• Multi-dimensional grouping in reports (group data by more than one attribute) 
• Interactive dashboards with widgets: add, resize, rearrange blocks, private or shared dashboards 
• Access dashboards and reports from any device; mobile-friendly interface 
• Geographic reports: sales by country, state, city, postal code; interactive map with zoom & hover info 
• Multiple visualization types: bar charts, pie charts, area charts, histograms 
• Comparison of current data vs past periods (e.g. same period last week/month/year) 
• Export reports in CSV and Excel XML formats 
• Quick Access & Sharing via links or URLs without full admin access 
• Integration with Google Sheets for pulling report data directly into spreadsheets 
• Email scheduling: send any report automatically via email on a schedule 
• Permissions / Access Control: limit who can view, edit, share reports or dashboards per user role

Ready-to-use Reports

The module includes 20+ reports that any online store needs:

• Sales Overview
• Orders Overview
• Sales by the Hour of the Day
• Sales by the Day of the Week
• Sales by the Coupon Code
• Sales by the Cart Price Rule
• Sales by Customers
• Sales by the Customer Group
• Sales by Geodata (Country)
• New vs. Returning Customers
• Customers Overview
• Sales by the Payment Type
• Sales by Tax Rates
• Product Performance
• Sales by the Category
• Sales by the Attribute
• Sales by Color, Brand, etc
• Sales by the Attribute Set
• Abandoned Carts
• Abandoned Products

You can also create your own reports with a built-in Report Builder tool.

Deep analytics

See extended statistics on the dashboard.

The module shows you insights of your business' performance that go way beyond the default Magento dashboard capabilities. You're not limited to data on Lifetime Sales, Average Order, Last Orders, Last Search Terms, and charts on orders and revenue.
Get all important KPIs and data such as Low Stock Items, Refunds, Discounts, Invoiced, Grand Total Summary. Choose the preferred display format of this info: single value, table, or chart.
The advanced dashboard of this extension presents you with the necessary reports so you can quickly see the dynamics of your business. Hover the mouse cursor over the chart to get the info for the particular day you need.

Exceptional Flexibility

With the extension’s flexible interface of the Advanced Reports, you get the ideal tool for configuring the data visualisation that best suits your business needs.
Choose what matters most. You can customize each widget to get an individual dashboard that presents the information which is most valuable to you. Add any widget that you need to the advanced dashboard and change each widget's output.
Rearrange widgets with a simple block-based drag and drop interface. Resize the widgets to highlight the most important statistics.

Custom Dashboards

The Advanced Report module replaces your admin panel's standard dashboard with a custom one which only displays the data you need.
Advanced Reports for Magento 2 allows you to create several dashboards to display your store's KPIs in the most convenient way.
Create designated dashboards to fulfill the needs of your entire team: business intelligence, marketing, sales, etc.

In-depth Customization

You can tweak the way the report is displayed at any time thanks to the intuitive UI of the Advanced Reports dashboard extension. For instance, you can:

• Switch time frame presets or select your own range
• Add or remove columns
• Change the column order
• Show or hide the columns
• Alter grouped data dimensions
• Filter reports by any variable
• Sort the report by any column

Create your own KPI

You can analyze any information that is available in the database of your Magento e-shop. The module supports all types of data contained in your store.
Build your own reports by using the custom report builder tool.
Get a quick view of the necessary information with additional blocks on the advanced reports dashboard. Choose the respective metric you want to display.
Additionally, you can display a comparison of the selected data to the previous period, same periods last week, month, and year.

Geographic Reports

The module includes a geodata report where you can look at sales on a world map. You can zoom-in into separate regions of Africa, Europe, the Americas, Asia, and Oceania. Each zone is split into smaller regions for the convenience of analyzing sales by country.
The Advanced Reports module is capable of showing the sales report even for states, cities and postcodes.
The map is interactive, so you can hover the mouse to get the exact numbers for a region or city. You can look at the geodata report to find markets with the most potential for your store.

Share dashboards

You can send the dashboard's direct URL to anyone without needing to share admin access to your admin panel.

Just create a board, add the widgets that you allow to be seen, and share the link with anyone.
For example, you have a couple of vendors and would like to share the metrics for each vendor but don't want to share the summary metrics for all vendors.
All you have to do is create a separate dashboard for each vendor, apply a relevant filter by vendor, and share these links with its representatives.

Ready for mobile

Access to the advanced dashboard on the go.

With the Advanced Reports module, you can check the reports on your store with your smartphone.
Any created advanced dashboard can be accessed via mobile device. Simply scan the QR-code of the dashboard with the camera of the smartphone.

Report Builder

Create custom reports with any data from your database. Simply duplicate an existing report and edit the copy to your needs.
Carefully craft the report by including the desired data dimensions and columns. Display only the information you need by applying primary filters.
Use internal filters with logical conditions to flexibly exclude irrelevant information from the report.

Multi-dimensional Grouping

Report Builder in Advanced Reports lets you add dimensions to your tables.
Create reports with data sets congregated by the parameters you need. Combine customer group and the order number, SKU and order status, or the day and the order number.
As a table dimension, you can use any data column to group the information from the database of your store.

Config Builder

Create your own columns.

Maximize the efficiency of your reports by adding more data to the grid. Craft your own columns in addition to dozens of those that your store's database provides.
Built-in Config Builder tool allows you to add columns that calculate a function from several other columns on the fly.
Configure your custom columns using the two provided examples of Custom Gross Profit and Relation column. Create them with XML Config.

Quick Access, Sharing, and Integration with Google Sheets

Quick Access & Sharing

For each report, you can enable quick access to share it with your team through a direct link.
Additionally, you can use quick access to download the report in CSV or XLSX formats without opening the admin panel. Even with quick links, all reports are generated in real-time, ensuring they always provide fresh data.
The direct access links can also be used as data providers for integrations with various external systems such as Google Sheets, Microsoft PowerBI, Zapier, Excel, Exploratory, and many more.

Integration with Google Sheets

With seamless integration with Google Sheets, you don't need to export and import data each time. Just use the built-in Google Sheets functions to import the most recent information from your reports directly to spreadsheets.

Easy Report Export

You can export a CSV or an Excel XML file of your report in order to create a backup, continue working on it locally or upload it to any other analytics suite.

Store reports locally by saving them to files from the admin panel.

Have the information emailed to your team members automatically.

This reporting plugin can regularly send emails with any reports with the option of scheduled report delivery. You can configure flexible schedule options by using cron-like expressions.

Configure the Advanced Reports extension to send the report as one file or attach each block of the report as a separate CSV file.

Demo

See it in action: Backend demo | Mobile dashboard