[01] The data model

Every source. Every metric.
One unified model.

Shopify, GA4, Meta Ads, Google Ads, and Klaviyo all linked into one shared context. Dashboards, signals, and AI briefs read from it.

Available on Shopify App Store
Karbon Analytics
Live
Shopify
Meta Ads
Google Ads
GA4
Klaviyo
Unified Data Model
Core
01 orders in model
02 sessions in model
03 ad_spend in model
04 customers in model
05 events in model

One schema. Every source mapped, every customer linked.

One schema · Many outputs
Dashboards
Daily Signals
AI briefs
Reports
Attribution

Inside the model

All platforms.
Every dimension. Every metric.
One place.

The model defines how every source maps into one shape, how records link across platforms, and how derived metrics get calculated. Reports query it. They don’t reinvent it.

[01] Unified Schema

Every object,
one shape.

Orders, sessions, customers, ad spend, events. Across every source, modeled the same way. Derived metrics like MER, ROAS, AOV, LTV, and CAC sit on top, calculated once and read by every output.

Karbon Analytics
Order Object
order_id PK
customer_id FK
revenue
channel
Ad Spend Object
ad_spend_id PK
campaign
spend
channel
Session Object
session_id PK
customer_id FK
source
medium
Customer Hub
customer_id PK
email
first_order_date
cohort
Relational hub
Event Object
event_id PK
customer_id FK
type
timestamp
Karbon Analytics

Meta Ads

Ad click

clicked May 21 · 11:24 PM
campaign May · prospecting

Klaviyo

Email open

opened May 24 · 09:02 AM
flow Win-back · day 14

GA4

Session

visited May 27 · 02:18 PM
source google / cpc

Shopify

Order

ordered May 28 · 04:31 PM
total $184.20

Customer #4815

unified.customer

Hub
cohort May 2026 · paid social
platforms 4 linked
many touchpoints · one person

[02] Shared Context

Customers, channels, events.
Connected.

One buyer across Meta, Klaviyo, GA4, and Shopify stays one customer in the model. Channels collapse to one canonical taxonomy. Touchpoints reconstruct as one journey. The links are pre-built; reports query them.

[03] Cross-platform reporting

Every source,
queryable together.

Compare Meta vs Shopify. Blend all ad spend into one MER. Build funnels that cross channels. Slice by either. All from one model, in one query.

Karbon Analytics
Live

Revenue

$124,400

+12.3% vs prev

Ad Spend

$32,100

+4.1% vs prev

Blended ROAS

3.87x

+0.42 vs prev

MER

3.87

−0.18 vs prev

Revenue by channel · last 7 days

cross-source query
Shopify direct
$48,200
Meta Ads
$34,500
Google Ads
$22,100
Klaviyo Email
$14,800
Organic
$4,800
5 sources · 1 query · 1 model drill into any row →

Managed infrastructure

All this,
without the development overhead.

Karbon Analytics provisions, syncs, and maintains the model. You skip the months of integration work, schema design, and pipeline upkeep that a unified analytics stack normally takes to build in-house.

Live in under 10 minutes Maintained by Karbon Analytics
[01] Not required

Data warehouse

  • Snowflake
  • BigQuery
  • Redshift
  • Postgres
Skips $10–50K/year in tooling
[02] Not required

ETL pipelines

  • Fivetran
  • Supermetrics
  • Airbyte
  • Stitch
Saves a multi-week fire drill each quarter
[03] Not required

SQL or dbt models

  • dbt project
  • SQL transforms
  • Metric layer
  • Schema design
No engineering tickets for analytics changes
[04] Not required

In-house build-out

  • Custom integrations
  • Schema modeling
  • Pipeline orchestration
  • In-house expertise
Months saved. Expertise included.

How the model works

From every source to one model, in four stages.

01 · Ingestion

Sources stream in continuously

Sources stream in continuously. No exports, no API keys, no schema mapping on your side. Once you authorize a connection, Karbon Analytics pulls data from Shopify, GA4, Meta Ads, Google Ads, and Klaviyo on a read-only schedule and keeps the model live.

02 · Normalization

Raw fields map to a shared schema

Every source mapped to one common shape. Each platform has its own event names and field structures; Karbon Analytics maps each into a unified schema so orders, sessions, customers, spend, and events land in a consistent structure inside the model.

03 · Linking

Shared keys connect every object

Customers and events linked across platforms. Customer identity, channel taxonomy, event time, and cohort membership join Shopify orders to Meta clicks to GA4 sessions to Klaviyo touchpoints. Pre-built, so reports query the relationships instead of reconstructing them.

04 · Activation

Every output reads from the same model

Every dashboard, signal, and AI brief reads from the model. Dashboards, Daily Signals, executive briefs, attribution analysis, and AI insights all query the same connected view. A metric defined once propagates everywhere, and nothing is recomputed downstream.

Karbon Analytics
Live

Connected sources · streaming

Read-only
ShopifyLive
Meta AdsLive
Google AdsLive
GA4Live
KlaviyoLive

Recent events

3s·Shopifyorders.created
12s·Meta Adscampaign.spend_synced
34s·GA4session.events
5 / 5 connectedrefresh · continuous

Schema map · 2 of 12 shown

many → 1

revenue

Shopifytotal_price
Meta Adspurchase_value
Google Adsconversion_value
Klaviyoattributed_value

Unified

unified.revenue

decimal · usd · refunds applied

customer identity

Shopifycustomer_id
Klaviyoprofile_id
Meta Adsmatched_id

Unified

unified.customer

uuid · cross-platform

12 mappings · 5 sourcesschema · v4.2

Shared keys · linked across sources

one connected view
Identity[email protected] · 8 touchpoints1 customer

Meta · Klaviyo · direct linked to one person

Channel"facebook" · "meta_ads" · "fb""Meta"

3 platform labels · 1 canonical channel

Event linkmeta_click_x9f + shopify_order_418271 customer journey

ad click joined to order via UTM + identity

Cohortcustomer #4815 · first order May 2026May 2026 · paid social

cohort tag applied once · queried everywhere

Objects linked · sources preservedone connected view

Outputs · reading from the model

5 / 5 healthy

Unified Data Model

One source of truth

rows24.1M
queries / hr1,847
latency p9542ms
Dashboards
2s ago
Daily Signals
14s ago
AI briefs
08:30 AEDT
Attribution
1m ago
Reports
queued
One metric definition · everywhererefresh · continuous

By the numbers

Karbon Analytics already analyzes serious data. Built to handle the volume your store produces.

0
Shopify orders analyzed
0
GA4 sessions analyzed
0
Data points across the unified model
0
Meta and Google ads analyzed
0
SKUs across inventory data

What reads from the model

Three outputs. One model.

Every output in Karbon Analytics queries the same unified model. Same dimensions. Same metric definitions. Same source data, no matter which surface you open.

[01]

Revenue
+12.4%
$84,329
Blended ROAS
+0.4×
3.2×
Sales Marketing Customer LTV Cohort retention Inventory Profitability MER Operations

Dashboards

Seven dashboard categories built on the unified model. Sales, marketing, customer, inventory, profitability, marketing efficiency, and operations. Every category reads from the same model.

See the dashboards

[02]

Today's signals
08:30 AM
ROAS dropped 38% on Meta
3 SKUs near stockout
$1.2k wasted ad spend
+24% revenue momentum
Revenue cliff ROAS below breakeven Stockout risk Wasted spend Refund spike Scaling opportunity Top sellers shift Identity double-count

Daily Signals

40+ detectors run against the model every night. The model lets a signal spot what single-platform tools cannot: cross-channel attribution shifts, identity-driven double-counting, true ROAS slips.

See Daily Signals

[03]

Morning brief
AI · 26 May

Meta ROAS slipped to 1.7× against a 2.5× baseline. Two campaigns are pulling the blend down. Pause and reallocate before lunch. Expected recovery within 3 days.

Suggested action Pause 2 campaigns
Plain-language summary Why it happened Suggested action Ranked by impact What to check next Severity flagged

AI briefs

AI writes the morning brief on top of the model. Plain-language summaries, ranked by impact, with a suggested next step. The model decides what is important; AI explains what happened.

See AI briefs

Ready when you are

See your real numbers in one place. Every morning.

Connect your store and ad accounts to Karbon Analytics. See what a unified data model unlocks in your first session.

FAQ

Frequently asked questions.

Everything about how the unified data model works, from connection through to activation.

About the model

What is the Karbon Analytics unified data model?
The unified data model is a single schema that every data source (Shopify, GA4, Meta Ads, Google Ads, Klaviyo) feeds into. Each platform’s objects (orders, sessions, customers, ad spend, events) share one shape across every source, and customers, channels, and events are linked across platforms. Derived metrics like MER, ROAS, AOV, LTV, and CAC are calculated once and read by every output. Every dashboard, signal, and AI brief queries this model instead of stitching reports together.
How is this different from a dashboard tool that just connects multiple sources?
Most analytics tools display data from each platform side by side and leave you to eyeball the differences. Karbon Analytics puts every source into one shared schema, links customers and channels across platforms, and pre-calculates derived metrics like MER, ROAS, LTV, and CAC. Each platform’s own measurements stay intact. What the model unlocks is cross-source analysis without manual exports or hand-joining in spreadsheets.
What does the model actually do?
Three things. (1) Unified schema: every source’s objects (orders, sessions, customers, ad spend, events) mapped to one shape, with derived metrics (MER, ROAS, AOV, LTV, CAC) calculated once on top. (2) Shared context: customer identity unified across platforms, channel labels collapsed to one canonical taxonomy, events linked into one customer timeline, cohorts defined once and reused everywhere. (3) Cross-platform reporting surface: every source sits side by side, queryable together, so you can compare them, combine them, or slice by either in one query. Report-level concerns like currency conversion, timezone display, and refund handling live in the reports that read the model, not in the model itself.

About cross-platform analysis

Why does this matter for a Shopify brand?
Without a unified model, your Meta, Google, GA4, Klaviyo, and Shopify views live in separate tools. Any cross-channel analysis means exporting to spreadsheets and joining by hand: hours of work, brittle, and easy to introduce errors. With one model, every source sits in the same schema and the customer, channel, and event links are already in place. You can read Meta’s view, read Shopify’s view, see the combined picture, and compare them in one query, without exports, without hand-joining.

About setup

Do I need to configure the model?
No. Once your sources are connected, the model is built automatically. There is no schema mapping, no metric configuration, and no SQL. The model adapts as you add or remove integrations and applies the same definitions across every output.
Does the model apply the same rules to every account?
Yes. Every normalization rule and metric definition is applied consistently across every account and every source. The model behaves the same way for a single-store operator and a multi-store brand.

Still have questions?

Talk to the team