SleekView for Subscribe2: subscribers as customizable tables
Subscribe2 splits subscribers across wp_subscribe2 for public emails and usermeta for registered users. SleekView merges both into one inline-editable view with confirmation state and category exclusions visible.
♾️ Lifetime License available
Two subscriber stores, one screen
Subscribe2 has carried two subscriber stores since the early WordPress days. The first is wp_subscribe2, a custom table holding email-only public subscribers along with IP, sign-up time and confirm code. The second is usermeta, where registered WordPress users opt in via the s2_subscribed key and store their excluded categories, format preference (HTML or plain text) and frequency (per post or digest) in additional usermeta keys.
The default Subscribe2 admin keeps the two stores on separate tabs. That made sense at the time but it makes auditing harder than it needs to be. Confirmation state for public subscribers shows as an icon, not a sortable column. Excluded categories per registered user are buried inside the user profile. Bulk actions cover delete and toggle confirm but do not span the two stores at once. SleekView unions the two sources keyed on email, surfaces type (Public or Registered), confirmation state, joined date, and excluded categories as columns, and runs filters across both at the same time.
The merged view changes how teams operate. Pre-launch cleanups bulk-confirm a backlog of pending public subscribers in one pass. Migrations to a hosted ESP dedupe the two stores into one canonical list before the export. GDPR data-subject requests pull a single record showing both halves of a subscriber's data, which is the only honest reply to "send me everything."
Workflow
Two subscriber stores, one merged table
Union the two sources
wp_subscribe2 and usermeta with key s2_subscribed, then unions them on email. Each row carries a type column (Public or Registered) so the source remains visible.
Surface usermeta as columns
Bulk-confirm pending publics
Export for migration
Sample columns
A typical Subscribe2 subscribers view
wp_subscribe2 + wp_usermeta
| Type | Confirmed | Excluded cats | Joined | Status | |
|---|---|---|---|---|---|
| alex@studio.co | Public | Yes | — | Apr 24 | Active |
| ria@design.io | Registered | Yes | off-topic | Apr 18 | Active |
| tom@hello.dev | Public | No | — | Apr 16 | Pending confirm |
| mia@brew.coop | Public | Yes | — | Mar 02 | Bouncing |
Comparison
Default Subscribe2 admin vs SleekView
Default Subscribe2 subscribers screen
- Public and registered subscribers live on separate tabs
- Confirmation state shown as an icon — not sortable or filterable
- Excluded categories per registered user are buried in user-meta
- Bulk actions are limited (delete, toggle confirm) and don't span the two stores
- Search filter doesn't combine email contains with confirm-state
SleekView
-
Union
wp_subscribe2withs2_subscribedusermeta - Surface excluded categories per registered user as a column
- Bulk-confirm pending public subscribers in one pass
- Filter by joined-date range across both subscriber types
- Inline-edit excluded categories without opening a profile
Features
What SleekView gives you for Subscribe2
Two stores, one table
Public subscribers and registered users opt in through different paths and live in different tables. SleekView merges them so reporting matches what is actually emailed.
Confirmation health
Sort by joined date among unconfirmed public subscribers to find the cohort that never clicked the confirm link, then re-send the confirmation or purge them.
Inline category exclusions
Edit which post categories a registered user is opted out of, directly in the row. Subscribe2 stores those as usermeta keys; SleekView pivots them into a column.
Audience
Who uses SleekView for Subscribe2
Newsletter operators
Audit who actually receives the digest by surfacing exclusions and confirmation state alongside email. The merged table is closer to the real send list than either store alone.
Privacy & GDPR
Export a single CSV showing every subscriber, type, confirmation timestamp and exclusions for a data-subject request. The merged view is the only honest reply.
Migration prep
Move from Subscribe2 to a hosted ESP cleanly by deduping the two stores into one canonical list, then exporting the result with all preferences attached.
The bigger picture
Newsletter ops needs the full subscriber list, not two halves
Subscribe2 was built when the WordPress newsletter market was younger and the lines between "public subscriber" and "site member" were harder to draw. The two-store model reflects that history. It still works, but it forces every audit and every migration to keep track of which half is which.
The default screens lean into that separation because it is faithful to how the data is stored. SleekView leans the other direction because it is faithful to how the data is used: a digest sends to everyone who opted in, regardless of which table they live in. So that is the table the team needs to scan, dedupe, segment and export.
The frequency column matters most for sites that mix per-post emails with weekly digests; the exclusions column matters most for sites with thousands of registered users who opted out of off-topic categories years ago. Both are invisible in the default UI, both are first-class columns in SleekView. The point is to surface everything that affects who actually receives the next send.
Questions
Common questions about SleekView for Subscribe2
Public subscribers go into a custom table (typically wp_subscribe2) with email, IP, time and confirm code. Registered users opt in via the s2_subscribed usermeta key, with related keys for excluded categories, format and frequency. SleekView reads both directly so the merged view is a faithful representation of who is actually subscribed.
Yes. Build a view that unions both sources keyed on email, with a precedence column showing which side wins (registered usually does because that user has richer preference data). The deduped result is what most teams want before exporting to an ESP, since hosted ESPs treat email as the unique key by default.
 Yes. SleekView writes through Subscribe2's existing functions where they exist (confirm, delete, subscribe, unsubscribe). Direct table writes only happen for fields the plugin treats as plain data with no associated hooks. That separation keeps custom integrations on top of Subscribe2 working when an audit edit fires.
 Subscribe2 stores excluded categories in usermeta with a known key. SleekView surfaces it as a column you can edit; the plugin reads usermeta on send, so the next digest respects the new exclusions. Bulk-editing exclusions across many users at once is one of the most useful operations the merged view enables.
 Yes. The format and frequency are stored in usermeta. Add them as columns to your view, sort by frequency, and you will see who is on which schedule. Most sites have a per-post crowd and a digest crowd; the column makes that mix visible and editable in bulk.
 
That token is rendered by the plugin at request time; it does not store data. SleekView focuses on subscriber rows, not on the public form HTML. To audit where the token is used in posts, the agent UI can scan post_content for the literal token string and return a separate report.
Subscribe2 HTML stores the same kinds of data in the same tables, plus a few extra usermeta keys for HTML-specific preferences. SleekView reads both shapes; if a usermeta key is present, it appears as a column. Sites that have not upgraded see a smaller column set, which is the expected behavior.
 
WordPress deletes that user's usermeta on account deletion, including s2_subscribed, so the registered-side row disappears. If the same email also exists in wp_subscribe2 as a public subscriber, that row remains. SleekView's merged view reflects this honestly: the user vanishes from the registered side and stays on the public side until explicitly purged.
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