For more details see the Advanced Reports for Magento 2 extension page.
Using advanced reports, you can significantly widen your analytical opportunities. Gather and process important statistical data to produce efficient marketing strategy.
You can find the Advanced Reports Dashboard by going to Reports → Advanced Reports in the Magento 2 admin panel
To configure the Reports Dashboard, please, do the following:
The whole dashboard will look the following way:
From the left navigation menu you can switch between different stats. Let's check them.
To choose order statuses you want to be used in all Sales Reports, please, go to Stores → Configuration.
Product Attribute used in Brands Report - choose an attribute to be used as Brand in Brands Report.
Select the time interval to view reports data.
Choose the step interval for data generation (day, week, month).
Export. Export necessary information to a CSV or XML file.
Columns. Manage columns for the report grid (available fields: Period, Number of Orders, Items Ordered, Subtotal, Tax, Shipping, Discounts, Total, Invoiced, Refunded).
Below you can see the total value of each column in a percentage or numeric format.
Compare sales data by custom periods with the 'Sales Comparison' report. Set several time ranges you want to compare and click the Compare button. You can set to compare specified periods by days, weeks, months and years. Also, you can choose a store view you want to compare sales of different periods within.
Configure Orders Report Filter stats data by the number of sold products or by the total sum paid by customers within a specific time period (Quantity/Total). It's also possible to filter data By status to get more precise information.
Use time based reports to figure out which time periods (days of the week, hours) bring you more sales. You can filter by Quantity and Total or specify the particular Store.
Two reports have identical settings and can be configured in a few clicks.
Easily study your customers' geolocation.
Due to the report you'll get detailed information on the most popular payment types utilized by your customers.
Use these data to organize your order management.
(Fields available: Payment Type, Number of Orders, Items Ordered, Subtotal, Tax, Shipping, Discounts, Total, Invoiced, Refunded)
The report clearly shows which customer groups bring you more sales. You can filter stats data by the number of sold products or by the total sum paid by customers within a specific time period (Quantity/Total).
(Fields available: Customer Group, Number of Orders, Items Ordered, Subtotal, Tax, Shipping, Discounts, Total, Invoiced, Refunded, Action)
In the Action column you can click the Show More link to instantly see the 'Sales by Product' report filtered by the chosen customer group:
If you run promo campaigns on your web store, you need to keep track of conversions generated by the coupons you offer. Learn which promo codes appeared to be more effective.
(Fields available: Day of week, Number of Orders, Items Ordered, Subtotal, Tax, Shipping, Discounts, Total, Invoiced, Refunded)
Use convenient graphs to study customers' demands. Find out which product groups enjoy greater popularity and restock accordingly.
(Fields available: Category, Number of Orders, Items Ordered, Subtotal, Tax, Shipping, Discounts, Total, Invoiced, Refunded)
In this tab you can check your cart price rules' effectiveness.
Set the necessary time period to get a detailed product sales report. The report includes:
With the extension, you can easily build custom rule-based product reports. For example, create unique reports for products with special attributes or a combination of attributes. To do this, please, go to Reports → Advanced Reports Rules.
On the grid, you can track and manage all existing reports rules. To create a new rule, please, click the Add New Rule button.
To configure the reports rule, give it a title and specify the necessary conditions. Then, you can create custom reports by applying the rule in the 'Sales by Product' report in the Display dropdown:
You can also create new rules by simply clicking the + New Rule button on the 'Sales By Product' report panel.
Find out which products enjoy greater popularity depending on a specific time period (month, year etc.) Set the time interval to get a detailed bestsellers report. The report includes:
The report allows you to learn which product configurations generate more conversions. Set the time period and select the necessary product attribute in a dropdown to get detailed stats data.
(Product Attributes available for filtering: Activity, Category Gear, Climate, Collar, Color, Country of Manufacture, New Theme, New Layout, Features, Format, Gender, Allow Gift Messages, Manufacturer, Material, Display Actual Price, Display Product Options in Layout, Pattern, Price View, Quantity, Ship Bundle Items, Size, Sleeve, Enable Product, Strap/Handle, Style Bags, Style Bottom, Style General, Tax Class, Visibility.)
The extension also allows to see the statistics based on brands. This feature will be useful for the owner of a multi-brand store.
Generate customer report based on a specific time period. Select the necessary time step (Day, Week, Month, Year) to tailor the report to your needs.
Manage data display on the graph by enabling/disabling such parameters as:
Easily study your audience to analyze your sales strategy. See the results for New and Returning Customers.
To refresh the statistics, go to Reports→Statistics→Refresh Statistics. To get the reports timely updated and see the latest data, select necessary elements in the list and apply the Refresh Lifetime statistics or Refresh the Statistics for the Last Day action.