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: Select a Data Storage

All data should have its home. Start by connecting a data storage where your X Ads data will be stored & processed.

✓
Choose a supported data warehouse such as BigQuery, Snowflake or Redshift.
✓
Store raw X Ads data in one central place so you can blend them later on with other ads data or with conversions data from GA4
✓
Keep full ownership and control over your data
Connect Data Warehouse
Step 1: Select a Data Storage
Step 1: Select a Data Storage
Step 2: Create X Ads Data Mart
Create

Step 2: Create X Ads Data Mart

Click on + New Data Mart, choose Connector as the definition type.

✓
Select X Ads as the data source
✓
Specify the Advertiser ID that you want to collect data from
✓
Authorize access to your X Ads account
Create Data Mart
Step 2: Create X Ads Data Mart
Select

Step 3: Select API Endpoint & Fields

Choose exactly which X Ads data should be collected.

✓
Select the appropriate API endpoint (for example, statistics)
✓
Choose metrics such as clicks, impressions, spend, engagements, video views, etc.
✓
Keep full ownership and control over your data
Collect X Ads Data
Step 3: Select API Endpoint & Fields
Step 3: Select API Endpoint & Fields
Step 4: Create X Ads Report in Google Sheets
Enable

Step 4: Create X Ads Report in Google Sheets

Now it's time to enable your X Ads data in Google Sheets.

✓
Add Google Sheets as a Destination
✓
Create a new Google Sheets Document, share it, then Create & Run your report
✓
Check the box for regular updates to keep data fresh
Enable X Ads Data
Step 4: Create X Ads Report in Google Sheets
Extend

Step 5: Get more from your X Ads Data

Your X Ads data is now available for analysis in Google Sheets. But why stop at just this? You can reuse the same X Ads Data Mart to:

✓
Enable X Ads AI Insights delivered on a schedule to Slack, MS Teams or by Email
✓
Visualize X Ads Data in Looker Studio. Just tick the box on the destinations tab
✓
Blend X Ads data with GA4, CRM, or other ad platforms
Schedule X Ads Insights
Step 5: Get more from your X Ads Data
Step 5: Get more from your X Ads Data
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 Twitter Ads Data into Actionable AI Insights

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
→