Affiliate Royale, the MemberPress affiliate add-on, writes its operational data into MemberPress-prefixed tables. Referral events land in mepr_aff_referrals with the affiliate ID, transaction reference, commission amount, and status (paid, unpaid, void). Clicks and visits accumulate as their own rows, and per-affiliate totals sit in the affiliate user record. The default admin shows a list view and a couple of summary boxes, but no real dashboard.

SleekView Charts reads the same tables and turns them into a configurable chart canvas. A Number card sums unpaid commission from mepr_aff_referrals.amount for the next payout run. A Pie card splits referrals by status. A Bar card ranks affiliates by total commission earned. An Area card plots daily commission volume so seasonality and promo campaigns show their shape.

Every card runs against the live tables, not a nightly export. Program managers can build a payouts dashboard for finance, a top-affiliate leaderboard for marketing, and a status-distribution view for fraud checks, all reading the same rows the affiliate admin screen reads, so the chart and the queue never disagree.

Affiliate programs are velocity businesses. Commission earned this week against last week, payout queue against the team's capacity to process it, top affiliates against the long tail of dormant signups. Affiliate Royale captures all of it in the MemberPress affiliate tables, but exposes it as a list view and a few summary boxes.

Program managers who want a real dashboard either build it themselves or export rows to a spreadsheet, and the spreadsheet drifts out of sync with the live queue within hours. SleekView Charts runs against the same tables the admin screen reads, so the unpaid-commission KPI matches the queue count and the daily trend reflects this morning's referrals. Finance, marketing, and program managers share one source of truth, and the dashboard is configured from WP Admin without writing SQL.