AI Sidekick — Sweetmag Insights

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 ...

Metric	Last week	Prev. week	Δ
Revenue	RM 47,240	RM 32,140	+47%
Orders	428	312	+37%
AOV	RM 110.4	RM 103.0	+7%
Live-attributed	RM 14,200	RM 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.

SKU	Days cover	Lead time	Suggested PO
SM-GLW-30 Glow Serum	18	14d	1,200 units
SM-HNY-4 Honey Lip Balm	5	14d	2,400 units · expedite

📈 Blended ROAS this month

💎 Most profitable segment

🔮 Forecast Glow Serum

🚨 Returns up on Shopee?