All case studies
Data & AI PlatformingConsumer RetailOperations
Optimizing marketing and merch operations
"Pyne unified our data across six platforms, giving leadership real-time visibility into CLTV and CAC. Their training embedded data-driven decision-making across our teams, transforming how we operate."
Campbell Ruggles
Co-founder
Client Background
Assembly is a leader in premium, custom apparel with a powerful digital platform and fully integrated supply chain. Data lived across MSSQL, HubSpot, Google Ads, Facebook Ads, Mixpanel, and Sanity—making it hard to get a single view of core metrics and day-to-day operations.
Aspiration
Centralize fragmented data and deliver executive-grade reporting so leadership can track CLTV, CAC, and inventory health—fast. Build this on solid governance while delivering quick wins that the wider organization can adopt.
How We Did It
- Centralized Data Platform (Less): Consolidated six sources into one governed platform—removing silos and enabling a unified business view.
- Semantic Layer & Reporting (Steep): Built role-based, management reporting with a consistent semantic layer as the single source of truth.
- Custom Reports: Delivered three executive dashboards focused on CLTV, CAC, and Inventory overview—aligned to sales, marketing, and leadership needs.
- Enablement: Ran targeted Steep training to drive adoption and embed data-driven decision-making across teams.
Key Outcomes
- Unified Visibility: Leadership now sees CLTV, CAC, and inventory in one place—no more stitching spreadsheets.
- Enhanced Decision-Making: Management reports are a standing item in executive meetings, improving clarity and speed of action.
- Operational Efficiency: Streamlined data flows reduced manual work and complexity across departments, creating a scalable foundation for future AI use cases.
Want similar results?
Let's discuss how we can help transform your data capabilities.