Contact us
Measurement & Data System

Each phase works on its own, or as part of the full path.

03

Data modeled around your questions, instead of the most convenient schema.

Data Preparation · Business requirements & markets

Having lots of data doesn't mean having answers: in this phase we turn raw data into something that answers real business questions. By market, by channel, by goal, instead of leaving you a messy warehouse to interpret on your own.

It's work done together with you: without knowing what you need to decide, no data preparation makes sense.

How we do it

  1. 01We start from your business questions and KPIs, collected through a structured form rather than a conversation.
  2. 02We translate market logic (segments, territories, channels) into readable data models.
  3. 03We write attribution and deduplication as explicit rules: they're business decisions, not technical details.
  4. 04We transform into versioned SQL, with automated tests on the data.

The tools we use

Requirements Structured DATA FORM template
Transformation dbt, Dataform on BigQuery
SQL Scheduled queries, materialized views, stored procedures
Validation Great Expectations, custom checks

Frequently asked questions

What do you need from us for this phase?

Your business questions and KPIs, collected through a structured form (the DATA FORM) rather than a conversation: without knowing what you need to decide, no data preparation makes sense.

Why can't we just work with the raw data directly?

Because raw data answers to whoever generated it, not to your business questions. A messy warehouse left for you to interpret on your own wastes time every time you need a number.

What exactly is the DATA FORM you use?

A structured template for collecting your business questions and KPIs before we start modeling the data, so we start from what you need to decide, not from a standard schema.

Do you decide the attribution and deduplication rules, or do we decide together?

We write them as explicit rules together with you: they're business decisions (who gets credit for a contact, when two leads are the same one), not technical details left entirely to us.

Let's talk about your project.

No endless quotes. One call, a clear path, a written proposal.

Get in touch →

See the full Measurement & Data System path →