January 31, 2025
Overview
How the affiliate system works
- Tracking via unique links: each approved affiliate is assigned a unique identifier, propagated through their links. When a visitor clicks, the click is timestamped and attributed to the source affiliate.
- Conversion attribution: an order placed following a click is attributed to the responsible affiliate according to a defined attribution window, making it possible to precisely link revenue to the source that generated it.
- Commission calculation: for each attributed conversion, the system calculates the commission due by applying the rate corresponding to the affiliate's tier, then consolidates these amounts for reporting and accounting.
Key features
Affiliate management
- Partner registration and approval
- Generation of unique tracking links
- Personalized dashboards for each affiliate
Analytics & Reporting
- Real-time performance tracking (clicks, conversions, revenue)
- Marketing dashboard with consolidated KPIs
- Report exports for accounting
Gamification & Incentives
- Tier system: automatic progression based on performance, with increasing commission rates
- Loyalty program: points redeemable for goodies and perks
- Bounties: bonuses on specific products when targets are met within a set timeframe
- Referrals: commission on the volume generated by referred affiliates
Architecture & data modeling
Gamification mechanics
- Tiers and commission thresholds: progression automatically unlocks higher commission rates, rewarding the most active partners.
- Time-limited bounties: targeted goals on specific products, valid over a given period, create controlled spikes in activity.
- Multi-level referrals: an affiliate can recruit other partners and earn a share of the volume they generate.
- Loyalty points: accumulated based on activity and redeemable for perks.
Security & reliability
- Data validation: systematic checks of inputs (registrations, tracking parameters) to prevent inconsistencies and injections.
- Click fraud prevention: detection of abnormal behavior to ensure that only legitimate interactions feed commissions.
- Transactional integrity: consistency between clicks, conversions, and commissions is preserved so that the amounts reported to accounting are always accurate and auditable.
Challenges and lessons learned
- From-scratch development: functional specifications, data modeling, anticipating future changes
- Cross-department collaboration: coordination with marketing, accounting, legal, and esports
- User iterations: continuous adjustments based on feedback from affiliates and internal teams
- Progressive rollout to production: staging, database migrations, security, monitoring
Tech stack
- Backend: PHP 8, CodeIgniter 4 (MVC)
- Database: MySQL (schema optimized for transactional data)
- Frontend: HTML, CSS, JavaScript (Thrustmaster brand guidelines)
- Tools: GitLab, staging environment
Impact
- Platform operational in production since 2023
- Significant reduction in affiliate management time for the marketing team
- Scalable solution allowing new features to be added without a full rewrite
Current status
- Ongoing maintenance and support
- New features according to business needs
- Performance and UX optimizations
