How to Transform Your E-commerce Data into Business Metrics

If you’re a DTC founder selling goods through an e-commerce store, there’s a pretty good chance you’re using a platform like Shopify, BigCommerce, or Woocommerce, and one of the dozens of analytics extensions like RetentionX, Sensai metrics, or Profitwell that provide off-the-shelf reporting.

At a high level, these tools are excellent for helping you understand “what” is happening in your business, but you’ll inevitably find yourself asking deeper questions that your off-the-shelf extensions can’t answer. You might also be frustrated to learn that the revenue reported by these off-the-shelf dashboards is inconsistent with the revenue that your finance team reports.

When you find that these problems are impeding your ability to make important decisions, it’s time to start thinking about building a data warehouse.

We created this guide for founding teams in M13’s portfolio companies who need a data warehouse but aren’t seasoned data pros. We’ll walk you through the fundamentals of modeling transactional sales data.

In this guide, we’ll cover:

Here’s what else you’ll need to get started:

This guide also includes sections that may be valuable to the SQL developer building the database, including: If you’re a founder at an M13 portfolio company who needs references for a contract or full-time SQL developer, please reach out to us on Slack or at propulsion@m13.co.