Shopify Analytics

Complete source transcription

PoolBestBuy — Performance Baseline (2023–2025)

Baseline of store performance pulled from Shopify Analytics, to benchmark future improvements against. Currency is THB (store reporting currency). Note: transaction volumes are very low, so treat figures as directional.

Headline finding

This is a conversion problem, not a traffic problem. The store draws ~4,300–5,400 sessions/year but converts only 5–6 orders/year — a conversion rate of roughly 0.1%, far below the typical 1–3% ecommerce benchmark. Getting to just 1% on the same traffic would mean ~50 orders/year instead of 5.

Sales, orders & sessions (full calendar years)

YearOrdersTotal sales (THB)Sessions
2023621,6605,006
202456,4904,331
2025535,8505,421

Note: 2026 year-to-date is 3 orders / ~THB 2,000. Net sales tracked total sales closely (THB 19,383 in 2023, THB 5,841 in 2024, THB 32,589 in 2025); refunds/reversals reduced net in 2023–2024.

Key metrics to benchmark against

  • Conversion rate: ~0.1% (biggest lever — far below the 1–3% norm)
  • Sessions: ~5,000/year (stable — you already have an audience)
  • Orders: ~5/year
  • Average order value: ~THB 3,000–4,000 (already solid; volatile at this volume)
  • Best year on record: 2025 at ~THB 35,850 total sales

Top products (2023–2025 combined)

Revenue is concentrated in a few pool-chemical products:

  • TCCA Granular Chlorine 50kg — ~THB 39,000 (6 units)
  • EM Series Underwater Light — ~THB 13,800 (1 unit; high-ticket outlier)
  • Long Lasting Chlorine — ~THB 5,100 (3 units)

Strategic takeaway

The store doesn’t have a traffic or demand problem right now — it has a “visitors aren’t checking out” problem. Before pouring in effort, confirm why conversion is so low (checkout friction, pricing/shipping, trust signals, or whether some traffic is bot/junk). Chlorine/pool chemicals are the commercial backbone; the big light sale was a one-off.

Source: Shopify Analytics (Total sales over time, Sessions over time, Total sales by product). Pulled 26 Jul 2026.

Items sold — full breakdown (2023–2025)

Units sold and total sales per product. Only items with at least one unit actually sold are listed.

ProductUnits soldTotal sales (THB)
TCCA Granular Chlorine 50kg639,000
EM Series Multi Colors - Underwater Light113,800
Long Lasting Chlorine35,100
Maxi Clear Skimmer Tablet 125g4800
Metal Magnet 1ltr1870
pH Minus1700
SHOCK AND SWIM1650
Eyeball wall return 2” (concrete pool)2640
pH UP 2kg1300
Open original Notion page ↗

Commercial priorities

Planning items from the Power BI report.

01

Launch PoolBestBuy Equipment shop

02

Launch PoolBestBuy Chemicals shop

03

Source new equipment products

04

Refresh chemical labels and sizes

05

Build marketing plan

06

Expand dropship, B2B and bundles