Stack HommeSTACK HOMMEPOWER BI & DATA ANALYTICS CONSULTANCY

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.

Shopify ecommerce5 report pagesJan 2024 – Jul 2026560 customers

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.

ECEcommerce StoreSHOPIFY STORE ANALYTICS
1 Jan 2024 – 31 Jul 2026 · 900 orders · 1,690 line items
Ecommerce Store · Store PerformancePAGE 01 / 05
Ecommerce Store — Store PerformanceEcommerce Store — Sales & ProductsEcommerce Store — CustomersEcommerce Store — Channels & MarketingEcommerce Store — Fulfilment

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

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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.

Book a free consultation