Можно ли связать ID транзакции с реферальной ссылкой?

[tobiaseigen]

Try with this data explorer query.

Use data explorer to get a list of users who signed up via invitations

I was able to update this data explorer query to include the invite_key used by the user to join the site. SELECT u1.username AS invitee, u2.username AS inviter, i.invite_key, iu.redeemed_at FROM invited_users iu JOIN invites i ON iu.invite_id = i.id JOIN users u1 ON iu.user_id = u1.id JOIN users u2 ON i.invited_by_id = u2.id WHERE iu.redeemed_at IS NOT NULL ORDER BY iu.redeemed_at DESC