Skip to main content
Upstack Data

BigQuery

Stream resolved events and orders into BigQuery, so your analysts work from the same identity graph the ad platforms receive.

DestinationData warehouse

About BigQuery

What BigQuery is, and why identity matters to it.

BigQuery is Google Cloud’s warehouse, and for most commerce teams it is where the analysis that matters actually happens.

Warehouse analysis is only trustworthy if it reconciles with what the ad platforms were told.

How it works

How BigQuery works.

BigQuery stores whatever you load into it and answers questions at scale. The usual failure is not the warehouse — it is that the orders in it and the conversions sent to Meta were produced by two pipelines with two definitions.

With Upstack Data

Get more out of BigQuery with Upstack Data.

Upstack writes the same resolved events to BigQuery that it forwards to every ad platform, so the warehouse and the platforms describe one dataset. When a number disagrees with a platform, that becomes a finding rather than an unresolvable argument about whose pipeline is right.

What you can do with it

Three jobs this connector does inside BigQuery.

  1. Send complete conversions

    Conversions reach BigQuery through its server-side API with restored click IDs and hashed identifiers attached, so more of what you send is matched on arrival — and the conversions you never saw stop being invisible.

  2. Optimise on the customer you want

    Map any order attribute to the conversion BigQuery receives — profit rather than revenue, new customers rather than repeat buyers, high-value orders rather than every checkout — so the platform learns from the buyers worth acquiring.

  3. One dataset, warehouse and platforms

    The rows in your warehouse are the rows the ad platforms received, so a discrepancy is a real finding rather than a pipeline difference.

Get BigQuery tracking right.

A 15-minute walkthrough tailored to your stack and channels.