Skip to content
+

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

MetricHow it is computed
Blended ROASNet revenue from BigQuery tables ÷ Google Ads spend, same period
Platform-reported ROASGoogle Ads conversion value ÷ ad spend
Ad-reported vs actual revenue gapReported conversion value − net revenue
Net profit after fees and adsContribution 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.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Ad-reported vs actual revenue gapAd-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 revenueCurrency
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency

Questions you can answer

QuestionGoogle Ads onlyBigQuery + Google Ads combined
What is the real revenue from ads?Conversion valueNet revenue in your warehouse
Can anyone ask?Only people who know Google AdsAnyone can ask Si in plain language
One definition?NoVersioned and shared

Steps

  1. 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. 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. 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. 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