What Comes Out Is Not What You Pictured
A Shenzhen seller runs four TikTok Shops: US, Malaysia, Thailand, and the Philippines. He asked me to help him “export the affiliate list”. He wanted to follow up with the 300 creators who had produced sales that month.
He assumed the file would arrive with handles and contact routes attached. Then he opened the CSV. It held order IDs, commission amounts, and attributable GMV. It also held creator display names. It held no contact route and no message history. Not one creator in that file could be reached from that file.
That gap decides everything downstream. It is also why most affiliate exports get downloaded once, skimmed, and never opened again.
This guide is for the operator running more than one TikTok Shop. Usually that means a US shop plus two or three Southeast Asian ones. You carry 50 to 200 SKUs, and someone on your team reconciles creator commissions against payouts at month end.
If you export affiliate data hoping to find creators to message, you are pulling the wrong report. A different path gets you closer to what you actually want.
This is an operational walkthrough, not a growth strategy. We will cover which export exists and where its button lives. We will also cover what the columns mean, and the two places where the file quietly misleads anyone reading it too fast.
Before You Export: Pick the Report by Decision
Most operators pull the wrong file because they start from the download button. Three questions sort it out in under a minute.
Are you reconciling money? If you are checking that commissions charged match commissions due, you need the settlement-bearing report. It lists creator-level commission amounts tied to orders. This is the file your finance person actually wants.
Are you deciding who to keep? If you are choosing which creators to renew or drop, pull the creator-level performance export. Order rows tell you what sold. Creator rows tell you who sold it. Sort by creator, then read row density. That is what surfaces repeat producers.
Are you hunting for new creators? Then the affiliate export is the wrong tool. It only contains creators who already promoted you. Net-new outreach needs a discovery surface, which is a separate job with separate data.
| What you are doing | Which report to pull | What it contains | What it will not contain |
|---|---|---|---|
| Month-end reconciliation | Order-level commission report | Order IDs, commission per order, settlement status | Creator totals, multi-shop rollup |
| Deciding who to renew | Creator-level performance export | Per-creator GMV, orders, commission | Contact routes, message history |
| Finding new creators | Discovery surface, not an export | Profile data on creators you never worked with | Any history, because there is none |
Naming varies by market, and the interface shifts every few months. Treat those labels as descriptions rather than literal button text. If nothing matches exactly, look for the export that puts orders or creators in rows. A report you can filter is the one you want.
Where the Export Button Lives, and Where It Does Not
The most common frustration is that the button moves. It is not hidden. It sits inside whichever module owns that data. That means there is no universal location, and tutorials age badly.
Affiliate and creator performance lives on the affiliate side. Open Seller Center, find the affiliate module, then look for the creator or partner view. Do not look in the product view. Export controls sit near the table they describe, usually above the right side of the table header. If you are staring at a chart, switch to the table view first. Most chart views have no export at all.
Order-level and commission data lives with orders. This is a separate place with a separate export. The two do not reconcile against each other without work, because they apply different filters by default. The creator view often excludes refunded orders. The order view often does not.
Cross-shop reporting does not exist natively. Run four shops and you have four exports. There is no built-in rollup. Every multi-shop team I have watched either pastes four CSVs into one sheet or writes a script. The manual route takes fifteen minutes a week. It also breaks roughly every third attempt, usually when someone forgets the current week in the date filter.
A Malaysia-based operator told me her team had been pulling the “wrong” file for two months. “Nobody had written down which module it came from,” she said. “Every time the interface changed, we guessed again. Half our guesses excluded refunds, so our commission totals were always slightly high and we blamed finance.” The file was right. Their map of where it lived was not.
This is the specific job DAMI’s multi-shop analytics view absorbs. One workspace holds every shop’s creator numbers and rolls them up without the paste step.
The Columns Everyone Reads Wrong
Three fields account for most of the confusion I see. Each one means something narrower than its label suggests.
Attributable GMV is not revenue you received. It is GMV credited to a creator inside the attribution window. It includes orders later refunded, unless you filtered those out at export. It is also denominated in the shop’s currency. That last part matters enormously once a US shop sits beside three Southeast Asian ones.
Commission shown is often unsettled. Early in a cycle, the commission column reflects estimates. Final settlement depends on the order surviving its return window. Export on the fifth of the month and treat that number as final, and you have manufactured a reconciliation gap.
Creator counts do not deduplicate across shops. One creator promoting in two of your shops appears as two entries. If you want a team-level picture of unique creators, deduplicate by handle yourself. No export setting will do it.
| Column | What it actually means | Common misreading |
|---|---|---|
| Attributable GMV | Credited GMV inside the window, not net receipts | Treated as revenue, ignoring refunds and currency |
| Commission | Frequently an estimate until settlement completes | Read as the final payable amount |
| Creator count | Rows per shop, not unique people | Summed across shops as distinct creators |
| Order count | Orders credited, including some later cancelled | Used as a proxy for stable demand |
A Thai shop’s baht figures and a Malaysian shop’s ringgit figures do not sum meaningfully. No export converts them for you.
The Two Limitations That Break Naive Reporting
Two structural limits sit behind nearly every “the numbers look wrong” conversation. Neither has a workaround inside the export itself.
The attribution window cuts both ways. A creator can influence a sale that lands after the window closes, and that sale will never appear credited. In the other direction, a credited sale may have had nothing to do with that creator’s content. Cross-shop brands feel this most sharply. A buyer who found you through a Malaysian creator and later purchased from your US shop often shows up nowhere at all.
You cannot recover this with a setting. You can only stay consistent about the window you chose. Stop comparing figures generated at different window lengths. Ad hoc exports make that mistake very easy to make by accident.
Everything is historical. Exports typically lag the live view, sometimes by up to two days for the most recent window. Anything you plan to do within 48 hours should not run off export data. That includes triggering a renewal conversation or pausing commission before a promotion ends. Use the live view for today’s decisions. Use the export for this month’s.
Where the Cleaning Stops Paying
Hand-cleaning has a ceiling. Past three shops or roughly thirty creators, deduplicating and converting currency in a spreadsheet stops being a weekly chore. It becomes a weekly risk. That is the point where most teams move the job into a system, and the export becomes a sanity check rather than the source of truth. DAMI’s shop analytics runs the currency and dedupe pass on ingest, so the spreadsheet never becomes the system of record.
Turning the File Into a Weekly Decision
Exporting is only worth the effort if something changes afterwards. The version that survives a real team looks like this. Pull the creator-level export on the same day each week. Deduplicate across shops once. Then read two things only.
Read the Distribution, Not the Average
The average hides the shape. If five creators produced 70% of your credited GMV, your program is five creators wide. That stays true no matter how many rows sit in the file. Any plan assuming a broad base is built on a number that is not real.
Read Movement at the Edges
Your top performers will mostly still be there next week. The interesting rows sit at the edges. Watch the creators who moved from zero to something. Watch the ones who dropped to zero after producing steadily. Those two shifts are actionable. Everything else is noise until it isn’t.
Frequently Asked Questions
Can I export affiliate data with creator contact details? No. Affiliate exports carry commercial data tied to your own orders, not contact routes. Reaching a creator you already worked with happens through the messaging surface in Seller Center or the affiliate module. The export tells you whom to message. It does not give you a way to message them.
How far back does the export go? It depends on the module and your shop’s history, and the limit moves with the interface. Set your date filter explicitly every time rather than trusting a remembered number. If the range you need gets rejected, export in monthly slices and concatenate. Slicing is reliable. Assuming the default range covers you is not.
Why do my export totals disagree with my dashboard? Usually one of three things. The export applied a different date filter. It treated refunds differently. Or you compared figures pulled at different attribution windows. Pick one definition, write it next to the file, and check that first before suspecting the platform.
Can I export affiliate data for all my shops at once? Not natively. Each shop exports separately. Teams either consolidate by hand or move reporting into a workspace with a shop-level analytics view that rolls the numbers up itself. DAMI’s shop analytics exists precisely for this case, and it removes the dedupe step that manual consolidation keeps getting wrong.
Is there an API instead of clicking export every week? Availability and scope vary by market and account type. The details change often enough that any specific answer here would age badly. If weekly manual export has become a real cost, check your integration options against your actual account rather than against a general guide.
Pull Once, Then Decide What Something Means
The Shenzhen seller’s problem was never the export. He got exactly the file the platform produces. His problem was that he had pictured something the platform does not offer, which is a contact list. Every downstream plan had assumed it would be there.
If you take one thing from this, take the sequence. Decide what you will do with the file before you pull it. Write down which module it came from. Stick to one attribution window so your month-over-month figures stay comparable. Those three habits fix most of what people blame on the platform.
For the point where commission numbers stop being trustworthy enough to act on, the double-counting problem in creator ROI explains why two teams can add up the same month and get different answers. If your real constraint is four shops producing four separate files every week, see how the DAMI workspace rolls them into one view on the product page. You can also create your account and run the rollup against your last full month.
