Discourse Affiliate - Invite to community

[Timelord]

Hey team.

I did use the search box, but I could not find specifically what I am looking for.

What I would like to do is implement an old school affiliate program for Discourse. Simple as each user can create an affiliate link (linking back to the community). Each time the link is used, and a person signs up, the ‘owner’ of the affiliate link gets some kind of credit. Initially, a straight up count would work.

Down the road, I would like to integrate with the gamification plugin, but that’s for another day.

[Timelord]

It looks like the invite functionality may work.

Now - question is, is there a way to report on number of folks who signed up with an invite link.

[Moin]

You can use data explorer

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

[Timelord]

This will do just nicely. I can run the report, and add the points manually into the gamification plugin.

Thanks.

[tobiaseigen]

You can also look into the ?username system in discourse, which keeps track of and awards badges to users automatically when their links are followed. The button on the post menu adds this automatically as you grab the link.

See https://meta.discourse.org/badges/21/nice-share for how this looks here on meta.