Ask Claude about your TikTok Ads data
Compare TikTok Ads spend with every other channel by SQL keys in your data warehouse, then ask Claude which campaigns drive sessions and orders. The answers come from your governed Data Marts.
TikTok AdsConnectedAd GroupsAd PerformanceAd Performance b…Ads
ClaudeDateCostClicksDaily 09:00Some countries take TikTok Ads budget without converting, and spotting them means sorting exports by hand.
Paste this into your AI assistant. It loads TikTok Ads performance by country into a governed Data Mart with OWOX Data Marts and connects Claude through the OWOX MCP server, so country rankings come from SQL.
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-claude.md. The task: connect Claude to our TikTok Ads Data Mart and rank countries by conversion rate, then show where cost per conversion is highest, with spend and reach beside each country. 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 Claude
Claude can read an ad account, but that shows what TikTok Ads spent per ad, not the orders in your store. Spend, sessions and orders sit in separate systems, and a chat is not built to join them reliably, at scale or business-ready, so the join belongs in a warehouse first.
- TikTok Ads reports views and clicks, not what a customer was worth
- The data analyst ties ad spend to sessions and orders by SQL keys and controls the result
- Claude answers from that tied data, not from one ad platform
TikTok AdsAd spendClaude
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. It works with any popular data warehouse.
- 7 endpoints and 217 fields to choose from, each endpoint in its own table
- Daily performance per ad and by country, with ad group and campaign IDs to roll up
- 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 your other ad platforms, then joins web analytics by date, source and medium. Pick an industry to see the shape of its model.
- TikTok Ads spend lines up with every other platform in one table
- Orders reach spend through sessions, joined by SQL keys, not VLOOKUP and gut feeling
- Measures such as platform_cpa are defined once
TikTok AdsAd Performance
Facebook AdsAd spend
Google AdsAd spendStep 3: Connect Claude to your TikTok Ads data with OWOX MCP
Add the OWOX MCP server in Claude under Settings > Connectors > Add custom connector. Claude then sees the Data Marts you publish and queries them through MCP.
- Settings > Connectors > Add custom connector, paste the OWOX MCP URL and sign in
- Claude sees only the Data Marts you publish
ClaudeConnectorsOWOX MCPAddConnectedStep 4: Ask Claude which campaigns in TikTok Ads earn their spend
Ask in plain words. Claude finds the right Data Mart and queries it, so the numbers come from your data warehouse and not from a guess.
- Ask about a campaign or a channel in plain words
- The answer joins TikTok Ads spend to sessions and orders, with measure names shown
ClaudeWhich channel has the lowest platform_cpa?get_relevant_data_marts_by_promptquery_data_martplatform_cpaconversion_rateStep 5: Export the answer to Google Sheets, CSV or XLS
Optional: in one click send Claude's answer, or the data behind it, to Google Sheets, CSV or XLS to check it or share it.
- Verify the answer in a sheet before it goes to stakeholders
- One Data Mart feeds the chat, the sheet and the file
Google SheetsCSVXLSOne click
- 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.36.0Support MCP protocol 2026-07-28 and alert on compatibility failures
Why OWOX for TikTok Ads in Claude
An ad-account connection gives Claude TikTok Ads numbers alone. OWOX gives it spend, sessions and orders together, from your own data warehouse.
- You own the data. It lands in your own data warehouse, in tables you control.
- Answers about the whole business. Ad spend, web analytics, orders and leads are linked, not copied from an ad account.
- Zero hallucinations on your data. Claude answers from governed Data Marts and shows the measure names it used.
- Campaign spend in context. TikTok Ads spend by campaign sits next to every other paid channel in one model.
- Maintained for you. No scripts to fix when TikTok changes its API.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.