Affiliate Commission Rate Worksheet: 8 Fields to Compare
Use an affiliate commission rate comparison worksheet to compare payout rules, eligible actions, duration, reversals, and sources before choosing offers.
On this page (8)
What Should You Compare Before Choosing?
An affiliate commission rate comparison worksheet helps publishers compare offers that calculate earnings in different ways. A percentage of a qualifying sale is not directly comparable with a fixed bounty, a recurring share, or a tiered rate that applies only after a threshold.
Use the worksheet below to capture the event, calculation base, duration, market, attribution, reversals, and payout conditions behind each offer. It is designed to help you choose a relevant program for your audience, not to predict how many people will buy or which rate will earn the most.
Quick answer: compare the complete earning rule
Do not rank offers by the largest percentage alone. Record what triggers a commission, what amount the rate applies to, how long it can recur, who qualifies, what can reverse it, and when approved earnings are paid. Leave private or unpublished terms marked unknown until you can verify them in the program's current source.
Use this affiliate commission rate comparison worksheet to normalize one row per offer. Keep unavailable terms marked unknown, not zero.
| Worksheet field | What to capture | Why it changes the comparison |
|---|---|---|
| Qualifying event | Sale, lead, signup, install, or other action | Events have different values and approval rules |
| Calculation base | Sale price, revenue, subscription, or fixed amount | A percentage needs a defined base |
| Commission model | Percent, bounty, recurring, tiered, or mixed | Structure controls future payment |
| Duration | One-time, fixed period, or ongoing | Same rate can produce different total payouts |
| Eligibility | Product, plan, customer, country, and channel | Not every audience action may qualify |
| Attribution | Window, model, and link requirements | A purchase may not credit as expected |
| Validation | Reversals, returns, lock, and approval status | Tracked and payable are different states |
| Payout and source | Threshold, schedule, currency, source date | A headline rate does not describe cash timing |
Why a rate needs its surrounding terms
The same percentage can produce different commissions when one program calculates it on the sale price and another on a narrower qualifying-revenue base. A rate can also apply once, for a limited number of months, or while a customer continues to pay. A fixed reward may beat a percentage on one event and trail it on another.
The current Impact.com partner contract guide describes default payouts as either a fixed amount or a percentage, with restrictions, limits, action locking, invoicing, and payout scheduling in the contract. Amazon Associates help says commission income is calculated on the sale price, not the list price, of qualifying items, and depends on the item being dispatched. These examples show why the earning rule needs to be recorded alongside the number.
The affiliate commission rate comparison worksheet should preserve the source and its scope beside each rate, especially when a public page covers only one market or product type.
Eight fields to add to your comparison worksheet
1. Qualifying event
Write the exact action that earns commission: a completed retail sale, an approved lead, a paid subscription, a software installation, or another event. Note whether the action must be new, first-time, shipped, activated, or verified.
Avoid broad labels such as “sale” when the terms define a narrower event. If a rate card pays for dispatched items, do not model the commission at checkout. If a SaaS offer pays only on the first invoice, do not multiply the amount across later renewals.
2. Calculation base
State the amount the percentage applies to. It might be the checkout value, qualifying revenue, a product subtotal, the first payment, or a defined portion of a subscription. Record whether taxes, shipping, discounts, or excluded products change the base.
For a percentage example, use the formula: qualifying base multiplied by rate equals estimated gross commission for that event. The formula is simple, but the definition of “qualifying base” must come from the current offer terms. Keep a fixed bounty in its own currency field rather than converting it into a percentage without an explicit comparison assumption.
3. Commission model
Mark whether the offer is a percentage, fixed bounty, recurring share, tiered rate, bonus, or combination. If the rate changes by product, customer type, volume, or partner tier, record the rule for each case instead of averaging them into one headline.
Add a source note beside every tier. A top rate may require an approval, sales volume, or product category that does not apply to a new publisher. Compare the entry condition you can actually meet with the entry condition on the second offer.
4. Duration and recurrence
Write how many qualifying payments can earn a commission. “Recurring” does not always mean lifetime, and “lifetime” may refer to the eligible customer relationship subject to active program terms. Record the number of payments or months when the offer states one.
Separate attribution duration from commission duration. A cookie window concerns whether a click can be credited later. The recurrence term concerns how many future payments can generate earnings after a referral is credited. They answer different questions and should not share one worksheet cell.
5. Product, customer, market, and channel eligibility
List the eligible products or plans, new versus existing customers, supported countries, accepted promotional channels, and any audience or content restrictions. If a program page is global but the rate card is country-specific, record the region beside the rate.
This field can eliminate an otherwise attractive offer. A creator with a newsletter, social profile, or comparison site should confirm that their actual channel is allowed. Do not infer eligibility from another brand in the same network or from the network's approval alone.
6. Attribution window and model
Record the cookie or click window, the attribution model, and any documented tracking conditions. Include whether an offer requires a specific link format or whether a coupon can override referral credit. Leave cross-device rules blank or unknown if the public source does not explain them.
The FindAffiliates guide to comparing affiliate programs covers the broader selection process. For each candidate, use the current contract or dashboard as the final source because network-level defaults may not define an advertiser's terms.
7. Validation, reversals, and payout status
Record the return or cancellation window, action locking period, approval process, and common reversal reasons. Keep tracked, pending, approved, cleared, and paid amounts separate. A pending event is not guaranteed income, and an approved event can still follow a payout schedule.
Use separate columns for the event status and expected cash date. If your rate comparison includes actual performance, calculate only with the statuses that answer your decision. For example, a content shortlist may compare approved commission, while a cash plan needs cleared or paid amounts.
8. Payout conditions and source date
Capture minimum thresholds, payment method, currency, payment schedule, tax forms, fees, and who handles the transfer. Save the source URL, the date you checked it, and whether the value came from public terms, an account dashboard, or a written message.
Recheck changed terms before updating an article or forecasting income. A source date does not make a term permanent, but it tells you which version supported your comparison. Keep a copy or note of the source if the public page is likely to change.
Example worksheet row and calculation
Suppose a publisher is comparing two hypothetical offers. Offer A pays a percentage of qualifying sale revenue for a stated period. Offer B pays a fixed amount for one approved signup. Put them on separate rows and fill the qualifying event, base, duration, market, attribution, reversal, and payout fields before calculating anything.
If an eligible sale has a qualifying base of 100 currency units and the written rate is 8 percent, the simple gross calculation is 8 units before exclusions, reversals, fees, currency conversion, or tax. That arithmetic does not say how often such a sale happens. It also does not make the fixed signup reward directly comparable until you define the expected event and reader value.
How to use the worksheet without overstating earnings
Start with the audience and the product decision your content can support. Remove offers that do not accept your channel, region, or intended product category. Then compare the remaining rules using the same event assumptions and currency.
When a commission amount is private, do not replace it with a network average. When the duration is missing, label it unknown rather than assuming that a recurring offer pays forever. Sources such as industry benchmark reports can provide context, but their samples may focus on a subset of programs and cannot replace the offer's own contract.
For examples of program pages to research, review the PartnerStack, Rewardful, and FirstPromoter listings, then verify the specific program terms you intend to promote. The affiliate commission rates by industry guide groups public examples, while the affiliate EPC comparison worksheet compares observed earnings per click. Neither replaces offer-level terms.
Key Takeaways for Affiliate Commission Rate Worksheet: 8 Fields to Compare
A useful affiliate commission rate comparison worksheet records the full earning rule, not just a percentage. Fill each field from a current source, keep unknowns visible, and shortlist offers that fit your audience before comparing possible payout scenarios. Use the FindAffiliates directory to find relevant programs, then confirm their terms before choosing.
FAQ
What should an affiliate commission comparison worksheet include?
Include the qualifying event, calculation base, commission model, duration, eligibility, attribution, reversals, payout conditions, and source date. These fields explain what the headline rate actually applies to.
How do I compare a percentage with a fixed bounty?
Keep the payout types separate until you define the same qualifying event and a scenario for each. A percentage can be calculated against a qualifying base, while a bounty requires an eligible action. Do not assume either will convert at a particular rate.
Does a recurring affiliate commission always last for life?
No. Check the stated number of payments or months and any customer or plan conditions. “Recurring” describes repeat payments but does not by itself define how long they continue.
Should I use public benchmarks instead of program terms?
Use benchmarks only as context for a carefully described sample. Use the specific program's current agreement or dashboard for its rate, eligibility, attribution, reversals, and payout timing.
