Export TikTok Ads & GMV Max Reports: Looker Studio, Power BI, Sheets

If your weekly report still starts with screenshots, CSV downloads, and one spreadsheet nobody wants to touch, you do not have a reporting workflow. You have a ritual. This guide is about how to export TikTok Ads GMV Max campaign reports into Looker Studio, Google Sheets, and Power BI without turning the numbers into a new source of arguments.

The mechanics are simple. The route choice is not: manual export, spreadsheet staging, third-party connector, or enterprise BI pipeline. Pick the wrong route and every later chart becomes fragile.

Why TikTok reporting breaks once you manage more than one account

One TikTok ad account can survive manual reporting for a while. You open Ads Manager, adjust the date range, export campaign and ad group data, paste the file into a sheet, and clean up the columns before the meeting.

The workflow starts breaking when the account count, shop count, or reporting audience grows. A buyer wants yesterday's campaign performance. The operator wants GMV Max sales by store. Finance asks why gross revenue does not match payout. The founder wants a Power BI view next to Meta, Google, Shopify, and marketplace data.

At that point, the report becomes a contract: included accounts, timezone, currency, attribution window, and whether ROI means platform ROI or net contribution after seller-side costs. Build that contract before the dashboard.

What you can export from TikTok Ads Manager

For regular TikTok Ads reporting, the useful export levels are usually campaign, ad group, ad, creative, audience, and conversion event performance. A basic weekly report should include stable IDs as well as names, because names change and IDs keep joins intact.

For conversion reporting, make sure the event column means what the team thinks it means. If website purchases, add-to-cart, complete payment, and TikTok Shop gross revenue are mixed, the dashboard will look clean and still be wrong. If tracking is unstable, fix that first; the Pixel and Events API dual tracking guide covers the tracking side.

For GMV Max, TikTok's official Product GMV Max reporting help lists cost, orders, cost per order, gross revenue, and ROI. Gross revenue can include paid and organic TikTok Shop orders attributed to the campaign, and ROI is gross revenue divided by cost. Useful, but not the same as payout profit.

The practical export list looks like this:

Report type	Use it for	Watch out for
Basic campaign report	Weekly spend, delivery, campaign-level ROI or CPA	Campaign names are not a join key
Basic ad group report	Budget pacing, targeting, bid and conversion checks	Timezone and attribution settings can shift totals
Basic ad report	Creative performance and fatigue checks	Low-spend ads create noisy CPA and ROAS
GMV Max campaign report	Shop campaign cost, orders, gross revenue, ROI	Gross ROI is not net ROI
Search and keyword reports	Search Ads query learning	Use a separate naming and query review process

For Search Ads, keep a separate review loop; search terms deserve more than a hidden column in the weekly table. See the TikTok Search Ads keyword reporting playbook.

How to export TikTok Ads GMV Max campaign reports

The safest way to export GMV Max data is to isolate it before the download. In Ads Manager or your reporting connector, filter by ad type or report type so the dataset only contains GMV Max rows. If your connector exposes a GMV Max campaign report, use it.

A clean GMV Max export workflow is:

1. Choose the ad account and shop scope.
2. Set the date range and timezone before exporting.
3. Filter by GMV Max or select the GMV Max campaign report.
4. Include campaign ID, campaign name, store or shop identifier, date, cost, orders, cost per order, gross revenue, ROI, and campaign status.
5. Export daily rows, not only totals, if the data will feed Looker Studio, Google Sheets, or Power BI.
6. Add a load date column after import so the team can tell when the data was pulled.

Daily grain matters. A total-only export cannot power trend charts, delayed attribution checks, or backfills.

Do not mix GMV Max ROI with regular ad ROAS in the same chart without labeling the metric. TikTok's GMV Max attribution help says Product GMV Max attributes paid and organic orders for selected products while the campaign is running, including purchases without an ad engagement. That is a different reporting object from a website purchase campaign.

TikTok Ads to Looker Studio: when it makes sense

Looker Studio makes sense when the audience wants a lightweight, shareable dashboard instead of a full enterprise model. It is good for weekly campaign reviews, client reports, and channel snapshots.

The caveat: Looker Studio does not give you a first-party Google TikTok Ads connector the way it gives you Google-native connectors. Google's help lists Google connectors such as BigQuery, Google Sheets, Google Marketing Platform products, and file upload. TikTok Ads usually comes through Community or Partner connectors, which Google treats as third-party services.

Neutral examples include Coupler.io, Catchr, and Windsor.ai. Compare fields, refresh frequency, account limits, backfill, cost, support, and GMV Max coverage.

Use Looker Studio when:

Good fit	Poor fit
Weekly client or team reporting	Finance-grade net profit reporting
A few accounts or shops	Heavy cross-channel attribution modeling
Visual review and trend monitoring	Row-level data governance and audit trails
Fast dashboard setup	Complex incremental loads and warehouse joins

Keep calculated fields minimal. If the report needs heavy transformation, move that work upstream into the connector, a sheet, or a warehouse.

Connect TikTok Ads to Google Sheets: the lightweight weekly report path

Google Sheets is still the best first step for many teams. It is not glamorous, but it makes the reporting contract easy to audit.

The free manual route is simple:

1. Export CSV from TikTok Ads Manager.
2. Import it into a raw data tab in Google Sheets.
3. Never edit the raw tab by hand.
4. Build a cleaned tab with standardized column names.
5. Connect Looker Studio to the cleaned sheet if you need charts.

This route is cheap and honest, but it does not auto-refresh. It is acceptable for one weekly report, not for budget decisions twice a day.

With a connector, Sheets becomes a staging layer rather than a paste area. Agencies often like this because account managers can inspect rows before dashboards update. The tradeoff is cost and vendor dependency.

Connect TikTok Ads to Power BI: the enterprise dashboard path

Power BI is the better fit when TikTok is one part of a wider executive dashboard: spend, revenue, margin, inventory, marketplace sales, and customer cohorts. Microsoft lists Power Query connectors across supported services, but do not assume TikTok Ads is available as a native first-party connector in the standard list. Teams usually route TikTok Ads into Power BI through a third-party connector, spreadsheet staging, database, warehouse, or custom pipeline.

The Power BI path needs more upfront discipline:

Layer	What to decide
Source	TikTok Ads export, connector, sheet, database, or warehouse
Refresh	Manual weekly, scheduled daily, or multiple times per day
Model	Account, campaign, ad group, ad, shop, product, date
Currency	Original currency plus reporting currency if needed
Measures	Cost, orders, gross revenue, ROI, CPA, conversion rate, net ROI
Governance	Who owns mapping, refresh failures, and metric definitions

Power BI can sit closer to finance. The risk is a polished executive dashboard built on bad assumptions. Define the semantic model before designing pages.

Fields to standardize before you build any dashboard

Before you connect TikTok Ads to Looker Studio, Google Sheets, or Power BI, standardize the fields that cause arguments.

Start with these:

Field group	Standardize this	Why it matters
Identity	Advertiser ID, account name, shop or store ID, campaign ID	Names change; IDs keep joins stable
Time	Account timezone, reporting date, load date, date grain	A day in Ads Manager may not match a BI day
Currency	Spend currency, reporting currency, exchange rate source	Multi-market reports need one finance view
Campaign taxonomy	Market, shop, objective, product line, owner, test type	Naming errors become dashboard filters
Conversion logic	Event name, attribution window, source of truth	Conversion counts differ when events differ
GMV Max metrics	Cost, net cost if available, orders, cost per order, gross revenue, ROI	Gross ROI must not be mislabeled as net ROI
Profit logic	Commission, coupon, platform fee, refunds, shipping or COGS if used	Raw exports do not give you net ROI by default

If you cannot explain a field in one sentence, keep it out of the executive dashboard. Test it in the operating sheet first.

Attribution and delay caveats

GMV Max reporting has three traps that deserve labels inside the report, not just tribal knowledge.

First, Product GMV Max uses a short attribution window. TikTok's examples say a purchase within one day can be attributed while a purchase three days later will not. Exported sales can look low when buyers return later. The deeper guide is here: GMV Max attribution guide.

Second, GMV Max ROI should not be compared directly with regular campaign ROAS. Product GMV Max can attribute paid and organic orders for selected products while the campaign is running. A website conversion campaign is usually judged against a different event stream and attribution model. Put them in adjacent charts if you want, but label the metric definitions.

The subtler trap is net ROI: raw exports do not give it to you. The standard GMV Max view can show cost, orders, gross revenue, and ROI, but commissions, coupons, platform fees, refunds, shipping, and product margin still need your own calculation. If net ROI drives budget decisions, build that model explicitly. We covered threshold migration in the GMV Max net ROI rule guide.

Also expect delay. A dashboard can refresh before attribution settles. Keep a "last refreshed" timestamp and avoid treating today's GMV Max ROI as closed.

When manual exports stop working

Manual export is not wrong. It stops working when the cost of being late is higher than the cost of automation.

The signs are easy to spot:

Symptom	What it means
The team exports the same CSV more than twice a week	The report is operational, not just historical
Numbers differ between buyer sheet and founder dashboard	Metric definitions are not centralized
GMV Max is checked every morning for the same exceptions	The team needs monitoring rules, not another chart
A shop or market is missing from weekly reports	Manual scope control is failing
Budget changes depend on someone noticing a row	Reporting is not connected to action

This is the moment to choose. Cross-channel executive reporting needs a BI pipeline. GMV Max exception handling may need a see-and-act workflow instead.

How AdRate fits

AdRate is not a Looker Studio connector. It is not a Google Sheets connector. It is not a Power BI connector, CSV export tool, or public API layer.

AdRate fits a narrower use case: GMV Max teams that want to watch performance and trigger actions without building a BI pipeline. The product automatically syncs GMV Max daily reports hourly for the last 3 days, runs a fuller daily refresh for the last 7 days, and performs a first 30-day backfill when a subscription is created. Report data is retained for 180 days.

Inside that GMV Max workflow, AdRate supports multi-store summary views, trend charts, and campaign drill-down. Metrics include cost, net cost, orders, cost per order, gross revenue, and ROI, with LIVE GMV Max adding live-specific metrics such as live views. The important part is the loop: reporting metrics can directly drive automation rules, so the team can see and act in one surface. The broader philosophy is explained in our TikTok Ads automation rules guide.

That makes AdRate a GMV Max see-and-act alternative for teams that do not want a BI pipe just to catch recurring exceptions. It does not replace cross-channel BI. If leadership needs TikTok, Meta, Google, Shopify, finance, and inventory in one model, use a connector or warehouse pipeline.

FAQ

How do I export TikTok Ads reports?

Use Ads Manager reporting or a connector to export campaign, ad group, ad, creative, audience, and conversion data. Keep IDs, date, timezone, currency, cost, conversion, and revenue fields.

Can TikTok Ads connect to Looker Studio?

Yes, usually through third-party Partner or Community connectors rather than a Google first-party TikTok Ads connector. Common options include Coupler.io, Catchr, and Windsor.ai.

Can I connect TikTok Ads to Google Sheets?

Yes. Manual means CSV export into Sheets. Automated means a connector refreshes TikTok Ads data into a sheet. Manual is cheap; automated is more reliable when the report drives decisions.

Can I connect TikTok Ads to Power BI?

Yes, usually through a third-party connector, spreadsheet staging, database, warehouse, or custom pipeline. Define the data model before building visuals.

How do I export GMV Max campaign reports?

Filter for GMV Max or choose a GMV Max campaign report if your tool exposes it. Export daily rows with campaign ID, store ID, cost, orders, gross revenue, ROI, and status.

Why do TikTok Ads exports differ from my BI dashboard?

Common reasons are timezone mismatch, refresh timing, conversion delay, attribution windows, missing accounts, currency conversion, edited names, and mixing GMV Max gross ROI with net ROI.

What fields should a weekly TikTok Ads report include?

At minimum: date, account ID, campaign ID, campaign name, objective or ad type, cost, impressions, clicks, conversions, CPA or cost per order, revenue, ROAS or ROI, currency, timezone, and load date. For GMV Max, add store ID, gross revenue, orders, cost per order, ROI, and a note on attribution.