Integrate Google BigQuery with Data Octopus
Connect Google BigQuery to Data Octopus. Data from Google BigQuery flows into one product data model and powers segmentation and product feeds for 35+ ad channels.
What is Google BigQuery?
Google BigQuery is a cloud data warehouse on Google Cloud built to store and analyse large datasets. In e-commerce, BigQuery collects raw GA4 data, data from ERP, warehouse and finance systems, and the company's own models and calculations.
Why does Google BigQuery data matter for product feeds?
In BigQuery, companies keep data that isn't in the e-commerce platform or ad dashboards, yet decides whether a product is profitable:
Margins, purchase costs (COGS) and logistics costs
Data from ERP and warehouse systems
Raw GA4 event data, free of sampling and interface report limits
Custom metrics and models, e.g. product priorities, demand forecasts, customer value
As long as this data stays in the warehouse, it has no effect on which products ad channels promote.
How does Data Octopus use Google BigQuery data to build better feeds?
Data Octopus pulls data from BigQuery and combines it with e-commerce platform, GA4, Google Ads and Meta Ads data in one model at product and variant level. On that basis it:
Factors actual margin and profit after all costs into product segments
Carries the company's own metrics and business priorities into the feed
Writes the results into custom labels and extra feed attributes
Delivers warehouse data to ad channels, price comparison sites and marketing automation systems with no extra IT work
As a result, BigQuery data stops being just the basis for reports and starts steering campaigns directly.
Find another integration
- Feed XML / CSV / JSONFeedWe get data
- IdoSellE‑commerce platformsWe get data
- ShopifyE‑commerce platformsWe get data
- ShoperE‑commerce platformsWe get data
- PrestaShopE‑commerce platformsWe get data
- Google Analytics 4AnalyticsWe get data
- Google AdsAd platformsWe get dataWe send data
- Meta AdsAd platformsWe get dataWe send data
- Google SheetsOtherWe get data
- OpenAIAI commerceWe send data
- Google Merchant CenterAd platformsWe send data
- Microsoft AdvertisingAd platformsWe send data
- Pinterest AdsAd platformsWe send data
- TikTokAd platformsWe send data
- SnapchatAd platformsWe send data
- RedditAd platformsWe send data
- SeznamAd platformsWe send data
- WP AdsAd platformsWe send data
- KauflandAd platformsWe send data
- CeneoPrice comparisonWe send data
- IdealoPrice comparisonWe send data
- HeurekaPrice comparisonWe send data
- BianoPrice comparisonWe send data
- FAVIPrice comparisonWe send data
- ZbožíPrice comparisonWe send data
- CriteoRTB / RemarketingWe send data
- RTB HouseRTB / RemarketingWe send data
- User.comMarketing automationWe send data
- EdroneMarketing automationWe send data
- Manago AIMarketing automationWe send data
- SyneriseMarketing automationWe send data
Frequently asked questions
What is Google BigQuery?
Google BigQuery is a cloud data warehouse on Google Cloud built to store and analyse large datasets. In e-commerce, BigQuery collects raw GA4 data, data from ERP, warehouse and finance systems, and the company's own models and calculations.
How do I use Google BigQuery data in a product feed?
Data Octopus pulls product-level data from Google BigQuery (e.g. views, add-to-carts, transactions, revenue) and writes the results into custom_label and extra feed fields. Campaigns in Google Ads and Meta Ads then split products by real performance, not just the catalogue.
How do I connect Google BigQuery to Google Merchant Center?
Google BigQuery doesn't send data to Merchant Center directly. Data Octopus combines Google BigQuery data with store product data and sends Merchant Center a ready feed with segments such as bestseller, high conversion or no sales.
How do I segment products using Google BigQuery data?
Most often by revenue, conversion rate, trend and share of sales. Data Octopus recalculates these metrics daily for every SKU, so products move between segments and campaign groups on their own.
How do I connect Google BigQuery to Data Octopus?
You enable the Google BigQuery integration in the Data Octopus panel in minutes by granting account access. No developer or site code changes needed.
How often does Google BigQuery data reach the feed?
Automatically, every day. Feed segments refresh from the latest data with no manual exports.
Connect your data with Data Octopus.
We'll show you how to bring your sources and channels together.