Home
Connectors
Lasso Commerce - Your warehouse

Send every Lasso Commerce event to your warehouse, server-side

Q: How do I check that Lasso Commerce events are reaching your warehouse?

Query the events table directly: count distinct resolved person IDs against count distinct sessions, and compare the ratio to what your analytics reports.

Q: Will re-runs or backfills duplicate rows?

No. Stable event IDs, so re-runs and backfills do not double rows.

Q: How long does it take to connect Lasso Commerce to your warehouse?

Most brands are live in under 20 minutes. Once Lasso Commerce is connected, every destination receives the same resolved events, your warehouse included.

Each event is resolved to a person against a 750M+ device graph before it reaches your warehouse, as a full-fidelity event stream you can query yourself.

Request a demo Start free trial

US device IDs in the graph: 750M+
Match rate on events: 90%+
Identity window, per customer: Lifetime
Most brands are live: <20 min

How it flows

How a Lasso Commerce event reaches your warehouse. Captured on the server, resolved to a person, then sent.

01 Capture

Captured from Lasso Commerce

Capture Lasso Commerce checkouts and upsells server-side, so orders that never touch a storefront page are still resolved and forwarded.

See the Lasso Commerce integration

Lasso CommerceWhat it sends

order_idLasso checkout order reference
email / phonecontact captured at checkout
line_itemsproducts and quantities on the order
total / discountorder economics after adjustments
landing_domainthe site the shopper started on, before the checkout hop

02 Understand

Resolved to one person before it leaves

Every Lasso Commerce event is matched against a 750M+ device graph, so a phone browse and a desktop checkout resolve to one customer rather than two strangers.

How resolution works

Resolved before it is sent

IdentityMatched against a 750M+ device graph, so a phone browse and a desktop checkout resolve to one customer.
customer_typeNew or returning, resolved before send.
DeduplicationStable event IDs, so re-runs and backfills do not double rows.
Bot and fraud filteringFiltered before load, with the filter decision recorded.

Warehouse data is only useful if you trust it enough to base a decision on it. These controls exist so you can reconstruct how any row got there.

03 Activate

Delivered to your warehouse

A clean, resolved event stream into BigQuery, Snowflake or Redshift: the same data your dashboards run on.

See the warehouse integration

Your warehouseWhat it receives

event_idprimary key you can join on
resolved person IDstitch sessions to customers
full property payloadnothing dropped, nothing sampled
ingest timestamprebuild any point-in-time view

The catch

Orders and on-site sessions come from two different systems with two different identifiers, so joining them in the warehouse requires a resolution step that does not exist by default.

Where to check in your warehouseA stream you can audit

Query the events table directly: count distinct resolved person IDs against count distinct sessions, and compare the ratio to what your analytics reports.

What changes

What changes when Lasso Commerce feeds your warehouse. Two gains on the warehouse side, two on the Lasso Commerce side.

Your warehouse

One resolved event stream

The same identity-resolved events that reach your ad platforms, landed in your warehouse.

Your warehouse

Nothing sampled

Full-fidelity events, not an aggregate or a sample.

Lasso Commerce

Every event, server-side

Storefront and checkout events are captured from Lasso Commerce on the server, independent of the browser.

Lasso Commerce

One setup, every destination

Connect Lasso Commerce once and forward to every ad platform, email tool and warehouse you run.

Setup

Live in under 20 minutes.

Connect Lasso Commerce once and every destination, your warehouse included, is forwarded the same resolved events.

Upstack dashboardExample

Lasso Commerce Data source Connected

Your warehouse Destination Healthy

Read the full warehouse setup guide

01

Connect Lasso Commerce

Capture Lasso Commerce checkouts and upsells server-side, so orders that never touch a storefront page are still resolved and forwarded.
02

Add the warehouse destination

Under Destinations, add your warehouse. Every resolved Lasso Commerce event is then forwarded to it.
03

Check delivery to your warehouse

Every row traceable to the event that produced it and the time it landed.

FAQ

Questions about Lasso Commerce and your warehouse.

How do I check that Lasso Commerce events are reaching your warehouse?

Query the events table directly: count distinct resolved person IDs against count distinct sessions, and compare the ratio to what your analytics reports.

Will re-runs or backfills duplicate rows?

No. Stable event IDs, so re-runs and backfills do not double rows.

How long does it take to connect Lasso Commerce to your warehouse?

Most brands are live in under 20 minutes. Once Lasso Commerce is connected, every destination receives the same resolved events, your warehouse included.