Skip to content

feat(creators): added referrers, code redemption, campaign tracking, etc #3198

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
waleedlatif1 merged 11 commits into from
Feb 13, 2026
Merged

feat(creators): added referrers, code redemption, campaign tracking, etc #3198

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
11 commits
Select commit Hold shift + click to select a range
f757eed
feat(creators): added referrers, code redemption, campaign tracking, etc
waleedlatif1 Feb 11, 2026
f4f60d8
more
waleedlatif1 Feb 11, 2026
75b5e8f
added zod
waleedlatif1 Feb 11, 2026
54346a5
remove default
waleedlatif1 Feb 11, 2026
81f0ee8
remove duplicate index
waleedlatif1 Feb 11, 2026
bf29346
update admin routes
waleedlatif1 Feb 12, 2026
a10d418
reran migrations
waleedlatif1 Feb 12, 2026
55aa406
lint
waleedlatif1 Feb 12, 2026
9641389
move userstats record creation inside tx
waleedlatif1 Feb 12, 2026
31113e5
added reason for already attributed case
waleedlatif1 Feb 13, 2026
aaa4c1c
cleanup referral attributes
waleedlatif1 Feb 13, 2026
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
remove default
  • Loading branch information
@waleedlatif1
waleedlatif1 committed Feb 13, 2026
commit 54346a5aadfac5c1d0f6bbdc4fe38343a1e8b198
16 changes: 9 additions & 7 deletions apps/sim/app/api/attribution/route.ts
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -11,7 +11,6 @@
*/

import { db } from '@sim/db'
import { DEFAULT_REFERRAL_BONUS_CREDITS } from '@sim/db/constants'
import { referralAttribution, referralCampaigns, user, userStats } from '@sim/db/schema'
import { createLogger } from '@sim/logger'
import { eq } from 'drizzle-orm'
Expand Down Expand Up @@ -157,9 +156,12 @@ export async function POST() {
}

const matchedCampaign = await findMatchingCampaign(utmData)
const bonusAmount = matchedCampaign
? Number(matchedCampaign.bonusCreditAmount)
: DEFAULT_REFERRAL_BONUS_CREDITS
if (!matchedCampaign) {
cookieStore.delete(COOKIE_NAME)
return NextResponse.json({ attributed: false, reason: 'no_matching_campaign' })
}

const bonusAmount = Number(matchedCampaign.bonusCreditAmount)

let attributed = false
await db.transaction(async (tx) => {
Expand All @@ -168,7 +170,7 @@ export async function POST() {
.values({
id: nanoid(),
userId: session.user.id,
campaignId: matchedCampaign?.id ?? null,
campaignId: matchedCampaign.id,
utmSource: utmData.utm_source || null,
utmMedium: utmData.utm_medium || null,
utmCampaign: utmData.utm_campaign || null,
Expand All @@ -189,8 +191,8 @@ export async function POST() {
if (attributed) {
logger.info('Referral attribution created and bonus credits applied', {
userId: session.user.id,
campaignId: matchedCampaign?.id,
campaignName: matchedCampaign?.name,
campaignId: matchedCampaign.id,
campaignName: matchedCampaign.name,
utmSource: utmData.utm_source,
utmCampaign: utmData.utm_campaign,
utmContent: utmData.utm_content,
Expand Down
5 changes: 0 additions & 5 deletions packages/db/constants.ts
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -8,11 +8,6 @@
*/
export const DEFAULT_FREE_CREDITS = 20

/**
* Default bonus credits (in dollars) for referral signups
*/
export const DEFAULT_REFERRAL_BONUS_CREDITS = 10

/**
* Storage limit constants (in GB)
* Can be overridden via environment variables
Expand Down