Acquisition beside behavior
Source, medium and campaign sitting in the same rows as what happened next.
Existing Practical Vision client? You do not need the Data Audit. Request BQSync access.
pv_analytics.sessions
your_crm.opportunities
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
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
Six things land in your warehouse.
Each card shows the one underneath it, because a benefit you cannot point at is a claim.
Source, medium and campaign sitting in the same rows as what happened next.
Acquisition information carried into later sessions, not only the one it arrived in.
Leads, customers and closed revenue, joined to behavior on a key you control.
A specific segment, an unusual range, a combination of conditions. Asked of the data itself.
What visitors from a campaign or landing page did over the days that followed.
The same dataset product and BI work from, so the numbers do not diverge.
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
Each of these needs acquisition context and later behavior in the same place as the commercial data.
That is the whole job.
How 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
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
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
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
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.
Keep going
Next · /bi-data
They usually own the decision, and they are the ones who will run the joins.
For BI & DataAlso · /solution
The audit, the transformations and the monitoring behind the tables.
See how it worksSideways · /for-product
What happens inside the product, after the campaign did its job.
For product teamsAlready working with Practical Vision? You do not need the Data Audit. Request BQSync access.