Demo — All numbers below are illustrative sample data. For context, see Attribution for Offline Conversions.

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.

Referral signups
152
From the top 6 referrers
Converted to paid
95
62.5% conversion rate
New customer revenue
$168.1k
12-month projected ARR from referred customers
Top referrer
Lina Park
24 converted · $41.3k
New customer revenue by referrer

Sorted by 12-month projected ARR from their referred signups

Referral funnel over time

Clicks on referral links → signups → paid conversions, by month

Cascading attribution: revenue by referrer's origin source

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.

Top referrers

Joined view across the marketing site, signup pipeline, and Stripe

ReferrerCodeCustomer sinceOriginally acquired viaReferralsConvertedConv. rateNew cust. revenue
Lina Park?r=lina2024-08-12
Paid Search — Google
brand_terms_us
382463%$41.3k
Owen Riley?r=owen422024-11-03
Paid Social — Facebook
lookalike_smb_q4
311961%$34.5k
Zara Okonkwo?r=zara2025-01-22
Organic — SEO
/blog/team-onboarding
261765%$28.9k
Sam Tahir?r=samt2025-03-19
Paid Search — Google
competitor_terms
221464%$24.2k
Ana Mendes?r=amendes2024-07-04
Affiliate — partner network
devtools_directory
191263%$22.4k
Kai Brennan?r=kaib2025-05-30
Paid Social — Facebook
retargeting_pricing
16956%$16.8k
One referral, end to end

A single new customer's journey from a friend's referral link to a renewed Stripe subscription

occurred_atpersoneventdetailnote
2024-08-12T09:31:00Zp_lina_parkpage_viewedsite.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:00Zp_new_4892page_viewedsite.com/?r=linaA friend lands on the marketing site with ?r=lina query param
2026-04-08T12:16:32Zp_new_4892signup_completedTrial — $0 / Pro planIdentity resolved to a new person record
2026-04-22T08:42:09Zp_new_4892subscription_started$24.00 / mo (Stripe)Conversion event, 14 days later
2026-05-22T08:42:09Zp_new_4892subscription_renewed$24.00 / mo (Stripe)+30 day retention — credits Lina with $48 of new customer revenue