Analyze Affiliate Program Performance

Generate a detailed performance report for my Shopify affiliate program.

Report Period: [DATE_RANGE]

Program-Level Overview:

  Total affiliate-driven revenue and percentage of store total revenue
  Total clicks generated, orders driven, and click-to-order conversion rate
  Total commissions paid vs affiliate-driven revenue (effective ROAS)
  Number of active affiliates vs total registered affiliates
  New affiliates recruited this period vs affiliates churned
  Average revenue per active affiliate


Top Performer Rankings:

  Top 10 affiliates by revenue generated this period
  Top 10 affiliates by number of orders referred
  Top 10 affiliates by conversion rate (clicks to completed orders)
  Top 10 affiliates by average order value of their referred traffic
  Rising stars: affiliates active less than [X] months with strong early metrics


Per-Affiliate Analysis:
For each active affiliate, report:

  Total clicks, orders, and revenue this period
  Commission earned and effective commission rate
  Average order value of referred customers
  Refund rate on their referred orders
  Performance trend vs previous period (growing, stable, or declining)
  Top 3 products most frequently purchased through their links


Traffic Quality Breakdown:

  Which affiliates send the most engaged traffic (high conversion, low refund rate)?
  Which affiliates send high volume but low-quality traffic (flag for review)?
  Geographic breakdown of affiliate-referred traffic by top 5 countries


Optimization Findings:

  Affiliates ready for tier upgrade based on performance criteria
  Previously active affiliates who have gone quiet (re-engagement candidates)
  Affiliates with anomalous metrics that need fraud review
  Products with strong affiliate traction vs products with zero affiliate coverage
  Content types (blog, video, social, email) driving the highest conversion rates


Action Items:

  List the top 5 affiliates to proactively reach out to this week
  Specific product promotions to pitch to top affiliates
  Program changes to test next period based on this data
  Budget reallocation recommendation based on channel ROAS


Present as a structured executive report with a one-page summary and full detail below.