Ask ChatGPT about your TikTok Ads data
Compare TikTok Ads spend with every other channel by SQL keys in your data warehouse, then ask ChatGPT which campaigns drive sessions and orders. The answers come from your governed Data Marts.
TikTok AdsConnectedAd GroupsAd PerformanceAd Performance b…Ads
ChatGPTDateCostClicksDaily 09:00TikTok Ads cost per conversion jumps on some days, and ChatGPT can't see why from a screenshot.
Paste this into your AI assistant. It loads TikTok Ads into a governed Data Mart with OWOX Data Marts and connects ChatGPT through the OWOX MCP server, so daily spend, conversions and video views 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-chatgpt.md. The task: connect ChatGPT to our TikTok Ads Data Mart and show me spend, conversions and cost per conversion by day this month, with how many video views reached the end. 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 ChatGPT
ChatGPT 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
- ChatGPT answers from that tied data, not from one ad platform
TikTok AdsAd spendChatGPT
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 ChatGPT to your TikTok Ads data with OWOX MCP
Install the "OWOX Data Marts" plugin in ChatGPT (Plugins > Install plugin) and sign in. ChatGPT then sees the Data Marts you publish and queries them through MCP.
- Plugins > Install plugin, find "OWOX Data Marts" and sign in
- ChatGPT sees only the Data Marts you publish
ChatGPTConnectorsOWOX MCPAddConnectedStep 4: Ask ChatGPT which campaigns in TikTok Ads earn their spend
Ask in plain words. ChatGPT 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
ChatGPTWhich 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 ChatGPT'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.0Resolve short links in every ads connector, with nested paths and a per-Data-Mart cache
Why OWOX for TikTok Ads in ChatGPT
An ad-account connection gives ChatGPT 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. ChatGPT 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.