Creating a table of order and profitability of the online store
The work was that the online store was created in Google tables using a number of formulas:
* Accounting of orders
Chronology of order status
* current status according to the carrier's website on orders
* Accounting of expenditure
• Monthly analysis (order / return / turnover / conversion / expenditure)
Efficiency of sales channels
* Summary of monthly work
The daily profitability
* Accounting of orders
Chronology of order status
* current status according to the carrier's website on orders
* Accounting of expenditure
• Monthly analysis (order / return / turnover / conversion / expenditure)
Efficiency of sales channels
* Summary of monthly work
The daily profitability