Seller Center analytics are useful for a quick look, but growing brands soon need more: combining TikTok Shop data with ads, affiliates, stock and finance, comparing periods, sharing reports with the team and tracking targets. That means exporting data and building a dashboard. It sounds technical, but a reliable weekly dashboard can be built with spreadsheets or common BI tools in a few hours.
This guide explains which data to export, how to clean it and how to build a simple dashboard. For which metrics matter most, read our guide to TikTok Shop analytics metrics. Export options and field names vary by market and change over time, so check what your Seller Center offers.
Data Sources to Export
- Orders: order ID, date, status, products, SKUs, quantities, prices, discounts, shipping and buyer region.
- Products: product and SKU performance, views, conversion, stock.
- Traffic and content: video, LIVE and shop tab performance.
- Affiliates: sales and commission by creator and product.
- Finance: settlements, fees, adjustments and payouts.
- Returns: return requests, reasons and refunds.
- Ads: spend, attributed revenue and orders from Ads Manager.
How to Export
Most areas of Seller Center provide an export or download button, often with date filters. Large exports may be generated in the background and made available for download later. Exports are usually CSV or Excel files. Keep a consistent schedule, for example every Monday for the previous week, and always use the same date ranges and time zone. Our Seller Center walkthrough shows where each area lives.
Automating Exports
Manual exports work for small shops. As you grow, consider automation: some analytics apps and connectors pull TikTok Shop data automatically, and developers can use the API to fetch data on a schedule. Automation saves time and reduces errors. Our Open API guide explains the developer route.
Cleaning the Data
Raw exports need cleaning before they are useful:
- Remove or flag cancelled and unpaid orders when measuring sales.
- Standardise dates and time zones.
- Convert currencies if you sell in several markets.
- Map SKUs to product names, categories and costs.
- Split multi-item orders into item rows if needed.
- Remove duplicate rows from overlapping exports.
Write down every cleaning rule so reports are consistent week to week.
A Simple Data Model
You do not need a data warehouse to start. A simple model has a few tables: orders (one row per order item), products (SKU, name, category, cost), daily ads (date, spend, attributed revenue), affiliates (creator, sales, commission) and settlements. Join them by SKU and date. This structure lets you calculate revenue, margin, ad efficiency and affiliate costs in one place.
Key Dashboard Metrics
- Gross revenue and net revenue after cancellations and refunds.
- Orders and average order value.
- Revenue by channel: videos, LIVE, shop tab, affiliates and ads, noting overlap.
- Top products and SKUs by revenue and margin.
- Contribution margin after product cost, fees, shipping, commissions and ad spend.
- Return rate and top return reasons.
- Stock cover for top SKUs.
- Shop health indicators such as late dispatch and response time.
Whichever metrics you choose, define each one in writing, including exactly what is included and excluded, so everyone reading the dashboard interprets the numbers the same way.
Choosing Tools
Spreadsheets such as Google Sheets or Excel are enough for many brands, especially with pivot tables and simple charts. Free or low-cost BI tools such as Looker Studio, Power BI or similar products make dashboards easier to share and update. Choose the tool your team will actually open every week. The best dashboard is the one people use.
Designing the Dashboard
Put the most important numbers at the top: revenue, orders, margin and ad efficiency for the week compared with the previous week and the same week last month. Below, show trends over time, then breakdowns by product, channel and creator. Keep it to one page if possible. Add short notes explaining unusual changes, such as a viral video or a stock-out.
Setting Targets and Alerts
A dashboard becomes far more useful when it shows targets. Add weekly or monthly targets for revenue, margin, return rate and dispatch performance, and colour each number by whether it is on track. For metrics that can go wrong quickly, such as stock cover on bestsellers or late dispatch, set simple alert thresholds so someone is told when a number crosses the line. Targets turn reporting from a history lesson into a tool for action.
Weekly Reporting Routine
- Export or refresh data every Monday.
- Run cleaning steps.
- Update the dashboard and check for errors.
- Write three to five bullet points on what changed and why.
- Agree actions for the week, such as restocks, creator outreach or ad changes.
Our daily and weekly checklist fits reporting into your routine.
Avoiding Common Data Errors
- Double counting sales across ads, affiliates and organic reports.
- Mixing time zones between exports.
- Including cancelled orders in revenue.
- Using list prices instead of actual paid prices.
- Forgetting fees and commissions in margin.
Our guide to ads attribution explains overlap.
Combining TikTok Shop With Other Channels
If you also sell on your website, Amazon or in retail, a combined dashboard shows how TikTok Shop fits into the whole business. TikTok activity often lifts sales elsewhere, for example shoppers who see a creator video and then search for the brand on Amazon. Add channel revenue side by side, using the same date ranges and definitions, and watch whether total brand sales rise when TikTok activity increases. This halo effect is easy to miss if you only look at TikTok Shop numbers.
Checking Data Quality
Before sharing a dashboard, run quick sanity checks. Does total revenue match the Seller Center summary for the same period? Are order counts in a believable range? Did any product suddenly show zero sales because its SKU changed? Small checks like these catch broken exports and mapping errors before anyone makes decisions on wrong numbers. Keep a short list of checks and run it every time the dashboard is refreshed.
Keeping History
Store every weekly export in an organised archive, named by data type and date range. Seller Center may only show a limited history for some reports, and having your own archive lets you compare this year with last year, analyse seasonality and recover from mistakes. Keep the archive in a secure shared drive with access limited to the people who need it.
Data Privacy
Order exports contain customer names, addresses and phone numbers. Only export what you need for reporting, remove personal data from files shared widely, store files securely and delete old exports according to your policy. Follow platform data rules and privacy law.
A Worked Example: A Monday Dashboard
A pet brand exports orders, affiliate sales, settlements and ad data every Monday into a spreadsheet. A cleaning tab removes cancelled orders and maps SKUs to costs. The dashboard shows weekly revenue, margin, top SKUs, affiliate share and blended ad efficiency, with stock cover for the top ten SKUs. In one week the dashboard shows revenue up but margin down; the notes reveal a deep flash deal stacked with high creator commission. The team adjusts the next promotion to protect margin.
Dashboard Checklist
- Export the right data on a fixed schedule.
- Clean and document rules.
- Build a simple data model joined by SKU and date.
- Show key metrics with comparisons and targets.
- Add notes and actions every week.
- Protect customer data.
- Automate when volume grows.
Desnora builds reporting dashboards for TikTok Shop brands. Explore our TikTok Shop services or contact us.
Frequently Asked Questions
Can I export data from TikTok Shop Seller Center?
Yes. Most areas offer export or download options, usually as CSV or Excel files.
What data should I export?
Orders, product performance, affiliates, finance, returns and ads data from Ads Manager.
Which tool is best for a TikTok Shop dashboard?
Spreadsheets work for many brands; BI tools like Looker Studio or Power BI help with sharing.
How often should I update my dashboard?
Weekly works for most brands, with daily checks on key numbers during campaigns.
Can I automate TikTok Shop exports?
Yes, through analytics apps, connectors or the Open API.
Why does my revenue not match Seller Center?
Check for cancelled orders, time zones, currencies and duplicate rows.
Should I include ad data?
Yes, to calculate margin after ad spend and blended efficiency.
How do I calculate contribution margin?
Revenue minus product cost, fees, shipping, commissions, discounts and ad spend.
Is it safe to share order exports?
Remove personal data before sharing and store files securely.
What metrics belong at the top of the dashboard?
Revenue, orders, margin and ad efficiency with comparisons to previous periods.
How do I avoid double counting?
Use Seller Center totals for revenue and treat channel reports as overlapping views.
Do I need a data warehouse?
Not to start. A simple spreadsheet model is enough until volume grows.
How do I check my dashboard is correct?
Compare totals with Seller Center summaries, check order counts are plausible and look for products suddenly showing zero sales.
Should I keep old exports?
Yes. Archive exports by type and date so you can compare years and analyse seasonality, stored securely.