Trusted, proven, recognized

The analytics system teams actually use

170K+
Users trust OWOX[1]
Analysts, marketers, and data teams across 20+ industries
4.9★
Rating on G2[2]
“A trusted data analytics partner” — verified review
370K+
Data marts delivered
Created and served by OWOX to business users
132K+
npm installs[3]
Self-managed OWOX Edition from GitHub
[1] Google Workspace Marketplace[2] G2.com reviews[3] OWOX GitHub
Connect

Step 1: Create a Google BigQuery Data Storage

Start by connecting your own Google BigQuery project as a data storage.

✓
Use your own BigQuery project and datasets
✓
Keep full ownership of TikTok Ads data
✓
No third-party data warehouses
Connect BigQuery
Step 1: Create a Google BigQuery Data Storage
Step 1: Create a Google BigQuery Data Storage
Step 2: Create a TikTok Ads Data Mart
Create

Step 2: Create a TikTok Ads Data Mart

Create a new Data Mart and choose Connector as the definition type.

✓
Select TikTok Ads as the data source
✓
Provide the required connection details to access your TikTok Ads account
✓
No API coding or engineering required
Create TikTok Data Mart
Step 2: Create a TikTok Ads Data Mart
Configure

Step 3: Select Fields & Configure Data Import

Choose exactly which TikTok Ads data you want to store in BigQuery.

✓
Select one of the available endpoints (as in the platform API)
✓
Select required fields like spend, impressions, clicks, and conversions
✓
No third-party data warehouses
Configure Data Import
Step 3: Select Fields & Configure Data Import
Step 3: Select Fields & Configure Data Import
Step 4: Run & Schedule TikTok Ads Data Collection
Run

Step 4: Run & Schedule TikTok Ads Data Collection

Once published, you can import TikTok Ads data manually or on a schedule.

✓
Incremental load to import the current day's data
✓
Backfill (custom period) to load historical data for a specific date range
✓
Track progress and status in Run history
Run Data Mart
Step 4: Run & Schedule TikTok Ads Data Collection
Activate

Step 5: Use TikTok Ads Data Across BI Tools & AI Insights

Your TikTok Ads data is now available in Google BigQuery.

✓
Analyze data in Google Sheets or Looker Studio
✓
Join TikTok Ads data with GA4, CRM, or revenue tables
✓
Enable AI Insights to ask questions or receive alerts
Activate Your Data
Step 5: Use TikTok Ads Data Across BI Tools & AI Insights
Step 5: Use TikTok Ads Data Across BI Tools & AI Insights
Social proof

Every claim has a receipt.

Every number below comes straight from our customers — on camera. Click any card to watch them say it.

5 min
From raw data to a decision you can trust — what used to take months.
B2
cell "users on platform"
Nodari Rizun
Founder & CEO, Pürblack®
3d ago

For 10 years, we couldn't get a source of truth. Now we make very high-quality decisions quickly. Literally in five minutes.

Watch the full story on youtube
Hours → minutes
Five or six reports across Shopify, GA and Klaviyo — now one prompt.
C4
cell "time to first report"
Mark Simmons
CMO, Pürblack®
1W ago

Something that used to take a couple of hours – pulling five or six reports from Shopify, Google Analytics, Klaviyo – I now do in minutes, and I know it's the correct answer.

Watch the full story on youtube
Self-service analytics

Turn TikTok Ads Data into Business Decisions

Google Sheets were never designed to be a system of record. With OWOX Data Marts, Sheets becomes a trusted analysis layer — powered by governed data marts defined upstream in your warehouse.

✓
Business teams keep the flexibility they love
✓
Data teams retain control over logic and definitions
✓
No more fragile joins duplicated across spreadsheets
See how it works
→