Neto Sales Dashboard

Release Information

• Version: 1.0.0
• Release Date: 9th April 2020
• Release Status: Beta Testing
• Product page

Prerequisite Software & Configuration

• You must be the administrator of a Neto eCommerce store to analyse.
• Microsoft Power BI must be installed for you to use this dashboard.
• The Sales Dashboard must be configured with data from your Neto store using your Neto API key and the Neto Connector (done by Gapwise).

Prerequisite Knowledge

• An understanding of sales and eCommerce concepts is required to use this product.

Welcome Tab

To jump to a section, click on the big square navigation buttons. You can also navigate by clicking on the tabs at the bottom of the Power BI window.

Sales Comparisons

This section lets you compare recent sales against earlier sales to see how you are performing. The chart on the left shows you how the cumulative sales in the current month to date compare with the cumulative sales of the previous month. The chart on the right shows you how cumulative sales for this year to date compare with the cumulative sales from the previous year.

For instance, if it is April 2020, the chart on the left will plot the sales from the start of April until now as ‘This Month’, and the sales from the start to the end of March as ‘Last Month’. The chart on the right will plot the sales from January until April 2020 as ‘YTD’, and the sales from January to December 2019 as ‘Last Year’.

Click on ‘Show Revenue’ to compare based on sales revenue, and click on ‘Show Profit’ to compare based on gross sales profit (only visible if you have entered your cost prices in Neto). You can also filter which sales channels are included by ticking or un-ticking the options under ‘Sales Channel’.

Sales Summary

This section shows you the sales breakdown by sales channel, and the breakdown by product category. You can click on ‘Show Revenue’ to plot sales revenue, or ‘Show Profit’ to plot the gross sales profit. You can also adjust the range of dates included in the statistics by clicking inside the blue bar under ‘Select Time Range’, or by dragging the ends of the blue box left or right. Clicking on Y / Q / M will toggle Year, Quarter, or Month view on the timeline.

Note that the charts are interactive, you if you click on one of the purple bars, it will highlight the data related to your selection in the other chart.

Product Search

This section lets you view details on the sales of each individual product type in your store. The search boxes in the top left let you search by product category or product name. Note that you can enter more than one keyword in each search box, and you can click on the little AND / OR button to the right of the boxes to either return matches for all search keywords (AND), or return matches for any search keywords (OR).

The timeline to the top right lets you filter which dates you are looking at. You can adjust the range of dates included in the statistics by clicking inside the clue bar under ‘Select Time Range’, or by dragging the ends of the blue box left or right. Clicking on Y / Q / M / W will toggle Year, Quarter, Month or Week view on the timeline.

In the bottom left, you can see a list of products which match your search keywords and date range, ordered by the sales volume. If you click on the sales volume, you can see the details for just that one product. You can also use CTRL to select multiple products.

In the bottom right, you can see the following:

• Total gross profit for the selected product(s) over the course of the selected time frame.
• Total revenue for the selected product(s) over the course of the selected time frame.
• The profit margin for the selected product(s), which is calculated from the difference between the cost price and the unit price.
• The profit growth, which is calculated by comparing the total gross profit made during the selected time period with the total gross profit made during the same amount of time prior to the selected time period.

For instance, the selected time period is Q4 2019 (October to December), and the selected product is Mens yellow Billabong t-shirt (S). The Profit Growth will display the change in profit for Mens yellow Billabong t-shirt (S) compared to the profit made in the previous Q3 2019 period (July to September).

• The revenue over time shows fluctuations in revenue coming in for the selected product(s) over time.

Abandoned Carts

This shows you Neto shopping carts which were abandoned by users before they finalised their purchases. The date range at the top left lets you choose which dates to show carts for. You can also adjust the dates by clicking inside the blue bar under ‘Select Time Range’, or by dragging the ends of the blue box left or right. Clicking on M / W / D will toggle Month, Week, or Day view on the timeline.

At the top-right, you can see the percentage of shopping carts which didn’t lead to an order being placed, and the amount of potential revenue lost as a result. At the bottom left you see a chart of the number of carts abandoned over time. In the centre bottom, you see a list of the top products contained in the abandoned carts, and the amount of potential revenue lost for each product. You can click on the purple bars to filter the other charts.

At the bottom right, you see a list of individual abandoned carts related to the selected product(s) and date range, and the total price of each cart. If you click on the link under ‘View Cart’, this will take you to view the actual cart contents in your Neto web store, just as if you were the customer. Please note that if you click on ‘View Cart’ more than once, it doesn’t automatically clear the old items from the shopping cart, but combines them. So you must be careful to manually delete the items from the cart after you are finished, or else clear your browser cache.

Support

Please send questions or bugs to [email protected]