Import Data from Facebook to Google BigQuery
Collect complete statistics on your Facebook, Instagram, and Audience Network ads in Google BigQuery
processed ad costs totaling $929,537 million
Automatically import cost data
Create a data pipeline from Facebook to Google BigQuery once and never manually upload data again. OWOX BI collects raw data from your advertising campaigns every day. While doing so, it recognizes dynamic parameters in UTM tags, converts costs into your default currency, and monitors the relevance of data.
Get the most out of your campaign statistics
In addition to data on costs, impressions, and clicks, OWOX BI uploads more than 200 metrics from Facebook to Google BigQuery. Using this data, you'll be able to build detailed reports for in-depth analysis of advertising, create remarketing lists, effectively manage advertising bids, and train your ML- models for more accurate planning.
Combine data from different sources
Combine your Facebook ad data with data from other advertising services, Google Analytics, your website, and your CRM in Google BigQuery. This will help you evaluate the effectiveness of your ads, taking into account the margin and redeemability of your products. Find out which campaigns bring the most profit and which don’t pay off.
Measure campaigns with ad accuracy
OWOX BI uploads raw data from Facebook to BigQuery and identify all UTM tags if they are available in the advertising service API. Build reports of the depth you want across any parameters and use insights from these reports to manage your ad bids.
Be sure of the quality and security of your data
All data is collected, stored, and processed in your Google BigQuery project. You fully control access to your data and can decide who to give access to. OWOX BI processes dynamic parameters, checks existing UTM tags in your campaigns, and reports on possible errors in your data.
With OWOX BI, you get a ready-made dataset in an easy-to-use structure
Unique advantages of OWOX BI
Complete statistics even from large accounts
OWOX BI works smoothly with large ad accounts and uploads all data regardless of the number of campaigns. We’ve already processed ad costs totaling $929,537 million.
OWOX BI will automatically update cost data in Google BigQuery if it changes in your Facebook Ads account within 21 days.
Measure past campaigns
If necessary, OWOX BI will upload your historical data from Facebook Ads to Google BigQuery.
Create a data pipeline from Facebook to Google BigQuery once (it takes all of 5 minutes) and get up-to-date cost data every day. You don’t need to regularly prepare CSV files, understand APIs, or use Apps Script.
How it works
Make sure your advertising links have UTM tags
In OWOX BI, select Facebook as the data source and grant access to OWOX
Measure uploaded data using SQL in Google BigQuery or get reports in OWOX BI Smart Data
OWOX BI products help you reach your business goals faster
2,000 companies rely on us
where our users work
who trust us
of data processed
Our Customers Success Stories
Discover how OWOX BI
analytics can boost
Sign up for a product demo to evaluate OWOX BI’s analytical capabilities.