A data warehouse collects data from many sources, such as Shopify orders, GA4 events, ad spend, email and SMS data, and cost of goods, and stores it in tables built for analysis. Common cloud options include Google BigQuery, Snowflake and Amazon Redshift. Data usually arrives through native exports or connector tools, and analysts query it with SQL or connect a dashboard tool on top.
GA4 has a native export to BigQuery. Standard GA4 properties have a daily export limit of 1 million events, and you can start in the free BigQuery sandbox, although storage and queries beyond its limits are billed.
Why it matters for eCommerce
Each platform reports its own version of the truth. A warehouse lets you join them: real order revenue and margin from your store, spend from every ad account, and behavior from GA4. That is what makes profit-first reporting possible, such as contribution margin by channel, cohort LTV by first product and POAS by campaign. It also keeps your raw data under your control, beyond the retention limits of each tool.
How it works in practice
- Start with the questions you need answered, not with every possible source.
- Connect the core sources first: store orders, GA4 and the ad platforms that take most of your budget.
- Build clean, documented tables (orders, customers, spend by day and channel) that reports read from.
- Add cost data so dashboards show margin, not just revenue.
Common mistakes
- Loading every source with no clear use case, then paying for storage nobody queries.
- Letting each analyst define metrics differently, so reports still disagree.
- Assuming the GA4 export will match Shopify revenue without reconciling the two.
- Building a warehouse before basic tracking and data quality are fixed.