Magento 2 Advanced Reports | Ultimate Guide

Table of Content

Improved Magento 2 Advanced Reports

You need to have statistical data to sell not worse than Amazon and manage your business by making data-driven decisions. Advanced Reports for Magento 2 gets you the current information about your customers’ behavior. This extension provides 20+ detailed report types that are merged into 3 big groups: sales, catalog, and customers.

Basic features of Advanced Reports and how to work with them

By default, Magento 2 offers 20 reports about Marketing, Reviews, Sales, Customers, and Products. But what if you want, for example, to know how many Nike sneakers were sold this month. Or maybe you need to compare sales in the Q1 2019 and Q1 2020. Usually, store owners use Google Analytics for these purposes. But with our extension, you can see all the data right in the admin panel. Let’s consider some examples to make it clear.

Example #1

Say, you need to analyze users’ behavior in summer. For this, you can compare summer sales in different years. Our extension includes the Sales Comparison report. Go to Reports > Advanced Reports and click Sales Comparison on the left panel. There you can set 2 or 3 data Ranges, choose the needed store view, and click Compare. Then, you will get the result like this:

example 1 sales comparison report

On the chart, you can see if your sales are higher or lower than in previous years and analyze if you have any seasonal features.

Also, you can download or print this image and use it for presentation or any other purposes.

Example #2

Say, you own a multi-brand store. Thus, you need to understand what brands are the most popular among your customers and correct your purchasing and marketing strategy according to this data. In the catalog section of our extension, you can find the By Brands report.

Configure the reporting period, choose the needed store view, and the plugin will display the chart with the info about how many items of a specific brand were sold, and how much revenue you got.

example 2 by brand report

From the table placed under the chart, you will get more detailed information: data about taxes, discounts, orders, and refunds:

example 2 by brand report table

Hide unnecessary columns, change their order, apply filters. Export the data in CSV or XML formats for further analysis and team meetings.

Example #3

Finally, we want to show how you can create a custom report for a specific request.

For this, go to Reports > Advanced Reports Rules or Reports > Advanced Reports > Custom Reports > New Rule and click Add New Rule. There you can set conditions for a custom report:

example 3 custom report

After you save the rule, a new report will appear in the Custom Reports section.

Set up the extension following this step-by-step guide

The latest update

Advanced Reports v. 1.5

#1. New ‘Conversion Rate’ report

Now, the extension includes a new report which lets you check the conversion rate of the store and see how it changes with time. Analyzing the effectiveness of your marketing strategy, you won’t miss a thing influencing your revenue.

conversion rate report

#2. New ‘Custom Reports’ section

If you use custom reports, now you can get access to them in one click with a special section we added for them. Create any report you need based on rules and analyze them on separate grids.

#3. Graphs design update

Now it's possible to visualize the same reports with different types of diagrams. Download, print, and use these images as visual aids for your reports:



graphs design option 2



graphs design option 1



Previous updates

Advanced Reports v. 1.1

#1. New 'Sales by Attribute Set' report

We've added the Sales by Attribute Set report to the Catalog group. Now, you can not only control separate product attributes like size, color, gender, but also track which attribute combination is the most popular among your customers. Set the period and choose the necessary attribute range to get detailed sales data:

sales by attribute set report

#2. Improved Sales by Product report

We have added new columns to this report for quantity:

  • sold;
  • ordered;
  • canceled;
  • refunded.

Define what products are refunded more often. You can tick them in the Column dropdown, in the upper-right corner:

sales by product report

Also, now you can additionally apply a rule based on Category, Attribute, Brand, to see a report for products from a specific category or with a certain attribute:

sales by product report 2

#3. The ‘Sales Comparison’ report

We’ve added the ‘Sales Comparison’ report where you can see the dynamic of your sales for different periods and analyze how they are changing:

sales comparison report

Advanced Reports v. 1.2 and 1.3

#1. New ‘Sales by Cart Price Rules’ report

We added the ‘Sales by Cart Price Rules’ report to the Sales group. This new report helps you check the use of shopping cart price rules in your Magento 2 store. Now you can compare different rules and analyze their effectiveness. Customize the report for your needs – sort your price rules by:

• Number of Orders;

• Items Ordered;

• Subtotal;

• Tax;

• Shipping;

• Discounts;

• Total;

• Invoiced;

• Refunded;

• Cart Price Rule.

Now you will need only one look at the chart to understand what’s going on with your sales. The Quantity graph is the number of customers that use cart price rules. The Total chart shows the money that these customers spent at your store.

#2. New ‘Sales by Brands’ report

Running a multi-brand Magento 2 store? Then you’ll be happy to learn that we added Sales by Brands report to the Catalog group. Now you can see what brands are popular among your customers and manage your marketing strategy with that in mind.

Customize this report table to make it meet your demands – use filters and column settings.

The columns in the graph clearly represent the demand of each brand in your store. But you can change this report and choose any other Product Attribute for Brands Report in extension settings. So you will get quick access to information about the most popular sizes, colors, materials and more. And you don’t need to choose this attribute every time, it will be saved in settings.

Also, you can see the Brand column in the report By Product. Thus, you can go to this brand report in one click.

Export the data in CSV or XML with correct information in tables and tooltips. You can use this file as a base for your monthly reports.

#3. ‘Sales Overview’ report update

The ‘Sales Overview Report’ has 2 main novelties. Now you can track the most important sales information on one page.

1. You can choose the percentage format for your report. Count daily percent of your income, taxes, orders, refunded money in one click. Check your day-to-day progress in 3 seconds.

2. Also, we introduced a new line with the total values of the columns. This feature allows you to use this tab as a quick and detailed financial report.

#4. The amCharts library update

We updated the amCharts library, now you can save data as PNG, JPG, SVG, or PDF files for all Magento 2 reports. Use these images to illustrate your presentations, reports, and offers. Now your business partners, stakeholders, and employees will understand their work results.

Advanced Reports v. 1.4

#1. New ‘Abandoned Carts' report

Do you know that the average abandonment rate in e-commerce is around 70%?

In our new ‘Abandoned Carts' report, you’ll see how many cart abandonments you have, what users leave their carts without finishing the purchase, and create a unique approach to retain more customers:

abandoned carts report

→Read how to recover up to 10% of abandoned carts 

#2. New ‘Product Performance’ report

In this report, you can check the information about a specific product:

  • how many times it was ordered;
  • how much revenue it gained;
  • who placed orders with this product;
  • and much more.

product performance report

#3. New ‘Order Item’ report

This report provides the possibility of splitting orders per separate item. Thus, you can analyze order data much deeper:

order item report

#4. ‘Today & Live’ block

Now you can get a short overview of your current situation in-store by clicking on a new ‘Today & Live’ block on Dashboard. It helps you estimate what is going on in your shop right now:

today and live block

In conclusion

Are you tired of building a business strategy on guesses? Make informed decisions with Advanced Reports Magento 2.

Haven’t found the feature you need? Leave your request here.

Stay in touch and don’t miss new big updates!

Additional resources

The full list of the latest extensions updates

Fix 404 error in default M2 Reporting

Guide to M1 Advanced Reports by Amasty

How to add Google Analytics to Magento 2

January 21, 2020
January 24, 2020
January 16, 2020
July 15, 2019
Should I pay for this update?
Polina Litreyeva
July 15, 2019
Hi, Muhammed No, we provide free lifetime updates to all our extensions. So you can update this module in your <a href="" rel="nofollow">account</a> or via Composer repository. <a href="" rel="nofollow">Here</a> is the free PDF guide on how to do this.
July 19, 2019
Hi! As I understood brand report is the same as report by attribute. Am I right?
Polina Litreyeva
July 19, 2019
Hello, Robert! Yes, you are right. But there are little differences between them. You don’t need to choose an attribute every time, it will be saved in settings. And you can see the <strong>Brand</strong> column in the report <strong>By Product</strong>. Thus, you can go to this brand report in one click.
November 17, 2020
Can you see what products are being reordered and by who?
Polina Kratovich
December 24, 2020
Hello, Jay! Thanks for your question. You can find general information about orders on your order grid. And if you want to add more details to it, you may be interested in our <a href="">Extended Order Grid</a> extension. It allows you to display not only customer data but also product info like name, SKU, thumbnail.
Leave your comment

Your email address will not be published

This blog was created with Amasty Blog Pro

This blog was created with Amasty Blog Pro