SleekView for MailPoet: subscribers, lists & campaigns as tables
MailPoet stores subscribers, lists, segments, and campaigns in dedicated custom tables. SleekView reads them so you can build segments, audit campaign deliverability, and bulk-list-manage from one screen.
♾️ Lifetime License available
Newsletter ops without per-subscriber clicks
MailPoet keeps its data in custom tables: mailpoet_subscribers stores subscriber records with status, source, and engagement counters, mailpoet_segments defines lists and dynamic segments, mailpoet_subscriber_segment is the pivot linking subscribers to segments, and mailpoet_newsletters stores newsletter and automated-email definitions. Sending statistics (opens, clicks, bounces) live in linked event tables.
MailPoet's default admin is competent but constrained. The subscribers list has fixed columns and limited filtering, list management runs through dropdowns, and campaign performance is a separate screen. Cross-list segmentation requires the segments builder rather than inline filters, which is great for defining reusable segments but slow for ad-hoc analysis. Per-source attribution — comparing engagement between WPForms-captured subscribers and WooCommerce-checkout subscribers — requires either reports navigation or custom queries.
SleekView reads the MailPoet custom tables directly, pivots subscriber meta, joins the segment pivot for list memberships, and joins mailpoet_newsletters for per-campaign deliverability views. Segments become saved views, bulk list management becomes inline operations, and engagement-by-source becomes a column.
Workflow
MailPoet tables as a flat newsletter workspace
Map the MailPoet tables
mailpoet_subscribers, mailpoet_segments, mailpoet_subscriber_segment, and mailpoet_newsletters. Each renders as a navigable view with MailPoet's columns intact.
Pivot meta and segments
Save the segments and audits
Bulk-list-manage inline
Sample columns
A typical MailPoet subscribers view
wp_mailpoet_subscribers + wp_mailpoet_segments + wp_mailpoet_subscriber_segment + wp_mailpoet_newsletters
| Subscriber | Status | Lists | Source | Opens (30d) | Joined |
|---|---|---|---|---|---|
| alex@studio.co | Subscribed | News, Pro | WPForms | 12 | Apr 12 |
| ria@design.io | Subscribed | News | Manual | 8 | Feb 03 |
| tom@hello.dev | Unconfirmed | — | WooCommerce | 0 | Apr 23 |
| mia@brew.coop | Unsubscribed | News | WPForms | 0 | Mar 02 |
Comparison
Default MailPoet admin vs SleekView
Default MailPoet admin
- Subscribers list has fixed columns
- Cross-list segmentation needs the segments builder, not inline filters
- Campaign-performance metrics live in a separate screen
- Bulk list management isn't a first-class queue
- Per-source attribution requires custom queries
SleekView
- Pivot subscriber meta into proper columns
- Filter by list + status + opens + last activity
- Bulk add/remove list memberships inline
-
Join
mailpoet_newslettersfor per-campaign analytics - Save segments as named views
Features
What SleekView gives you for MailPoet
Cross-list segmentation
Combine list membership, status, opens, and source into a single filterable view that becomes a reusable segment. Save it, target the next campaign, refine after each send.
Bulk list management
Select rows and add or remove list memberships in bulk through MailPoet's API — clean up after imports, reorganise lists, or run cohort-based migrations in one pass.
Campaign deliverability audit
Per-campaign tables joined to subscribers showing sent/opened/clicked counts inline. Identify deliverability gaps and subscribers who consistently don't receive your broadcasts.
Audience
Who uses SleekView for MailPoet
Newsletter editors
Build segments and audit campaign performance without exporting CSVs. The same workspace powers next-send segmentation and previous-send post-mortem.
List ops
Bulk subscribe, unsubscribe, or re-list contacts after a campaign or import. Post-event cleanup that takes hours through the default UI compresses to a single saved view and bulk action.
Growth ops
Per-source attribution and engagement-by-segment reports inline. Compare lead-capture channels (WPForms, WooCommerce, manual) on engagement and lifetime conversion.
The bigger picture
Why newsletter teams need flat subscriber tables
Newsletter operations cycle through the same set of tasks every month: cleaning up unconfirmed subscribers from the last campaign, segmenting for the next send, auditing deliverability after the previous broadcast, reconciling new sign-ups from various lead-capture sources. MailPoet provides the tools for each of those individually but doesn't compose them into one workspace where ops can scan, filter, edit, and act inline. The default subscribers list shows fixed columns; the segments builder is for reusable definitions, not ad-hoc work; deliverability stats live in another tab.
The data exists in well-structured custom tables — every subscriber, every segment pivot row, every newsletter event — but composing it into a single operational view requires either jumping between screens or running queries. SleekView's joined view fixes that. A newsletter editor can build the next send's segment by combining list, status, and recent-opens filters in one place.
A list ops person can clean up unconfirmed subscribers in a single bulk operation. A growth manager can see engagement broken down by source on the same screen as the bulk-resubscribe queue. The data was always there; SleekView makes it operational.
Questions
Common questions about SleekView for MailPoet
Yes. Automated emails are stored alongside newsletters in mailpoet_newsletters with a type field distinguishing them. SleekView surfaces them with type as a filter, so you can audit welcome-series performance separately from broadcast performance, or build a unified view across both.
Yes. SleekView writes through MailPoet's API where supported, so registered hooks (confirmation emails, integration callbacks, double-opt-in flows) fire as expected. Direct DB writes are available with conflict detection for bulk cleanup that doesn't need to retrigger emails.
 
Subscriptions created via WooCommerce checkout land in mailpoet_subscribers with the source field populated automatically. SleekView surfaces them with source as a filterable column, so you can build a WooCommerce-customer segment for product-launch campaigns or compare engagement between checkout-derived and form-derived subscribers.
Yes. Paginated and indexed queries on MailPoet's custom tables mean the workspace runs smoothly with hundreds of thousands of subscribers. The joins use the indexed pivot tables rather than scanning meta, so segment views stay fast even as lists grow.
 Yes. Open and click counts can be aggregated as columns and used as filters. Build a view of subscribers with zero opens in the last 90 days for a re-engagement campaign, or sort by total opens to find your most engaged audience for premium-content sends.
 Yes. Each subsite has its own MailPoet tables (or the network-wide tables if MailPoet is configured network-wide), and SleekView reads the current subsite's data only by default. Network-wide views can be configured explicitly when newsletter ops span multiple subsites.
 
Yes. Filter to status unconfirmed and created_at within the last 7 days. That's the cleanup queue — subscribers who started signup but never confirmed. Either bulk-delete them or trigger a re-send of the confirmation email through MailPoet's API directly from the inline action.
Premium adds dynamic segments, advanced analytics, and a few additional tables for tracking. SleekView reads whichever MailPoet variant is active and surfaces the additional Premium data as columns or separate views — the workspace adapts to your install rather than requiring a specific MailPoet edition.
 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
- Shipstation Woocommerce
- Woocommerce Quantity Discounts
- Woocommerce Inventory Pro
- Flexible Shipping
- Woocommerce Google Analytics Pro
- Printful Integration
- Woocommerce Nowpayments
- Etsy Shop Importer
- Woocommerce Conditional Discounts
- Woocommerce Pricing Deals
- Woocommerce Tax Toggle
- Givewp
- Woocommerce Mercado Pago
- Edd Points Rewards
- Edd Convertkit
- Lifterlms Pro Membership
- Wishlist Member X
- Tva Thrive Apprentice
- Restrict Content Pro
- User Access Manager
- Buddypress Media
- Ihc Membership
- Profile Magic
- Wp Affiliate Manager
- Private Content Restricted Content
- Memberium Infusionsoft Pro
- Armember Pro
- Memberpress Coupons
- Register Plus Redux
- Ultimatemember Paid Content