WP Affiliate Platform keeps affiliate operational data in custom tables. wp_affiliates_tbl holds one row per affiliate with account_status (active, banned, pending), refid, commission_level, and balance, while wp_affiliates_sales_tbl records every tracked sale with txn_id, sale_amount, commission_amount, and buyer_email. Approved payouts land in wp_affiliates_payments_tbl with amount, method (PayPal, manual), and date_paid.

The default WP Affiliate Platform admin gives Affiliates, Sales, and Payouts separate screens with single-column filtering. Asking which affiliates have unpaid commission above a threshold, sorted by lifetime sales, requires either the Pro reporting module or manual export. Approval queues for pending affiliates and payout batches for the next pay cycle live in different screens with no joined view of affiliate balance against pending sales.

SleekView reads all three custom tables and joins on refid so a single affiliate-centric view shows status, lifetime sales, pending commission, last sale date, and last payout date. Payout batches become saved views filtered by balance threshold; approval queues become filtered views on account_status. Status edits route through the plugin's WPAM_Affiliate class where supported, with direct table writes for bulk migrations.

Affiliate programmes only work when payouts run on schedule and approvals happen quickly, both of which are cross-table problems. Which active affiliates have pending commission above the payout threshold this month. Which pending affiliates have already driven a first sale and should be approved.

Which banned affiliates still have an outstanding balance to be resolved. WP Affiliate Platform stores the data to answer all of those, but its default admin keeps affiliates, sales, and payouts on separate screens, which means the operational question always involves a cross-screen reconciliation. SleekView's joined view collapses the three tables into one workspace where each row is an affiliate with their lifetime sales, pending commission, last sale, and last payout visible inline.

Finance teams get a payout batch as a saved view, affiliate managers get an approval queue that already shows referral source and first sale, and growth teams get a lifetime-sales leaderboard for partnership prioritisation. The default admin can answer each question individually, but only by jumping between screens. The joined workspace answers all three from the same view.