Monthly Performance Tracking on TikTok Shop
Most sellers I talk to don't track their TikTok Shop numbers until the end of the month when they're trying to figure out why revenue dropped. By then it's too late. The data gets noisy because TikTok's analytics combine organic and paid views together, making it nearly impossible to know which short videos or livestreams actually moved product. A Tracker For TikTok Shop Monthly gives you a cleaner picture when you set it up right. I built a simple Google Sheets system about two years ago because the native TikTok Shop Seller Center didn't break down commission fees, returned items, and net profit in a way that was useful for running the business day to day. The Seller Center shows you gross sales and refund amounts, but it doesn't auto-calculate your actual take-home after the platform fee, creator commission, and shipping costs. That's where the tracker comes in.
Setting Up a Tracker For TikTok Shop Monthly
Start by exporting your seller center data weekly rather than waiting until month end. Go to Seller Center, Sales Analytics, and download the CSV. Do this every Friday. TikTok does keep data backdated for a few days sometimes, so pulling early prevents gaps. In the spreadsheet, create these columns: Date, Order ID, Product SKU, Quantity, Gross Revenue, TikTok Commission Rate, Platform Fee, Creator Commission Paid, Refund Amount, Net Profit, Source (Short Video / Livestream / Shop Page), and Campaign or Link Tag if applicable. The Source and Campaign columns are the ones people skip and immediately regret. One specific edge case I ran into that I still see beginners hit: TikTok's attribution window resets at midnight Beijing time, not your local timezone. If you run ads targeting European or US audiences, your overnight campaigns often get attributed to the wrong calendar day in the export. I solved this by adding a manual Date Adj column and flagging anything between 4am and 8am UTC that shifts to the previous day. It takes maybe three minutes a week to scan those rows.
Another thing nobody warns you about is the way TikTok handles multi-sku orders. One order can contain three different products, each with a different commission rate. The export lists the total order value but not the per-SKU breakdown in most regions. I learned this the hard way when my profit margins looked fine on paper but my bank deposits were consistently two percent lower than expected. The fix was pulling the order detail report separately and matching by Order ID using a VLOOKUP formula instead of trusting the summary row. For tracking which videos drive sales, use UTM parameters on every link you share. TikTok's own link-in-bio tools are getting better but they still don't pass through clean attribution data for shop purchases. I use a simple bitly setup with UTM tags: source=tiktok, medium=video, campaign=productname-weeknumber. This lets me sort the weekly exports by campaign tag and see which specific uploads pulled orders. The monthly roll-up is straightforward. Sum Net Profit for the month. Divide by Total Gross Revenue to get your effective margin. Compare that against the prior month. If margin dropped but revenue grew, check whether you shifted toward higher-commission categories or added more creator collabs without adjusting prices. If both dropped, look at your refund rate first. TikTok Shop refunds have been creeping up across the platform as buyers get looser with return policies, and a refund spike often hides behind flat revenue numbers.
Get the Full Details
If you want a ready-made version instead of building from scratch, there are several shared Google Sheets templates floating around in TikTok Seller communities. The ones worth using are the older ones from 2023 and 2024 because the newer ones assume features TikTok hasn't universally rolled out yet. Check the comments section to see if people mention the UTM tracking working correctly for their region. The biggest limitation of any tracker like this is that TikTok occasionally changes their fee structure without notice. Last quarter they adjusted the platform service fee for certain categories and a lot of sellers ran their trackers for six weeks before catching the discrepancy because the formula was hardcoding the old rate. Keep an eye on the Seller Center announcements and update your commission rate cells quarterly at minimum. Also, trackers don't capture what happens after the sale. Customer service response time, dispute rates, and negative reviews all affect your shop ranking and eventual sales velocity. I added a separate tab for those metrics and cross-reference them against the monthly revenue tabs to spot when a drop in rating precedes a drop in orders by about two weeks.
The whole system takes about twenty minutes a week once it's running. Without it, I'd be guessing at the end of every month like most sellers do.
