Skip to content
BQSyncby Practical Vision

Managed analytics data for the stack you already have.

BQSync maintains normalized relational tables in your BigQuery environment so BI and data teams can stop repeatedly parsing nested GA4 exports and start using behavioral data in the dashboards, notebooks, and models they already run.
See how it works

Existing Practical Vision client? You do not need the Data Audit. Request BQSync access.

metacortex.pv_analyticsOwned by you
TableGrainState
sessionsOne row per sessionUp to date
page_viewsOne row per viewUp to date
purchase_eventsOne row per purchaseUp to date
form_submissionsOne row per submissionBehind

Kept raw

select page_location, session_id, revenue
from `metacortex.pv_analytics.purchase_events`
where event_date >= '2026-08-01'

Where it fits

Less time rebuilding nested GA4 logic.
More time using behavioral data in the dashboards, notebooks, and models you already run.

BI and data teams typically evaluate, approve, and own the implementation. BQSync is not a replacement for your BI stack. It is managed analytics data those tools can query: normalized relational tables in your BigQuery environment, kept current, and easier to join to the rest of the business.

What you receive

What you receive

Six things land in your warehouse.
Each card shows the one underneath it, because a benefit you cannot point at is a claim.

Normalized relational tables

Instead of repeatedly parsing GA4's nested export in every dashboard and model.

sessionspage_viewscheckout_steps

Structures you reuse everywhere

The same tables feed dashboards, notebooks and models. The parsing lives in one place.

dbt modelsscheduled queriessemantic layers

Joins to the rest of the business

CRM, customer, subscription, revenue or operational data, on a key you control.

join onuser_pseudo_id

Freshness you can check

Before someone else finds the stale number in a report, in words rather than logs.

Behindevents, since Aug 19

Processing somebody watches

Retried, escalated and maintained when Google changes something. Not a project dump.

last 14 daysevery run recorded

Queries and tables that stay yours

In your project, readable by your team, and still there if you stop paying us.

metacortex.pv_analytics

BQSync does not replace Looker, Tableau, notebooks, dbt models, or the rest of your analytics stack. Those tools keep doing the analysis. BQSync keeps the underlying behavioral data in a shape they can reuse.

Questions this data can support

Four questions that stop needing a project.

Answered in the tools your team already runs, on tables that were already parsed, already joined and already up to date this morning.

  • Which customer segments use a specific feature?
  • What happened before or after a conversion?
  • How does behavior connect to revenue or CRM data?
  • Which behavioral signals belong in existing BI models?

How teams use it

How BI and data teams use it

BI and data teams generally evaluate and approve BQSync, then operate alongside it. These are the patterns that follow.

01

One parsing layer instead of many

The unnesting logic stops being copied into every dashboard, notebook, and model. It lives in maintained tables, so a change is made once rather than tracked down across the stack.

02

Behavioral data as a modeling input

The relational tables sit in the same project as your other sources, so behavioral events can be referenced from dbt models, scheduled queries, and BI semantic layers like any other table.

03

Serving product and marketing requests faster

Requests from product and marketing stop starting from raw event parsing. The structural work is already done, so your team spends its time on the analysis rather than the plumbing.

04

Operational visibility you can check

Freshness, run history, failures, and BigQuery access state are visible in the dashboard, so you can confirm the state of the data before someone else discovers it in a report.

Justifying it

BI and data teams usually evaluate and own the implementation. If you are the one being asked to justify it internally, the audit, the transformations, and what happens when Google changes something are all set out in full.

New organizations start with a Data Audit.
Existing clients do not.

Talk to us

Already working with Practical Vision? You do not need the Data Audit. Request BQSync access.

Accessibility options

These options stay in this browser. They sit on top of the page's own markup and do not change how the site looks for anyone else.

Display
Motion and reading