Analyze Affiliate Program Performance

Build a discount-code-driven revenue report for my affiliate program using real Shopify store data (Sidekick can’t read data inside my affiliate app, but if each affiliate has a unique discount code, that code is a usable proxy):

Report Period: [DATE_RANGE]
Affiliate discount code prefix/pattern: [e.g., codes starting with “aff-“]

Build a ShopifyQL report covering:


  
    Revenue by code - Total revenue and order count grouped by each affiliate discount code, for the report period.
  
  
    Ranking - Rank codes by revenue generated and by order count, so I can see my top 10 affiliates by that proxy.
  
  
    Average order value - Average order value per code, to spot which affiliates drive higher-value traffic.
  
  
    Refund rate - Refund rate on orders using each code, flagged if notably above the store average (a signal worth manually reviewing in my affiliate app for fraud).
  
  
    Trend - Compare this period’s revenue per code against the prior period to flag growing vs declining affiliates.
  


Present as a structured report with a one-page summary and the full per-code breakdown below. Note clearly that click data, commission amounts, and non-code-based attribution live in my affiliate app and aren’t in this report.