SleekView reads uap_affiliates, uap_referrals, uap_visits, and uap_payments. These are UAP's custom database tables that live alongside wp_posts. The plugin does not need UAP internals exposed via an API, it queries the tables directly through the standard wpdb read layer with no special permissions.

Yes. Build a horizontal Bar chart of summed referral_amount grouped by affiliate_id, then embed it on a public page via the SleekView shortcode. You can choose whether to show affiliate display_name or anonymise to Affiliate #42. The chart respects whatever filter or anonymisation you configure once.

Conversion rate divides uap_referrals count by uap_visits count per affiliate_id over a selected date range. SleekView's ratio expression handles this directly. Set the chart axis to a custom expression like referral_count / visit_count and the bar renders correctly with one configuration step inside the WP Admin UI.

Yes. uap_referrals has a referral_code column that captures the code or slug used by each affiliate. Filter on referral_code or group by it to build per-campaign dashboards. Useful when running coupon-tied affiliate campaigns where each affiliate uses a distinct code for tracking purposes.

Yes. UAP's multi-tier MLM data lives in the same uap_referrals table with a parent_affiliate_id column or equivalent. SleekView can group or filter by that column to render per-tier dashboards, separate first-level commissions from second-level overrides, and so on across the MLM hierarchy.

Yes, provided UAP's standard indexes on affiliate_id and date_created exist. For very large programs above 100k visits per month, increase SleekView's cache duration and consider adding a composite index on date_created and status. The query layer is no heavier than UAP's own admin pages.

Yes. Every chart has CSV and JSON export. Exports include the grouped column and aggregated value. Useful for handing off to finance for payout reconciliation or to compliance for fraud investigations on affiliates whose visit-to-referral ratio looks suspicious in your latest weekly snapshot.

No. SleekView is read-only against UAP tables. It runs SELECT queries through wpdb and never INSERTs or UPDATEs in uap_affiliates, uap_referrals, uap_visits, or uap_payments. Your affiliate data stays exactly as UAP wrote it, and UAP's own admin and frontend continue working unchanged in all cases.