...
width | 50% |
---|
Table of Contents
Warning |
---|
Firefox user notice: Please use another web browser to view this document. Sorry for the inconvenience. |
...
width | 30% |
---|
...
Magento 2 Advanced Reports provides a comprehensive overview of a web store performance. The data reported comes via 10 report widgets and 12 reports made against a variety of metrics. The data reported can be compared/contrasted by various time periods, furthermore it can be sorted by specific customer segments. Each report reflects a specific aspect of performance of the store at a varying level of elaboration. The reports can be viewed and emailed, due mailing schedule arranged.
Compatibility: Magento Open Source 2.3.X -2.4.X, Magento Commerce 2.3.X -2.4.X
Thank you for choosing Aheadworks!
Installing Advanced Reports
...
Panel | ||||
---|---|---|---|---|
| ||||
1. Backup your web directory and store database |
Panel | ||||
---|---|---|---|---|
| ||||
2. Download the Advanced Reports installation package |
Panel | ||||
---|---|---|---|---|
| ||||
3. Upload contents of the Advanced Reports installation package to your store root directory |
...
borderWidth | 2px |
---|---|
borderStyle | solid |
4. In SSH console of your server navigate to your store root folder:
No Format |
---|
cd path_to_the_store_root_folder |
run the following command: :
No Format |
---|
php -f bin/magento module:enable Aheadworks_AdvancedReports |
then:
No Format |
---|
php -f bin/magento setup:upgrade |
after:
No Format |
---|
php -f bin/magento setup:static-content:deploy |
Panel | ||||
---|---|---|---|---|
| ||||
5. Flush store cache; log out from the backend and log in again |
Note |
---|
Make sure the installation is done from the FTP Administrator account. Otherwise, set 775 permissions to the store root directory after the extension is deployed. |
...
width | 50% |
---|
...
borderWidth | 2px |
---|---|
borderStyle | solid |
If you are installing an extension from Aheadworks for the first time, you need to add our composer repository to your Magento store:
Panel | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
1. Login to your ssh console and navigate to your store folder:
Run the following command:
On successful execution of the command you will be able to use the composer to install the extensions. |
...
borderWidth | 2px |
---|---|
borderStyle | solid |
To install the extension:
2. Login to your ssh console and navigate to your store folder:
Panel | ||||
---|---|---|---|---|
| ||||
cd path_to_the_store_root_folder |
...
borderWidth | 2px |
---|---|
borderStyle | solid |
3. Run the following command to install the latest version of the extension:
Panel | ||||
---|---|---|---|---|
| ||||
composer require aheadworks/module-advanced-reports |
if you need to install a specific version, run this command:
Panel | ||||
---|---|---|---|---|
| ||||
composer require aheadworks/module-advanced-reports:<version> |
Tip |
---|
Specify the version of the extension in <version> |
Panel | ||||
---|---|---|---|---|
| ||||
When prompted, enter Public Key (Username) and Private Key (Password): |
Note |
---|
Both Public Key (Username) and Private Key (Password) can be found in My Projects and Licenses in your personal account on our site: |
Panel | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||
4. Enable the extension:
Next, register the extension:
Recompile your Magento store if you are in the Production mode:
To verify that the extension is enabled, run this command:
Clean store cache, by running the following command:
Log out and Log in the backend again. |
...
borderWidth | 2px |
---|---|
borderStyle | solid |
To upgrade the extension:
5. To update or upgrade an extension:
Download the updated extension file. Take note of the module-name and version. Export the contents to your Magento root.
If a composer package exists for the extension, run one of the following.
Code Block | ||
---|---|---|
| ||
composer update aheadworks/module-advanced-reports |
Code Block | ||
---|---|---|
| ||
composer require aheadworks/module-advanced-reports:<version> |
Run the following commands to upgrade, deploy, and clean the cache.
Panel | ||||
---|---|---|---|---|
| ||||
php bin/magento setup:upgrade --keep-generated
php bin/magento setup:static-content:deploy
php bin/magento cache:clean |
Updating to a New Version
...
width | 50% |
---|
On updating to a newer version, reindex the Advanced Reports extension via the console. To do this, follow the steps below:
Panel | ||||
---|---|---|---|---|
| ||||
Reindexing will start. Note, that the command above doesn't reindex the whole store, but the reports tables only. |
Note |
---|
With the release of the version 2.7.0, the database is not blocked (as it was in the previous versions) when reindexing is run. |
Set up cron
...
width | 50% |
---|
Skip this step if you have already configured cron or if you are familiar with the job. Otherwise, read the following instructions on setting cron job on your Magento store: Magento user guide.
Generally, it is enough to run the following command in the SSH console:
Code Block | ||
---|---|---|
| ||
crontab -e |
And insert the following lines:
Code Block |
---|
*/3 * * * * php -c <ini-file-path> <your Magento install dir>/bin/magento cron:run
*/3 * * * * php -c <ini-file-path> <your Magento install dir>/update/cron.php
*/3 * * * * php -c <ini-file-path> <your Magento install dir>/bin/magento setup:cron:run |
Confirm the Save request before exit.
Introducing Advanced Reports
Section |
---|
Available ReportsTo help reflect on the performance of a store Magento 2 Advanced Reports suggests 12 reports, 4 general and 8 detailed. General Reports
Detailed Reports
Key-FeaturesAdvanced Reports is totally a backend module. The module facilitates store admins with comprehensive statistics on various aspects of their store performance. Each aspect is reflected upon in a report. The reports are accessible from either the menu or dashboard. The dashboard furthermore allows for comparison and contrast of data with regard to the given time period. The period is set with the help of the advanced calendar. The extension allows configuring reports both in bulk and individually. Configuration includes settings for scheduled emailing of reports or their parts. Emailing could be done to multiple addresses. What's New?The present version of the extension (2.8.0) extends the number of performance indices within the Sales Detailed report to 45, including those of shipping and billing. Furthermore, the calendar now features the Latest Quarter parameter. On top of everything, scheduled emailing was added as a key-feature. |
Using Advanced Reports
...
Report Dashboard
Dashboard Layout
The dashboard shows 10 configurable widgets to reflect on the overall performance of the store.
The widgets come as 8 numeric and 2 chart ones. Each widget has the following elements:
- Name - performance indicator (clickable);
- Total (in bold) - the total $, # or % of the index as of the current period (see below for details);
- Total (faded out) - the total of the index as of the previous period (see below for details);
- Increment (green) - the ratio between the two totals / decrement (red);
- View Report - an active link to the full report.
Tip |
---|
The increment comes in % by default. Hover the mouse cursor over the increment to see absolute values. |
In addition to the above, the chart widgets will show relevant trends (for example, conversion rate by time period) and legends telling the time periods in comparison. Hovering the cursor over the trend milestones will show a popup telling the value of the X time-line in that point of time (day, month or other augment).
Finally, the dashboard has a set of filters (see top of the page). You can track the performance of a selected customer group and/or store view.
Changing widget content
The module enables changing the content of the widgets. To do so, click on the name of the widget. A folding list will appear showing three categories of indices available for display. The indices and categories are as follows in the table below.
...
...
...
On choice of an index the widget will update its data.
The content of the widgets is saved automatically, so you will not need to configure the widgets every time you enter the dashboard page.
Tip |
---|
You can save several dashboard views as bookmarks and later switch between them with the help of the View block in the top right. |
Setting Comparison Period
The dashboard presents data in comparison and contrast. To set the periods for statistical comparison refer to the Comparison Period Block in the top right.
The block comes as a dropbox with the following options:
- Today
- Yesterday
- Week to Date
- Last 7 Days
- Last Week (Sun - Sat)
- Last Business Week (Mon - Fri)
- Month to Date
- Last Month
- Last Quarter.
On choice of the current period the period for comparison will be set automatically one step back. For example, Today will be compared to Yesterday, Yesterday to the day before, and so on.
Advanced Reports also allows for setting custom periods for comparison. This feature is only available in the Calendar, which in turn is only available on the pages of the reports, not on the Dashboard page.
The Calendar features an additional option the list of options for comparison above - "Custom Date Range". On enabling this option, either type-in the dates in the date fields, or select the dates on the calendar tables to the left. To set a custom comparison period, activate the checkbox next to the "Compare to" feature and select 'Custom' in the drop list. The date range fields will then become active. Type-in the dates in the comparison date fields, or select the dates on the calendar tables to the left.
The choice of the time period will be saved automatically on page reload or when surfing to another page.
Performance Reports
Report Layout
To get access to the reports go to Reports > Advanced Reports by Aheadworks. Alternatively, should you find yourself on the Dashboard page click the View Report active link on the widget (see Dashboard Layout above). Finally, you may employ the Navigation menu.
Generally, each report page has the following elements:
- Navigation menu – used for quick navigation within the extension. With the help of the navigation menu, you can switch to the required report.
- Calendar – used to set the period for reporting. It comes with the same predefined reporting periods as the report dashboard. Setting custom comparison periods is also possible.
- Report intervals – used to quickly group the data reported by the one of the four periods: day, week, month, quarter and year;
Tip |
---|
You can generate a report from a whole month's data (1st to 31st) and then group it by day (31 entry – day-by-day sales), week (5 entries – week total sales), or month (1 entry – month sales total). |
- Report chart – used to present sales data in a visual form;
- Chart parameters - these represent the legend for the visualization;
- Dual Y-axis - two-axis charts present data against the two prearranged key-indices, thereby they are twice more informative;
- Totals block - represents the totals for quick examination;
- Report grid – represents the data built against the period defined in the calendar;
- Filters and report grid adjustments - represent a set of filters, including Customer Group, Segment, Store View, as well as some other tools for filtering and arranging reports.
For more convenience, the generated reports can be later exported to *.csv or *.xml tables with the help of the 'Export' button above the report grid.
Generating a Report
The extension comes with 12 reports each covering a specific aspect of performance of the store. To generate a report, take the following steps:
Step 1 - Select the required report from the list (go to Reports > Advanced Reports by Aheadworks).
Step 2 - Use the calendar to select the required report date range and click the 'Apply' button.
Step 3 - The report is generated. Now, you can adjust the period for reporting and data grouping to get the required presentation. Adjust filters if necessary.
Step 4 - Once the required filters are selected, save the current view by expanding the 'Default View' box and clicking Save view as.
The saved view will be available on all Advanced Reports pages. It can be recalled anytime you make changes to the filters or the report grid.
Report Drill-down
All reports are interconnected. It means that you can consecutively get a deeper picture of the report subject matter.
Taking the 'Sales Overview' report as a starting point, you can navigate to a 'Product Performance' report by clicking on an entry in the report grid. Next, clicking on the entry in the 'Product Performance' report will take you to an 'Individual Product Performance' report page.
You can use the breadcrumb trail above each report chart to navigate the sequence of reports.
The available drill-down scenarios are as follows:
- 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.
Configuring Reports
To configure the report, click on the Report Settings option in the Grid Management Bar.
A popover will appear, suggesting two blocks for customization: Order Statuses and Report Configuration.
The former comes as a list of order statuses available for selection. Only orders of selected herein statuses will be the sources of data for the given report. By default the list is disabled, the values set for all reports on the Extension Settings page are used. Disable the checkbox next to the 'Use Default Value' to customize the list of statuses.
The Report Configuration block allows for columns customization. You can substitute the default names of the report columns with your text, and also to decide whether data in these columns are to be exported to emails (see the checkbox next to the column name).
Info |
---|
The Customer Sales and Sales Detailed reports will also feature the Include Refunded Items toggle. This option is meaningful only for these two reports, and thereby is not available for other. |
Extension Settings
Section | ||
---|---|---|
The general settings of the extension can be accessed from Stores > Configuration > AHEADWORKS EXTENSIONS > Advanced Reports. The Settings page comes in two blocks: General Settings and Scheduled Email Reports. General SettingsThe General Settings block allows tweaking Order Statuses, Ranges, and Manufacturer Attribute.
If required, you can select multiple order statuses using either of the two hot-keys: + (press Shift, hold Right Button, select) to select a group of orders or + (press CTR, click right button) to select order statuses one by one. Specifying order statuses herein will extend the selection over all the reports. See Configuring Reports above for individual configuration of reports.
Once done, click Save Config in the top right of the page, or proceed to the next step. Scheduled EmailingAs of version 2.8.0 Advanced Reports allows scheduling emails containing reports. It is possible to send full reports or parts of thereof. Furthermore, the extension supports multi-address mailing. The Scheduled Email Reports block of the Settings page contains the following configuration options:
Once done, click Save Config in the top right of the page. |
Report Indexes
...
Starting from version 2.0.0, the extension introduces report indexes which facilitate faster data load, a period for reporting specified.
Report indexing eliminates the need for report generation on demand. Basically, the reports are generated once a day (or more frequently depending on the cron settings). Post-generated results are loaded when you open a report.
Report indexing is particularly useful for busy stores processing large numbers of orders. For example, it should not take more than a couple of minutes to reindex ~200k orders on a decent server hardware. Considerable lags on reports generation may occur otherwise.
How to index reports?
As it was mentioned above, the reports are indexed automatically depending on your store cron setup. By default, cron runs once a day, meaning that the data reported will always be up-to-date.
You can always run reindexing manually, however, it involves console usage. Follow the link to learn more on manual reindexing.
Once reindexing is done, the reports will feature latest data.
Will the Advanced Reports extension process those orders which were placed before the installation?
Yes, the Advanced Reports extension will index ALL orders which have been placed in the store.
Note |
---|
With the release of version 2.7.0, the database is not blocked (as it used to be in the previous versions) when reindexation of the module is run. |
Troubleshooting
...
I have deleted the product. Will it impact the reports?
If the product was deleted, the 'Product Performance' report will erase the SKUs of the product from the order table. It means that configurable products and products with custom options will have their SKUs marked as 'product was deleted'. The deleted products will not impact the report performance or the data generated.
I can't see the attribute in the 'Sales by Attributes' report!
Make sure you have enabled the 'Use for Promo Rule Conditions' option for the attribute you cannot find in the report. If required, refresh cache and reload the page.
Why can I not see some configurable and bundle products in the 'Sales by Attributes' report?
It depends on whether you have set a dynamic or fixed price for the corresponding configurable and/or bundle products.
- If you have set dynamic prices - only child products will be considered while building the report;
- If you have set fixed prices - both parent and child products will be considered while building the report.
How are profit values calculated in the 'Product Performance' report?
Total revenue, cost, profit, and margin are calculated in accordance to the following formulae:
Total Revenue (excl. Tax)
No Format |
---|
Total Revenue (excl. Tax) = sum for each item (Item final price * Qty sold - Taxes - Total discount) |
Total Cost
No Format |
---|
Taken from the order, not from the current product attribute value |
Total Profit
No Format |
---|
Total Profit = Total Revenue (excl. Tax) - Total Cost |
Total Margin
No Format |
---|
Total Margin = (Total Profit / Total Revenue (excl. Tax)) * 100 |
Uninstalling Advanced Reports
...
width | 50% |
---|
Manual Removal
...
1. Disable the module by executing the following commands:
No Format |
---|
php bin/magento module:disable Aheadworks_AdvancedReports
php bin/magento setup:upgrade |
...
2. Remove the extension files from the following folder:
No Format |
---|
app/code/Aheadworks/AdvancedReports |
...
width | 50% |
---|
Automatic Removal (via Composer)
...
1. Disable the module by executing the following commands:
No Format |
---|
php bin/magento module:uninstall Aheadworks_AdvancedReports |
...
Warning |
---|
For more information follow the product user manual on our website |
Thank you for choosing Aheadworks!
Need Customization?
You can always find the latest version of the software, full documentation, demos, screenshots, and reviews on http://aheadworks.com
License agreement: https://aheadworks.com/end-user-license-agreement
Contact Us: https://aheadworks.com/contact
Copyright © 2021 Aheadworks Co. http://www.aheadworks.com
...