Connector

Ask TikTok Ads Questions in ChatGPT

Ask TikTok Ads questions in ChatGPT using OWOX Data Marts. Collect TikTok Ads data into a governed data mart, then get answers in ChatGPT via OWOX's MCP server — every number traces back to analyst-written SQL.

Get Started Free

Endpoints

TikTok Ads endpoints

7 TikTok Ads endpoints you can import. Each lands in its own table in your warehouse.

  • Ad Groups

    Ad groups within your campaigns — bid strategy, optimization goal, placement, and targeting schedule.

    45 fieldstiktok_ads_ad_groups

  • Ad Performance

    Daily ad performance — impressions, clicks, spend, conversions, video views, and engagement.

    39 fieldsTime seriestiktok_ads_ad_insights

  • Ad Performance by Country

    Daily ad performance broken down by country — impressions, clicks, spend, conversions, and video views.

    40 fieldsTime seriestiktok_ads_ad_insights_by_country

  • Ads

    Individual ads — creative type, format, call to action, status, and links to their campaigns and ad groups.

    46 fieldstiktok_ads_ads

  • Advertiser Account

    Advertiser account — name, company, and currency.

    4 fieldstiktok_ads_advertiser

  • Campaigns

    Your campaigns — objective, type, status, budget, and schedule.

    34 fieldstiktok_ads_campaigns

  • Custom Audiences

    Custom audiences — type, size, validity status, and expiration.

    9 fieldstiktok_ads_audiences

Data schema

TikTok Ads data schema

Ad Groups 45 fields · tiktok_ads_ad_groups
FieldTypeDescription
adgroup_idSTRINGAd Group ID
adgroup_nameSTRINGAd Group Name
advertiser_idSTRINGAdvertiser ID
campaign_idSTRINGCampaign ID
campaign_nameSTRINGCampaign Name
operation_statusSTRINGOperation Status
budgetNUMBERAd Group Budget
budget_modeSTRINGBudget Mode (BUDGET_MODE_DAY or BUDGET_MODE_TOTAL)
bid_typeSTRINGBidding Type
bid_priceNUMBERBid Price
optimization_goalSTRINGOptimization Goal
optimization_eventSTRINGOptimization Event
app_idSTRINGID of the app being promoted
app_typeSTRINGType of app
audience_typeSTRINGType of audience
audience_idsARRAYList of audience IDs
excluded_audience_idsARRAYList of excluded audience IDs
genderSTRINGTarget gender
age_groupsARRAYTarget age groups
languagesARRAYTarget languages
location_idsARRAYTarget location IDs
interest_category_idsARRAYInterest category IDs
placementsARRAYAd placements
placement_typeSTRINGType of placement
schedule_start_timeDATETIMESchedule Start Time
schedule_end_timeDATETIMESchedule End Time
schedule_typeSTRINGType of schedule
frequencyINTEGERFrequency cap
billing_eventSTRINGBilling Event Type
conversion_idSTRINGConversion ID
conversion_bid_priceNUMBERConversion Bid Price
conversion_windowINTEGERConversion Window
click_attribution_windowINTEGERClick Attribution Window
view_attribution_windowINTEGERView Attribution Window
is_smart_performance_campaignBOOLEANFlag indicating if the ad group uses smart performance optimization
is_new_structureBOOLEANFlag indicating if the ad group utilizes a new structure
auto_targeting_enabledBOOLEANFlag indicating if auto targeting is enabled
targeting_expansionOBJECTTargeting expansion settings
device_price_rangesARRAYTarget device price ranges
device_model_idsARRAYTarget device model IDs
operating_systemsARRAYTarget operating systems
network_typesARRAYTarget network types
carrier_idsARRAYTarget carrier IDs
create_timeDATETIMECreation Time
modify_timeDATETIMELast Modified Time
Ad Performance 39 fields · tiktok_ads_ad_insights
FieldTypeDescription
ad_idSTRINGAd ID
advertiser_idSTRINGAdvertiser ID
campaign_idSTRINGCampaign ID
adgroup_idSTRINGAd Group ID
stat_time_dayDATEStatistics Date
date_startDATEStart Date
date_endDATEEnd Date
impressionsINTEGERImpressions
clicksINTEGERClicks
costNUMBERCost
ctrNUMBERClick-Through Rate
conversionINTEGERConversions
cost_per_conversionNUMBERCost Per Conversion
conversion_rateNUMBERConversion Rate
reachINTEGERReach
engagementINTEGEREngagement
video_viewsINTEGERVideo Views
video_watched_2sINTEGER2s Video Views
video_watched_6sINTEGER6s Video Views
video_completionINTEGERVideo Completion
spendNUMBERSpend
cpcNUMBERCost per click
cpmNUMBERCost per thousand impressions
frequencyNUMBERFrequency of occurrence
video_play_actionsINTEGERNumber of video plays
video_views_p25INTEGERVideo views at 25% completion
video_views_p50INTEGERVideo views at 50% completion
video_views_p75INTEGERVideo views at 75% completion
video_views_p100INTEGERVideo views at 100% completion
profile_visitsINTEGERProfile visits
likesINTEGERLikes count
commentsINTEGERComments count
sharesINTEGERShares count
followsINTEGERFollows count
real_time_conversionINTEGERReal-time conversions
real_time_cost_per_conversionNUMBERCost per conversion in real-time
real_time_conversion_rateNUMBERReal-time conversion rate
resultINTEGERNumber of results
cost_per_resultNUMBERCost per result
Ad Performance by Country 40 fields · tiktok_ads_ad_insights_by_country
FieldTypeDescription
ad_idSTRINGAd ID
advertiser_idSTRINGAdvertiser ID
campaign_idSTRINGCampaign ID
adgroup_idSTRINGAd Group ID
country_codeSTRINGTwo-letter ISO country code (geographic breakdown dimension)
stat_time_dayDATEStatistics Date
date_startDATEStart Date
date_endDATEEnd Date
impressionsINTEGERImpressions
clicksINTEGERClicks
costNUMBERCost
ctrNUMBERClick-Through Rate
conversionINTEGERConversions
cost_per_conversionNUMBERCost Per Conversion
conversion_rateNUMBERConversion Rate
reachINTEGERReach
engagementINTEGEREngagement
video_viewsINTEGERVideo Views
video_watched_2sINTEGER2s Video Views
video_watched_6sINTEGER6s Video Views
video_completionINTEGERVideo Completion
spendNUMBERSpend
cpcNUMBERCost per click
cpmNUMBERCost per thousand impressions
frequencyNUMBERFrequency of occurrence
video_play_actionsINTEGERNumber of video plays
video_views_p25INTEGERVideo views at 25% completion
video_views_p50INTEGERVideo views at 50% completion
video_views_p75INTEGERVideo views at 75% completion
video_views_p100INTEGERVideo views at 100% completion
profile_visitsINTEGERProfile visits
likesINTEGERLikes count
commentsINTEGERComments count
sharesINTEGERShares count
followsINTEGERFollows count
real_time_conversionINTEGERReal-time conversions
real_time_cost_per_conversionNUMBERCost per conversion in real-time
real_time_conversion_rateNUMBERReal-time conversion rate
resultINTEGERNumber of results
cost_per_resultNUMBERCost per result
Ads 46 fields · tiktok_ads_ads
FieldTypeDescription
ad_idSTRINGAd ID
ad_nameSTRINGAd Name
advertiser_idSTRINGAdvertiser ID
campaign_idSTRINGCampaign ID
campaign_nameSTRINGCampaign Name
adgroup_idSTRINGAd Group ID
adgroup_nameSTRINGAd Group Name
operation_statusSTRINGOperation Status
secondary_statusSTRINGSecondary Status
create_timeDATETIMECreation Time
modify_timeDATETIMELast Modified Time
ad_textSTRINGAd Text/Caption
ad_textsARRAYMultiple Ad Text Variations
call_to_actionSTRINGCall To Action Text
call_to_action_idSTRINGCall To Action ID
image_idsARRAYImage IDs Used in the Ad
video_idSTRINGVideo ID Used in the Ad
image_modeSTRINGImage Display Mode
creative_typeSTRINGType of Creative (video, image, etc.)
ad_formatSTRINGFormat of the Ad
landing_page_urlSTRINGLanding Page URL
landing_page_urlsARRAYMultiple Landing Page URLs
deeplinkSTRINGDeep Link URL
deeplink_typeSTRINGType of Deep Link
tracking_pixel_idSTRINGPixel ID for Tracking
impression_tracking_urlSTRINGURL for Impression Tracking
click_tracking_urlSTRINGURL for Click Tracking
video_view_tracking_urlSTRINGURL for Video View Tracking
is_new_structureBOOLEANFlag indicating new ad structure
is_acoBOOLEANFlag indicating Automated Creative Opt.
optimization_eventSTRINGEvent being optimized for
catalog_idSTRINGProduct Catalog ID
product_set_idSTRINGProduct Set ID
sku_idsARRAYSKU IDs for Products
domainSTRINGDomain for the Ad
display_nameSTRINGDisplay Name shown in the Ad
profile_image_urlSTRINGURL for Profile Image
app_nameSTRINGName of the App being promoted
tracking_app_idSTRINGApp ID for Tracking
identity_idSTRINGIdentity ID
identity_typeSTRINGType of Identity
page_idSTRINGTikTok Page ID
tiktok_item_idSTRINGTikTok Item ID
disclaimer_typeSTRINGType of Disclaimer
disclaimer_textSTRINGDisclaimer Text
utm_paramsOBJECTUTM Parameters
Advertiser Account 4 fields · tiktok_ads_advertiser
FieldTypeDescription
advertiser_idSTRINGAdvertiser ID
advertiser_nameSTRINGAdvertiser Name
company_nameSTRINGCompany Name
currencySTRINGAccount Currency
Campaigns 34 fields · tiktok_ads_campaigns
FieldTypeDescription
advertiser_idSTRINGAdvertiser ID
campaign_idSTRINGCampaign ID
campaign_nameSTRINGCampaign Name
app_promotion_typeSTRINGType of app promotion being used in the campaign
operation_statusSTRINGOperation Status
bid_typeSTRINGType of bid strategy being used in the campaign
roas_bidNUMBERReturn on ad spend bid target
is_advanced_dedicated_campaignBOOLEANFlag indicating if this is an advanced dedicated campaign
is_search_campaignBOOLEANFlag indicating if the campaign is for search ads
rf_campaign_typeSTRINGReach and frequency campaign type
rta_bid_enabledBOOLEANFlag indicating if RTA bidding is enabled
secondary_statusSTRINGAdditional status information of the campaign
postback_window_modeSTRINGMode for the postback window
disable_skan_campaignBOOLEANFlag indicating if SKAdNetwork is disabled for the campaign
budget_optimize_onBOOLEANThe metric or event that the budget optimization is based on
budget_modeSTRINGBudget Mode (BUDGET_MODE_DAY or BUDGET_MODE_TOTAL)
objectiveSTRINGCampaign Objective
campaign_product_sourceSTRINGSource of products for the campaign
optimization_goalSTRINGSpecific goal to be optimized for in the campaign
special_industriesSTRINGSpecial industries classification for the campaign
deep_bid_typeSTRINGType of deep bidding strategy
rta_idSTRINGReal-time advertising ID
rta_product_selection_enabledBOOLEANFlag indicating if RTA product selection is enabled
budgetNUMBERCampaign Budget
is_new_structureBOOLEANFlag indicating if the campaign utilizes a new campaign structure
is_smart_performance_campaignBOOLEANFlag indicating if the campaign uses smart performance optimization
modify_timeDATETIMELast Modified Time
app_idSTRINGID of the app being promoted
objective_typeSTRINGType of objective selected for the campaign (e.g., brand awareness, app installs)
campaign_typeSTRINGType of campaign (e.g., awareness, conversion)
campaign_app_profile_page_stateSTRINGApp profile page state for app campaigns
create_timeDATETIMECreation Time
catalog_enabledBOOLEANFlag indicating if product catalog is enabled
bid_align_typeSTRINGType of bid alignment
Custom Audiences 9 fields · tiktok_ads_audiences
FieldTypeDescription
audience_idSTRINGUnique identifier for the audience
advertiser_idSTRINGAdvertiser ID
nameSTRINGName of the audience
audience_typeSTRINGType of audience (e.g., demographic, interest-based)
cover_numINTEGERNumber of audience members covered
create_timeDATETIMETimestamp indicating when the audience was created
is_validBOOLEANFlag indicating if the audience data is valid
is_expiringBOOLEANFlag indicating if the audience data is expiring soon
expired_timeDATETIMETimestamp indicating when the audience data expires

In ChatGPT

Ask TikTok Ads questions in ChatGPT

You

How did TikTok spend and conversions move day by day this month?

ChatGPT

From Ad Performance (tiktok_ads_ad_insights) I summed spend and conversion by stat_time_day for this month, with cost_per_conversion for each day so a jump in cost is easy to spot.

This comes from your governed TikTok Ads Data Mart through the OWOX MCP server, so it is as fresh as that Data Mart's last scheduled refresh.

You

Are people watching the videos to the end?

ChatGPT

video_views and video_completion for the same days show how many views reach the end. Comparing video_watched_2s with video_watched_6s shows how quickly viewers drop off in the first seconds.

Trust

Data Partner You Can Trust

users

175K

Executives and data analysts across 20+ industries

G2 rating

4.9★

“A trusted data analytics partner” — verified review

npm installs

156K

In Open Source We Trust

Customers

What users are saying

Every claim has a receipt.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3re: trusting AI
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
C9re: one source of truth
Mark SimmonsMark SimmonsCMO, Pürblack®
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
E7re: getting time back
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“We regained time. And time is the one resource that never comes back.”

Turn TikTok Ads Data into Answers in ChatGPT

See how OWOX Data Marts helps you ask TikTok Ads questions in ChatGPT, blend it with other sources, and scale reporting without rebuilding logic.

Get Started Free