Combine BigQuery with Google Ads to measure ROAS on your own warehouse data
Many businesses already load orders, transactions or GA4 events into BigQuery, while ad spend is still read inside Google Ads. DataxLand loads the BigQuery tables you choose incrementally by a cursor column and reads Google Ads spend by day and campaign, then computes everything on one model: blended ROAS on net revenue, the gap against the conversion value Google reports, cost per order and profit after ads. You get defined metrics and Si answers questions on the warehouse data you already have, without building another reporting layer.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Your BigQuery data is the source of truth, but it lacks a shared metric layer for people who do not write SQL.
- Google Ads conversion value does not subtract the refunds and cancellations recorded in your warehouse.
- One definition of blended ROAS for dashboards, Si, scheduled reports and MCP.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Blended ROAS | Net revenue from BigQuery tables ÷ Google Ads spend, same period |
| Platform-reported ROAS | Google Ads conversion value ÷ ad spend |
| Ad-reported vs actual revenue gap | Reported conversion value − net revenue |
| Net profit after fees and ads | Contribution margin − allocated ad spendNeeds cost of goods in the warehouse or an added cost table. |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
| Ad-reported vs actual revenue gap | Ad-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenue | Currency |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
Questions you can answer
| Question | Google Ads only | BigQuery + Google Ads combined |
|---|---|---|
| What is the real revenue from ads? | Conversion value | Net revenue in your warehouse |
| Can anyone ask? | Only people who know Google Ads | Anyone can ask Si in plain language |
| One definition? | No | Versioned and shared |
Steps
- 1
Connect BigQuery
Enter the project, dataset and a read-only service account key; choose the tables and the cursor column for incremental loading.
- 2
Connect Google Ads
Enter your Google Ads credentials (developer token, client ID, client secret, refresh token) and customer ID; keys are encrypted when stored.
- 3
Review Si's mapping
Si investigates the BigQuery tables with read-only, cost-capped queries and proposes the order table and how spend joins by day and campaign; you approve.
- 4
Build and read the dashboards
The Ads dashboard shows blended ROAS next to reported ROAS; a weekly report is sent to Slack.
Frequently asked questions
Do DataxLand queries cost BigQuery money?
Yes, loading data runs queries in your project. Incremental loading by a cursor column only scans new rows; Si's investigation queries are capped in count and cost, and any query over the cap waits for a technical user to confirm.
What permissions does the service account need?
Read access to the datasets you load and permission to run jobs in the project. No write access is needed.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect BigQuery →Connect Google Ads →Ask Si about your BigQuery data →Ask Si about your Google Ads data →
Other combinations
Combine BigQuery and Google Ads in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes