User Tools

Site Tools


Sidebar

magento_2:advanced_reports

For more details see the Advanced Reports for Magento 2 extension page.

Guide for Advanced Reports for Magento 2

Using advanced reports, you can significantly widen your analytical opportunities. Gather and process important statistical data to produce an efficient marketing strategy.

  • Get 20+ ready-made essential e-commerce reports
  • Have all key metrics at hand on the informative dashboard
  • Analyze sales dynamics comparing different periods
  • Track your sales performance in real time
  • Build an unlimited number of custom reports
  • Use multiple filters for each report type

Dashboard

Have key metrics at hand, placing widgets with the most significant stats in the reports dashboard. 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:

  • Select the most important report parameters that will be displayed on the top bar. Press the Settings icon to see a popup dropdown with all the available parameters. Choose the parameters you want to be displayed right from the dashboard start.
  • Press Details to see more specific data for each particular parameter.
  • Check Today & Live block on the dashboard to see what is going on in your store right now.

  • Specify the time interval for a Sales overview graph. Select a particular month and year from dropdowns, pick a day from the grid and the data will be updated automatically. Otherwise, input a date manually in the From and To fields and press Enter.
  • Use slider to have more detailed view on particular data.

You can easily save any of your charts as images in PNG, JPG, SVG and PDF format. Also, you can print it if needed.
  • Set the time period for a Conversion funnel and a Conversion Rate.

  • See the Bestsellers list.

  • View Last order's details on a grid.

Configuration

To choose order statuses you want to be used in all Sales Reports, please, go to Amasty → Advanced Reports → Configuration.

Product Attribute used in Brands Report - choose an attribute to be used as Brand in Brands Report.

From the left navigation menu you can switch between different stats. Let's check them.

Sales and Orders

Overview

Select the time interval to view reports data.

The module displays information for the last 7 days by default.

Choose the step interval for data generation (day, week, month). Choose the way of visualization of the report: line chart or bar graph.

Columns. Manage columns for the report grid. Choose which of them should be shown in the report.

See the total value of each column in a percentage or numeric format. Export the necessary information to a CSV or XML file.

Sales Comparison

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

Get a full list of orders during a specified period. The extension updates order statuses in real-time so you’ll see your revenue accurately calculated. Filter stats data by the number of sold products or by the total sum paid by customers within a specific time period (Quantity/Total). You can also filter the orders By Status. Choose the way of visualization of the report: line chart or bar graph.

Configure Order Items Report

View the report By Order Items, to see the orders split per separate products.

Sales By

Check Sales by Hour/ Week Reports

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.

Configure Sales by Country Report

Easily study your customers' geolocation and get access to the sales data by countries.

The report shows stats data based either on the number of sold products (Quantity) or on the Total sum paid by customers within a specific time period. Use a map for better info perception.

Generate Sales by State Report

View Country-State report to analyze sales data per state.

Configure Payment Type Report

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)

Fine tune Customer Groups Report

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:

Generate Sales by Coupons Report

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)

Configure Sales by Category Report

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)

Choose the way of visualization of the report: pie chart or bar graph.

Configure Sales by Cart Price Rules report

In this tab, you can check your cart price rules' effectiveness.

Catalog

Configure Product Report

Set the necessary time period to get a detailed product sales report. The report includes:

  • Product SKU
  • Product Name
  • Product Quantity
  • Quantity Sold (is calculated as “qty sold = qty ordered - qty cancelled - qty refunded”)
  • Quantity Ordered
  • Quantity Cancelled
  • Quantity Refunded
  • Product Total
  • Brand

You can filter By Product stats data by customer group, SKU or a product name.

When closing order with a bundle product, the “bundle” value won't be marked in the Quantity Cancelled column.
In this section, you may also generate custom rule-based product reports. Please, refer to 'Custom Reports' section to know more.

Generate Reports Based on Product Attributes

The report allows you to learn which product configurations generate more conversions. Set the time period and select the necessary product attribute or attribute set in a dropdown to get detailed stats data.

You can also choose to show reports based on product attribute set.

In the Discounts column only the discounts from cart price rules are counted.

You may use default attributes for your report or create custom ones.

To create a new attribute, please go to Stores → Product → Add New Attribute.

To create a new attribute set, please go to Stores → Attribute Set → Add Attribute Set.

Check Reports Based on Brands

The extension also allows seeing the statistics based on brands. This feature will be useful for the owner of a multi-brand store.

Configure Bestsellers Report

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:

  • Product SKU
  • Product Name
  • Product Quantity
  • Product Total

You can filter Bestsellers stats data by SKU or a product name.

Customers

Configure Customer Report

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:

  • New Accounts;
  • Orders;
  • Reviews.

Check New vs. Returning Customers Report

Easily study your audience to analyze your sales strategy. See the results for New and Returning Customers.

Generate Abandoned Carts Report

Use this report to identify customers who left your website without checking out. Easily view the cart abandonment rate over time. Track the data by customer’s name email address, the number of products in the cart, subtotal, the date, etc.

Add Request A Quote extension to check the abandoned products and instantly offer better deals to your customers right from Abandoned Carts Report page

Track Conversion Rate

The extension includes a new report option which lets you check the conversion rate of the store, or, in other words, the percentage of customers who find the store suitable enough to place the order. Break the data by custom sales ranges for more details.

Custom Reports

Advanced Reports Rules (for Custom Reports)

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 or Reports → Advanced Reports → Custom Reports → New Rule.

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 'By Product' report in the Display dropdown:

You can also create new rules by simply clicking the + New Rule button on the 'By Product' report panel.

Refresh Statistics

To refresh the statistics, go to Reports → 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.

Find out how to install the Advanced Reports extension for Magento 2 via Composer.

Rate the user guide
 stars  from 4 votes (Details)
magento_2/advanced_reports.txt · Last modified: 2019/10/14 11:57 by semenova