Welsdom Affiliate KPI Tracker & Monthly Reporting Guide
This page defines the key performance indicators (KPIs) your team should track monthly, how to pull them from UpPromote, and how to use the data to optimise the affiliate program for growth.
Affiliate dashboard: affiliate.welsdom.com | UpPromote admin: Shopify Admin → Apps → UpPromote Affiliate
Monthly KPI Targets (Days 76–90 Baseline)
| KPI | Month 1 Target | Month 3 Target | Month 6 Target |
|---|---|---|---|
| New affiliate signups | 20 | 60 | 150 |
| Active affiliates (≥1 sale) | 8 | 25 | 75 |
| Total affiliate-driven revenue | $1,000 | $5,000 | $15,000 |
| Average commission paid per affiliate | $40 | $75 | $100 |
| Total affiliate clicks | 2,000 | 8,000 | 25,000 |
| Affiliate conversion rate | 1.5% | 2% | 2.5% |
| New customers from affiliates | 30 | 150 | 500 |
| Affiliate program ROI | 5x | 8x | 12x |
Weekly Dashboard Check (Every Monday)
Log in to UpPromote → Reports → pull these numbers:
- New sign-ups this week — track which campaign or outreach batch drove them
- Clicks this week by affiliate — flag any affiliate generating clicks but 0 conversions (may need content coaching)
- Sales this week by affiliate — identify top performers for tier upgrades
- Any compliance flags — review affiliate content tagged by your team or reported by customers
Monthly Report Template
Complete and share with stakeholders at the end of each calendar month.
Section 1 — Program Overview
- Reporting period: [MONTH YEAR]
- Total affiliates in program: [NUMBER]
- New affiliates joined this month: [NUMBER]
- Active affiliates (generated ≥1 sale): [NUMBER]
- Inactive affiliates (0 sales): [NUMBER]
Section 2 — Revenue & Traffic
- Total affiliate-driven revenue: $[AMOUNT]
- Total commissions paid: $[AMOUNT]
- Program ROI: [REVENUE / COMMISSIONS PAID]x
- Total affiliate clicks: [NUMBER]
- Total orders from affiliates: [NUMBER]
- Affiliate conversion rate: [ORDERS / CLICKS]%
- Average order value from affiliates: $[AMOUNT]
- New customers acquired via affiliates: [NUMBER]
Section 3 — Top 5 Affiliates by Revenue
| Rank | Affiliate Name/Handle | Platform | Revenue Generated | Commission Earned | Current Tier |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 |
Section 4 — Campaign Performance by Product
| Campaign | Affiliates Active | Clicks | Orders | Revenue | Conv. Rate |
|---|---|---|---|---|---|
| AroJuice / Aronia | |||||
| Sea Moss | |||||
| Pet Wellness | |||||
| Yuemi | |||||
| Wellness Bundle |
Section 5 — Actions Taken This Month
- Affiliates upgraded to Growth tier: [NAMES]
- Affiliates upgraded to VIP tier: [NAMES]
- Affiliates upgraded to Partner tier: [NAMES]
- Affiliates deactivated / suspended: [NAMES + REASON]
- New outreach batches sent: [NUMBER + CAMPAIGN]
- Compliance issues identified and resolved: [DESCRIPTION]
Section 6 — Next Month Priorities
- Outreach target: [NUMBER] new affiliates from [WHICH LISTS]
- Content support needed: [WHICH AFFILIATES need new assets or coaching]
- Tier upgrades to action: [NAMES]
- Re-engagement campaign for inactive affiliates: Yes / No
- New product or seasonal promotion to brief affiliates on: [DETAILS]
Optimisation Decision Tree
Affiliate has clicks but no sales
- Review their content — are they linking correctly? Is the CTA clear?
- Send them a personalised email with conversion tips from their content kit
- Offer a limited-time higher commission (e.g., 12% for 30 days) to incentivise effort
- If still no sales after 60 days: move to inactive list
Affiliate has sales but low volume
- Ask them what content performed best — double down on that format
- Provide them with a seasonal promotion code (e.g., "SUMMER10") to drive urgency
- Suggest cross-promoting multiple product lines (e.g., AroJuice + Wellness Bundle)
Affiliate is approaching a tier threshold
- Send a proactive email: "You're $[X] away from VIP tier — here are tips to get there"
- Provide a 2-week content calendar suggestion
- Upgrade them as soon as threshold is crossed — do not make them wait until end of month
Affiliate is inactive (0 sales for 30 days)
- Send re-engagement email: "We miss you! Here are new assets to make promoting Welsdom easier"
- Include a link to their content kit and a fresh coupon code
- If no activity after 60 days: archive their account in UpPromote (do not delete — they may return)
Compliance Review Checklist (Monthly)
- Search "[brand name] affiliate" on Instagram, TikTok, and YouTube — review top posts
- Check that all posts include clear disclosure (#ad, #sponsored, "affiliate link")
- Flag any posts making health claims (immunity, detox, cure, treat, prevent) — contact affiliate immediately
- Review any customer complaints mentioning affiliate-driven misleading claims
- Document all compliance actions in the monthly report Section 5
