--- title: "TikTok Ads to Databricks Connector | OWOX" canonical: "https://www.owox.com/connectors/free-tiktok-ads-connector-to-databricks" updated: "2026-10-29" --- # Load TikTok Ads data into Databricks Send TikTok Ads campaigns, ad groups, ads and daily performance to Databricks with OWOX Data Marts: one table per endpoint, readable descriptions, a scheduled refresh. Join them with web analytics and CRM to see which videos led to deals. ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · Connected · Ad Groups · Ad Performance · Ad Performance b… · Ads Data Mart · Published · one definition ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Databricks · Date · Cost · ClicksDaily 09:00 Refreshed on a schedule. No exports, no copy-paste. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## TikTok Ads Endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/tik-tok-ads/readme/) 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 fields](/data-sources/tik-tok#schema-ad-groups) * [Ad Performance Daily ad performance — impressions, clicks, spend, conversions, video views, and engagement. 39 fields · Time series](/data-sources/tik-tok#schema-ad-performance) * [Ad Performance by Country Daily ad performance broken down by country — impressions, clicks, spend, conversions, and video views. 40 fields · Time series](/data-sources/tik-tok#schema-ad-performance-by-country) * [Ads Individual ads — creative type, format, call to action, status, and links to their campaigns and ad groups. 48 fields](/data-sources/tik-tok#schema-ads) * [Advertiser Account Advertiser account — name, company, and currency. 4 fields](/data-sources/tik-tok#schema-advertiser-account) * [Campaigns Your campaigns — objective, type, status, budget, and schedule. 34 fields](/data-sources/tik-tok#schema-campaigns) * [Custom Audiences Custom audiences — type, size, validity status, and expiration. 9 fields](/data-sources/tik-tok#schema-custom-audiences) ## S00 · Why ## Why join TikTok Ads with web analytics and CRM in Databricks TikTok Ads Manager shows spend, video views and the conversions TikTok counted. The purchase made later on your site lives elsewhere. Join spend, website touch points and CRM deals in one [data warehouse](/data-storages) to connect the two. * Put TikTok spend beside Facebook, Google and Microsoft Ads * Follow video views and clicks to the visits and deals after them * Keep video and engagement metrics next to cost in your tables ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · Video ad spend Web analytics · Visits, sign-ups CRM · Deals ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Your data warehouse · Databricks · Ad · Touch point · DealJoined by id · Video watched or clicked · Deal laterOne query links the ad to the deal. ## S01 · Step 1 ## Step 1: Connect TikTok Ads and choose what to load Create a Data Mart, choose TikTok Ads as the [data source](/data-sources), continue with TikTok or add an access token, list your advertiser ids and tick only the fields you need. * 7 endpoints and 217 fields to choose from * Ad Performance alone has 39 fields: spend, clicks, conversions, video views, likes, shares * Choose a data level for performance: ad, ad group, campaign or advertiser New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Cpath%20d%3D%22M16.3343%207.52231C16.7982%206.30445%2017.4362%205.18325%2018.3834%204.2747C22.1723%200.58247%2028.4355%201.51036%2031.0065%206.14981C32.9397%209.66805%2034.9887%2013.109%2036.9798%2016.5886C40.3048%2022.3685%2043.6684%2028.1485%2046.9546%2033.9478C49.719%2038.7999%2046.7227%2044.9278%2041.2327%2045.7591C37.8691%2046.2617%2034.7181%2044.7152%2032.9783%2041.6996C30.0593%2036.6155%2027.121%2031.5314%2024.202%2026.4667C24.144%2026.3507%2024.0667%2026.2541%2023.9894%2026.1574C23.6801%2025.9061%2023.5448%2025.5388%2023.3515%2025.2102C22.0563%2022.9291%2020.7224%2020.6674%2019.4273%2018.4057C18.596%2016.9365%2017.7261%2015.4867%2016.8949%2014.0175C16.141%2012.703%2015.793%2011.2725%2015.8317%209.76471C15.8897%208.99147%2015.9863%208.21823%2016.3343%207.52231Z%22%20fill%3D%22%233C8BD9%22%2F%3E%0A%3Cpath%20d%3D%22M16.3343%207.52246C16.1603%208.21838%2016.0057%208.91429%2015.967%209.64887C15.909%2011.2727%2016.315%2012.7805%2017.1269%2014.1917C19.2533%2017.8452%2021.3797%2021.5181%2023.4868%2025.191C23.6801%2025.5196%2023.8347%2025.8483%2024.028%2026.1576C22.8682%2028.168%2021.7083%2030.1591%2020.5291%2032.1695C18.9053%2034.9725%2017.2815%2037.7948%2015.6384%2040.5978C15.5611%2040.5978%2015.5417%2040.5592%2015.5224%2040.5012C15.5031%2040.3465%2015.5611%2040.2112%2015.5997%2040.0566C16.3923%2037.1569%2015.735%2034.5859%2013.7439%2032.3822C12.5261%2031.0483%2010.9796%2030.2944%209.20114%2030.0431C6.88142%2029.7145%204.83233%2030.3137%202.99588%2031.7636C2.66726%2032.0149%202.45462%2032.3822%202.068%2032.5755C1.99067%2032.5755%201.95201%2032.5368%201.93268%2032.4788C2.86057%2030.8743%203.76913%2029.2699%204.69702%2027.6654C8.52456%2021.0155%2012.3521%2014.3656%2016.199%207.7351C16.2376%207.65778%2016.2956%207.59979%2016.3343%207.52246Z%22%20fill%3D%22%23FABC04%22%2F%3E%0A%3Cpath%20d%3D%22M2.01%2032.5366C2.37729%2032.2079%202.72525%2031.86%203.11187%2031.5507C7.80931%2027.8391%2014.8651%2030.5261%2015.8897%2036.4028C16.141%2037.8139%2016.0057%2039.1671%2015.5804%2040.5203C15.561%2040.6363%2015.5417%2040.7329%2015.5031%2040.8489C15.3291%2041.1582%2015.1744%2041.4868%2014.9811%2041.7961C13.2607%2044.6378%2010.7283%2046.049%207.40336%2045.8363C3.59514%2045.5657%200.598834%2042.7047%200.0768961%2038.9158C-0.174407%2037.0794%200.192882%2035.3589%201.1401%2033.7738C1.33341%2033.4258%201.56539%2033.1165%201.77803%2032.7685C1.87468%2032.6912%201.83602%2032.5366%202.01%2032.5366Z%22%20fill%3D%22%2334A852%22%2F%3E%0A%3Cpath%20d%3D%22M2.00996%2032.5363C1.93263%2032.6136%201.93263%2032.7489%201.79732%2032.7683C1.77798%2032.633%201.85531%2032.5556%201.93263%2032.459L2.00996%2032.5363Z%22%20fill%3D%22%23FABC04%22%2F%3E%0A%3Cpath%20d%3D%22M15.5031%2040.8491C15.4258%2040.7138%2015.5031%2040.6172%2015.5804%2040.5205C15.5998%2040.5398%2015.6384%2040.5785%2015.6577%2040.5978L15.5031%2040.8491Z%22%20fill%3D%22%23E1C025%22%2F%3E%0A%3C%2Fsvg%3E%0A)Google Ads · ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · ![](data:image/svg+xml;utf8,%3Csvg%20viewBox%3D%220%200%2048%2048%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%3E%3Cpath%20fill%3D%22%23FF4500%22%20d%3D%22M24%2048c13.2548%200%2024-10.7452%2024-24S37.2548%200%2024%200%200%2010.7452%200%2024s10.7452%2024%2024%2024Z%22%2F%3E%3Cpath%20fill%3D%22%23fff%22%20d%3D%22M40.0082%2024.0013c-.0247-.6756-.2443-1.3296-.6323-1.8831-.388-.5536-.9278-.9831-1.5544-1.2368-.6266-.2537-1.3132-.3207-1.9771-.193-.6638.1277-1.2765.4448-1.7642.9129-2.7302-1.8559-5.9395-2.8812-9.24-2.952l1.56-7.488%205.136%201.08c.0611.5675.3224%201.0947.7371%201.487.4148.3922.9557.6238%201.5258.6531.5701.0293%201.132-.1455%201.5848-.4931.4528-.3476.7668-.8452.8858-1.4035s.0351-1.1407-.2366-1.6427c-.2718-.502-.7135-.89074-1.2461-1.09639-.5325-.20564-1.1208-.21475-1.6594-.0257-.5387.18906-.9922.56389-1.2794%201.05729l-5.88-1.17603c-.0962-.0211-.1956-.0229-.2924-.0053-.0969.0176-.1893.05425-.2719.10783-.0826.05357-.1537.12301-.2093.20429-.0556.08127-.0945.17281-.1144.26921l-1.776%208.328c-3.3411.0503-6.5945%201.0764-9.36%202.952-.37-.3481-.8112-.6117-1.2932-.7723-.4819-.1606-.993-.2145-1.4979-.158-.5048.0565-.9913.2222-1.42582.4854-.43447.2633-.80651.6178-1.09033%201.0392-.28383.4213-.47264.8993-.55337%201.4008-.08072.5016-.05142%201.0147.08587%201.5038.13729.4891.37928.9425.70922%201.3288.32993.3863.73991.6962%201.20153.9083-.027.3514-.027.7045%200%201.056%200%205.376%206.264%209.744%2013.992%209.744%207.728%200%2013.992-4.368%2013.992-9.744.027-.3515.027-.7046%200-1.056.5922-.2944%201.0891-.7504%201.4331-1.3152.344-.5649.5211-1.2155.5109-1.8768Zm-24%202.4c0-.4747.1408-.9387.4045-1.3334.2637-.3947.6385-.7023%201.0771-.8839.4385-.1817.9211-.2292%201.3866-.1366.4656.0926.8932.3212%201.2289.6568.3356.3357.5642.7633.6568%201.2289.0926.4655.0451.9481-.1366%201.3866-.1816.4386-.4893.8134-.8839%201.0771-.3947.2637-.8587.4045-1.3334.4045-.3152%200-.6273-.0621-.9184-.1827-.2912-.1206-.5558-.2974-.7787-.5203-.2228-.2228-.3996-.4874-.5202-.7786-.1206-.2912-.1827-.6033-.1827-.9184Zm13.944%206.696c-1.7027%201.2831-3.7977%201.8402-5.928%201.752-2.1303.0882-4.2253-.5649-5.928-1.848-.1021-.1244-.1542-.2822-.1463-.4429.0079-.1607.0752-.3127.189-.4264.1137-.1138.2657-.1812.4264-.1891.1607-.0078.3186.0443.4429.1464%201.443%201.0584%203.2043%201.5918%204.992%201.512%201.7899.0973%203.5595-.4192%205.016-1.464.1273-.1242.2987-.1926.4765-.1904.088.0011.175.0196.2559.0543.0809.0347.1541.085.2156.1481.0615.063.1099.1375.1426.2193.0326.0817.0489.1691.0477.2572-.0011.088-.0195.1749-.0542.2558-.0348.0809-.0851.1542-.1481.2157ZM29.5%2029.0005c-.4747%200-.9185-.244-1.3132-.5077-.3946-.2637-.7023-.6385-.8839-1.0771-.1817-.4385-.2292-.9211-.1366-1.3866.0926-.4656.3212-.8932.6568-1.2289.3357-.3356.7633-.5642%201.2289-.6568.4655-.0926.9481-.0451%201.3866.1366.4386.1816.8134.4892%201.0771.8839.2637.3947.4045.8587.4045%201.3334.013.3252-.0402.6496-.1565.9536-.1162.3039-.2931.5811-.5199.8145-.2267.2335-.4986.4184-.799.5436-.3004.1251-.6194.195-.9448.1915Z%22%2F%3E%3C%2Fsvg%3E)Reddit Ads · AuthorizeConnected · Endpoint · Ad Performance · Ad Groups · Ad Performance by… · Ads ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ad Performance · 39 fields · stat\_time\_dayspendimpressionsclicksconversionvideo\_views ## S02 · Step 2 ## Step 2: Load TikTok Ads into Databricks tables The catalog defaults to main, and the schema and table are pre-filled; change any of them. Run it and the first load, from the start of the previous month through today, lands in your own Databricks workspace. * Performance goes to a table such as tiktok\_ads\_ad\_insights * Several advertiser ids load into one table ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Destination · Databricks · Catalog · main · Schema · tiktok\_ads · Table · ad\_insights · Run Run History · Pending · Running · SuccessIncremental load ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Table · main.tiktok\_ads.ad\_insights ## S03 · Step 3 ## Step 3: Open the output schema in plain words The first run gives you the output schema: every field with an alias and a readable description, not an API identifier. Your [data quality](/product/data-quality) checks can read it too. * Video completion and engagement fields such as follows and profile visits are described in plain words * Teammates can query the table without the API reference ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)main.tiktok\_ads.ad\_insights · Output schema · Field · Descriptionstat\_time\_day · Statistics Date · spend · Spend · impressions · Impressions · clicks · Clicks · conversion · Conversions · video\_views · Video Views ## S04 · Step 4 ## Step 4: Keep the TikTok Ads tables linked Campaigns, ad groups, ads and performance stay separate tables, joined by ids. In SQL they become one TikTok Ads [data model](/product/data-modeling). * campaign\_id, adgroup\_id and ad\_id repeat down the levels * Pick the data level before the first load; to change it, start a new Data Mart or table ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Campaigns · campaign\_id · campaign\_name · objective ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ad Groups · adgroup\_id · adgroup\_name · optimization\_goal ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ads · ad\_id · campaign\_id · adgroup\_id ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ad Performance · ad\_id · spend ## S05 · Step 5 ## Step 5: Refresh on a schedule and backfill the history Set it once. A scheduled refresh keeps the Databricks tables current, and a manual run loads a past period of your choice. * A lookback window, 2 days by default, reloads recent days on each run * Backfills longer than 31 days run in consecutive segments Schedule · Run on a schedule · Daily 09:00 Backfill · Run backfill Run History · Daily schedule · Manual backfill · Daily schedule ## S06 · Step 6 ## Step 6: Reuse the Databricks tables in every tool One set of tables feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-assistants) like Claude and ChatGPT and AI insights in Slack or email. * Rank videos by cost and conversions in one view * Every report reads the same table ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · Data Mart · Published Blended ad spend ![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets ![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards ![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT ![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email ## Related connectors [TikTok Ads to Claude](/connectors/tiktok-ads-connector-to-claude)[Facebook Ads to Databricks](/connectors/free-facebook-ads-connector-to-databricks)[Google Ads to Databricks](/connectors/free-google-ads-connector-to-databricks)[TikTok Ads to ChatGPT](/connectors/tiktok-ads-connector-to-chatgpt)[Microsoft Ads to Databricks](/connectors/free-microsoft-ads-connector-to-databricks)[Bank of Canada to Databricks](/connectors/bank-of-canada-connector-to-databricks)[Criteo Ads to Databricks](/connectors/free-criteo-ads-connector-to-databricks)[LinkedIn Ads to Databricks](/connectors/free-linkedin-ads-connector-to-databricks)[LinkedIn Pages to Databricks](/connectors/free-linkedin-pages-connector-to-databricks) · Show 6 more · Show fewer ## Recent updates * [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog/#compare-linkedin-ads-results-across-markets-spend-by-country-region-and-county-0430) * [0.43.0 · The Sheet link of a Google Sheets source opens the imported tab, not the first one](https://docs.owox.com/docs/changelog/#the-sheet-link-of-a-google-sheets-source-opens-the-imported-tab-not-the-first-one-0430) * [0.43.0 · Connect a Google Sheets plan with one Google sign-in](https://docs.owox.com/docs/changelog/#connect-a-google-sheets-plan-with-one-google-sign-in-0430) * [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410) * [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410) ## Why OWOX ## Why OWOX for TikTok Ads in Databricks Databricks has connectors of its own, and plain API notebooks get TikTok data in too. OWOX adds control over the grain and how it reads. * **You own the data.** It lands in your own Databricks workspace, in tables you control. * **Your grain, your table.** Choose ad, ad group, campaign or advertiser level, and load a country breakdown as its own table. * **Described columns.** Video completion and engagement fields such as follows and profile visits carry plain-word descriptions. * **Joined by campaign, ad group and ad ids.** The tables arrive ready to meet web analytics and CRM in SQL. * **Maintained for you.** No jobs to repair when TikTok changes its API. * **Free to self-host.** The open-source OWOX Data Marts runs in your own infrastructure. [Book a call](/book-a-call) [Get Started Free](https://www.owox.com/app-signup) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [Documentation](https://docs.owox.com/packages/connectors/src/sources/tik-tok-ads/readme) - [Ad GroupsAd groups within your campaigns — bid strategy, optimization goal, placement, and targeting…](https://www.owox.com/data-sources/tik-tok) — /data-sources/tik-tok.md - [data warehouse](https://www.owox.com/data-storages) — /data-storages.md - [data source](https://www.owox.com/data-sources) — /data-sources.md - [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md - [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md - [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md - [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md - [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md - [TikTok Ads to Claude](https://www.owox.com/connectors/tiktok-ads-connector-to-claude) — /connectors/tiktok-ads-connector-to-claude.md - [Facebook Ads to Databricks](https://www.owox.com/connectors/free-facebook-ads-connector-to-databricks) — /connectors/free-facebook-ads-connector-to-databricks.md - [Google Ads to Databricks](https://www.owox.com/connectors/free-google-ads-connector-to-databricks) — /connectors/free-google-ads-connector-to-databricks.md - [TikTok Ads to ChatGPT](https://www.owox.com/connectors/tiktok-ads-connector-to-chatgpt) — /connectors/tiktok-ads-connector-to-chatgpt.md - [Microsoft Ads to Databricks](https://www.owox.com/connectors/free-microsoft-ads-connector-to-databricks) — /connectors/free-microsoft-ads-connector-to-databricks.md - [Bank of Canada to Databricks](https://www.owox.com/connectors/bank-of-canada-connector-to-databricks) — /connectors/bank-of-canada-connector-to-databricks.md - [Criteo Ads to Databricks](https://www.owox.com/connectors/free-criteo-ads-connector-to-databricks) — /connectors/free-criteo-ads-connector-to-databricks.md - [LinkedIn Ads to Databricks](https://www.owox.com/connectors/free-linkedin-ads-connector-to-databricks) — /connectors/free-linkedin-ads-connector-to-databricks.md - [LinkedIn Pages to Databricks](https://www.owox.com/connectors/free-linkedin-pages-connector-to-databricks) — /connectors/free-linkedin-pages-connector-to-databricks.md - [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog) - [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md