Child pages
  • Advanced Reports - Magento 2

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.



Advanced Reports is a Magento 2 extension by aheadWorks that helps getting a perspective on the store performance with a set of a eight reports:

  • Sales Overview –  detailed order representation with the average values for the sales period;
  • Product Performance – per product sales report;
  • Sales by Category – product categories performance for a set period;
  • Sales by Product Attributes - overview of an attribute or attribute combination sales; (Only attributes with 'Use for Promo Rule Conditions' enabled are processed)
  • Sales by Coupon Code – number of coupon uses with the total discount applied;
  • Sales by Payment Type – number of orders placed and items ordered per payment method;
  • Sales by Manufacturer – product manufacturer perspective sales;
  • Sales Detailed - sales per single item per customer;
  • Traffic and Conversion - unique page visits to orders placed ratio;
  • Sales by Location - provides an overview of the customers by country for identifying new promotional campaigns;
  • Abandoned Carts - introduces abandonment cart rate statistics to the store.



Reference table


Report range – the date range the report generated displays total sales for;

Report entry – the timespans the Report range is split to; altogether are equal to the Report range set.



How does it look like?

Advanced Reports extension introduces its section to Reports > Advanced Reports by aheadWorks where store administrator can find all the reports available. Reports screen is represented with the following elements:

Here, at the Sales Overview report screen, which will be used in the context of this readme for introduction purposes, storeowner can find the following elements:

Navigation menu – used for quick navigation within an extension; with the help of the navigation menu store administrator can switch to required report, get to the documentation or extension settings;

The available extension pages are:

    • Sales Overview;
    • Product Performance;
    • Sales Detailed;
    • Traffic and Conversions;
    • Abandoned Carts;
    • Sales by Category;
    • Sales by Product Attributes
    • Sales by Coupon Codes;
    • Sales by Payment Type;
    • Sales by Manufacturer;
    • Settings;
    • Readme;
    • Get Support.

            • Calendar – used to set the reporting period; it comes with the pre-defined reporting periods for quick access;

The calendar allows selecting from the following pre-defined report ranges: today, yesterday, last 7 days, last week, last business week, this month, last month.



  • Report intervals – used to group the report data by a necessary period;

For example: you can generate a report from a whole month (1st to 31st) and group the report table entries by day (31 entry – day by day sales), week (5 entries – week total sales), or month (1 entry – month sales total).
Sales Overview report at screenshot covers the dates between July 20th and September 6th and the report entries are represented by week.

  • Report chart – used to visualize the sales data in a readable chart;
  • Availble chart parameters - these represent the most important aspects of the particular report that can be presented in the chart;
  • Totals block - represents the report specific totals for quick evaluation;
  • Report grid – represents the report specific sales data built for the period defined in the Calendar;
  • Filters and report grid adjustments - represent a set of filters including: customer group, segment, and report specific criteria; that can be applied to get more details.

For the convenience purposes the reports generated can later be exported to the .csv or .xml tables with the help of the Export button.

Generating a report

The extension comes with eight report types each covering particular aspect of the store performance. To generate a report take the steps below:

Step 1

To generate a report store administrator selects a required report from the list available under Reports > Advanced Reports by aheadWorks.

Step 2

Then, store administrator uses Calendar to select required report date range; and clicks  button.

Step 3

The report is generated. Now, store administrator can adjust the Report period grouping to get the required report representation and adjust the filters necessary .

Step 4

Once the required filters are selected, store administrator can save the perfect report grid look by clicking Default View button and Save view as...

The View saved will be transferred as you navigate through reports and can be recalled any time you have made any changes to filters or report grid.

Report drill-down

All the reports of Advanced Reports extension are interconnected, meaning that store administrator can get more in-depth look on the report entry with each click.

Taking a Sales Overview report as a starting point, store administrator can get to the Product Performance report by clicking a required report entry. The Product Performance period will match the Sales Overview report entry clicked and will be grouped accordingly.

Moreover, clicking a Product Performance report entry will take the store administrator to the Individual Product Performance report screen.

When done with the report drill-down, store administrator can use the breadcrumb trail to get back to the starting or intermediate location of the drill. The breadcrumb trailed is marked with the red line on the screenshot above.

The drill-down scenarios available for reports are:

  • Sales Overview > Product Performance;
  • Product Performance > Product Variant Performance;
  • Sales by Category > Product Performance;
  • Sales by Coupon Code > Sales Overview;
  • Sales by Payment Type > Sales Overview;
  • Sales by Manufacturer > Product Performance;
  • Traffic and Conversions > Product Conversion >
  • Sales by Location > Sales by State/Region > Sales by City/Place.



Extension settings



The Advanced Reports general settings can be accessed using a navigation menu or found under Stores > Configuration > aheadWorks extensions > Advanced Reports.

The extension settings are represented with the Order Statuses selector. The selector defined which order statuses the extension will process for building reports. By default only ‘Complete’ orders will be processed.

If required store administrator can select additional order statuses for the extension to process by either using  +  to select a group of orders, or  +  to select order statuses one by one.


Version 2.1.0 of Advanced Reports extension introduced Order Status selector on per-report basis. Now store administrators can adjust what order types should be processed by a particular report.

To do this, administrator can click button at the top of the report grid to proceed to the Order Statuses selector and override General Settings values.