Tracking referrals? Encouraging users to invite others?

Community Building
3

As @fefrei said, you can use Data Explorer with a query like this:

-- [params]
-- int :limit

select user_id, 
    invited_by_id
from invites
where created_at > CURRENT_TIMESTAMP - INTERVAL '30 days'
and user_id > 1
limit :limit

And modify that query with more complex query if you want.
See this queries’s directory that you can use

Good luck !

Ps, updated: I added tracking-referrals.sql to the list :wink:

10 „Gefällt mir“