SleekView Charts for PMPro Discount Codes: redemption insight
SleekView reads pmpro_discount_codes, pmpro_discount_codes_uses, and pmpro_membership_orders, then builds dashboards showing which codes drive the most signups, which levels they unlock, and how much revenue each campaign brings in over time, all without leaving WordPress.
♾️ Lifetime License available
PMPro discount codes ship without real reporting
PMPro Discount Codes powers thousands of membership campaigns, but the built-in admin only lists codes in a table with use counts. There is no chart of redemptions over time, no breakdown by level, no comparison of code revenue against full-price signups, and no way to spot which campaign actually moved the needle this month. Most site owners end up exporting from pmpro_discount_codes_uses into a spreadsheet just to answer basic questions.
SleekView reads the real tables. It pulls pmpro_discount_codes for code definitions, pmpro_discount_codes_uses for every redemption, and pmpro_membership_orders for the actual revenue captured per use. The plugin joins on code_id and order_id, exposes columns like timestamp and total, and lets you group by any of them, aggregate Count or Sum, and filter by date or by level.
For a membership site running ten campaigns a quarter, this means a one-screen answer to which code drove the most new Gold tier signups, which campaign produced the highest average order value, and which codes were used heavily but converted to low-value plans. A typical PMPro site sees 12 to 18 percent of signups attached to a discount code, and SleekView turns that 12 to 18 percent into a measurable, comparable cohort instead of a black box.
Workflow
From PMPro discount tables to live charts
Connect the discount tables
Define your scope
Pick chart and aggregation
Publish and review
Sample dashboard
PMPro discount code dashboard preview
Total redemptions this month
Count(id)
Top codes by redemption
Count(id)
group by code_id
Revenue per code
Sum(total)
group by code_id
Redemptions per day
Count(id)
group by timestamp
Comparison
Default PMPro Discount admin vs SleekView
Default PMPro Discount admin
- Built-in admin shows code list with use counts but no chart of redemptions over time
- No revenue-per-code view because orders and discount uses are not joined visually
- Cannot group redemptions by membership level without exporting CSV manually
- No way to compare campaigns side by side, only one code at a time in the table
- No frontend embed or read-only share for marketing teammates without admin access
SleekView Charts
-
Read
pmpro_discount_codes,pmpro_discount_codes_uses, andpmpro_membership_orders - Group by code_id, level_id, timestamp, or any other column on the joined tables
- Aggregate Count of redemptions or Sum of order total with one configuration switch
- Filter by date, by code, by status, by level, by user, all from the SleekView UI
- Embed code performance charts on a campaign landing page via the SleekView shortcode
Features
What SleekView Charts gives you for Paid Memberships Pro Discount Codes
Real redemption joins
SleekView joins pmpro_discount_codes_uses to pmpro_membership_orders on order_id, exposing actual revenue per redemption. The dashboard answers questions PMPro's code list cannot, like which codes produce the highest average order value across the last 90 days of activity.
Revenue by code
Sum order totals grouped by code_id to see which campaigns generated the most revenue, not just the most uses. A free trial code with 500 redemptions might generate less revenue than a 10 percent off code with 80 redemptions on a higher-tier plan.
Timeline view
Gradient Area and Line charts plot redemptions and revenue over time using the timestamp column. Spot launch spikes, weekend dips, and the long-tail decay of a promo across days, weeks, or months without any custom SQL or external analytics tools.
Audience
Practical PMPro discount code reporting
Find your winning codes
A horizontal Bar of redemption counts plus a Bar of revenue totals, side by side, shows which codes are winners on both volume and value. Useful when deciding which campaigns to repeat next quarter and which to retire.
Track campaign decay
Area chart of daily redemptions for a single code reveals the typical decay curve of a launch promo, helping marketing schedule follow-up nudges before the redemption rate falls below the cost-acquisition threshold for that tier.
Match codes to levels
A Pie of redemptions grouped by membership_id, joined through pmpro_membership_orders, shows which levels each code actually drove signups to. Confirms whether a Gold-tier promo really drove Gold subscribers or got rerouted to lower plans.
The bigger picture
Discount code data is a marketing asset
Most PMPro sites use discount codes constantly but never measure them properly because the built-in admin only shows use counts. Marketing spends real budget creating campaigns, designing emails, and writing landing pages around codes, then has no idea afterward which codes paid back. The data is right there in the database, sitting in pmpro_discount_codes_uses and pmpro_membership_orders, but joining them requires either a developer or a CSV export and a spreadsheet.
SleekView removes that friction. It reads the same tables the PMPro core code reads, joins them inside WordPress, and renders dashboards that answer the actual marketing questions. Once teams see redemptions by code, revenue by code, and signup timeline by code, the campaign planning conversation changes.
Instead of guessing which code to use next quarter, the team picks the one that actually generated the highest revenue per redemption on the right membership level last time.
Questions
Common questions about SleekView Charts for Paid Memberships Pro Discount Codes
SleekView reads pmpro_discount_codes for code definitions, pmpro_discount_codes_uses for every redemption event, and pmpro_membership_orders for the captured revenue. It joins on code_id and order_id to expose redemption count and revenue per code in a single chart, all inside WordPress.
Yes. Use a Bar chart grouped by code_id with aggregation set to Sum on pmpro_membership_orders.total. The chart shows actual captured revenue per code rather than raw use counts, which is the single most useful view when comparing campaign performance across the last quarter or year.
Yes. Both code types live in the same pmpro_discount_codes table and write to pmpro_discount_codes_uses identically. SleekView treats them the same way at the data layer. You can filter by uses=1 or uses=0 in the discount codes table if you want to scope a dashboard to one type only.
Yes. pmpro_discount_codes has a starts column and an expires column. SleekView lets you filter on both, so you can build separate dashboards for active campaigns and for historical campaigns, or compare expired-code performance against codes that are still live in the system right now.
Queries run on demand when a dashboard loads, with results cached for a configurable duration. For most sites a one to five minute cache is appropriate. You can clear the cache manually after a big campaign send if you want to see real-time results inside SleekView within seconds of new redemptions hitting the database.
Yes. Join pmpro_discount_codes_uses to pmpro_membership_orders on order_id, then to pmpro_membership_levels on membership_id. SleekView's UI exposes this join as a single grouping selector, so you can render a Pie or Bar of redemptions by level for any code or set of codes.
No. SleekView is strictly read-only against PMPro tables. It runs SELECT queries through the standard wpdb layer and never INSERTs or UPDATEs in pmpro_discount_codes, pmpro_discount_codes_uses, or pmpro_membership_orders. Your discount code data stays exactly as PMPro wrote it.
Yes. Generate a read-only share link or use the shortcode to embed any chart on a frontend page. Marketing can see redemption counts and revenue without needing WordPress admin access, and you can scope a chart to a single code or a list of codes per share link.
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 checkoutBrowse more
- Wc Multivendor Marketplace
- Woocommerce Conditional Shipping And Payments
- Winwar Aelia Currency Switcher
- Yith Woocommerce Frequently Bought Together
- Woocommerce Multistep Checkout
- Woocommerce Google Product Feed
- Thirstyaffiliates
- Woocommerce Shop As Customer
- Woocommerce Shipping Australia Post
- Wpc Smart Wishlist
- Mollie Payments
- Rehub Affiliate
- Woo Stripe Payment
- Woocommerce Quick View
- Woocommerce Points And Rewards