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
Store
GMV
MoM %
vs Target
Status
✅ 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
Product channel data not available — showing all-channel products for this shop/month view.
🎵 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?
Lin Official is not on TikTok Shop. No TikTok account exists for this store yet — entry plan slated for Q3 2026 (see platform-channel-notes.md).
No TikTok orders in this month.KPIs are zero — the section is intentionally quiet for months with no TikTok activity.
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.
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.
#
Creator
Videos
Total GMV ฿
Total Views
Orders
GPM ฿
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 / Creator
Brand
Spend ฿
Impressions
CPM ฿
Clicks
GMV ฿
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
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 ID
Platform
GMV ฿
Plat. Fee
Aff. Fee
Trans. Fee
Ship 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 Name
Type
GMV ฿
Seller Disc.
Platform Disc.
Net Cost
ROI
Status
📊 Promo Type Performance placeholder · GMV vs orders
Why: reveals whether flash sales, fixed-price deals, or coupons drive better GMV and 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 ID
Product
Return Reason
Shop
Status
Amount ฿
⚠️ 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.
#
Product
Shop
Orders
GMV ฿
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
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
#
Product
Shop
GMV ฿
Orders
Qty
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
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 Date
Shop
Amount ฿
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:01–34–78–1213+
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.