New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
There's no number to sum, just the fact that something happened, and I don't know how to model that.
What you'll have at the end
A fact table with no measures at all, counted by row instead of summed
You need
A log of signup events from your product, each carrying the source system's own event id, a timestamp, and which marketing channel or campaign brought that person in.
Not covered
Answering which campaigns brought in zero signups at all, which needs a coverage table listing every campaign that ran, a different technique than counting the signups you already have.
Leans on
Design your first star schema
Start there first if you haven't built a normal, measure-bearing fact table yet; this recipe assumes you already know what a fact and a dimension are.
Untangle a many-to-many relationship with a bridge table
Reach for this instead when one occurrence ties several rows of the same dimension together, like several categories on one order, rather than a single event with no measure.
Checked 25 Aug 2026
Part of the Data Warehousing cookbook