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)
- 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.
- Exclude refund / chargeback orders — Remove or weight down refunded revenue and reversed commissions for the reporting window. Call out partial refunds.
- 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.
- 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)
- Platform: Shopify, WooCommerce, Impact, ShareASale, custom spreadsheet?
- Attribution: code-only, UTM-only, or hybrid; window (e.g. 7-day click).
- Commission model: % of sale, flat per order, hybrid, tiered by volume.
- Refund policy: full window for affiliate eligibility; chargebacks.
- Gross margin or COGS % (or confirm "use payout as CAC proxy").
- Renewal date or campaign end.
For fraud heuristics and renewal rubric detail, read references/affiliate_playbook.md when needed.
Mandatory success output: master table
Every full affiliate reconciliation or ROI report must include this table (one row per creator; use Influencer ID as the stable key — handle, platform ID, or internal code):
| Influencer ID |
Orders attributed |
Actual revenue |
CAC |
Renewal rating |
| … |
… |
… |
… |
… |
Column definitions
- Influencer ID: Stable identifier (agree with merchant).
- Orders attributed: Count of orders matched to this creator in the window, after refund/chargeback exclusion (state rule).
- Actual revenue: Net revenue attributable to that creator (gross order value minus refunds for attributed orders), same currency.
- CAC: Customer acquisition cost for that creator’s attributed sales — typically
(fixed fees + variable commissions + product/samples allocated) divided by new customers or by attributed orders; if only payout is known, define CAC as total creator cost / attributed orders and label it clearly.
- Renewal rating: Tier such as A (renew strong), B (renew with caps), C (renegotiate or shorten), D (pause / investigate fraud) — always tie to numbers (conversion, refund rate, traffic quality).
Below the table, add: ROAS proxy (revenue / creator cost), fraud or quality flags if any, and renewal terms per tier.
Pushy deliverables (when user asks vaguely)
If they ask "who should we keep" or "affiliate ROI" without structure, still output: the master table, attribution rule summary, refund-adjusted figures, and at least two renewal scenarios (e.g. same rate vs reduced rate + cap).
Report outline (full run)
- Scope — date range, attribution rule, currency.
- Master table — required columns above.
- Refund / chargeback impact — table or bullets per creator if material.
- Profit or contribution — formula stated; margin assumptions if used.
- Fraud / low-quality signals — spikes, refund rate, session quality (if data exists).
- Renewal playbook — A/B/C/D actions and suggested contract language bullets.
Split with other skills
- Paid social ads without affiliates → not this skill.
- Legal contracts → flag for counsel; you provide economic summary only.
1---2name: affiliate-kol-roi-monitor3description: Automate affiliate and KOL reconciliation, attribution, true ROAS, commission math, and renewal strategy. Use when the user has more than ~5 KOL or affiliate partners, needs real ROAS (not vanity clicks), must match orders to creators, settle commissions net of refunds, spot fake or low-quality traffic, or wants influencer performance reports and tiered renewal offers. Also trigger on affiliate payout disputes, UTM vs discount-code attribution, "which creator actually sold," commission spreadsheets, or CAC by creator — even if they only say "clean up our affiliate mess." Do NOT use for generic social media growth tips with no orders or payouts, pure content calendars without performance data, or single one-off creator contracts with no reconciliation need.4---56# Affiliate & KOL ROI Monitor78You 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**.910## Core workflow (always follow in order)11121. **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.132. **Exclude refund / chargeback orders** — Remove or weight down refunded revenue and reversed commissions for the reporting window. Call out partial refunds.143. **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**.154. **Tiered renewal proposals** — Rate each creator; propose continue / renegotiate / pause with concrete terms (rate, cap, exclusivity, content minimums).1617## When NOT to use1819- No order or payout data — only branding or follower counts.20- Single creator, no reconciliation — simple contract review only.21- Paid ads (Meta/Google) without affiliate linkage — use ads ROAS skills.2223## Gather context (infer first; ask gaps)24251. Platform: Shopify, WooCommerce, Impact, ShareASale, custom spreadsheet?262. Attribution: code-only, UTM-only, or hybrid; window (e.g. 7-day click).273. Commission model: % of sale, flat per order, hybrid, tiered by volume.284. Refund policy: full window for affiliate eligibility; chargebacks.295. Gross margin or COGS % (or confirm "use payout as CAC proxy").306. Renewal date or campaign end.3132For fraud heuristics and renewal rubric detail, read `references/affiliate_playbook.md` when needed.3334## Mandatory success output: master table3536Every **full** affiliate reconciliation or ROI report must include this table (one row per creator; use **Influencer ID** as the stable key — handle, platform ID, or internal code):3738| Influencer ID | Orders attributed | Actual revenue | CAC | Renewal rating |39|---------------|-------------------|----------------|-----|----------------|40| … | … | … | … | … |4142**Column definitions**4344- **Influencer ID**: Stable identifier (agree with merchant).45- **Orders attributed**: Count of orders matched to this creator in the window, **after** refund/chargeback exclusion (state rule).46- **Actual revenue**: **Net revenue** attributable to that creator (gross order value minus refunds for attributed orders), same currency.47- **CAC**: **Customer acquisition cost for that creator’s attributed sales** — typically `(fixed fees + variable commissions + product/samples allocated)` divided by **new customers** or by **attributed orders**; if only payout is known, define CAC as **total creator cost / attributed orders** and label it clearly.48- **Renewal rating**: Tier such as **A (renew strong)**, **B (renew with caps)**, **C (renegotiate or shorten)**, **D (pause / investigate fraud)** — always tie to numbers (conversion, refund rate, traffic quality).4950Below the table, add: **ROAS proxy** (revenue / creator cost), **fraud or quality flags** if any, and **renewal terms** per tier.5152## Pushy deliverables (when user asks vaguely)5354If they ask "who should we keep" or "affiliate ROI" without structure, still output: the **master table**, **attribution rule summary**, **refund-adjusted figures**, and **at least two renewal scenarios** (e.g. same rate vs reduced rate + cap).5556## Report outline (full run)57581. Scope — date range, attribution rule, currency.592. Master table — required columns above.603. Refund / chargeback impact — table or bullets per creator if material.614. Profit or contribution — formula stated; margin assumptions if used.625. Fraud / low-quality signals — spikes, refund rate, session quality (if data exists).636. Renewal playbook — A/B/C/D actions and suggested contract language bullets.6465## Split with other skills6667- **Paid social ads** without affiliates → not this skill.68- **Legal contracts** → flag for counsel; you provide economic summary only.
dvcrn