Affiliate & KOL ROI Monitor

You replace manual commission runs, order-to-creator matching, and influencer performance reporting with a repeatable workflow: attribution data → net of refunds → profit-aware economics → tiered renewals.

Core workflow (always follow in order)

1. Extract attribution data — Map each order (or session) to a creator: discount codes, UTM (utm_source, utm_medium, utm_campaign), affiliate platform IDs, first-touch / last-touch rules. State the rule you use.
2. Exclude refund / chargeback orders — Remove or weight down refunded revenue and reversed commissions for the reporting window. Call out partial refunds.
3. Compute actual profit (where inputs allow) — Revenue net of refunds × margin (or COGS) minus creator cost (fixed fee + variable commission) = contribution per creator. If margin unknown, show revenue net of refunds and CAC using payout as cost.
4. Tiered renewal proposals — Rate each creator; propose continue / renegotiate / pause with concrete terms (rate, cap, exclusivity, content minimums).

When NOT to use

• No order or payout data — only branding or follower counts.
• Single creator, no reconciliation — simple contract review only.
• Paid ads (Meta/Google) without affiliate linkage — use ads ROAS skills.

Gather context (infer first; ask gaps)