Talk to an engineer

Case study · Consumer goods · Fortune 250 company · Since 2019

Bennett built and operates the D2C analytics platform for seven brands at a Fortune 250 consumer-goods company

Multi-brand, direct-to-consumer e-commerce analytics. Since 2019, Bennett has grown the platform from one brand to seven, standardized KPI logic across the portfolio, & brought recurring reporting from about a week to minutes. Worldwide.

One platform, four layers, seven brands

Bennett turned seven separately reported brands into one governed analytics platform. Scroll to see it built, layer by layer.

One platform, four layers, seven brandsBrand-level data from seven brands flows into per-brand warehouses, through one shared KPI logic layer, into brand and corporate dashboards with a portfolio roll-up, and on to customer analytics: lifetime value, acquisition cost, retention and predictive models.01 CUSTOMER ANALYTICSLifetimevalueAcquisitioncostRetentionPredictivemodels02 REPORTING LAYERCorporate dashboards · Portfolio roll-updef. Adef. Bdef. Cdef. Ddef. Edef. Fdef. G03 STANDARDIZED KPI LAYERONE KPI LOGIC · DEFINED ONCE · SAME MEANING IN EVERY BRAND04 DATA FOUNDATIONper-brand warehouses · recurring ETLBRAND-LEVEL DATA FROM ACROSS CHANNELSBrand 1Brand 2Brand 3Brand 4Brand 5Brand 6Brand 7Brand 1 since December 2019 · seven brands todaySeven tools · seven KPI definitionsAbout a week of manual reconciliation for each portfolio report
Select a brand to trace its data through the platformDrawn from the four layers Bennett built and operates · Brands shown schematically · Not to scale
  1. Before

    Seven brands, seven ways of reporting

    Each brand reported its own way, in its own tools, with its own KPI definitions. One metric meant different things across brands, and the recurring portfolio report took an analyst about a week of manual reconciliation.

  2. 04 · Data foundation

    Every brand’s data, in one platform

    Per-brand warehouses, source connectors and recurring ETL pull brand-level data from across channels into one platform. Each brand keeps its own warehouse, and every brand arrives in the same platform.

  3. 03 · Standardized KPI layer

    One definition for every metric

    One shared KPI logic, defined once and maintained by Bennett, so the same metric means the same thing in every brand. This is the layer that makes seven brands directly comparable.

  4. 02 · Reporting layer

    From a week to minutes

    Tableau brand and corporate dashboards plus a portfolio roll-up replaced the fragmented reporting. The recurring portfolio report that took about a week now runs in minutes.

  5. 01 · Customer analytics

    Where the decisions get made

    Lifecycle views of lifetime value, acquisition cost and retention, with predictive models where brand data supports them. Leadership sees which brands lead or lag, where acquisition cost is rising and where lifetime value is strongest.

  6. The platform today

    Built and operated by Bennett since 2019

    One brand in December 2019, seven today, on one governed platform that corporate reads on a single standardized set of figures.

    • 1 → 7brands on the platform
    • Week → minrecurring portfolio report
    • ~6 yrsbuilt and operated by Bennett

Bennett gives the corporate parent one standardized view of worldwide direct-to-consumer performance across all seven brands. The recurring portfolio report that once took an analyst about a week of manual reconciliation now runs in minutes, and brands can be compared directly on the same definitions.

Seven brands, from separate reporting to one portfolio viewBefore: seven brands each reported their own way, with their own KPI definitions, and one analyst reconciled them by hand into a portfolio report that took about a week. After: all seven brands flow through one shared KPI logic layer into one portfolio view on the same definitions, and the report runs in minutes.SEVEN BRANDS · EACH REPORTING ITS OWN WAYSEVEN BRANDS · ONE SET OF DEFINITIONSMANUAL RECONCILIATIONone analyst, every reporting cyclePortfolio reportONE SHARED KPI LOGIC LAYERONE PORTFOLIO VIEWsame definitions · every brandB1B2B3B4B5B6B7def. AB1def. BB2def. CB3def. DB4def. EB5def. FB6def. GB7RECURRING PORTFOLIO REPORTBeforeabout a weekAfterminutes
Brands shown schematically · Bars illustrate a shared comparison, not reported values

Before

  1. Each brand reported its own way, in its own tools, with its own KPI definition
  2. One metric meant different things across brands
  3. Corporate could not compare brands directly
  4. A recurring portfolio report took an analyst about a week of manual reconciliation

After

  1. Every brand is read through one shared KPI logic layer
  2. The same KPI means the same thing everywhere
  3. Corporate compares the full portfolio on one standardized set of metrics
  4. The recurring portfolio report runs in minutes

Bennett turned scattered brand reporting into a governed portfolio platform. Leadership moved from manual reconciliation to comparable brand views and recurring reporting in minutes, and can now read the full portfolio on one standardized set of figures: which brands lead or lag, where acquisition cost is rising and lifetime value is strongest, and which brands deserve more support, more scrutiny, or a strategic decision.

Next case studyBennett built the risk model behind Irth's North American recurring revenue product
Talk to an engineer