SleekView for MemberPress Coupons: coupons & uses as tables
MemberPress coupons are memberpresscoupon CPTs and uses live in mepr_transactions via coupon_id. SleekView joins them so coupon performance and expiry cleanups happen in one workspace.
♾️ Lifetime License available
Coupon performance without exports
MemberPress coupons are stored as memberpresscoupon CPT entries with postmeta holding the discount type, amount, usage limit, expiry, and applicable memberships. Coupon uses are recorded inside mepr_transactions via the coupon_id column (and the related mepr_subscriptions rows when the coupon applies to a recurring plan). MemberPress also tracks usage counts on the coupon post itself, but the row-level attribution per transaction stays in mepr_transactions.
The default coupons admin lists coupons with current uses and expiry but does not surface attributed revenue, conversion rate (visits to use), or which memberships each coupon actually drove. Asking which coupons are expiring next month and still have remaining usage budget, or which expired coupons are still being attempted in the checkout, requires either the Reports module or custom queries.
SleekView reads the coupon CPTs and joins them to mepr_transactions on coupon_id so each coupon row shows uses, attributed revenue, average discount applied, last used date, and expiry status. Inline edits to usage_count_limit and expiry route through MemberPress' coupon class so registered hooks fire.
Workflow
MemberPress coupons joined to transactions
Map the coupon source
memberpresscoupon CPT and mepr_transactions. Each becomes a navigable view with native columns intact.
Join on coupon_id
mepr_transactions rows. Aggregate amount for attributed revenue and count rows for uses.
Save the campaign views
Edit through the coupon class
Sample columns
A typical MemberPress Coupons view
mepr_transactions with uses, attributed revenue, and expiry status.
wp_posts (post_type=memberpresscoupon) + wp_mepr_transactions
| Code | Discount | Uses | Attributed revenue | Expires | Status |
|---|---|---|---|---|---|
| LAUNCH20 | 20% | 184 | $3,680 | Jul 12 | Active |
| SUMMER10 | £10 | 62 | £930 | Jun 30 | Expiring soon |
| BLACKFRI | 30% | 412 | €10,300 | Dec 02 | Expired |
| FRIEND25 | 25% | 8 | $160 | (none) | Active |
Comparison
Default MemberPress Coupons admin vs SleekView
Default MemberPress Coupons admin
- Coupon admin shows uses count but not attributed revenue
-
No joined view linking
memberpresscoupontomepr_transactionsper row - Filtering to coupons expiring this month requires sort or scan
- Bulk expiry updates aren't first-class
- Per-coupon membership attribution (which plan each use bought) isn't surfaced
SleekView
-
Attributed revenue aggregated from
mepr_transactionsper coupon - Filter by expiry window: this week, this month, expired
-
Usage budget remaining inline (uses vs
usage_count_limit) -
Inline bulk edit on expiry and
usage_count_limit - Save the expiring-soon cleanup view per campaign
Features
What SleekView gives you for MemberPress Coupons
Attributed revenue per coupon
Aggregate amount from mepr_transactions joined on coupon_id for true revenue attribution per coupon, not just the uses count the default admin shows.
Expiry window filters
Filter coupons by expiry window (this week, this month, expired but still being attempted) and save each as the relevant cleanup or extension cohort.
Bulk usage and expiry edits
Update usage_count_limit and expiry date inline across many coupons at once. Edits route through the MemberPress coupon class so registered hooks fire.
Audience
Who uses SleekView for MemberPress Coupons
Marketing ops
Per-coupon attributed revenue ranks campaigns by actual contribution, not just usage. Filter by date for campaign retrospectives.
Finance ops
Audit total discount applied per month for accounting. Filter mepr_transactions with coupon_id populated and sort by month.
Support
When a customer says a coupon did not apply, support sees the coupon's expiry, remaining uses, and applicable memberships inline. No context-switching to the coupon edit screen.
The bigger picture
Why coupon ops needs joined tables
Coupons drive a meaningful share of membership revenue, and yet the default MemberPress coupons admin treats them as a flat list of codes with usage counts, not as marketing investments with measurable return. Asking which coupon actually drove the most revenue in a quarter requires the Reports module or a manual export, and the simpler operational questions like which expiring coupons still have unused budget are not addressed at all. SleekView's joined view turns each coupon into a row with attributed revenue, uses against budget, expiry status, and applicable memberships visible inline.
Marketing teams get the per-campaign revenue ranking they need for retrospectives, finance teams get the discount audit for monthly close, and support gets the per-coupon status check that resolves checkout issues without leaving the screen. The default admin already stores all the data SleekView reads. The joined workspace just makes it usable in the way coupon-driven stores actually work.
Questions
Common questions about SleekView for MemberPress Coupons
Each coupon is a memberpresscoupon CPT with postmeta holding discount type, amount, usage limit, expiry, and applicable memberships. Uses are tracked through the coupon_id column on mepr_transactions.
Yes. Joining memberpresscoupon to mepr_transactions on coupon_id and aggregating amount gives revenue attributed to each coupon, which the default admin does not show.
Yes. Edits to usage_count_limit and expiry route through MemberPress' coupon class where supported so registered hooks fire. Direct DB writes stay available for bulk migrations.
Filter on expiry within the next 14 days and uses below usage_count_limit. Save the result as the extension or replacement queue for marketing.
Yes. Coupons applied to recurring plans write the coupon_id onto the first transaction in the recurring chain. SleekView attributes that first transaction's revenue and subsequent renewals separately.
Yes. mepr_transactions includes product_id pointing to the membership purchased. Group coupon uses by product_id to see which plans each campaign drove.
Yes. SleekView queries paginate and use indexed columns (coupon_id on mepr_transactions). Even installs with hundreds of coupons and tens of thousands of uses stay fast.
Yes. Any joined view exports to CSV or JSON. Build the per-coupon revenue view for a campaign window and export it as the campaign report.
 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
- Woocommerce Image Swatches
- Woocommerce Wholesale Prices
- Woocommerce Packlink Pro
- Paystack Woocommerce
- Presta Shop Bridge
- Order Status Manager
- Woocommerce Etsy Integration
- Woocommerce Ebay Integration
- Wcfm Marketplace
- Woocommerce Product Table
- Wpc Product Quantity
- Shopify Bridge
- Woocommerce Tax Toggle
- Yith Woocommerce Request A Quote
- Mollie Payments
- Restrict User Access Pro
- Leaky Paywall
- Paid Membership Pro Pro
- Membershipworks
- Profilepress
- Wp Fluent Affiliate
- Membership Pro Paypal
- Super Socializer
- Restrict User Access
- Restrict Content Pro
- Wp Affiliate Manager
- Buddydrive
- Paid Member Pro
- Ultimatemember Real Time Notifications
- Memberpress Developer