What This Actually Is
A Workbook For TikTok Shop Weekly is just a structured spreadsheet template — usually Google Sheets or Excel — built to track the metrics that matter for a TikTok Shop account on a recurring basis. You fill it in once every seven days. It records orders, refund rates, affiliate commissions, live sale totals, ad spend, and a few calculated KPIs so you can spot trends instead of guessing from scattered backend screenshots. I built the first version of my own after watching three weeks of TikTok Shop data disappear into the native analytics dashboard. The built-in reports update on a delay and they don't cross-reference ad spend against actual net revenue. I lost about $4,200 in a single month because I couldn't tell which creative was actually profitable versus which one just drove clicks. That was the moment I decided to track everything manually in one place.
Workbook For TikTok Shop Weekly Setup Guide
Start a blank Google Sheet. Label the columns the same way every time. This isn't optional. Inconsistent column names are the single biggest reason people abandon these spreadsheets after two weeks. Your headers should be: Week Ending Date, Gross Sales, Refunds, Net Revenue, Affiliate Commissions Paid, Ad Spend (Spark + In-Feed), Total Profit After Ads, Live Stream Sales, Organic Sales, Return Rate %, CAC, and Notes. The Notes column is where most people skip discipline and that's exactly where you'll lose track of what happened. When I ran a flash sale with a stacked coupon, I need to know later why organic sales jumped 340% that week but profit margin collapsed. Writing "15% coupon + free shipping threshold" in Notes costs three seconds now and saves forty minutes of debugging later. Set up a conditional formatting rule on the Return Rate column. Anything above 8% should flag red automatically. The TikTok Shop baseline for most categories sits between 4% and 7%. When your rate climbs above 8%, something is wrong with your product listing, your sizing info, or your shipping promises — not with your marketing. I learned this the hard way after a supplier sent mismatched inventory for a clothing bundle and my return rate hit 14% in one week. The spreadsheet flagged it before the TikTok backend did because I was entering data daily instead of checking once a month.
Create a separate tab for your affiliate tracking. TikTok Shop's affiliate marketplace doesn't give you clean per-affiliate ROI data unless you're on a higher seller tier. I had to manually log each affiliate's code, their follower count range, commission rate, and actual sales they generated. This took about twenty minutes per week and cut my affiliate spend waste by roughly 30% over three months. I stopped paying 15% commission to creators who moved 200 units but generated zero repeat buyers. Add a pivot table if you're comfortable with them. If you export your weekly TikTok Shop order data and paste it into a raw data tab, a pivot table organized by product SKU and week will show you which items are trending and which are dying before the algorithm stops pushing them. I caught a product declining two weeks before it disappeared from my storefront this way. Without the pivot table, I would've kept restocking it at full margin. There are legitimate reasons this system breaks down. If you're moving more than two hundred orders per week across dozens of SKUs, manual entry becomes unsustainable and error-prone. One wrong decimal in the refund column throws off your entire profit calculation for that period. I switched to a lightweight Zapier automation that pulls order data from TikTok Shop into a new row every time an order status changes, but even that required me to build a validation script because the API sometimes duplicates entries during peak traffic. The hybrid approach — automated pull with manual verification on Sundays — works best for shops doing five hundred to two thousand orders weekly.
Get the Full Details
If you're a brand-new seller under five hundred orders per month, the manual method is fine and probably better because you'll actually read the numbers. At that volume, the spreadsheet itself teaches you what to look for before any automation could replace human attention. For larger operations, look into tools like SellPy or MerchantWords that offer built-in TikTok Shop analytics with export functions. The spreadsheet still holds value as a supplementary cross-reference layer, but it shouldn't be your only source of truth past that threshold. The file lives in Google Sheets. I keep mine shared with my virtual assistant so she handles the weekly entry while I review the summary tab every Monday morning. Total time investment after the initial build is about twenty-five minutes per week. The first build took me roughly six hours spread across three days because I was refining formulas and testing edge cases. Search Google Sheets for the template name or build from scratch using the column structure above. Don't download random templates from YouTube thumbnails. Most of them are outdated for the current TikTok Shop API and will pull the wrong data fields. A clean sheet you built yourself with correct labels will always beat a polished third-party template that references deprecated metrics.
