IMG Sports Technology Group
ShopDesq Analytics Dashboard Guide
Table of Contents
1. YoY Trend ... 3
1.1 Order Trend Since 2010... 3
1.1.1 Order Value Trend ... 4
1.1.2 Volume Comparison ... 4
1.1.3 Average Value Comparison ... 4
1.1.4 Order Trend – Volume and Average Value... 5
1.1.5 Unique Purchases Trend – Volume and Average Value ... 5
1.2 Top 10 Promotions in Last 3 Years ... 5
1.2.1 Order Value ... 5
1.2.2 Order Volume ... 6
1.2.3 Average Order Value ... 6
2. Monthly Overview ... 6
2.1 Order Trend In The Last Month ... 6
2.1.1 Order Value ... 7
2.1.2 Order Volume ... 7
2.2 Top 10 Selling Categories ... 7
2.2.1 Category Value ... 7
2.2.2 Category Volume ... 8
2.3 Top 10 Selling Products ... 8
2.3.1 Product Value ... 8
2.3.2 Product Volume ... 9
3. Operational Dashboard ... 9
3.1 Order Summary in Last 7 Days ... 9
3.2 Order Listing By Status In Last 7 Days ... 10
3.3 Orders By Day of Week ... 10
3.3.1 Order Value ... 10
3.3.2 Order Volume ... 10
3.4 Weekly Density Analysis ... 11
3.4.1 Order Value ... 11
1.
YOY TREND
This dashboard summaries the order trend since 2010 to present on annual basis.
1.1
ORDER TREND SINCE 2010
This report compares the orders and value since 2010 to current year, including 5 charts listed below:
- Order Value Trend
- Volume Comparison
- Average Value Comparison
- Order Trend – Volume and Average Value
- Unique Purchases Trend – Volume and Average Value
Filters
No user prompt filters available Drill functionality
Drill down functionality is provided across all charts in this report. It allows users to drill the data from year to month to date.
1.1.1 ORDER VALUE TREND
A line chart shows the base value and total order value trend since 2010. The gaps between 2 lines represent the amount of GST and postage.
1.1.2 VOLUME COMPARISON
Compares the volume between orders and unique sold items by year.
1.1.3 AVERAGE VALUE COMPARISON
Compares the average order value with average unique item value by year.
- Average order value represents the average value per order.
1.1.4 ORDER TREND – VOLUME AND AVERAGE VALUE
Shows the relationship between order volume and average order value.
1.1.5 UNIQUE PURCHASES TREND – VOLUME AND AVERAGE VALUE Shows the relationship between item volume and average item value.
1.2
TOP 10 PROMOTIONS IN LAST 3 YEARS
This report lists the top 10 promotions in last 3 years by revenue, including 3 charts listed below:
- Order Value
- Order Volume
- Average Order Value
Filters
Promotion Start Date
Drill functionality Not Available 1.2.1 ORDER VALUE
1.2.2 ORDER VOLUME
Lists order volume of top 10 promotions
1.2.3 AVERAGE ORDER VALUE
List average order value of top 10 promotions
2.
MONTHLY OVERVIEW
This dashboard provides a snapshot of key data for order in the last month, including order trend analysis, top 10 selling categories, and top 10 selling products.
2.1
ORDER TREND IN THE LAST MONTH
This report shows the order trend by volume and value in the last month. Filters
Order Date
Drill functionality None
2.1.1 ORDER VALUE
Compares the daily order vlaue in the last month.
2.1.2 ORDER VOLUME
Compares the daily order volume in the last month.
*Swith between chart and table by clicking on the top right corner, which allows users to
export the order list.
2.2
TOP 10 SELLING CATEGORIES
Lists top 10 selling categories based on sales revenue for the last month. The report is presented both by category value and category volume. Filters
No user prompt filters available Drill functionality
None
2.2.1 CATEGORY VALUE
2.2.2 CATEGORY VOLUME
Lists the sales volume against top 10 selling categories.
2.3
TOP 10 SELLING PRODUCTS
Lists top 10 selling products based on sales revenue for the last month. The report is presented both by product value and product volume. Filters
No user prompt filters available Drill functionality
None
2.3.1 PRODUCT VALUE
2.3.2 PRODUCT VOLUME
Lists the sales volume against top 10 selling products.
3.
OPERATIONAL DASHBOARD
This dashboard aims to provide more granular data analysis for order in the last week, including order summary, order listing, day of week analysis, and weekly density analysis.
3.1
ORDER SUMMARY IN LAST 7 DAYS
Summarises the key order data in the last 7 days, including order volume, order status distribution, order value, and average order value.
Filters
No user prompt filters available Drill functionality
3.2
ORDER LISTING BY STATUS IN LAST 7 DAYS
Provides an operational list of orders by order status in the last 7 days. Filters
No user prompt filters available Drill functionality
None
3.3
ORDERS BY DAY OF WEEK
Compares the order value and volume between each day of week in the last 7 days. Filters
No user prompt filters available Drill functionality
None
3.3.1 ORDER VALUE
Shows the order value by day of week.
3.3.2 ORDER VOLUME
3.4
WEEKLY DENSITY ANALYSIS
Shows the density of orders value and order volume on weekly basis. Filters
No user prompt filters available Drill functionality
None
3.4.1 ORDER VALUE
3.4.2 ORDER VOLUME
