Spot a referral ring by the browser it was made from
A referral you can reach from the referrer's own browser is self-referral. One query separates a farm from a community.
Tagged “referrals”
5 entries
Filter out referrals that were never real
Count active referrals, not registered ones. Four queries that separate a genuine promoter from someone with a script.
Three referral commission models, and what each one costs
Percentage of earnings, one-off signup bonus, or a share of what you earn from the referral. The arithmetic that decides which one bankrupts you.
Attribute a referral with a cookie and a window
First touch or last touch, a window that expires, and the check that stops a user referring themselves.
Generate referral codes that survive contact with users
Short, unambiguous, collision-checked, and not the username. The alphabet choice is what stops support tickets about codes that do not work.