See average order value data at your store.
This report shows the average order value of the cart, gross sales, net sales, number of items sold, and number of transactions by budtender. In addition, if the fulfillment model is selected, data shows the budtender responsible for adding the item to the cart. Data includes in-store, curbside, and delivery orders.
Important: The AOV report does not include returns, voids, and revenue fees.
Table of contents
Getting started
Access
To access this report:
- Go to the Reports module in the Backoffice.
- Click Sales and search Average Order Value in the search bar.
- Click on click on the report name to bring up the report page.
Default dates and search criteria
This report is run for the location you are logged in on, with default search dates starting 7 days from the current date using your local timezone. All Sales Reports use order date as the search criteria, and each record pulled is related to close or completed orders.
Using the Average Order Value report
This report is used to help you understand the average order value of each cart for your budtenders. Through this report you can get insight into:
- Which budtenders have the highest cart values, on average?
- How many items did each budtender sell?
- For the fulfillment model, how many items did each budtender add to carts?
- How many transactions did each budtender fulfill or complete?
- What are your gross and net sales by budtender?
Column configuration
Columns in this report can be rearranged or removed to give you a better snapshot at the exact data you want to see. After running the report, if there are columns you wish to configure, click the Settings gear on the right hand side of the report table to unselect a column and drag and drop the column order.
Descriptions and calculations
The table below provides a description of each of the columns in this report and whether this field is calculated or is base data. Calculated data type describes columns that are made up of multiple points of data being combined such as Net Sales, Gross Sales, or Total Inventory Sold. A Base data type describes data derived from a single point of interest such as a Package ID, Category, or Location Name.
Tip
AOV report is best used to track budtender performance, therefore, calculations in this report do not subtract returns from Net Sales or returned items from Total Inventory Sold.
| Column field title | Data type | Description |
| Budtender Name | Base data | Name of the person completing the sale. |
| Total Orders | Calculation | The total number of Orders that are successfully completed and closed out in the given time range. |
| Total Inventory Sold | Calculation |
Total units of inventory sold. Weight-based items are counted as one item regardless of weight. Inventory types are either Quantity, Weight or Volume. Each type will have an associated default unit. Note: The AOV report does not subtract returned items. |
| Gross AOV | Calculation | Gross average order value. Calculated by dividing Gross Sales by the # of Total Orders completed during the selected time range. |
| Net AOV | Calculation | Net average order value. Calculated by dividing Net Sales by the # of Total Orders completed during the selected time range. The AOV Report does not subtract returns in the Net Sales calculation. |
| Net AOV with Tax | Calculation | Net average order value including taxes paid by the consumer. Calculated by dividing the sum of Net Sales + Taxes amount by the # of Total Orders placed during the selected time range. The AOV Report does not subtract returns in the Net Sales calculation. |
| Gross Sales | Calculation | Gross Sales is the Price * Quantity sold for every item that was sold in the selected time range. |
| Net Sales | Calculation |
Grosssales minus discounts, returns, and loyalty applied as discounts. Note: The AOV report does NOT subtract returns from Gross Sales |
| Net Sales with Tax | Calculation | Net sales with taxes included. |