Data questions to BI fell about 90% after I rebuilt it. I help other teams free up time the same way.

Both systems below run in production at a 90-person HR tech company, where I lead BI in-house. For other companies, I advise, build it with the team, or teach them to build it themselves.

I built the system that shows which channels drive signups, and what they cost.

My role: I designed and built the stack; my teammate wrote parts of the attribution SQL.

Before

We couldn't reliably tell which channels brought in signups.

Gaps in the tracking made it hard to tell what was working.

Now

~95% of signups covered by the attribution model.

Combining tracked data with survey-informed estimates.

Finance, marketing, and leadership could now see what each channel cost and what it brought back.

What I built

A channel classifier and daily SQL models that combine tracked data with survey-informed estimates, then price each channel with ad spend and finance costs.

How it works

Each signal from ads, forms, and product data flows into one system that prices each channel.

The website sends consent and tags through Google Tag Manager to Amplitude events and the signup survey. An attribution model in BigQuery, a channel classifier and daily SQL models, covered about 95% of signups, combining tracked data with survey-informed estimates. Before, gaps in tracking made it hard to tell which marketing channels brought in signups. Cost allocation adds ad spend and finance costs, and Hex dashboards show CAC by channel and campaign return. Attributed signups flow back into Google Ads as the conversion signal. Before building, the AI agents learned from 47 expert sources on attribution.

Also applied to

  • Finance

    The workspace I built survived a handover; the incoming owner ran the recurring work alone after 2 sessions, and it's still in use months later.

  • Product marketing

    Emails used to need manual fixes between the design tool and delivery platform; the next one rendered correctly on the first attempt, in under 1 hour.

Let's build something like this for your team.

Working together can mean advisory, hands-on implementation, or training your team to build it themselves. If you want to start smaller, the €400 Starter Kit gives you a working workspace, 6 installable skills, and a 1-hour session.