Skip to content
BQSyncby Practical Vision

Connect acquisition to
what users actually do
after they arrive.

BQSync keeps campaign and traffic-source information alongside later behavioral activity, in data that can be joined to CRM, leads, customers, and revenue - using the same warehouse tables BI and product already work from.
See how it works

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

Acquisition, attached to what happened next

pv_analytics.sessions

Source / mediumCampaignFirst seen
google / cpcq3_brandAug 14
linkedin / paidq3_abmAug 11
join on user_pseudo_id

your_crm.opportunities

AccountStageValue
NorthwindClosed won48,000
Tyrell CorpQualified–

Kept raw

select s.source, s.medium, s.campaign, o.stage, o.value
from `metacortex.pv_analytics.sessions` s
join `your_crm.opportunities` o using (user_pseudo_id)

No attribution model is applied and no channel gets credit assigned for you. The rows arrive intact, for your team to model however it already does.

Where it fits

Marketing gets campaign and traffic-source information alongside later behavioral activity, in data that can be joined to CRM, leads, customers, and revenue.

BQSync is not an attribution platform, CDP, or marketing reporting product. It does not apply a proprietary attribution model. It maintains the underlying analytics data so you can study downstream behavior by source, medium, campaign, audience, or landing experience using the tools you already have. Marketing does not need to query the warehouse directly - it needs the questions to be answerable when it asks them.

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.

Acquisition beside behavior

Source, medium and campaign sitting in the same rows as what happened next.

sourcemediumcampaign

Context that survives the visit

Acquisition information carried into later sessions, not only the one it arrived in.

first seenAug 14

A path to CRM and revenue

Leads, customers and closed revenue, joined to behavior on a key you control.

join onuser_pseudo_id

Questions the report will not take

A specific segment, an unusual range, a combination of conditions. Asked of the data itself.

sessionstraffic_sources

Landing experience to outcome

What visitors from a campaign or landing page did over the days that followed.

page_locationlanding_page

Not a marketing-only copy

The same dataset product and BI work from, so the numbers do not diverge.

metacortex.pv_analytics

BQSync is not an attribution platform, a CDP, a marketing dashboard, or a proprietary reporting product. It does not decide which channel gets credit. It keeps the behavioral data those questions depend on.

Questions this data can support

Past the click, into the pipeline.

Each of these needs acquisition context and later behavior in the same place as the commercial data.
That is the whole job.

  • Which acquisition sources bring visitors who go on to become qualified leads or customers?
  • What do people actually do after landing on a specific page or campaign entry point?
  • How does campaign spend relate to CRM pipeline and closed revenue, not just form fills?
  • Which channels look strong on first-visit metrics but weak on everything after?

How teams use it

How marketing and growth teams use it

These are the working patterns that become possible when acquisition context and later behavior live in the same place as the commercial data.

01

Channel quality, not just channel volume

Compare sources on what happened after the visit - signups that activated, leads that reached sales, customers that renewed - rather than on sessions and immediate conversions alone.

02

Landing experience to downstream behavior

Look at what visitors from a specific campaign or landing page did over the following days and sessions, so a page can be judged on the outcomes it produced instead of its bounce rate.

03

Joining marketing data to CRM and revenue

Because the behavioral tables sit in the warehouse next to CRM and billing data, your data team can connect campaign context to pipeline and revenue without exporting spreadsheets between tools.

04

Questions the reporting interface will not answer

Ad-hoc questions - a specific segment, an unusual date range, a combination of conditions - can be answered from the underlying data instead of being abandoned because the report does not support them.

For ongoing Practical Vision clients, broader measurement implementation and dashboards may be supported through the wider engagement, separately from the core BQSync product.

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