How to Connect TikTok Ads to Databricks

TikTok Ads generates performance data that most analytics teams never see in full – video view rates, Spark Ads engagement, audience breakdowns by interest and behavior – but it all stays trapped inside TikTok Ads Manager. 

Getting that data into Databricks where you can join it with other paid channels and run proper cross-platform analysis is typically a custom API integration project, and TikTok's API makes it harder than most.

It doesn't have to be. This guide shows you how to collect TikTok Ads data to Databricks in about 2 minutes using OWOX – an open-source connector platform that handles api access, schema mapping, and incremental loads automatically. As well as many other reporting workflows. No custom scripts, no token management, no maintenance.

What you'll need before you start

TikTok's connector has more prerequisites than most ad platforms. 

Databricks workspace access

You need an active Databricks workspace with permissions to create tables and run queries. Gather these three values before you start:

• Workspace URL – the full URL of your Databricks deployment (e.g., https://dbc-abc123.cloud.databricks.com)
• SQL Warehouse HTTP path – found under SQL Warehouses → your warehouse → Connection Details
• Personal Access Token (PAT) – generate one from User Settings → Developer → Access Tokens

If you're on a Databricks trial, everything works the same way. Just make sure your SQL Warehouse is running when you configure the connection.

TikTok Ads credentials

You need a TikTok Ads account connected to a TikTok Business Manager. It’s absolutely the same as for platforms like Google Ads or Facebook Ads. 

OWOX uses OAuth authentication – you sign in with your TikTok Ads account and authorize access. No long-lived tokens to generate, no app IDs to configure manually.

Make sure the TikTok account user you'll authenticate with has at least Advertiser or Admin access to the ad account you want to connect.

OWOX account

Sign up at owox.com/app-signup if you don't have one yet. The free tier includes connectors and enough data volume to get started.

Step 1: Configure Databricks as your storage in OWOX

The first step is telling OWOX where to write data. You'll register your Databricks workspace as a storage destination so that every connector you set up later writes to the same place.

Log into your OWOX account and navigate to Settings → Storages.

‍

Click Add Storage and select Databricks from the list of supported warehouses.

Enter your Databricks connection details

Fill in the three values you gathered in the prerequisites:

‍

‍

Click Save to verify everything works. OWOX will now use this Databricks workspace as the target for all connectors you configure.

Troubleshooting tip: If the connection test fails, check that your SQL Warehouse is in a Running state. Databricks auto-suspends idle warehouses, and a stopped warehouse will reject connection attempts.. 

Step 2: Create a new data mart with the TikTok Ads connector

Now that Databricks is connected as your storage you can set up the actual data pipeline. In OWOX, every data pipeline lives inside a Data Mart – a logical container that defines what data to pull, from where, and on what schedule. 

Navigate to the Data Marts section and click Create New Data Mart.

Select the TikTok Ads connector

Select Input Source - Connector. Then from the connector library, select TikTok Ads. OWOX supports dozens of data sources – advertising platforms, CRMs, analytics tools – but for this guide, we're focusing on TikTok Ads. 

Authorize with TikTok Ads OAuth

Click Continue with TikTok. A standard TikTok OAuth window will appear – sign in with your TikTok account that has access to the ad account and grant OWOX the requested permissions.

‍

Paste in your advertiser ID(s) separated by comas and click Next to proceed to the next step. OWOX validates the credentials by making a test API call to TikTok's Marketing API.

Step 3: Choose your API endpoints and fields

This is where you decide exactly what TikTok data flows into Databricks. OWOX exposes the TikTok Marketing API surface – you pick the resources and fields that matter for your reporting.

Select endpoints

Each endpoint corresponds to a TikTok Marketing API resource and creates a separate table in your Databricks catalog.

‍

Common endpoint selections for TikTok Ads analytics:

• Ad Insights - ad-level performance metrics (impressions, clicks, spend, conversions, video views) broken down by date and dimension
• Campaigns – campaign-level settings, objectives (traffic, conversions, reach), budget type, and status
• Ad Groups – targeting parameters (age, gender, interests, behaviors), placement settings, bidding strategy, and schedule
• Ads – individual ad creative references, format type (In-Feed, TopView, Spark Ads), status, and call-to-action
• Ads Insights by Country
• Audiences

Select fields within each endpoint

For selected endpoint, choose which fields (columns) to import. OWOX selects the most commonly used fields by default, but you can customize this.

‍

TikTok's API includes metrics you won't find on other platforms – 6-second focused views, video completion rates by quartile, profile visits from ads, and Spark Ads engagement (likes, shares, comments on organic posts promoted as ads). If you're running video-heavy campaigns, make sure to include these fields.

Pro tip: Start with the defaults and iterate. TikTok's API has hundreds of fields per endpoint – importing everything creates wide, sparse tables. Focus on the metrics and dimensions you'll actually query.

Step 4: Configure the destination and schedule

With endpoints and fields selected, tell OWOX where to write the data in Databricks and how often to refresh it.

Set the Databricks destination

Choose the catalog, schema (database), and table prefix for your TikTok Ads data. Since you already configured Databricks as your storage in Step 1, these options will be available in the dropdown.

‍

A clean naming convention keeps things organized:

• Schema: tiktok_ads or marketing_raw
• Table prefix: tt_ – so your tables become tt_campaigns, tt_ad_groups, tt_ads, etc.

Step 5: Publish and run your first import

Everything is configured. Time to launch.

Publish the data mart

Click Publish & Run to activate your data mart. This saves all settings and makes the pipeline ready to run.

Trigger the backfill run

After publishing, you have two options:

• Incremental load – pulls the current day's data plus any days within the reimport lookback window
• Backfill (custom period) – pulls historical data for a date range you specify

For the next run, use Backfill to load your historical TikTok Ads data. Select the start and end dates and click Run.

‍

The initial import duration depends on your data volume:

• Small accounts (< 10 campaigns, < 1 year of data) – a few minutes
• Medium accounts (50–100 campaigns, 2–3 years) – 10–30 minutes
• Large accounts (hundreds of campaigns, heavy video ad spend) – up to a few hours

You can monitor progress on the data mart page. OWOX shows import status, row counts, and any errors in real time.

Set the refresh schedule and lookback window

OWOX supports daily, hourly, and custom cron schedules. For TikTok Ads, daily works well for most teams.

‍

Note: TikTok's connector also has a Reimport Lookback Window setting – this controls how many previous days get re-imported with each incremental load. TikTok's attribution can adjust conversion data retroactively, so setting this to 3-7 days ensures you always have accurate numbers even when TikTok recalculates conversions from earlier in the week.

Step 6: Verify your data in Databricks

Once the import completes, head to your Databricks workspace and confirm the data landed correctly.

Run a quick validation query

Open a SQL Editor or notebook in Databricks and run a basic check:

1-- Check that tables were created
2SHOW TABLES IN your_catalog.tiktok_ads;
3
4-- Preview campaign performance
5SELECT
6  campaign_name,
7  objective_type,
8  impressions,
9  clicks,
10  spend,
11  conversions,
12  stat_datetime
13FROM your_catalog.tiktok_ads.tt_reporting
14WHERE stat_datetime >= CURRENT_DATE - INTERVAL 7 DAYS
15ORDER BY spend DESC
16LIMIT 20;

‍

If you see your campaign names, metrics, and recent dates – you're set. The data is now in your Databricks Lakehouse and ready for analysis.

Check video-specific metrics

TikTok is a video-first platform, so verify that video engagement data came through:

1SELECT
2  ad_name,
3  impressions,
4  video_play_actions,
5  video_watched_6s,
6  video_watched_p25,
7  video_watched_p50,
8  video_watched_p75,
9  video_watched_p100,
10  profile_visits_rate
11FROM your_catalog.tiktok_ads.tt_reporting
12WHERE video_play_actions > 0
13ORDER BY video_play_actions DESC
14LIMIT 10;

‍

These video completion metrics – 6-second views, quartile watch rates, and profile visit rate – are unique to TikTok and critical for evaluating creative performance. If these columns are populated, your pipeline is working correctly.

Why collect TikTok Ads data in Databricks?

TikTok is now the fastest-growing paid channel for many consumer and e-commerce brands, but its analytics capabilities inside Ads Manager are surprisingly limited compared to the size of ad budgets flowing through the platform. Here's why centralizing TikTok data in Databricks matters.

TikTok Ads Manager shows you surface-level metrics

TikTok's native reporting gives you impressions, clicks, and conversions – but everything stays in a silo. You can't correlate TikTok spend with downstream revenue from your CRM, join TikTok audience data with product analytics, or compare creative performance across TikTok, Facebook, and Google in a single query.

The moment you need to answer "what's the true cost per acquired customer from TikTok vs. Meta?" or "which TikTok audiences convert to repeat buyers?" – you need the raw data in your data warehouse, not in TikTok's UI.

TikTok's video-centric metrics need deeper analysis

TikTok generates metrics that don't exist on other platforms – 6-second focused views, video completion by quartile, Spark Ads engagement (likes, comments, shares on boosted organic posts), and profile visit rates. These metrics are gold for understanding creative fatigue and content resonance, but TikTok Ads Manager doesn't let you analyze them at scale or combine them with conversion data from other systems.

In Databricks, you can build models that predict when a creative will fatigue based on declining completion rates, or identify which content themes drive the highest downstream LTV – analysis that's impossible inside TikTok's walled garden.

Your Databricks Lakehouse is already the single source of truth

If your team already uses Databricks for product, sales, and analytics data, adding TikTok Ads to the same Lakehouse keeps everything in one place – governed, versioned, and queryable with the same tools your analysts already use. No more exporting CSVs from TikTok Ads Manager and pasting them into spreadsheets.

When TikTok spend data lands in the same catalog as your revenue tables, building a proper multi-touch attribution model that includes TikTok alongside Google Ads, Facebook Ads, LinkedIn Ads, and other channels is just SQL.

How OWOX Data Marts enable self-service analytics on TikTok Ads data

Raw TikTok Ads data in Databricks is powerful – but raw API tables with hundreds of columns and cryptic field names aren't something a marketing manager or creative strategist can work with directly. This is exactly the gap [OWOX Data Marts](https://www.owox.com/product-features/data-mart-management) fill.

What are OWOX Data Marts?

A Data Mart is a reusable, SQL-defined analytical dataset that sits on top of your Databricks tables. Analysts write the SQL logic once – defining metrics, joins, filters, and business rules – and publish it as a clean, governed dataset. Business users then pull reports from that data mart into Google Sheets, Looker Studio, or any BI tool without touching SQL or waiting on the data team.

Think of it as a contract between analysts and business users: the analyst guarantees the logic is correct and the data is fresh; the business user gets self-service access to explore it freely.

Practical examples with TikTok Ads data

Once your TikTok data lands in Databricks, you can build data marts like:

• Video creative performance dashboard – creative teams see completion rates, 6-second view rates, and engagement metrics for every ad variation. Refreshed daily, available in Google Sheets without touching SQL
• Cross-channel spend and ROAS comparison – a single data mart that joins TikTok, Facebook, Google, and LinkedIn spend with CRM revenue data, giving leadership a blended CAC view filterable by channel, region, or product line
• Spark Ads organic uplift tracker – measures how promoted organic posts perform vs. standard in-feed ads, tracking both paid metrics and organic engagement growth
• Audience performance by interest segment – tracks which TikTok interest and behavior targeting segments deliver the best cost-per-conversion, not just clicks

Each of these data marts auto-refreshes on the schedule you set, and business users can slice the data through familiar tools. No more "can you pull this for me?" tickets in your analytics backlog.

Creative fatigue detection at scale

TikTok creatives burn out faster than on any other platform – the algorithm rewards novelty, and ad fatigue sets in within days, not weeks. With raw TikTok data in Databricks and OWOX Data Marts on top, you can build a creative fatigue model that tracks day-over-day changes in video completion rates, CTR, and CPA per creative. When metrics cross a threshold, your data mart flags it – giving your creative team a head start on producing replacement assets before ROAS degrades.

Sign up for OWOX to start building data marts on top of your Databricks tables.

The open-source advantage

OWOX connectors are fully open-source. The TikTok Ads connector code is available on GitHub under an open license.

This matters in practice. If you need a TikTok Marketing API field that isn't exposed in the UI, a custom breakdown dimension, or a new endpoint – you can fork the repository, add it, and submit a pull request. Contributor guides are in the repo.

For enterprise teams, this means:

• Audit the code – see exactly what API calls are made and how data is transformed
• Extend functionality – add new endpoints, custom breakdowns, or post-processing logic
• Self-host if needed – run connectors in your own infrastructure with the Self-Managed Edition (though the Cloud Edition handles everything for most teams)

This fork-and-extend model is especially valuable for data teams in regulated industries or those with strict data governance requirements.

Troubleshooting common issues

TikTok's connector has a few unique failure modes compared to other ad platforms. Here are the most common issues and fixes.

Connection test fails

Problem: OWOX can't reach your Databricks workspace.

Check:

• Is your SQL Warehouse running? Databricks auto-suspends idle warehouses
• Is the workspace URL correct, including the full https:// prefix?
• Is your Personal Access Token still valid? Tokens can expire based on your org's policies
• Are there network restrictions (IP allowlists, private endpoints) blocking external access?

TikTok access token is rejected

Problem: OWOX reports an authentication error when connecting to TikTok.

Check:

• Has your access token expired? TikTok tokens are long-lived but not permanent – regenerate one if it's been months since the initial setup
• Is the App ID correct? Copy it directly from the TikTok Developer Portal – don't type it manually
• Is the App Secret the right one? If you've regenerated secrets, the old one no longer works
• Is your TikTok developer app still in approved status? Apps can be suspended if TikTok detects policy violations

TikTok developer app not approved

Problem: You submitted your app for review but it was rejected or is still pending.

Check:

• Was your App Description specific enough? TikTok rejects vague descriptions. Explain exactly how you'll use the API (e.g., "importing ad performance data into a data warehouse for marketing analytics")
• Did you select the correct permissions scope? Request only the read-only scopes you actually need
• Approval can take up to 7 business days – wait for the confirmation email before retrying

Missing data or empty tables

Problem: Tables exist in Databricks but contain no rows.

Check:

• Does the ad account have data for the selected date range? New accounts may have no historical data
• Did you enter the correct Advertiser ID? If you manage multiple ad accounts, double-check you selected the right one
• Check the data mart run logs in OWOX for error details – they'll show which API calls failed and why
• TikTok's Marketing API has rate limits – very large accounts may need multiple runs to complete the initial backfill
• Verify the Reimport Lookback Window setting if recent data appears missing – a window that's too narrow may skip days with attribution updates

Key takeaways

Connecting TikTok Ads to Databricks takes more setup than Google or Facebook because of TikTok's developer app requirement – but once the credentials are in place, OWOX handles everything else. The actual connector configuration takes about 10 minutes after your TikTok app is approved.

With your TikTok Ads data in Databricks, you unlock analysis that's impossible inside TikTok's native reporting: cross-channel attribution, creative fatigue modeling, video completion analysis at scale, and integration with your CRM and product data. And because the connectors are open-source, your data team keeps full control.

Ready to get your TikTok Ads data into Databricks? Sign up for OWOX and follow the steps above – you'll be querying TikTok campaign data in your Lakehouse as soon as your developer app is approved.