📊 TRR E-Commerce Dashboard

Lin Official · Lin Sweet Creation · Rei Sugar  |  Oct 2025 – Apr 2026
Data as of: Shopee: — | TikTok: — | Lazada: — Scope: Year (May 25 – May 26)
Live API Data — This dashboard pulls from BigQuery (trr-ecommerce-data.marketplace_raw). Last updated: 2026-05-07 09:00 ICT. Source tables: raw_lazada_*, raw_tiktok_*, v_sku_master, v_tiktok_order_fee_detail.
✅ Data verified — Shopee, Lazada & TikTok exports confirmed. Internal transfers & B2B excluded. Real customer sales only. Total portfolio GMV ฿4.29M (all completed orders). The ฿3.99M figure in some references excludes certain MyCloud/B2B adjustments.
Total GMV
—
Total Orders
—
Items Sold
—
Avg Order Value
—
AOV per order
Items per Order
—
Avg basket size
Target Achievement
—

📊 Store Comparison Apr 26

StoreGMVMoM %vs TargetStatus
✅ What's Working
    ⚠️ Watch Out
      🚀 Priority Actions

        📊 Actual vs Target Portfolio · All Months

        Monthly GMV Trend by Shop

        Category Mix share of GMV

        Channel Share by Month 100% stacked

        AOV & Items per Order by Channel grouped

        Channel GMV Trend by Channel

        GMV by Shop total

        Order Count by Month stacked by Shop

        AOV Trend ฿ per order

        🏆 Top 20 Products by GMV

        #ProductCategoryShopGMV ฿GMV %StockOrdersItemsAOV ฿

        🎵 1. Channel Overview Oct 2025 – Apr 2026Is TikTok growing? How does it compare to portfolio?

        First thing you need to know — is TikTok growing? How does it compare to the portfolio?
        TikTok GMV
        —
        Orders
        —
        AOV
        —
        Avg order value
        Rei Sugar Share
        —
        Cancel Rate (Rei)
        —
        % cancelled orders
        Cancel Rate (LSC)
        —
        % cancelled orders
        Channel contribution: TikTok represents ~11.3% of total portfolio GMV (฿478,211 of ฿4.23M). Rei Sugar is the dominant TikTok shop (~82% of TikTok GMV). Lin Official has no TikTok account.

        TikTok Monthly GMV by Shop · Oct 25 – Apr 26

        📊 Traffic Signals May 2026Where do TikTok Shop visitors come from?

        Traffic source, funnel depth, and video efficiency. Funnel data starts May 2, 2026. Traffic source mix is not yet available from the pipeline.
        ⚠ Funnel + product + video data starts May 2, 2026. Traffic source mix relies on an order-level field that the pipeline is not populating — fix pending.

        Traffic Source Mix placeholder · pipeline fix needed

        🚫
        No data available
        Pipeline fix needed — raw_tiktok_orders.traffic_source is 100% NULL across 5,094 rows. Donut chart will render here once the pipeline populates this field.

        Shop Funnel LIVE · May 2–6 2026

        Impressions → Visitors → Page Views → Buyers. Rate = pv_to_order_rate from raw_tiktok_shop_performance — not cross-divided with orders table.

        Top Products by Traffic placeholder · pipeline fix needed

        🚫
        No data available
        Pipeline fix needed — raw_tiktok_product_performance.page_view = 0 across all 530 rows. Product traffic table will render here once the pipeline is fixed.

        Video GPM — Top Creators LIVE · from raw_tiktok_video_performance.gmv

        GPM = GMV ÷ Views × 1,000. Source: raw_tiktok_video_performance.gmv only. Ranked by GPM, minimum ฿1,000 total GMV.
        #CreatorVideosTotal GMV ฿Total ViewsOrdersGPM ฿

        New vs Repeat Buyer SPARSE · Rei Sugar only

        Sparse — only Rei Sugar populated, May 2 onward. Lin Sweet Creation new_buyers/repeat_buyers = NULL in pipeline.

        🏆 2. Shop Performance placeholder · last 30 daysSPS drives ad eligibility & search ranking

        SPS score affects ad eligibility and search ranking on TikTok Shop. Must track daily — drop below 4.0 and ad spend will be restricted automatically.

        Lin Sweet Creation WATCH

        SPS Score
        4.4 / 5
        target ≥ 4.5
        Late Dispatch
        1.8%
        target ≤ 4%
        Cancellation
        7.7%
        target ≤ 3% · Apr 2026 actuals · varies by month

        Rei Sugar WATCH

        SPS Score
        4.3 / 5
        target ≥ 4.5
        Late Dispatch
        3.4%
        target ≤ 4%
        Cancellation
        6.8%
        target ≤ 3% · Apr 2026 actuals · varies by month

        SPS Score Trend placeholder · 30-day rolling

        📦 3. Product Performance Apr 26Different SKUs win on TikTok vs Lazada

        TikTok sales are video/impulse-driven. Different SKUs win vs Lazada — need to know which products are TikTok-native winners to brief creators and prioritise stock.

        Top 10 Products by GMV

        Category Mix placeholder · share of TT GMV

        GMV by Top Products placeholder · horizontal

        📣 4. Ads Performance live · 6 days (May 3–8, 2026)Reach campaign — impressions over conversions

        Updated 2026-05-09 — TikTok ads data corrected (was 13× inflated due to MERGE bug, now fixed). Source: raw_tiktok_ads_performance in BigQuery, post-dedupe (6 rows / 1 campaign / 6 ads). Only 1 campaign has run YTD: a REACH-objective creator-content push for the ชงชง Fest event in Chiang Mai. No ROAS yet — REACH does not track conversions.
        Total Ad Spend
        ฿1,102
        May 3–8 (6 days, 2 active)
        no prior period
        Blended ROAS
        N/A
        REACH campaign — no conv tracking
        switch to PRODUCT_SALES to track
        Total Impressions
        95,225
        CPM ฿11.58 · 0 clicks (REACH)
        Conversions / GMV
        0 / ฿0
        REACH objective — awareness only

        Daily Spend & Impressions live · May 3–8

        Spend by Brand live · 100% Rei

        🏆 Ads by Spend (REACH campaign — ชงชง Fest) live · May 3–8

        #Ad / CreatorBrandSpend ฿ImpressionsCPM ฿ClicksGMV ฿Status
        ⚠️ Updated 2026-05-09 — TikTok ads data corrected (was 13× inflated due to MERGE bug, now fixed). Previous numbers (฿14,077 spend) were a duplicate-row artefact — true spend is ฿1,102. ROAS columns dropped from this view: the only live campaign is REACH-objective and does not record conversions.
        ✅ What's Working
        • Single Rei "ชงชง Fest" reach push delivered 95K impressions on ฿1,102 spend (CPM ฿11.58 — efficient for awareness)
        • 6 creator-led video ads all served — content rights pipeline is functional
        ⚠️ Watch Out
        • Campaign went dark May 5–8 (zero spend) — ฿2,000 budget exhausted in 2 days; Min may want to recheck pacing
        • REACH objective records 0 clicks / 0 GMV by design — no ROAS visibility on this campaign
        • Lin Brand and Lin Sweet have zero ads YTD — no TikTok ads dataset for those shops
        🚀 Priority Actions
        • Launch a PRODUCT_SALES (ROAS-tracked) campaign for Rei syrup before next payday so we have conversion data
        • Brief Lin Sweet creators on TikTok Ads — start a small test budget to fill the data gap
        • Re-run the QA check after one full ROAS cycle (10–14 days post-launch)

        🎬 5. Content & Organic placeholder · last 30 daysReduces ad dependency long-term

        Organic reach reduces ad dependency long-term. Track follower growth and which content drives engagement — high engagement videos can be re-used as paid ad creatives.
        Total Followers
        12,590
        Lin Sweet 11,286 · Rei Sugar 1,304
        +1,790 last 30d
        Organic reach is early stage. Growth strategy active for Q3 2026.
        Total Video Views
        312,400
        last 30 days
        +12.6% MoM
        Avg Engagement
        5.7%
        (likes+comments+shares)/views
        Videos Published
        42
        last 30 days

        Follower Growth — Last 30 Days placeholder

        Top 10 Videos by Views placeholder

        🎬 Video Performance — Top 10 (last 30d) placeholder

        #TitleAccountViewsLikesSharesCommentsEngagement %

        📺 Live Sessions placeholder · last 30d

        Total Lives
        18
        across both shops
        Avg Viewers
        142
        per live session
        Live-Attributed GMV
        ฿38,400
        ~8% of TT GMV
        Best Live
        Rei Lychee · Apr 29
        ฿11,200 GMV in 90min

        Top Creators all-time · by Video GMV

        💰 6. Fee & Settlement placeholder · Apr 26TikTok takes 19–22% — make true take-home visible

        TikTok takes 19–22% of GMV. Sellers often don't know their true take-home. This makes it visible — and shows how much higher TikTok fees are vs Lazada (14.8%) and Shopee (18.2%).
        Gross GMV
        ฿549,283
        Apr 2026 — all platforms
        Total Platform Fees
        ฿104,364
        19.0% of GMV
        Net Settlement
        ฿444,919
        81.0% of GMV
        Effective Fee Rate
        19.0%
        blended TT+Lazada+Shopee
        +0.4pp vs Mar

        Fee Breakdown placeholder · Apr 26

        Effective Fee Rate by Platform placeholder

        🏆 Top 10 Orders by GMV — Fee Breakdown placeholder

        #Order IDPlatformGMV ฿Plat. FeeAff. FeeTrans. FeeShip Sub.Seller Disc.Net ฿Net %

        🎟️ 7. Promotions & Campaign Analysis placeholder · Oct 2025 – Apr 2026 (7 months)Did the discount actually pay off?

        Flash sales and coupons drive spikes but erode margin. This section answers 5 questions: which promos paid off, which promo type wins, when do customers buy, is dependency rising, and how much does TikTok subsidise.
        Active Promotions
        3
        spanning 7 months
        Promo-Attributed GMV
        ฿94,200
        7-month total · 19.7% of TikTok GMV
        Avg Promo ROI
        11.0×
        GMV per ฿1 of seller discount
        Platform-Funded %
        30.5%
        TikTok covers 30.5% of discount cost

        📋 Promo ROI Scorecard placeholder · GMV vs cost

        Why: shows which promotions were worth running — GMV generated vs cost to seller.
        #Promo NameTypeGMV ฿Seller Disc.Platform Disc.Net CostROIStatus

        📊 Promo Type Performance placeholder · GMV vs orders

        Why: reveals whether flash sales, fixed-price deals, or coupons drive better GMV and orders.

        📅 Payday + Campaign Calendar Heatmap placeholder · 7 months × 31 days

        Why: visually shows which days of the month drive TikTok orders — the 25th–28th payday pattern.
        Order volume: 0 1–5 6–15 16–30 31+
        Peak days: 25th–28th each month (payday). Darkest cells = highest order volume.

        📈 Promo Dependency Trend placeholder · % monthly GMV from promo orders

        Why: if promo-attributed GMV keeps rising as % of total, customers are being trained to only buy on discount — a margin risk.
        ⚠️ Promo dependency trending up — watch margin erosion. Apr 26 hit 23.6%, up from 14.2% in Oct 25.

        🥧 Platform vs Seller Discount Split placeholder · 7-month

        Why: TikTok funds part of every discount. Knowing the split shows TRR's true cost.
        TikTok funds 38% (฿3,050) of discount cost via platform subsidies. TRR's net discount cost = ฿4,981 across 3 active promotions.
        ⚡
        Payday Spike — Apr 29–30 (Wed–Thu)
        ฿25,283 in 2 days = ~37% of April TikTok GMV. Discount: 15% off + free shipping. Margin impact ~9pp, but volume uplift 2.4× baseline → net positive ฿14,200. Schedule next major promo around May 29–30.

        ⚠️ 8. Returns & Health placeholder · last 30 daysAffects SPS — affects ad eligibility

        Return rate and cancellations affect SPS score. SPS affects ad eligibility and listing visibility. Early warning prevents platform penalties.
        Return Rate
        2.1%
        platform avg ~3.5%
        −0.3pp MoM
        Cancellation Rate
        7.2%
        target ≤ 3% · blended LSC 7.7% + Rei 6.8%
        −0.2pp MoM
        Seller-Fault Returns
        0.6%
        target ≤ 1%
        Open Disputes
        3
        awaiting resolution

        Return Rate Trend placeholder · 7-month rolling, by shop

        📋 Recent Returns placeholder · last 30 days

        Order IDProductReturn ReasonShopStatusAmount ฿
        ⚠️ Risk callout: If return rate exceeds 5% over a rolling 30-day window, TikTok will restrict new ad campaign creation and may suspend the shop's "Quality Mark". Current 2.1% leaves a safety buffer of 2.9pp — investigate early if any single SKU drives a spike.

        🛍️ 1. Channel Overview placeholder · Oct 25–Apr 26Is Lazada growing? Which shop drives it?

        Is Lazada growing? What's the GMV trend across 3 shops? Lazada is search-driven and has the lowest fees — understanding scale here informs channel strategy.
        Lazada GMV
        ฿112,613
        7-month total · Oct 25–Apr 26
        +11.2% MoM
        Total Orders
        745
        all 3 shops · 7 months
        +8.4% MoM
        AOV
        ฿151
        avg order value
        Items Sold
        1,497
        2.01 items/order

        Monthly Lazada GMV by Shop placeholder · Oct 25–Apr 26

        Shop Mix placeholder · share of GMV

        Top 5 Months by GMV placeholder

        🔎 Traffic Signals 7-month · Oct 25–Apr 26Demand proxy via order patterns

        Lazada Business Advisor traffic API is not available (industry-wide gap). These metrics use order data as a demand proxy to reveal when and what customers buy.
        ⚠ Lazada Business Advisor traffic API not available — industry-wide gap. Metrics below use order data as a demand proxy.

        Order Volume by Month LIVE · 7-month dataset

        Monthly GMV trend (Oct 2025–Apr 2026). Day-of-week granularity requires Lazada Business Advisor export — not yet available.

        Top Demand SKUs LIVE · 7-month dataset

        Ranked by GMV. Avg/month = total GMV ÷ 7. SKUs with gap-months flagged.
        #ProductShopOrdersGMV ฿Avg/mo ฿

        Basket Depth Trend LIVE · items/order by month

        Items per order across 7 months. Multi-item order rate rose from 28% → 39% over the period.
        🔒 Lazada Traffic Unlock Plan
        • Lazada Business Advisor not API-accessible. Industry-wide limitation — no programmatic traffic data available from any Lazada seller tool.
        • Path to real traffic data: Manual CSV export from Business Advisor takes ~30 min/week. Upload to BigQuery weekly to power this section.
        • Fields to capture: Traffic source breakdown, search keywords, product page impressions, add-to-cart rate, conversion rate by source.
        • Priority: Medium. Order data proxy is sufficient for demand planning. Full traffic data unlocks SEO keyword strategy.

        ⚕️ 2. Seller Health STAR SELLER ELIGIBLE5 metrics drive search ranking

        These 5 metrics directly drive Lazada search ranking and Star Seller badge. Losing Star Seller cuts visibility ~30%. All 5 thresholds must be met simultaneously.
        Positive Seller Rating
        98.2%
        target ≥90% (Star Seller)
        +0.3pp vs prev
        Ship-on-Time
        96.8%
        target ≥95% (Star Seller)
        +0.2pp vs prev
        Chat Response Rate
        91.4%
        target ≥85% (Star Seller)
        −1.1pp vs prev
        Cancellation Rate
        1.3%
        target ≤2% (Star Seller)
        −0.2pp vs prev
        Avg Review Score
        4.7 / 5
        127 reviews · last 90 days
        ⭐⭐⭐⭐⭐ 89% · ⭐⭐⭐⭐ 8% · ⭐⭐⭐ 2% · ⭐⭐ 1% · ⭐ 0%
        ⚡ Why these 5 metrics matter
        • Algorithm ranks sellers by these 5 signals — directly affects how often products surface in search results.
        • All 4 + review score must hit threshold simultaneously to keep Star Seller badge. Losing it cuts visibility ~30%.
        • Chat Response 91.4% is comfortable but trending down (−1.1pp) — monitor weekly.

        Health Trend — Last 90 Days placeholder · 3 metrics

        📦 3. Product Performance placeholder · 7-monthSearch-driven SKUs differ from TikTok

        Lazada is search-driven. Different SKUs win vs TikTok. Understanding Lazada-specific bestsellers guides listing optimisation and stock allocation.
        Total SKUs
        273
        all 3 shops
        Active SKUs
        241
        88.3% activation
        Avg Product Rating
        4.6 / 5
        across active SKUs
        Top Category
        Syrup
        42% of Lazada GMV

        🏆 Top 10 Lazada Products by GMV placeholder · 7-month

        #ProductShopGMV ฿OrdersQty

        Category GMV placeholder · horizontal

        GMV by Shop placeholder · 7-mo total

        📦 4. Inventory & Stock placeholderOOS listings get deranked by Lazada

        Lazada penalises out-of-stock listings (listing deranked when OOS). Stock visibility is critical — catching at-risk SKUs early avoids lost rank that takes weeks to recover.
        Total SKUs
        273
        all 3 shops
        SKUs In Stock
        255
        93.4% in-stock rate
        SKUs at Risk
        15
        <30 days of stock
        Avg Days of Stock
        67 days
        across active SKUs

        Top 15 SKUs — Days of Stock Bar placeholder · red <30d · amber 30–60d · green >60d

        📦 At-Risk SKU Detail placeholder · 15 SKUs

        SKUProductShopOn HandAvg Daily SalesDays LeftStatus

        💰 5. Fee & Settlement placeholder · Apr 26Lazada fees ~7pp lower than TikTok

        Lazada's ~15% fee is significantly lower than TikTok's ~22%. Understanding this drives channel investment decisions — Lazada GMV is more profitable per ฿1.
        Gross GMV
        ฿16,087
        representative month · all 3 shops
        Platform Fees
        ฿2,381
        14.8% of GMV
        Net Payout
        ฿13,706
        85.2% of GMV
        Effective Margin
        85.2%
        after Lazada fees
        +0.4pp vs Mar

        Fee Composition (% of GMV) placeholder · Apr 26

        Fee Rate by Platform placeholder · TT vs Shopee vs LZ

        💸 Recent 10 Payouts placeholder · 15-day cycle

        #Payout DateShopAmount ฿Status

        💬 6. Customer Feedback placeholder · 127 reviewsReviews feed back into Seller Rating

        Reviews feed back into Seller Rating (Section 2). Identifying negative patterns early prevents rating drops — a single 1-star streak can ding the algorithm for weeks.
        Total Reviews
        127
        last 90 days
        Avg Rating
        4.7 ★
        platform avg ~4.4
        Response Rate
        82.7%
        replied by us

        Rating Distribution placeholder

        30-Day Rolling Avg Rating placeholder · sentiment trend

        📝 Latest 10 Reviews placeholder

        🎟️ 7. Promotions & Demand Patterns placeholder · Oct 25–Apr 26Voucher API blocked — infer from order patterns

        Lazada voucher API unavailable — signals inferred from order volume and finance data. Use these patterns to time promotions, validate bundles, and quantify subsidies.
        ⚠️ Lazada voucher API blocked. Promotion signals here are derived from order timing, AOV variance, and platform discount fees in finance data — not direct voucher usage logs.
        Peak Day Orders
        28
        highest single-day order count · payday 28th
        Platform Discount Rate
        3.2%
        of GMV funded by Lazada platform
        Peak vs Off-Peak AOV
        ฿189 / ฿148
        +27.7% peak premium
        Multi-Item Order Rate
        34%
        orders with ≥2 items

        📅 Order Volume Calendar Heatmap placeholder · 7 months × 31 days

        Why: even without voucher data, order spikes reveal when Lazada promotions are running.
        Order volume: 0 1–3 4–7 8–12 13+
        Order spikes on 25th–28th (payday) visible without voucher data. Cross-reference with Lazada campaign calendar.

        💰 Peak vs Off-Peak AOV placeholder · 4 day-of-month segments

        Why: determines if campaign days attract deal-hunters (low AOV, high volume) or stack-up shoppers (high AOV).
        ✅ Payday drives both higher AOV (+27.7%) and higher volume — stack-up buying, not just deal-hunting.

        🛒 Platform Discount Absorption placeholder · monthly ฿ & % of GMV

        Why: shows how much of Lazada's revenue TRR effectively subsidises through platform-funded vouchers.

        📦 Multi-Item Order Signal placeholder · % orders ≥2 items

        Why: rising % of 2+ item orders suggests bundle acceptance — validates whether 3-pack listings would succeed on Lazada.
        ✅ Multi-item rate rising — bundle listings likely viable. Test 3-pack SKUs on Lazada (Apr 26 = 39%, up from 28% in Oct 25).