HOME / WORK / ECOMMERCE STORE
CASE STUDY · ECOMMERCE
Ecommerce Store
SHOPIFY STORE ANALYTICS
Turns a Shopify store's orders, products, customers, marketing and fulfilment data into one report, from revenue by channel to orders still sitting unshipped.
TOTAL REVENUE
$187,296
31 months
ORDERS
900
average order $208.11
CUSTOMERS
560
448 have purchased
ORDER RATING
3.79
315 rated orders
WALK THE REPORT
Five pages, one question each
Each page answers one question the leadership team asks every week. Pick a page to see it full size.





THE QUESTION
How is the store trading, and where does the revenue come from?
$107.4K
through the online store
79.2%
of revenue from the United States
$221.86
average order in Canada, the highest
CONTEXT
Why a Shopify store needs this report
Shopify's own analytics answer the questions Shopify can see. They are good on revenue and orders and weak on everything that sits beside them: product cost, discount load, repeat purchase value, and the orders that have been paid for but not yet shipped.
For a store doing real volume, those are the numbers that decide the month. A 47.7% average margin and a 4.8% discount load tell a different story from gross revenue alone, and $28.5K of unshipped orders is an operations problem before it becomes a refund problem.
How the report is built
Five pages cover store performance, products and margin, customers and loyalty, channels and discounting, and fulfilment — the last of these being the page most storefront dashboards leave out.
Orders, line items, costs, customers and fulfilment events are modeled together, so revenue, margin, lifetime value and shipping performance all come from one source rather than three exports.
WHAT IT BRINGS TOGETHER
- Shopify orders and line items
- Product catalogue, cost and stock
- Customer records and order history
- Traffic source and device
- Discount codes
- Fulfilment, shipping and refunds
WHO IT SUITS
Shopify and other DTC stores past the point where built-in analytics answer the question, especially where cost, discount and fulfilment data matter.
PAGE BY PAGE
What each page of the ecommerce store report answers
PAGE 01
Store Performance
Revenue and orders
How is the store trading, and where does the revenue come from?
- $107.4K through the online store
- 79.2% of revenue from the United States
- $221.86 average order in Canada, the highest
PAGE 02
Sales & Products
Catalogue and margin
Which products sell, and which earn the margin?
- $175,727 product revenue
- 47.7% average margin, Beauty highest at 58.0%
- 12,888 units in stock across 55 SKUs
PAGE 03
Customers
Segments and loyalty
Do customers come back, and what are they worth?
- 59.8% repeat rate
- $418.07 lifetime value per purchasing customer
- 46.5% of revenue from 123 VIP customers
PAGE 04
Channels & Marketing
Traffic and discounts
Which channels bring orders, and what do discounts cost?
- 45.2% of orders placed on mobile
- 45.1% of orders used a discount
- $8,478 given in discounts, 4.8% of gross
PAGE 05
Fulfilment
Delivery and returns
Are orders shipped quickly, and how much comes back?
- 2.9 days on average to fulfil
- 144 orders unfulfilled, $28.5K unshipped
- $27,030 revenue at risk from refunds
What the report surfaced
Figures the ecommerce report puts in front of the leadership team every week.
- $187,296 of revenue across 900 orders over 31 months, at an average order value of $208.11, with 79.2% of revenue from the United States.
- Product revenue of $175,727 runs at a 47.7% average margin, highest in Beauty at 58.0%, across 55 SKUs and 12,888 units in stock.
- 59.8% of customers repeat, lifetime value per purchasing customer is $418.07, and 123 VIP customers generate 46.5% of revenue.
- 45.2% of orders are placed on mobile and 45.1% use a discount, costing $8,478, or 4.8% of gross.
- Orders take 2.9 days on average to fulfil, with 144 unfulfilled worth $28.5K and $27,030 of revenue at risk from refunds.
Want a report like this for your business?
Tell us the decision you need to get right. We'll show you what the data can answer in a free 30-minute call.








