Pull TikTok Ads data into Microsoft Excel
TikTok shows views and clicks; Excel needs orders. Load TikTok Ads into your data warehouse, link spend to sessions and orders, and pull the Data Mart into a workbook the creative team can open.
TikTok AdsConnectedAd GroupsAd PerformanceAd Performance b…Ads
Microsoft ExcelDateCostClicksDaily 09:00TikTok Ads reports views and clicks, while the creative team's Microsoft Excel review needs orders.
Paste this into your AI assistant. It loads TikTok Ads into your data warehouse with OWOX Data Marts, links spend to sessions and orders, and pulls the Data Mart into a Microsoft Excel workbook.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/tiktok-ads-connector-to-microsoft-excel.md. The task: pull a TikTok Ads Data Mart into a Microsoft Excel workbook for our creative team with spend, views, sessions and orders by campaign and ad, from our data warehouse. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
TikTok Ads Endpoints
7 TikTok Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Groups
Ad groups within your campaigns — bid strategy, optimization goal, placement, and targeting schedule.
45 fieldsAd Performance
Daily ad performance — impressions, clicks, spend, conversions, video views, and engagement.
39 fieldsTime seriesAd Performance by Country
Daily ad performance broken down by country — impressions, clicks, spend, conversions, and video views.
40 fieldsTime seriesAds
Individual ads — creative type, format, call to action, status, and links to their campaigns and ad groups.
48 fieldsAdvertiser Account
Advertiser account — name, company, and currency.
4 fieldsCampaigns
Your campaigns — objective, type, status, budget, and schedule.
34 fieldsCustom Audiences
Custom audiences — type, size, validity status, and expiration.
9 fields
Why TikTok Ads does not go straight to Excel
TikTok Ads can be exported to Excel, but not reliably, at scale or business-ready. The file counts views and platform conversions, and nothing in it says which video led to a paying customer. The data warehouse joins the cost to sessions and orders first.
- TikTok Ads reports views and conversions, not what a customer was worth
- The data analyst links ad spend to sessions and orders by SQL keys
- Creative and finance read the same workbook
TikTok AdsAd spendMicrosoft Exc…
Data warehouseJoined by idStep 1: Load TikTok Ads into your data warehouse first
Create a Data Mart with TikTok Ads as the source and choose where the data lands. Any popular warehouse works.
- 7 endpoints and 217 fields; Ad Performance feeds the workbook
- Ad Performance, plus a by-country table, next to ad, ad group and campaign tables
- Open the TikTok Ads connector for your data warehouse below
TikTok AdsData MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databrickstiktok_ads.ad_insightsStep 2: Link TikTok Ads to sessions and orders
In your data warehouse the model merges TikTok Ads with Facebook Ads and Google Ads, then joins sessions and orders by a campaign key. Pick an industry to see the shape of its model.
- Short-video spend joins the same table as search and social
- Sessions and orders join by SQL keys, not by a screenshot
- Measures such as platform_roas have one definition
TikTok AdsAd Performance
Facebook AdsAd spend
Google AdsAd spendStep 3: Pull TikTok Ads data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published TikTok Ads Data Mart (Ad Performance), tick the columns you want and press Create & Run.
- Pick stat_time_day, spend and conversion; add cost_per_conversion if wanted
- The workbook reads the data warehouse, so no TikTok token travels with it
Microsoft ExcelYour columns staystat_time_dayspendimpressionsStep 4: Refresh the TikTok Ads workbook when you need it
Refresh when the creative review starts. The imported columns update and your own scoring column stays where it is.
- Your ranking formula sits beside spend and survives
- Refresh is manual, so a pause costs nothing
Microsoft ExcelYour column staysstat_time…spendimpressio…YoursStep 5: Reuse TikTok Ads inside OWOX MCP
TikTok Ads reaches beyond the workbook in OWOX MCP, your assistant for data. Request any report, chat with it, then open it in Google Sheets or Excel in one click.
- Ask which country returns the most per dollar
- Same platform_roas in chat and workbook
Google SheetsOpenExcelOpen
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Short links resolve only on known short link services and domains you allow
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
Why OWOX for TikTok Ads in Excel
Ad-manager exports give Excel a file per account. OWOX gives it a Data Mart where TikTok cost meets orders.
- Creative spend meets orders. Ad cost joins sessions and orders in your data warehouse, so a video is judged on revenue.
- Pick the grain you need. Seven endpoints, each a table: Ad Performance, Ad Performance by Country and the entity tables.
- Pull on demand. The add-in refreshes imported columns and leaves yours.
- Maintained for you. When TikTok changes its reporting API, the connector is updated, not your workbook.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.