Referral attribution (demo)
Which existing customers refer the most new customers? The referral link is a touchpoint (?r=<code> on the landing page). The conversion is a Stripe subscription. In the warehouse, the link between them is one identity-resolved join — including all the renewals that come months later.
Sorted by 12-month projected ARR from their referred signups
Clicks on referral links → signups → paid conversions, by month
New-customer revenue from referrals, grouped by the marketing source that originally acquired the referrer. A paid search dollar that brought in Lina also seeded 24 referred customers.
Joined view across the marketing site, signup pipeline, and Stripe
| Referrer | Code | Customer since | Originally acquired via | Referrals | Converted | Conv. rate | New cust. revenue |
|---|---|---|---|---|---|---|---|
| Lina Park | ?r=lina | 2024-08-12 | Paid Search — Google brand_terms_us | 38 | 24 | 63% | $41.3k |
| Owen Riley | ?r=owen42 | 2024-11-03 | Paid Social — Facebook lookalike_smb_q4 | 31 | 19 | 61% | $34.5k |
| Zara Okonkwo | ?r=zara | 2025-01-22 | Organic — SEO /blog/team-onboarding | 26 | 17 | 65% | $28.9k |
| Sam Tahir | ?r=samt | 2025-03-19 | Paid Search — Google competitor_terms | 22 | 14 | 64% | $24.2k |
| Ana Mendes | ?r=amendes | 2024-07-04 | Affiliate — partner network devtools_directory | 19 | 12 | 63% | $22.4k |
| Kai Brennan | ?r=kaib | 2025-05-30 | Paid Social — Facebook retargeting_pricing | 16 | 9 | 56% | $16.8k |
A single new customer's journey from a friend's referral link to a renewed Stripe subscription
| occurred_at | person | event | detail | note |
|---|---|---|---|---|
| 2024-08-12T09:31:00Z | p_lina_park | page_viewed | site.com/?gclid=Cj0KC… (utm_source=google,utm_medium=cpc) | Lina (the future referrer) is acquired via paid search 18 months earlier |
| 2026-04-08T12:14:00Z | p_new_4892 | page_viewed | site.com/?r=lina | A friend lands on the marketing site with ?r=lina query param |
| 2026-04-08T12:16:32Z | p_new_4892 | signup_completed | Trial — $0 / Pro plan | Identity resolved to a new person record |
| 2026-04-22T08:42:09Z | p_new_4892 | subscription_started | $24.00 / mo (Stripe) | Conversion event, 14 days later |
| 2026-05-22T08:42:09Z | p_new_4892 | subscription_renewed | $24.00 / mo (Stripe) | +30 day retention — credits Lina with $48 of new customer revenue |