A webinar promoter reconciled affiliate commissions without the spreadsheet séance

Representative examplesEvery case study in this library is an illustrative composite of the kind of engagement we deliver — written to show our method and standards, not to name clients.

Where they started

Webinars are the product: a small promoter produces paid webinars for an information product and pays twenty affiliates a commission for the attendees they bring. The affiliates range from a newsletter operator who drives serious volume to several part-timers who mail their lists when a launch suits them. Payouts happen monthly, and the promoter — with a bookkeeper on contract — runs the whole operation from a funnel account and a payment processor, with no dedicated affiliate infrastructure beyond what the funnel platform provides out of the box.

What it was costing

Affiliates promoted webinars on trust and memory: clicks were tracked loosely, refunds weren't netted out, and commission payouts were a spreadsheet reconciliation that took two days and always generated one argument.

What they could see

• Affiliates email monthly asking how many signups their links produced, and the answer is a manual count.
• A refunded purchase still pays a commission unless someone remembers to net it out by hand.
• The payout spreadsheet reconciles clicks from two dashboards that disagree, and every month one affiliate disputes their number.
• One high-volume affiliate openly doubts the tracking and asks why their clicks and the dashboard never match.
• Payout day absorbs the bookkeeper for most of a day and ends, reliably, with one unresolved argument.

The constraints we worked inside

• The CRM features available in the plan had to be verified in-app — several assumed tracking features didn't exist.
• Affiliates needed visibility or they'd disengage — reporting had to be self-serve.
• Refund windows meant commissions were provisional for 30 days — the system had to say so.

What had been tried before

Each month the bookkeeper reconciled the payout spreadsheet by hand against funnel and payment-processor exports.

The math took the better part of a day and still rested on two dashboards that disagreed, which is where the recurring argument lived.

For one quarter the promoter paid flat bounties per signup instead of commission.

The disputes ended and so did the effort — the best affiliates stopped promoting, because flat fees ignore what their traffic is worth.

Clicks were counted manually from the funnel dashboard and attributed to affiliates by link order in the spreadsheet.

Last-click arguments could not be settled by a number nobody trusted, and every disputed month eroded confidence in the next payout.

What we proposed

Keep the programme where it lives and make its math visible: first verify in-app what the plan's affiliate tracking actually does — cookie windows, attribution behaviour, reportable fields — and document it, so the design fits the software rather than the brochure. Each affiliate gets a live self-serve view of clicks, signups, and provisional commissions, which ends the monthly how-many-did-I-send emails. Refund-netted commission statements generate on a schedule; the promoter reviews and pays, and the method behind every number is written where affiliates can read it. Disputes die when the math is visible, not when it is defended.

Just as important is what we ruled out, and why:

• A dedicated affiliate platform — A subscription and the re-onboarding of twenty affiliates mid-programme, to escape a platform whose tracking — once verified — covered the need.
• Custom-built tracking — A bespoke attribution system for a twenty-affiliate programme is maintenance the operation cannot staff, and it inherits every dispute it cannot document.
• Paying commissions without refund netting — Simpler monthly math, but it pays commissions on returned products and hands the loss to the promoter every refund cycle.

How the work ran

Delivered by the systems pod — automation specialist over 5 weeks, with working increments reviewed with the client every week.

The stack, and the reasoning

ClickFunnels CRM

The webinar funnel already lived here, so tracking at the source avoided the reconciliation of a second system nobody had budget to babysit.

Affiliate tracking

The plan's built-in tracking covered the need once its actual behaviour was verified and documented; the brochure had promised features the account never had.

Commission statements

Refund-netted statements generated monthly turn the payout from a negotiation into a reading; the promoter signs, the affiliate checks, the math is identical for both.

Self-serve reporting

Affiliates who can see their own provisional commissions stop emailing for counts — and the high-volume sceptic became the easiest convert once the view matched reality.

What went wrong

How we worked together

Cadence

A kickoff mapping session, then a monthly statement-review call with the promoter and bookkeeper; affiliates received a written onboarding note rather than meetings.

Client side

The promoter owned policy — the refund-netting rule and attribution terms — and the bookkeeper validated the statement math each month.

Decisions

The refund-netting rule was signed off before the build; anything the verification showed the platform could not do became a written limitation, not a workaround promise.

They provided

The affiliate agreement and contact list, the historical payout spreadsheet for validation, funnel account access, and the bookkeeper's reconciliation notes.

What changed

The headline: monthly affiliate reconciliation time, including the end of the recurring argument — 2 days → 30 min, read from Time study plus payout history. A second check: commission disputes in the two quarters since go-live at 0.

Payout day shrank from an event the bookkeeper braced for to a review-and-approve that fits in a coffee. The recurring argument — the one that arrived every month with the spreadsheet — has simply stopped arriving, because both sides now read the same numbers from the same place. Affiliates promote with more conviction when they can watch their own scoreboard, and the promoter's trust in the programme is no longer a matter of memory.

The result was read from Time study plus payout history against the pre-engagement baseline over the stated window, with a guardrail check on commission disputes in the two quarters since go-live. Where platform-reported numbers and business outcomes differ, this record says which layer it is quoting.

What they own now

• The commission-statement template with the refund-netting calculation documented inside it.
• A written attribution note — cookie windows, last-click rule, known limitations — referenced by the agreement.
• Self-serve report links provisioned per affiliate, owned by the promoter's account.
• A monthly review checklist for the promoter and bookkeeper covering sign-off and payment.
• The verification record of what the plan's tracking does, so future plan changes can be checked against it.