How can Data Explorer list invited user link url

[Jun]

I’ve created multiple links to invite users. When user invited, how to distinguish the specific link url user clicked?

[tobiaseigen]

That’s a good question. Looks like the pending invites page only displays how many times a given invite has been redeemed, and the redeemed page only shows the invited users and whether the invitation was sent via link or email.

A small product improvement could be to change the last column on the redeemed list so it displays the link code itself instead of simply link/email.

It would also be helpful if the first column on the pending list could be improved:

• show full invite code link instead of just the first four characters
• link to a filtered view of redeemed invites, showing just the members who that used that invite link code to join the site.
• when an invite is sent by email, still show the full invite link code and indicate if it was redeemed

The invite modal could also be improved:

• indicate next to “max uses” how many times an invite has already been redeemed, as a link to a filtered view of redeemed invites
• if an emailed invite has already been redeemed, indicate that it has already been redeemed with a link to a filtered view of redeemed invites
• if an emailed invite has already been redeemed, do not allow the update and update and send email to be submitted.

[tobiaseigen]

I just noticed that you are asking about data explorer. It certainly is possible to get this data that way - try using the query below.

@tobiaseigen

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