The Affiliate Dashboard is a consolidated view of your tier configuration, user distribution, exception (override) users, program KPIs, top performers, commission status, recent activity, and monthly commission trends. |
1. Tier Overview
The Tier Overview section shows how your tier configurations are set up for the active client, and how many users currently fall into each tier.
Controls
Add Tier Configuration — navigates to the admin form to create a new tier configuration.
View All Tiers — opens the full tier configuration list in admin.
Total Users in Tiers
Displays the sum of user counts across all tier levels shown. Exception users (those with custom override rates) are excluded from this total so they do not inflate tier membership numbers.
Tier Cards
Each tier card displays the following information:
Field | Description |
Tier Name | e.g. Tier 1, Tier 2, Tier 3 |
User Count | Number of users currently classified in that tier |
Tier Type | Metric used to determine tier membership: Referral Count, Order Value, or Order Count |
Tier Range | Min (inclusive, >= min_value) and Max (exclusive, < max_value). No max = min and above |
Conv Rate | Conversion commission rate for that tier |
Ret Rate | Retention commission rate for that tier |
How Tier Membership is Calculated
Tier counts are derived from UserAffiliateDetails, using the tier type to determine which field to compare:
Referral Count tier type uses the referral_count field
Order Value tier type uses the total_order_value field
Order Count tier type uses the total_order_count field
Users configured as exception users are excluded from tier counts.
2. Exception Users (Custom Commission Rates)
This table lists affiliates who have custom commission rates that override the default tier rules. Exception users come from tier config entries tied directly to a specific user.
Column | Description |
The affiliate user's email address | |
Full Name | Affiliate full name (if available) |
Referrals | The affiliate's referral count |
Total Commission | Total referred order value, displayed as a currency value |
Total Orders | Total referred order count |
Override Commission | Custom commission rates shown as Conv: X% / Ret: Y% |
Referral and order totals are sourced from UserAffiliateDetails for each user. Missing details default to zero.
3. Affiliate Statistics (KPI Cards)
This section summarises overall affiliate program performance, plus weekly activity snapshots.
KPI | How It Is Calculated |
Total Affiliates | Count of users with an affiliate ID assigned |
Total Referrals | Total number of affiliate commission records (referral events tracked in the system) |
Total Commission Earned | Sum of all affiliate commission amounts across all statuses |
Total Payouts Paid | Sum of affiliate commissions in PAID status |
Weekly Referrals | Count of affiliate commission records created in the last 7 days |
Weekly Commission | Sum of commission amounts created in the last 7 days |
Referral Conversion Rate | referral_orders / total_orders * 100. Referral orders are commissions linked to an order; total orders are all orders in the system |
Pending Payouts | Count of pending affiliate payout records awaiting processing |
Avg Commission per Referral | total_commission_earned / total_referrals. Safely shows $0.00 when there are no referrals |
4. Top Performing Affiliates
Ranks your best affiliates by total commission value. Groups commission records by affiliate email, aggregates totals, and sorts by highest total commission. Typically shows the top 10 affiliates.
Column | Description |
Rank | Position based on total commission (highest first) |
Affiliate | Affiliate email address |
Total Commission | Combined commission across all statuses |
Total Referrals | Number of referral events for this affiliate |
Paid Commission | Sum of commissions in PAID status |
Pending Commission | Sum of commissions in PENDING status |
5. Commission Status Distribution
Shows how affiliate commissions are split across statuses, aggregated from AffiliateCommission records grouped by status.
Column | Description |
Status | e.g. Paid, Pending |
Count | Number of commission records in that status |
Total Amount | Sum of commission values in that status |
6. Recent Affiliate Activity
Shows the most recent affiliate commission events so you can quickly audit activity. Pulls the latest commission records (most recent first), typically the last 10.
Column | Description |
Affiliate | Affiliate user email |
Referred User | Referred user email |
Commission | Commission value for that event |
Status | e.g. Pending, Paid |
Date | Timestamp when the commission record was created |
7. Monthly Commission Trend
Shows how affiliate commission totals have trended month-to-month. Looks back across the last several months and sums all commission amounts created within each month, displayed in chronological order.
Field | Description |
Month | e.g. January 2026 |
Commission | Total commissions created in that calendar month |
Summary: The Affiliate Dashboard shows your tier configuration and tier membership, exception users with custom commission rates, affiliate KPIs (including weekly stats), top-performing affiliates, commission status breakdown, recent commission activity, and a monthly commission trend. |