We are at eTail Connect West in Los Angeles, CA from 13-15th September, 2023. We are also hosting a roundtable exclusively for retailers. Meet us there for data chats & more!

Room vs House: Which data model suits your brand?

Balaji

Balaji

Co-Founder

Digital brands with well established product market fit often scale rapidly due to lower cost structures, availability of funds, and the ability to reach a global audience by leveraging digital marketing channels.

Unfortunately, in this pursuit of hyper-growth, most brands miss to pay more attention in putting together data systems to scale further and build a robust data-driven culture.

In this article, I would like to compare setting up a data function with an analogy of renting a room vs. building a house and discuss the pros and cons of each model. 

Room Model

In a rooms model, each business team (marketing, marketplaces, finance, and supply chain) lives in their own rooms (read silos), make their own decisions on tools, and have their own definitions of different business metrics like revenue, CLV, CAC, profits, etc. Business teams use point solutions available to support running their business functions. For example,

  1. Google Analytics, Triple Whale, or North Beam for attribution
  2. Lifetimely, Daasity, Glew for eCommerce reporting
  3. Seller Board, or Merchant Spring for managing their marketplace reporting 

There may be 1 or 2 room maintenance staff (read analysts) supporting all data needs of the organization. These analysts are often the first hire in data teams and are usually spread thin across different requirements. Learn about the cons of a one-person data team.

Benefits & Challenges of Room Model

Benefits

  1. The hotel model gives autonomy to teams and can be very efficient if founders are hands-on with marketing, operations, and finance. 
  2. Decision-making is faster and is vital in the early stage (<5M) 
  3. Most of the point tools are cost-effective in the initial scale (5M) 

Challenges

  1. Multiple sources of truth affect overall data quality, leading to limited data governance and misalignments between teams.
  2. Point solutions do not help with the deep financial and customer insights necessary for brands to become investor ready. 
  3. Point solutions are often not customizable to specific business use cases and do not cater to all required use cases. It leads to uncatered data needs as the scale of the business grows. 
  4. Founders, Investors, and CFOs who are not well-versed with the above tools and have limited bandwidth are usually dependent on individual teams for reporting and insights. 
  5. The frequency of comprehensive reporting is monthly at best and quarterly at worst  
  6. Blending data between different systems/sources is extremely limited, affecting team collaboration. 
  7. Any new data or report request takes a disproportionate amount of time to create and maintain 
  8. Setting organizational objectives and aligning all the teams on a standard measurement framework is challenging. 
  9. Hiring experienced professionals in different functions can be challenging as they expect data systems to already be in place to work. 

House Model

In the house model, a central data team is set up to build the data function from the ground up.

  1. Every house has a foundation, which in the data parlance is equivalent to consolidating data across all sources into a data warehouse.
    1. Cloud data warehouses like BigQuery or Snowflake can be set up in 15 minutes and are serverless, cost-effective, and easy to manage.
    2. No-code data pipelines like Daton make aggregating data in a data warehouse easy.
  2. Pillars in the house model are equivalent to modeled datasets in data stacks.
    1. Shopify, Amazon, and Walmart sales across countries can be unified into a single sales data set.
    2. Similarly, ads, customers, and finance can be unified into datasets for reporting and analysis.
  3. Dashboards and reports are equivalent to different rooms and interior elements of the house.
    1. Executives and Investors can have a central dashboard with access to every other team’s numbers.
    2. Each Individual team has its own room, which is customizable and accessible to other teams.
    3. As the foundation has all the data and pillars organized, building new dashboards and reports or rooms should be faster.  
    1.  

Benefits & Challenges of House Model

Benefits

  1. Single pane of view for all business teams (executive, finance, growth, product, and operations) to interact with and align on 
  2. Become investor ready by understanding profitability across different sales channels and customer profitability through cohorts in the D2C channel. 
  3. Stitch customer touchpoints across Ads, Analytics, Orders, Customer support, reviews, and surveys to create a unified customer profile 
  4. Use the raw events data from GA4 to create a custom multi-touch attribution model. 
  5. Blending data across is seamless, and model datasets should cover more than 80% of standard dimensions and metrics out of the box. 

Challenges

  1. Building a data team requires a specialized team of analytics engineers, data engineers, BI developers, and data scientists who are difficult to hire and expensive in the market. 
  2. Most brands end up hiring one or two analysts and expect them to perform all the roles leading to failed projects (Read more on Unicorn Analysts). 
  3. Any churn in the data team can mean loss of tribal knowledge leading to a black box for new resources who replace them. 

When should a brand move towards a House model?

I believe any brand with a revenue visibility of $10M ARR should invest in a house model, and the rationale is that every brand should budget 1% of its revenues in the data function. This 1% investment in optimizing their advertising strategies, becoming investor ready, and understanding the voice of their customer better more than pays for the investment. 

Are you tired of renting rooms and are considering shifting to a data house? Schedule a call with me, and I’ll be happy to showcase how we have helped hundreds of retail, eCommerce, and DTC brands accelerate their data journey!