SleekView Charts for AffiliateWP
Read directly from affiliate_wp_affiliates, affiliate_wp_referrals, affiliate_wp_visits, and affiliate_wp_payouts. Compose chart cards into the affiliate-program dashboard every program manager rebuilds in a spreadsheet.
♾️ Lifetime License available
Affiliate ops needs a dashboard, not a report exporter
AffiliateWP keeps its data in dedicated tables: affiliates, referrals, visits, and payouts. The reports tab gives a referrals-over-time graph and an earnings-by-affiliate list, which is fine for spot-checks but not for the operational dashboard most programs need by week two. Questions like 'where are unpaid earnings stacking up', 'which affiliates are converting versus just sending traffic', 'how does referral type mix shift over a quarter' all live in the tables but not on one screen.
SleekView Charts reads affiliate_wp_referrals, affiliate_wp_affiliates, and affiliate_wp_visits directly. Cards group by status, type, affiliate, or date and aggregate counts and amounts on indexed columns. Visit-to-referral ratios become a chart, not a manual cross-table check. Unpaid-earnings concentration becomes a horizontal bar with the top affiliates ranked, ready for the next payout cycle.
The Charts view sits alongside the Table view on the same dataset. Apply a filter once on the Table (last quarter, status = unpaid), switch to Charts, and the dashboard reflects the same scope. Payout admins, affiliate managers, and fraud auditors each get the dashboard their role needs, without rebuilding queries for every cycle.
Workflow
From four AffiliateWP tables to one chart dashboard
Point a view at affiliate_wp_referrals
Compose status, type, and date cards
Add visits-side cards
Save per role
Sample dashboard
Charts you can build from AffiliateWP data
Total unpaid earnings
Sum(amount)
Referral status mix
Count
group by status
Top affiliates by unpaid earnings
Sum(amount)
group by affiliate_id
Referrals by day
Count
group by date
Comparison
Default AffiliateWP reporting vs SleekView Charts
Default AffiliateWP reports tab
- Reports tab gives a referrals-over-time graph and an earnings-by-affiliate list, but no composable dashboard
- Unpaid-earnings concentration isn't surfaced as a chart, just as a sortable list
- Visit-to-referral ratios live in the visits table without a chart-level summary
- No way to put referral-type pie next to a top-affiliates bar on the same screen
- Reports don't share filters with the referrals list, so chart and rows can disagree
SleekView Charts
- Compose Number, Area, Bar, and Pie cards from affiliate_wp_referrals and friends
- Unpaid-earnings ranking and total become a chart, not a sort-by-column exercise
- Visit-to-referral ratios chart directly from affiliate_wp_visits
- Filter shared with the Table view so chart and rows always match
- Save dashboards per role: payouts, growth, fraud audit
Features
What SleekView Charts gives you for AffiliateWP
Payout-cycle dashboard
Total unpaid amount, top affiliates by unpaid balance, status mix donut, and referrals-by-day area on one screen. The payout cycle becomes a load-and-review, not a multi-screen audit.
Affiliate leaderboards
Horizontal bar cards rank affiliates by referrals count, earnings, unpaid earnings, or visit count. Useful for monthly performance reviews and prioritising recruitment for the next tier.
Fraud and traffic audit
Visit-to-referral ratio cards from affiliate_wp_visits, plus rejected-referral trends. Spot click farms and API abuse with a chart instead of a manual cross-reference.
Audience
Who builds AffiliateWP charts dashboards with SleekView
Payout admins
Unpaid-earnings total, top affiliates by unpaid balance, and status mix loaded as one dashboard before each payout cycle. The audit step becomes a quick visual review instead of a spreadsheet pass.
Affiliate managers
Leaderboards by referrals, earnings, and visits with rolling-window comparisons. Performance reviews stop being manual and become a recurring saved dashboard.
Fraud auditors
Visit-to-referral ratio chart, referrer-domain pie, and rejected-referral trend in one view. Patterns that take a SQL query in default admin show up as visual outliers in the dashboard.
The bigger picture
Why affiliate programs need a real dashboard
Affiliate programs scale on operational visibility. A 50-affiliate program is fine on any reports tab; a 5,000-affiliate program where ten affiliates carry half the unpaid balance needs a dashboard that makes that concentration obvious. The default AffiliateWP reports give individual graphs and a sortable list, which works for spot-checks but breaks down when the program manager wants the whole picture on one screen.
Each payout cycle, the question 'where is the unpaid balance' should be answered by a chart, not a re-sort of a long list. Each performance review, the question 'who is converting versus who is just sending traffic' should be a chart, not a manual cross-table check. SleekView Charts turns the AffiliateWP tables into the dashboard the program manager already has in their head.
Same data, same hooks, the visualisation that makes the patterns obvious.
Questions
Common questions about SleekView Charts for AffiliateWP
No. The reports tab stays where it is for headline graphs. SleekView Charts is the dashboard layer for cross-cutting and role-scoped views, like an unpaid-balance ranking next to a status mix donut on the same screen with the same filter. Most teams use both.
Primarily affiliate_wp_referrals for counts and amounts. Joins to affiliate_wp_affiliates for affiliate identity and to affiliate_wp_visits for traffic-side charts. Payouts come from affiliate_wp_payouts for cycle-level summaries.
Yes. A horizontal bar grouping by affiliate_id with sum of amount filtered to status = unpaid ranks affiliates by unpaid balance. Combine with a Number card for the total unpaid figure and you have the payout cycle's headline view.
Yes. Cards on affiliate_wp_visits chart visit volume, referrer-domain mix, and converted-vs-non-converted share. Useful for fraud audits where the visit-to-referral ratio matters more than absolute counts.
Yes. Any integration creating referrals via the AffiliateWP API lands in affiliate_wp_referrals, so the charts pick them up automatically. The type field (Sale, Lead, Opt-In) shows up in the column picker and works as a groupBy key out of the box.
Yes. Save a dashboard, gate it by WordPress capability. Payout admins see the unpaid-balance dashboard, affiliate managers see leaderboards, fraud auditors see ratio outliers. One database, three role-scoped views, no rebuilding per environment.
Yes. Each subsite has its own affiliate_wp_* tables, so each subsite's Charts view is scoped to its own program. Cross-site aggregation isn't supported (each subsite is independent), but per-site dashboards behave as expected.
Yes. affiliate_wp_referralmeta keys present in the data appear in the column picker. Useful for add-ons like Direct Link Tracking or Lifetime Commissions that store integration data on the referral row, where a chart of referrals by attribution source becomes a one-card add.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkout