Sweetmag Insights v2
TikTok Shop performance last week
💬 Chat with data
You
How did TikTok Shop perform last week? Compare it to the previous week.
Sidekick
TikTok Shop revenue was RM 47,240 last week (47% above the prior week's RM 32,140), driven mainly by three creator livestream sessions that drove RM 14,200 in attributed sales. Glow Serum 30ml was the standout — 412 units sold (vs 218 the previous week), most of that during the Wednesday live with creator @nadiabeauty.
Query 1: total revenue + orders for tiktok_shop, this week vs last
SELECT day, SUM(net_revenue_base), SUM(orders) FROM rollup_channel_daily WHERE channel_id = 4 AND day BETWEEN ...
MetricLast weekPrev. weekΔ
RevenueRM 47,240RM 32,140+47%
Orders428312+37%
AOVRM 110.4RM 103.0+7%
Live-attributedRM 14,200RM 2,800+5×
Query 2: top SKUs by attribution_type=live for tiktok_shop
You
Which products from the live should I prioritise restocking?
Sidekick
Two are urgent. Glow Serum 30ml has 18 days of cover at current unified velocity (412 units/week across all channels) and a 14-day supplier lead time — that's a tight overlap. Suggested PO: 1,200 units. Honey Lip Balm 4g had a stockout-risk flag fired during the live; only 142 units left across 4 channels at 28 units/day combined velocity = 5 days cover.
SKUDays coverLead timeSuggested PO
SM-GLW-30 Glow Serum1814d1,200 units
SM-HNY-4 Honey Lip Balm514d2,400 units · expedite
📈 Blended ROAS this month
💎 Most profitable segment
🔮 Forecast Glow Serum
🚨 Returns up on Shopee?
Powered by Claude · queries only run against pre-aggregated rollups · figures never invented