v2.0

GoRules Version 2 is here - redesigned, now with managed cloud.GoRules Version 2 is here!

Watch the launch videoWatch

Affiliate Commission Calculator

Dynamic system that calculates precise affiliate payouts based on product category, performance metrics, and promotional factors.

Solution

This affiliate commission system calculates payouts by analyzing multiple performance factors to reward top-performing partners. The calculator first establishes base commission rates specific to each product category (electronics, fashion, beauty, and home goods), with fashion and beauty offerings earning higher rates to incentivize promotion in these categories.

Performance bonuses are determined by examining both referral volume and conversion quality. Affiliates generating higher traffic (100+ monthly referrals) with exceptional conversion rates (15%+) earn maximum volume bonuses. The system incorporates special promotion multipliers that increase commission rates by 25% during promotional periods, encouraging timely marketing efforts. Final calculations combine all factors to determine precise commission amounts on each sale, creating a transparent and motivating payment structure.

How it works

The decision graph processes affiliate performance data through three key stages:

  1. Category Rate Determination: Assigns appropriate base commission rates and potential volume bonus caps according to product category, with rates ranging from 5-15%.

  2. Performance Evaluation: Analyzes two key metrics - monthly referral quantity and conversion rate quality - to calculate volume bonuses and performance multipliers. Higher-performing affiliates receive bonuses up to 5% and multipliers up to 1.2x.

  3. Commission Calculation: Applies the promotion multiplier (1.25x for special promotions) and combines all factors to calculate the final commission rate and exact payout amount for each sale.

This tiered approach ensures affiliates are rewarded proportionally to their contribution, with top performers potentially earning over triple the base commission rate.

Where teams use it

  • E-commerce affiliate programs
  • Fashion and beauty brand partnerships
  • Electronics retailer referral systems
  • Subscription service referral programs
  • Influencer marketing campaigns
  • Digital marketplace commission structures

Inside the decision model

Affiliate Commission Calculator ships as a JDM decision graph with 4 nodes, 2 decision tables and 10 rules. Download it, load it into GoRules, and run it as-is on Zen Engine.

Decision graph4 nodes · read-only
input requesttable categoryRatestable performanceRatesexpression calculateCommission
01

Request

input

Five flat fields drive the payout: productCategory, monthlyReferrals, conversionRate, isSpecialPromotion, and saleAmount. The category picks the base economics and the rest scale them.

Sample requestJSON
{
  "productCategory": "fashion",
  "monthlyReferrals": 75,
  "conversionRate": 0.12,
  "isSpecialPromotion": true,
  "saleAmount": 350
}
02

Category Rates

table

Category economics are set in one first hit lookup on productCategory: 'electronics' maps to a baseCommissionRate of 0.08 with a volumeBonusMax of 0.03, 'fashion' to 0.12 and 0.04, 'beauty' to 0.15 and 0.05, 'home_goods' to 0.10 and 0.03, and the blank fallback row pays 0.05 with a 0.02 cap for anything else.

These spreads track category margins the way real affiliate programs do: beauty and fashion carry the richest payouts because their gross margins support them, while electronics run thin and pay accordingly. Emitting each category's own bonus ceiling alongside the base rate keeps later performance bonuses proportional, so a top affiliate in electronics cannot out-earn the category's economics.

Decision tablefirst hit policy
Product CategoryproductCategoryBase RatebaseCommissionRateVolume Bonus MaxvolumeBonusMax
'electronics'0.080.03
'fashion'0.120.04
'beauty'0.150.05
'home_goods'0.100.03
-0.050.02
03

Performance Rates

table

Bonuses require traffic and quality together: a first hit table over monthlyReferrals and conversionRate pays the full volumeBonusMax with a 1.2 performanceMultiplier at 100+ referrals converting at 0.15 or better, then steps down through volumeBonusMax * 0.8 at 1.15, * 0.6 at 1.1 for the 50-referral band, and * 0.3 at 1.05 for 25 referrals converting at just 0.05. The blank fallback row pays no volumeBonus and a neutral multiplier of 1.

Gating every bonus row on conversionRate as well as referral count is standard affiliate-program defense, since raw referral volume is cheap to inflate with low-intent traffic while conversions are not. Expressing bonuses as fractions of the category's cap rather than fixed numbers keeps the incentive curve identical across categories, and a 15 percent conversion bar for the top band is a genuinely demanding threshold in e-commerce.

Decision tablefirst hit policy
Monthly ReferralsmonthlyReferralsConversion RateconversionRateVolume BonusvolumeBonusPerformance MultiplierperformanceMultiplier
>= 100>= 0.15volumeBonusMax1.2
>= 100>= 0.10volumeBonusMax * 0.81.15
>= 50>= 0.10volumeBonusMax * 0.61.1
>= 25>= 0.05volumeBonusMax * 0.31.05
--01
04

Calculate Commission

expression

Final math happens in three expressions: promotionMultiplier is 1.25 when isSpecialPromotion is true and 1 otherwise, finalCommissionRate computes (baseCommissionRate + volumeBonus) * performanceMultiplier * promotionMultiplier, and commissionAmount applies that rate to saleAmount. Stacking the multipliers after the additive bonus is what lets a top performer during a promotion earn well above the category base rate on the same sale.

Expressions3 fields
promotionMultiplierisSpecialPromotion ? 1.25 : 1
finalCommissionRate(baseCommissionRate + volumeBonus) * performanceMultiplier * $.promotionMultiplier
commissionAmountsaleAmount * $.finalCommissionRate

Make this template
your own.

Load Affiliate Commission Calculator into GoRules, adjust the rules to your policy, and ship it behind your own API.