Is the marketing warehouse under control?

Check the items your organisation already meets. You will get a maturity score and pointers on where to start.

GA4 (or other analytics) export to the warehouse is configured and monitored Ecommerce events send transaction_id (or equivalent order key) CRM / ERP data is loaded into the warehouse on a known schedule Ad spend (Google Ads, Meta, etc.) lands in the warehouse or joins on campaign key Time zones and currencies are unified across sources before reporting

We have separate raw / staging / marts layers (or equivalent split) Facts and dimensions have a defined grain (e.g. day, order, customer) A customer key links analytics, CRM and store data (where possible) SQL / dbt transforms are versioned and documented Table retention and partitioning are planned (costs under control)

Business glossary contains approved definitions of key marketing KPIs Each metric has an assigned owner (Data Owner) Revenue and conversion have one business definition company-wide Exclusions are documented (cancellations, returns, test orders) Metric definition changes are versioned and communicated to report users

Executive report has documented lineage (where each number comes from) Self-service is limited to approved views / semantic layer Critical dashboards have regression tests or review before publish Report refresh schedule is known and enforced Anomaly alerts (conversion drop, source mismatch) are configured

Warehouse access is controlled by IAM roles (not everyone sees everything) Dev / test / prod environments are separated Backup and recovery procedure has been tested BigQuery (or other warehouse) costs are monitored with alert thresholds

Your score

Want to improve your score?

I help build marketing data layers - from GA4 and BigQuery to Power BI and governance.

Resources hub BQ calculator DG guide Services

Original editorial work. 24 items in 5 categories; score calculated locally in the browser. Not a substitute for a technical or legal audit. Last verified: July 3, 2026.

Is the marketing warehouse under control?

Sources and ingest

Warehouse and model

Metrics and single version of truth

BI and consumption

Operations and access

Your score

Want to improve your score?

Is the marketing warehouse under control?

Sources and ingest

Warehouse and model

Metrics and single version of truth

BI and consumption

Operations and access

Your score

Want to improve your score?

This site uses cookies

Cookie settings

Essential

Analytics

Marketing