CRUX
Data Foundation

Best-in-class data you can trust, inspect, and own.

Every data source in your stack, ingested automatically, joined by dbt models built to ecommerce best practice, and validated daily with hundreds of automated tests. The single source of truth your entire growth system runs on.

Included in all retainer plans. The data layer and dashboard suite are part of every engagement, not an add-on.

Shopify
Meta
Google
TikTok
GA4
Klaviyo

Unified Data Layer

BigQuery · Transparent & Owned · AI Ready

Unified Data Layer

All your sources in one clean, tested BigQuery warehouse you own.

S
Shopify
M
Meta
G
Google
G4
GA4
K
Klaviyo
TT
TikTok

dbt transform + test

BigQuery

Owned warehouse

📊
Looker Studio
💬
Slack AI
📋
Google Sheets
What's included

Built for ecommerce, from the ground up.

100+ dbt Models

Orders, customers, channels, cohorts, and profitability all pre-built and analysis-ready. Customised to your metric definitions.

Hundreds of Automated Tests

Missing orders, revenue mismatches, date gaps, and attribution inconsistencies caught before they reach a dashboard.

You Own It

Hosted in your own Google BigQuery project. Fully transparent, fully inspectable. No black-box logic, no lock-in.

Daily Refreshes

All sources updated daily. Alerts fired to Slack if something breaks before you see it.

Standard integrations

ShopifyMeta AdsGoogle AdsGA4KlaviyoTikTokAmazonRecharge+ custom sources on request
Dashboard Suite

Every report you need, built for your business.

A full Looker Studio dashboard suite tailored to your metric definitions, your brand, and your growth model. Daily triage, weekly summaries, and a single view of the business your entire team can read from.

Daily and weekly Slack insights are also pushed to your workspace automatically, so the team stays on top of performance without opening a dashboard.

lookerstudio.google.com/reporting/crux-kpi-dashboard
Crux KPI Dashboard · Looker Studio

Revenue

£48.2k

+12%

Orders

412

+8%

CAC

£24.10

-6%

Daily Revenue vs. Forecast

Actual
Forecast

Dashboard Suite

Full reporting for performance vs budget, new customers, retention, LTV, and unit economics.

Business Overview

Daily revenue, orders, conversion rates, and contribution margins (CM1–CM3). New vs. returning customers and CAC.

Health Monitoring

Statistical anomaly detection across 12 weeks of same-weekday history. Four-tier classification flags what actually needs attention.

Channel Performance

Meta, Google, and TikTok deep dives with CAC, spend efficiency, creative diversity, and ad fatigue tracking.

LTV & Retention

Cohort-based LTV by acquisition channel, product, and geography. CAC payback periods and retention curves.

Profitability

Product-level COGS, fulfilment, and payment processing. Three contribution margin levels for true unit economics.

Attribution

Cross-channel attribution combining GA4, UTM tracking, post-purchase surveys, and cross-device identity.

Access Methods

One data layer. Three ways to use it.

The same clean, validated, modelled data underneath — whether you are checking a dashboard, running a query, or asking a question in Slack.

Looker Studio dashboards with health monitoring

Not just 'conversion rate dropped 15%' but whether that drop is unusual for a Tuesday in March. Statistical anomaly detection with four-tier classification: Urgent, Caution, Opportunity, and No Action.

  • Business Overview with daily revenue, orders, and CM1/CM2/CM3
  • Health indicators comparing against 12 weeks of same-weekday data
  • Marketing performance by channel (Meta, Google, TikTok, Influencer)
  • LTV cohorts by acquisition channel, product, and geography
  • Creative fatigue tracking with ad production forecasting
  • Profitability analysis at product and order level
Pricing

The platform is the foundation of every retainer.

All plans include the full data layer, all dashboards, AI analyst access, and BigQuery warehouse. The difference is the number of advisory hours per month.

Essentials

3 hrs/month

£759/mo

Platform running with a monthly strategic check-in.

Growth

6 hrs/month

£1,089/mo

Actively working on growth initiatives and analytical projects.

Scale

9 hrs/month

£1,399/mo

Multi-market brands, Amazon-heavy operators, or advanced programmes.

See the data layer in action.

Every engagement starts with a two-week pilot where we build a demo version of the data layer on your data. £299, fully credited against whatever you commit to next.

Book a Call