Stop Guessing Which Marketing Channels Work.
Start Driving Profitable Growth.
Your e-commerce data is fragmented across Shopify, Google Analytics, and a dozen ad platforms. You're making critical budget and strategy decisions based on incomplete reports and manual spreadsheets, leaving revenue on the table.
Our packaged eCommerce analytics solution takes you from fragmented data to a single source of truth for attribution, LTV, and cohort analysis in weeks, not months.
View Github RepoWhen Your Data Can't Keep Up with Your Customers
As a modern e-commerce brand, you're interacting with customers across countless touchpoints. But without a unified data foundation, you're facing a set of familiar, high-stakes challenges.
You're Flying Blind on Attribution
You can't connect ad spend to the actual LTV of the customers they acquire.
You Don't Know Your True Customer Value
Calculating an accurate LTV or understanding your most valuable customer segments is a manual, error-prone process.
Your Team is Drowning in Manual Reporting
Your most valuable team members spend hours every week in spreadsheets, leaving no time for strategic analysis.
Answer Your Most Critical E-commerce Questions,
Out-of-the-Box
The RA Warehouse for E-commerce is a customisable and extensible dbt package and set of example React dashboards that solves the core analytics challenges for D2C brands. It integrates your transactional, behavioral, and marketing data into a single, cohesive data model, ready for analysis.
Customer Lifetime Value (LTV)
Accurately calculated and sliced by acquisition cohort or channel
Customer Acquisition Cost (CAC)
A blended CAC across all channels for a true profitability picture
LTV:CAC Ratio
The ultimate measure of marketing efficiency
Cohort Retention Analysis
Track how well you retain customers from each monthly acquisition cohort over time
RFM Segmentation
Automatically segment your customers by Recency, Frequency, and Monetary value to identify your VIPs, at-risk customers, and more
Create a Single View of your eCommerce KPIs
Everything you need to understand your customers, optimize marketing spend, and grow revenue, using our extensible and customisable dbt Package and LookML project
Accelerate Your Journey to Data-Driven Growth
Building a custom data warehouse takes 6-12 months and is fraught with risk. Our pre-built solution delivers 80% of what you need in a fraction of the time, allowing you to focus on insights, not infrastructure.
Rapid Time to Value
Go from siloed data to a unified warehouse in 2-4 weeks. Our proven, pre-built data models are designed for rapid deployment and immediate business impact.
Flexible & Extensible
Our modular architecture allows you to use only the components you need and easily add custom metrics without breaking the core functionality. The open-source dbt code provides complete transparency and control.
Best Practices Built-In
Benefit from our years of expertise. We've built in best practices for identity stitching, incremental data processing, data quality testing, and comprehensive documentation, ensuring your platform is reliable and scalable from day one.
Open-Source dbt Package for eCommerce Analytics
The RA Ecommerce Data Warehouse v2 is a comprehensive dbt project that integrates data from multiple ecommerce and marketing platforms, following best practices for data modeling and providing extensive analytics capabilities.
Key Features
Multi-Source Integration
Shopify, Google Analytics 4, Google/Facebook/Pinterest Ads, Klaviyo, Instagram Business
Layered Architecture
Staging → Integration → Warehouse with clear separation of concerns
Data Quality Monitoring
Comprehensive pipeline health tracking and data quality metrics
Attribution Analysis
Multi-touch customer journey attribution across all touchpoints
Performance Analytics
Campaign performance, customer segmentation, product analytics
Comprehensive Testing
100+ data tests for data integrity and business rules
Need help adopting, customizing, or extending the package to cover additional data sources?
Open-Source & Extensible
Ready to Centralise Your eCommerce KPIs?
Get fast time-to-value with a packaged analytics solution from Rittman Analytics