Journal · 10 min
Cohorts without vanity sign-ups
Marketing will always want the largest denominator. Product needs the honest one. If you start the activation clock at form submit, you mix people who never saw the app with people who bounced on SSO. Both groups matter. They are not the same leak.
Hostmatrixbase’s Cohort Lattice Lab asks for three grains: submitted, reached first surface, completed activation behaviour. Report all three. Never average them. The Sheffield HR case on our reviews page is the dull version of this sermon, and it still saves quarters of argument.
Invited seats deserve a fourth grain. An admin can manufacture “new users” all afternoon. If those rows never accept, your activation rate is a story about email, not product.
When leadership asks for a single number, give them the middle grain as the headline and the other two as footnotes they cannot delete from the slide. If they delete them anyway, you have a governance problem, not a Looker problem.