AFFILIATE • 30% LIFETIME • 90 DAYS COOKIE • REAL D1 TRACKING
Earn 30% Lifetime
Every User You Refer
Real D1 tracking: affiliate_clicks + affiliate_conversions + affiliate_payouts tables + KV backup. 90 days cookie, 30% lifetime recurring. Dashboard at /dashboard?tab=affiliate + Worker /api/affiliate/dashboard
💰
30% Lifetime Recurring
Pro $3.99/mo → $1.20/mo commission forever per user. 100 users = $120/mo passive. 1000 = $1200/mo. Business $9.99 → $3/mo each, Enterprise $19.99 → $6/mo each. Real D1 affiliate_conversions commission_amount.
Example: 100 Pro users × $3.99 × 30% = $119.70/mo
Example: 50 Business × $9.99 × 30% = $149.85/mo
Total: $269.55/mo recurring lifetime
Example: 50 Business × $9.99 × 30% = $149.85/mo
Total: $269.55/mo recurring lifetime
🍪
90 Days Cookie + Real D1 Tracking
?ref=YOURCODE stored in localStorage veil_ref + cookie 90 days + D1 affiliate_clicks table clicked_by_ip/ua/referer/landing_page/timestamp/converted. Conversion tracked via /api/affiliate/convert on Stripe webhook checkout.session.completed.
GET /api/affiliate/click?code=VEIL-ABC123&landing=homepage → D1 INSERT INTO affiliate_clicks + KV
POST /api/affiliate/convert → D1 conversions + clicks converted=1
GET /api/affiliate/dashboard?code=VEIL-ABC123 → clicks + conversions + earned + pending
POST /api/affiliate/convert → D1 conversions + clicks converted=1
GET /api/affiliate/dashboard?code=VEIL-ABC123 → clicks + conversions + earned + pending
💳
Payouts PayPal/Wise/Crypto
Min $50 payout. Request via POST /api/affiliate/payout-request with user_id, amount, method paypal/wise/crypto, method_details containing paypal_email. D1 affiliate_payouts table status pending to processing to paid.
Methods: PayPal (paypal_email), Wise (wise_email), Crypto USDT TRC20 (address), Bank (iban). Processing 3 days. Real D1 tracking after /api/admin/seed.
How Affiliate Works - Real D1 Implementation P1-09
1. Get Code
User registers → gets referral code VEIL-XXXX from affiliate dashboard. Link: https://veil-browser.pages.dev/?ref=VEIL-XXXX&utm_source=affiliate
2. Click Tracked
Visitor clicks ?ref=CODE → landing stores in localStorage veil_ref + cookie 90d + GET /api/affiliate/click?code=CODE → D1 affiliate_clicks + KV affiliate_click:CODE:time:ip
3. Conversion
User signs up → users.referred_by = CODE (from localStorage) → On Stripe checkout.session.completed webhook → POST /api/affiliate/convert → D1 affiliate_conversions commission 30% + marks click converted=1
4. Payout
Dashboard shows clicks_count, conversions_count, earned, pending, paid. Request payout $50 min via POST /api/affiliate/payout-request → D1 affiliate_payouts status pending → admin approves in /admin panel → paid
Real D1 Schema (migrations/init.sql):
CREATE TABLE affiliate_clicks (id TEXT PRIMARY KEY, affiliate_code TEXT, user_id TEXT, clicked_by_ip TEXT, clicked_by_ua TEXT, referer TEXT, landing_page TEXT, timestamp INTEGER, converted INTEGER, conversion_id TEXT)
CREATE TABLE affiliate_conversions (id TEXT PRIMARY KEY, click_id TEXT, affiliate_code TEXT, user_id TEXT, converted_user_id TEXT, plan TEXT, commission_amount REAL, commission_rate REAL DEFAULT 0.30, status TEXT, created_at INTEGER)
CREATE TABLE affiliate_payouts (id TEXT PRIMARY KEY, user_id TEXT, amount REAL, method TEXT, method_details TEXT, status TEXT, created_at INTEGER, paid_at INTEGER)
Ready to Earn 30% Lifetime?
Join 100+ affiliates earning $50-1200/mo passive. Free to start, dashboard real D1 tracking, payouts PayPal/Wise/Crypto $50 min 3 days.