BigQuery + OWOX Data Marts. Spreadsheet reporting and AI Insights on autopilot.
Build data marts on BigQuery. Automate reporting to Google Sheets and BI tools. Get AI Insights delivered to Slack, email, or Teams.
Available connectors for Google BigQuery
Available connectors for Google BigQuery
- Google BigQuery Connector to ChatGPT
- Google BigQuery Connector to Claude
- Bank of Canada Connector to Google BigQuery1 endpoint3 fieldsExchange Rates
- Criteo Ads to Google BigQuery Connector4 endpoints196 fieldsPlacement Categories, Placements, Statistics, Transactions
- Facebook Ads to Google BigQuery Connector15 endpoints1,172 fieldsAd, Ad Account, Ad Account User, Ad Creatives, Ad Insights, Ad Insights by Ad Set, Ad Insights by Age and Gender, Ad Insights by Campaign, Ad Insights by Country, Ad Insights by Device Platform, Ad Insights by Link URL Asset, Ad Insights by Product ID, Ad Insights by Publisher Platform and Position, Ad Insights by Region, Ads
- GitHub Connector to Google BigQuery3 endpoints54 fieldsRepository Contributors, Repository Information, Repository Statistics
- Google Ads to Google BigQuery Connector9 endpoints166 fieldsAd Group Ads Stats, Ad Groups, Ad Groups Stats, Campaigns, Campaigns Stats, Criterion, Geo Stats, Geo Target Constants, Keywords Stats
- Google Sheets Connector to Google BigQuery
- LinkedIn Ads to Google BigQuery Connector5 endpoints175 fieldsAd Accounts, Ad Analytics, Campaign Groups, Campaigns, Creatives
- LinkedIn Pages to Google BigQuery Connector2 endpoints18 fieldsFollower Statistics, Time-Bound Follower Statistics
- Microsoft Ads to Google BigQuery Connector3 endpoints225 fieldsAd Performance Report, Campaigns, User Location Performance Report
- Open Exchange Rates to Google BigQuery Connector1 endpoint4 fieldsHistorical exchange rates data
- Open Holidays Connector to Google BigQuery1 endpoint7 fieldsPublic Holidays
- Reddit Ads to Google BigQuery Connector18 endpoints675 fieldsAd Account, Ad Account User, Ad Groups, Ad Performance, Ad Performance by Account, Ad Performance by Ad Group, Ad Performance by Campaign, Ad Performance by Community, Ad Performance by Country, Ad Performance by DMA, Ad Performance by Interest, Ad Performance by Keyword, Ad Performance by Placement, Ads, Campaigns, Custom Audiences, Funding Instruments, Lead Gen Forms
- Shopify to Google BigQuery Connector25 endpoints337 fieldsAbandoned Checkouts, Article Metafields, Articles, Blog Metafields, Blogs, Collection Metafields, Collections, Customer Metafields, Customers, Discount Codes, Fulfillment Orders, Inventory Items, Location Metafields, Locations, Order Metafields, Orders, Page Metafields, Pages, Product Metafields, Product Variant Metafields, Product Variants, Products, Shop, Shop Metafields, Tender Transactions
- TikTok Ads to Google BigQuery Connector7 endpoints217 fieldsAd Groups, Ad Performance, Ad Performance by Country, Ads, Advertiser Account, Campaigns, Custom Audiences
- X Ads to Google BigQuery Connector10 endpoints187 fieldsAccounts, Ad Performance, Ad Performance by Country, All Cards, Campaigns, Cards, Line Items, Promoted Tweets, Targeting Locations, Tweets
- BigQuery to Google Sheets Reporting System
- Google BigQuery Connector to API
- Google BigQuery Connector to Data Studio
- Google BigQuery Connector to Microsoft Excel
- Google BigQuery Insights to Email
- Google BigQuery Insights to Google Chat
- Google BigQuery Insights to Microsoft Teams
- Google BigQuery Insights to Slack
- 0.34.0Temporary BigQuery faults no longer fail the whole import
- 0.33.0Calculated Fields in the Output Schema
- 0.33.0Cheaper incremental imports into Google BigQuery
- 0.32.0AI metadata generation for SQL data marts: no dataset-creation permission, and visible failures
- 0.32.0Connecting a Google account no longer fails intermittently
R01 · Data storage
What is Google BigQuery data storage?
Good analytics starts with data ownership. You don’t own your business data until it lives in your own data warehouse — not inside ad platforms or CRMs.
- Collect raw data from ad platforms, CRMs, and tools directly into BigQuery
- Model it into trusted data marts using SQL, tables, or views
- Reuse the same marts across Sheets, Data Studio, and AI Insights
R02 · Who it is for
Who is BigQuery with OWOX for?
Teams that have data scattered across marketing, product, sales, and finance tools — and want one warehouse powering all reports, dashboards, and insights.
- Data and BI teams centralizing metrics across the company
- Marketing teams tired of manual exports and broken dashboards
- Companies building self-service analytics with AI Insights
R03 · Why teams pick OWOX
Why use OWOX Data Marts with BigQuery?
BigQuery is the most popular data warehouse for marketing and product analytics. But raw tables don’t help business teams — they need reports, dashboards, and insights. OWOX bridges that gap: define a data mart in SQL, and OWOX handles delivery, scheduling, and AI-powered summaries.
R04 · How it works
How to use BigQuery with OWOX Data Marts
- Store all business data in a single cloud data warehouse (BigQuery)
- Automatically collect raw data from ad platforms and other sources
- Create reusable Data Marts using SQL, tables, views, or patterns
- Define metrics once and reuse them everywhere
- Power BI tools, spreadsheets, and reports from the same data marts
- Schedule AI Insights, reports, or analyses to Slack, email, or other channels – powered by your BigQuery data.
Why OWOX as a companion to BigQuery
One data warehouse, full picture
All your business data in BigQuery — one place for ownership, governance, and consistency.
Raw detail, no sampling
Full granularity from every platform, stored directly — no sampling, no aggregation loss.
Always fresh
Refresh on your schedule: hourly, daily, or every 15 minutes.
Less rework, more output
Model data once at the data warehouse level. No duplicated pipelines or broken dashboards.
Reusable across tools
Same data marts work in Sheets, Data Studio, Power BI — no logic rebuilds.
Confident decisions
Trusted, centralized data means fewer debates and faster action across teams.
Not testimonials. Comment threads.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
Nodari 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.”
Mark SimmonsCMO, Pürblack®“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”
Transform your BigQuery data into business actions
Connect your BigQuery project in minutes. Build data marts, automate reporting, and deliver AI Insights — free to start.
- Internal OWOX data as of 2026-10-02
- G2 reviews of OWOX
- npm installs stat
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.