✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for MemberPress Coupons

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

1

Map the coupon source

Point SleekView at the memberpresscoupon CPT and mepr_transactions. Each becomes a navigable view with native columns intact.
2

Join on coupon_id

Build a coupon-centric view joining each coupon to its mepr_transactions rows. Aggregate amount for attributed revenue and count rows for uses.
3

Save the campaign views

Save the active-and-spending view, the expiring-soon-with-budget view, and the post-mortem revenue ranking. Gate by role for marketing, finance, and support.
4

Edit through the coupon class

Usage-limit and expiry edits route through the MemberPress coupon class so registered hooks fire. Direct DB writes stay available for bulk migrations.

Sample columns

A typical MemberPress Coupons view

Coupons joined to mepr_transactions with uses, attributed revenue, and expiry status.
Source: 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 memberpresscoupon to mepr_transactions per 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_transactions per 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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