The GetCourse platform collects statistics on sales results.
Analysis of sales statistics allows us to evaluate work efficiency, identify the strengths and weaknesses of marketing activities, determine the direction of further development.
The data necessary for the analysis can be obtained in the «Sales» — «Statistics» section.
For convenience, the data are presented in three types of reports, each of which is used depending on the objectives of the analysis:
- The order creation date and order payment date are two different parameters. All reports are built on the payment date of the order by default .
- Orders with the «False» status are not taken into account in statistics.
- It is not recommended to remove products — this affects the correctness of statistical data (the product can be transferred to the «Not active» status).
1. «TABLE» TAB
On the «Table» tab you can see data for certain periods in the context of orders and payments. Such a report will help to analyze the volume of sales, determine the conversion of requests into orders, get the value of the average receipt, and also see the dynamics of these indicators.
The table shows the following parameters:
Orders created — all orders are taken into account in all statuses, except for the «False» status;
Orders paid — fully paid orders are considered that are not in the «False» status;
Users paid — the number of users who have a fully paid for an order;
Partially paid orders — the number of orders with partial payment;
Total payments — how much money is received after deduction of fees of payment systems (if any);
Tax total — tax is taken from the amount after deduction of the fees of the payment system;
Sum of the commissions — the amount of commissions paid to partners, managers;
Prepayment sum — the amount of payments in partially paid orders;
Average check — the amount of payments divided by the number of paid orders;
Money earned — the amount received after deducting fees of payment systems, commissions paid to partners and managers, taxes.
If the company consists of several units (branches), then you can view both the general data and the data of each of the units individually.
Units are displayed if they are specified during product setup:
2. «GRAPH» TAB
This report allows you to select a segment for analysis using the necessary conditions:
With regular sales analysis, it’s convenient to use preset segments. To do this, in the «Orders» section, you must create and save a segment with the necessary conditions.
After saving, it will be available in the report. In the future, you can immediately use preset segments.
The results are presented similarly to the previous report — in the form of a table.
In addition to the table, the results are displayed in a graph. On the graph, you can display/hide the necessary indicators. The graph timeline is divided into weeks.
3. «CUMULATIVE» TAB
This report is generated based on sales statistics for months and for all time.
There are two forms of displaying statistical data: «Cumulative» and «In dynamics».
The following indicators are available for analysis:
Base — the number of active users in the account;
Turnover — the amount of fully paid orders;
Products selling now — the number of relevant products in the project;
Gain / base — an indicator that determines the average profit from one client (Turnover / Base);
Customers — the number of users who paid for the order at the moment in question;
LTV — life time value — the ratio of the turnover for the period to the number of customers for this period;
Payments — the number of fully paid orders for the period;
Average check — the ratio of turnover for the period to the number of paid orders for this period;
First orders — the number of first fully paid orders (first, so the user previously had no other paid orders);
Repeat orders — the number of repeated fully paid orders (previously there were other paid orders for this user).
«In dynamics» — displays data for each period separately. Absolute values of indicators are calculated without taking into account the previous period.
The LTV indicator in this report form is not relevant, since it is used for forecasting and calculated over a long period (the larger the period, the more accurate the forecast can be considered).
Using this report, a control analysis of sales is carried out (the current period is compared with the previous ones). The dynamics of such important indicators as the average receipt, the number of first and repeated orders is reflected.
The number of first and repeated orders will help to better understand the sales structure, identify weaknesses (for example, if there are fewer repeat sales than the first, this may mean that customers were somewhat disappointed — this may be a signal to correct the situation and, in the end, become growth point).