Europe/Paris
Projects

Hercules Thrustmaster Affiliate System (Freelance)

Hercules Thrustmaster Affiliate System (Freelance)
January 31, 2025
As part of a freelance assignment for Hercules Thrustmaster (2023 – present), I designed and built a complete affiliate system from scratch. The goal: to create a robust, scalable solution for the marketing department, integrated into the existing infrastructure. This strategic project is now in production and continues to evolve with new features. An affiliate marketing system allows a brand to rely on a network of partners (content creators, media, gamers) to promote its products. Each affiliate has unique tracking links and earns a commission on the sales they generate. Building such a platform in-house rather than relying on a third-party solution provides full control over business rules, data, and integration with the brand's ecosystem. The core of the platform relies on three complementary mechanisms:
  • 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.
  • Partner registration and approval
  • Generation of unique tracking links
  • Personalized dashboards for each affiliate
  • Real-time performance tracking (clicks, conversions, revenue)
  • Marketing dashboard with consolidated KPIs
  • Report exports for accounting
  • 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
The backend follows the MVC pattern provided by CodeIgniter 4: controllers orchestrate requests, models encapsulate data access and business logic, and views handle the rendering of dashboards. This separation of concerns makes maintenance easier and allows new features to be added without a full rewrite. The MySQL database was modeled to support reliable transactional data. The main entities revolve around affiliates, clicks, conversions, commissions, and progression tiers. The relationships between these tables make it possible to trace, for each piece of revenue, the entire chain (from the initial click to the commission paid out), while keeping queries performant for real-time dashboards. Gamification is designed as a lever to drive affiliate engagement:
  • 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.
Handling financial data demands a high level of rigor:
  • 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.
  • 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
The cross-functional dimension was decisive: each department brought its own constraints (steering needs on the marketing side, accuracy requirements on the accounting side, regulatory framework on the legal side, specific operations on the esports side). Translating these requirements into clear specs, then into a data model and iterations delivered to the staging environment before production, was the guiding thread of the project.
  • Backend: PHP 8, CodeIgniter 4 (MVC)
  • Database: MySQL (schema optimized for transactional data)
  • Frontend: HTML, CSS, JavaScript (Thrustmaster brand guidelines)
  • Tools: GitLab, staging environment
  • 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
The freelance assignment continues with:
  • Ongoing maintenance and support
  • New features according to business needs
  • Performance and UX optimizations
This experience allowed me to strengthen my skills in full stack development, project management, and cross-functional collaboration on a real product in production.