SleekView Charts for Subscribe2
Subscribe2 splits subscribers across wp_subscribe2 and usermeta. Chart the merged set with confirmation, exclusion, and growth cards rather than tabbing between two screens.
♾️ Lifetime License available
Two subscriber stores, one chart board
Subscribe2 carries two subscriber stores since the early WordPress days. Public subscribers live in wp_subscribe2 with email, IP, sign-up time, and confirm code. Registered users opt in via the s2_subscribed usermeta key, with additional usermeta keys for excluded categories, format, and frequency. The default admin keeps the two stores on separate tabs.
SleekView Charts unions both sources keyed on email and treats the result as one chart subject. A Number card pins the merged subscriber count, which is what actually receives the digest. A Pie shows the public-vs-registered mix. A Bar ranks subscribers by excluded-category count. An Area card plots sign-ups per day so a campaign push or a quiet stretch shows up immediately.
The merged view is closer to the real send list than either store alone, which means the chart counts match what arrives in inboxes. The same configuration drives the audit table, so a filtered slice (confirmed, type=Public) feeds both views.
Workflow
How SleekView Charts reads Subscribe2 data
Union the two sources
wp_subscribe2 and the s2_subscribed usermeta key, then unions them on email. Each row carries a type column (Public or Registered) so the source remains visible in chart group-bys.
Pivot usermeta keys
Track confirmation health
Plot growth from sign-up dates
Sample dashboard
Charts you can build from Subscribe2 data
Confirmed subscribers
Count
Public vs registered
Count
group by subscriber_type
Registered users by excluded categories
Count
group by excluded_categories
Sign-ups per day
Count
group by joined_date
Comparison
Default Subscribe2 reporting vs SleekView Charts
Default Subscribe2 admin
- Public and registered subscribers live on separate tabs, no merged chart
- Confirmation state shown as an icon, never as a Pie slice
- Excluded-category distribution is invisible without exporting CSV
- No time-series view of merged sign-ups
- Bulk-confirm flows have no before/after KPI
SleekView Charts
- Number card for confirmed merged subscribers (the real send list)
- Pie card for the public-vs-registered subscriber-type mix
- Bar card ranking excluded categories among registered users
- Area card plotting merged sign-ups per day
- Filters carry from the table view so audit and chart share a slice
Features
What SleekView Charts gives you for Subscribe2
Merged set, not two halves
Charts union wp_subscribe2 with the s2_subscribed usermeta key. The counts you see are the counts that actually receive the next send, not two disjoint tabs.
Exclusions as a Bar
Registered users opt out of categories. The Bar surfaces which categories readers most often skip, which feeds editorial planning rather than a quarterly export.
Growth in one curve
Both stores expose a sign-up date. The Area card plots growth across both subscriber types in one curve, which is how operators actually want to see the audience trend.
Audience
Who builds Subscribe2 charts dashboards with SleekView
Newsletter operators
Pin the confirmed Number, the public-vs-registered Pie, and the sign-up Area for a one-screen send-list health board, then ship the next digest with confidence.
Privacy and GDPR
Chart the confirmation backlog and the exclusion mix so a data-protection officer sees a real audience picture rather than an inferred one from CSV exports.
Migration planners
Before moving to a hosted ESP, chart the deduped merged set against the per-store splits to predict the imported list size and skip ESP-side billing surprises.
The bigger picture
Why merged subscriber data deserves a chart layer
Subscribe2 was built when the WordPress newsletter market was younger and the line between public subscriber and site member was 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. The chart view 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. The merged Number is the operational truth.
The Pie is the architecture truth. The Bar and the Area are the editorial planning truth. Together they replace the screenshot-driven audits and quarterly exports most Subscribe2 operators still run, with one board the team can read on the morning of a send.
Questions
Common questions about SleekView Charts for Subscribe2
Directly from wp_subscribe2 for public subscribers and wp_usermeta for the s2_subscribed key and related preference keys. The merged chart subject unions both sources on email so the counts reflect the real send list.
Yes. Each merged row carries a subscriber-type column. A Pie grouped on that column surfaces the proportional split between the two stores so growth-path decisions read from data rather than instinct.
Yes. Subscribe2 HTML stores additional preference keys in usermeta. The column picker surfaces every key present in the data, so installs running the HTML variant get richer chart sources without per-install configuration.
Excluded categories are stored as a serialized list per user. The chart layer normalises that into rows so a Bar grouped on category counts how many registered users opted out of each topic, which is the editorial planning view.
Yes. View-level filters (subscriber type, confirmation state, date range) apply to every chart card. One saved configuration drives both the audit table and the chart view so triage and reporting share a slice.
No. The union keys on email and merges duplicate rows. If a registered user also exists in the public table, the merged row reflects the registered side (which carries richer preference data) and the count stays accurate.
Yes. Each saved chart view is gated by WordPress capability. Newsletter operators, privacy reviewers, and migration planners each save a view with role-appropriate cards while reading from the same merged source.
No. Subscribe2's admin still owns subscriber edits, manual confirmations, and the send composer. The chart view adds a reporting surface on top of the data Subscribe2 already maintains, so the plugin keeps owning the lifecycle and the dashboard owns the summary.
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