To connect TikTok Shop GMV to Looker Studio, you have three realistic routes: upload Seller Center and Ads Manager exports to Google Sheets, use a third-party connector that supports TikTok Shop, or pull data from TikTok's official APIs into BigQuery and point Looker Studio at that. The same three routes work for Power BI. The hard part is not the connection. It is reconciling shop GMV, affiliate GMV and ad-attributed revenue so nothing is counted twice.
Key takeaways
- TikTok Shop data lives in three places: Seller Center (orders, GMV, affiliate analytics), the TikTok Shop Partner API, and TikTok Ads Manager (GMV Max and Spark Ads).
- At the time of writing (October 2026), there is no free native TikTok Shop connector in Looker Studio or Power BI.
- CSV exports to Google Sheets are fine for weekly reporting. Daily or multi-store reporting usually justifies a connector or a BigQuery pipeline.
- Ads Manager gross revenue and Seller Center GMV are defined differently, and GMV Max revenue includes organic orders.
- Use Seller Center orders as the source of truth for total GMV and never sum affiliate and ad revenue.
What TikTok Shop data can you actually get?
Before choosing a tool, be clear about where each number comes from. Most broken TikTok dashboards mix three sources without labeling them.
1. Seller Center
Seller Center holds your orders, product performance and affiliate analytics. TikTok's guide to Shop analytics in Seller Center defines GMV as the total amount paid for orders in the selected period, including canceled and refunded orders, calculated by time of payment. Order lists and affiliate analytics lists can be exported for offline analysis.
This is your closest thing to a ledger. If finance asks what the shop sold, this is where the answer starts.
2. The TikTok Shop Partner API
TikTok Shop runs a Partner Center for developers. Registered apps that a seller authorizes can read data such as orders, products and settlements, and TikTok has also released affiliate APIs that include searching and retrieving affiliate orders. This is the foundation every connector and custom pipeline builds on.
3. TikTok Ads Manager
GMV Max and Spark Ads performance lives in Ads Manager. TikTok's article on Product GMV Max reporting lists cost, orders, cost per order, gross revenue and ROI at campaign level, with product and video breakdowns. Ads Manager also supports custom reports that you can download or schedule by email.
For automation, TikTok's API for Business has a dedicated GMV Max campaign report endpoint. At the time of writing (October 2026), its documentation says dates follow the ad account time zone and daily breakdowns are limited to 30-day ranges per request.
If you need a refresher on how the campaign type works, read what GMV Max is and how it works first.
What are the options to connect TikTok Shop GMV to a BI tool?
There are three practical methods. They differ mainly in setup effort, how fresh the data is, and how much control you have over definitions.
| Method | Effort | Refresh | Best for |
|---|---|---|---|
| CSV export to Google Sheets or Excel | Low setup, ongoing manual work | Whenever someone uploads (usually weekly) | Single-shop brands, early-stage reporting, testing which metrics matter |
| Third-party connector (SaaS) | Low to medium; paid subscription | Scheduled, often daily or more | Teams that want automation without engineers |
| Custom pipeline on official APIs into BigQuery | High; needs a developer and app approval | As often as you schedule it | Multi-store brands, custom attribution, joining TikTok with other channels |
A sensible path for most brands is to start with exports, learn which views people actually use, then automate. Paying for a pipeline before you know what the dashboard should show tends to produce an expensive dashboard nobody opens.
How do I connect TikTok Shop GMV to Looker Studio?
Looker Studio has no native TikTok Shop source, so you feed it through Google Sheets, a connector, or BigQuery.
Option A: Google Sheets (free)
- Export orders from Seller Center for a fixed date range. Keep the date range consistent, such as last week Monday to Sunday.
- Export affiliate data from affiliate analytics, at creator and video level if you need creator reporting.
- Export a custom report from Ads Manager with GMV Max cost, gross revenue, orders and ROI by day and campaign.
- Paste each export into its own tab in one Google Sheet, appending new rows rather than overwriting. Add a column for the export date.
- Add the Sheet as a data source in Looker Studio, one source per tab.
- Blend sources on date (and on product ID where available) to build combined charts.
Option B: Connector
- Authorize the connector against your TikTok Shop seller account and your Ads Manager account.
- Pick Looker Studio as the destination, or send data to a Sheet or BigQuery first.
- Choose fields and set the refresh schedule.
- Build charts, then compare one week's totals against Seller Center before sharing the report.
Option C: BigQuery as the source
If your data is already in BigQuery (see below), add BigQuery as a Looker Studio data source and query modeled tables or views, not raw ones. This is the most stable setup at scale.
How do I connect TikTok Shop GMV to BigQuery?
BigQuery is the right home when you want history, several stores, or TikTok joined with Shopify, Amazon or Meta data.
- Create a Google Cloud project and a dataset, for example tiktok_shop, in the region your other data uses.
- Pick the load method. Upload exports as CSV to tables, point a connector at BigQuery, or build your own job.
- For a custom job, register an app in the TikTok Shop Partner Center, have the seller authorize it, and call the order and affiliate endpoints on a schedule. Use the API for Business for GMV Max reports. Run it with a scheduler such as a cloud function or a workflow tool.
- Land raw data unchanged in staging tables, with a load timestamp on every row.
- Re-pull recent days. Orders change status and refunds arrive later, so reload a rolling window (for example the last 30 days) on every run rather than only yesterday.
- Build modeled tables: one row per order line, one per creator per day, one per GMV Max campaign per day. Standardize time zones and currency here.
- Connect your BI tool to the modeled tables only.
How do I connect TikTok Shop GMV to Power BI?
Power BI works with all three methods. The steps mirror Looker Studio.
- From files: save exports to a SharePoint or OneDrive folder and use Get Data, then Folder, so Power BI combines every file you drop in. Scheduled refresh picks up new files.
- From a connector: many connectors can write to a database or warehouse that Power BI reads, and some offer a Power BI destination directly.
- From BigQuery: Power BI Desktop includes a Google BigQuery connector. Sign in, select your modeled tables, and choose Import or DirectQuery depending on data size.
- Model the relationships: a date table, a product table, and fact tables for orders, affiliate performance and ad performance, all joined to date and product.
- Write measures for GMV, net GMV after refunds, ROI and affiliate share instead of calculating them in visuals.
If you would rather have someone set up the reporting around a live affiliate and GMV Max program, you can book a 30-minute call and we will walk through what your data can and cannot answer today.
Which metrics belong on a TikTok Shop GMV dashboard?
Keep the first version short. These are the views we find founders and ecommerce managers actually use week to week:
| Metric | Source | Why it matters |
|---|---|---|
| Total GMV and orders | Seller Center | The top-line number; your source of truth |
| Refunds and net GMV | Seller Center | GMV includes refunded orders, so gross alone overstates sales |
| Affiliate GMV by creator | Seller Center affiliate analytics | Shows which creators to keep, tier and re-seed |
| GMV Max cost, gross revenue, ROI | Ads Manager | Tracks paid efficiency against your break-even |
| Spark Ads spend and results | Ads Manager | Shows which creator videos earn more budget |
| GMV by product | Seller Center | Reveals which SKUs carry the shop |
Affiliate GMV by creator is the view most brands are missing. It turns your affiliate program from a list of samples sent into a ranked roster. Pair GMV Max ROI with your break-even figure, explained in our guide to setting a GMV Max ROI target, so the chart shows profit, not just a ratio.
What are the common pitfalls in TikTok Shop reporting?
Different definitions of revenue
TikTok's note on gross revenue for TikTok Shop Ads says Ads Manager gross revenue is customer payment minus sales taxes plus platform price discounts, while Seller Center GMV is customer payment. Label every chart with its source so nobody compares the two as if they were the same.
Attribution overlap
GMV Max gross revenue covers both paid and organic orders attributed to the campaign. Affiliate GMV is attributed to creators separately. One order can appear in both reports.
Double counting affiliate and ad orders
This is the most common mistake. Adding affiliate GMV to GMV Max revenue and calling it total sales can produce a number larger than the shop actually sold. Total GMV comes from Seller Center. Affiliate and ad numbers are overlapping slices of it, useful for comparison, never for summing.
Refund timing
GMV includes refunded orders, and refunds can land days or weeks after the sale. A week that looked strong can shrink later. Reload recent periods and report net GMV alongside gross.
Time zones
Your ad account has its own time zone, and the GMV Max report API returns dates in it. If that differs from the shop or from your other channels, daily totals will not line up. Pick one reporting time zone and convert everything to it.
Attribution windows
Ads and affiliate reports each credit orders within their own windows after a view or click, and those windows can change. Comparing a seven-day ad window with a longer affiliate window will flatter one channel. Check the current settings in each tool and note them on the dashboard.
Do you need to build this yourself?
Not always. If you work with an agency that runs your creators and ads, reporting should come with it. SparkGMV's Growth Partner plan includes an analytics dashboard alongside creator network building and GMV Max campaign management, so affiliate and ad performance are read from the same numbers.
If you are not sure whether your current GMV Max and affiliate numbers are telling the truth, start with the free audit self-check. It is a quick way to spot double counting, weak ROI targets and creators who are quietly driving most of your sales.