SleekView for EDD Mailchimp: customer sync & list tables
Read directly from edd_customers and the EDD Mailchimp meta keys recording list membership and last sync. Build subscriber views, opt-in audits, and post-purchase segments without exporting to a separate dashboard.
♾️ Lifetime License available
Mailchimp sync state isn't visible in the EDD admin
EDD Mailchimp adds customers to Mailchimp lists when they purchase, optionally tagging them with product purchases and storing the sync state in edd_customermeta or edd_ordermeta under keys like _edd_mailchimp_subscribed and _edd_mailchimp_list_id. The default EDD admin doesn't surface any of this on the Customers or Orders screen, so opt-in status and list membership stay invisible at the row level.
SleekView reads edd_customers together with edd_customermeta and joins to edd_orders so opt-in status, list id, last sync timestamp, and lifetime value become first-class columns. Marketing builds a saved view of subscribers acquired in the last quarter, support sees opt-in state inline when responding to GDPR requests, and ops triages customers whose sync failed before the next campaign sends.
Inline edits to subscription state route through EDD's CRUD layer where supported so EDD Mailchimp's subscribe and unsubscribe hooks fire. Direct meta writes are guarded by conflict detection so a stale admin row never overwrites a Mailchimp webhook update.
Workflow
How SleekView reads EDD Mailchimp data
Pick the base table
edd_customers for subscriber-rooted views, edd_orders for purchase-rooted views joined to opt-in state. SleekView detects EDD 3.0 automatically.
Compose Mailchimp columns
_edd_mailchimp_subscribed, list id, last sync timestamp, and any tag-related keys from the column picker. Only keys present in your data are listed.
Save segments and audit views
Edit inline or export
Sample columns
A typical EDD Mailchimp subscriber view
edd_customers with edd_customermeta Mailchimp keys and aggregated order totals from edd_orders.
wp_edd_customers + wp_edd_customermeta + wp_edd_orders
| Customer | Opt-in | Mailchimp list | Orders | LTV | Last order |
|---|---|---|---|---|---|
| alex@studio.co | Subscribed | Main list | 4 | $192.00 | Apr 24 |
| ria@design.io | Pending | Main list | 2 | $96.00 | Apr 24 |
| tom@hello.dev | Subscribed | Beta testers | 6 | $248.00 | Apr 23 |
| mia@brew.coop | Unsubscribed | (none) | 1 | $48.00 | Apr 23 |
Comparison
Default EDD Mailchimp admin vs SleekView
Default EDD Mailchimp admin
-
Opt-in status lives in
edd_customermetaand isn't shown in the Customers list - Mailchimp list id and tags aren't joined into the EDD customer view
- Failed syncs sit in error logs that nobody reads daily
- No saved view for customers acquired in last quarter, subscribed, with LTV over X
- Unsubscribes aren't easily auditable against purchase history
SleekView
-
Surface
_edd_mailchimp_subscribedand list id as columns - Customer-rooted view with opt-in, list, LTV, order count
- Saved view: subscribed customers acquired in last quarter
- Audit-friendly view of unsubscribes joined to last order date
- Export segments to CSV for upload to Mailchimp ad-hoc
Features
What SleekView gives you for EDD Mailchimp
Subscribers and customers in one view
Build a view on edd_customers with Mailchimp opt-in, list id, and lifetime spend as columns. Marketing sees subscriber and customer context together without switching to Mailchimp.
Segment by purchase plus opt-in
Combine product purchased (via edd_order_items), opt-in state, and last-order date to build segments inside WP. Saved views are reusable per campaign.
Sync failures triage
Saved view of customers whose last sync failed, with last error visible inline. Fix data, requeue, send the campaign with the actual subscriber list intact.
Audience
Who uses SleekView for EDD Mailchimp
Marketing
Build segments by product purchased, opt-in state, and LTV. Export to CSV for ad-hoc campaigns, or use saved views as the briefing for the next email.
Customer support
See opt-in status inline when responding to a GDPR request or a complaint about emails. Unsubscribe a customer through the integration's hook without leaving WP admin.
Store admins
Daily sync-failure triage view: which customers didn't sync, what the last error was, and how to fix it. Less guessing about why a campaign sent to fewer subscribers than expected.
The bigger picture
Why post-purchase segmentation needs row-level views
EDD Mailchimp is one of the most common ways a digital store keeps its marketing list in sync with its customer list. The integration works cleanly on the happy path: a customer buys, gets added to a Mailchimp list, optionally gets tagged with the product. Where it falls down is making the result usable inside WordPress.
The default EDD admin treats opt-in state as invisible meta. The default Mailchimp UI knows nothing about LTV or which EDD product a subscriber bought first. Operators end up exporting CSVs both directions to build a segment that's really just "customers who bought X, opted in to list Y, ordered more than once".
SleekView turns that into a saved view inside WordPress: subscribers and customers joined, opt-in state visible, product purchases joined through edd_order_items. Marketing builds the segment once and rebuilds it monthly with two clicks. Same database, same Mailchimp integration, dramatically less CSV juggling.
Questions
Common questions about SleekView for EDD Mailchimp
Yes. SleekView reads edd_customers and edd_customermeta on EDD 3.0 and later. On older EDD versions customer data lived in a different schema and would need a different mapping, but most stores have migrated.
Yes. Status changes that route through EDD Mailchimp's hooks trigger the Mailchimp API call as configured. The actual subscribe or unsubscribe goes through the plugin's existing chain, so behaviour matches manual admin actions.
 
EDD Mailchimp tags customers with products purchased if you've configured tagging. If those tags are stored in edd_customermeta, SleekView's column picker will list them. If they're stored only in Mailchimp, SleekView can't show them without a pull-back sync.
Yes, if EDD Mailchimp records the list id in edd_customermeta. Multiple lists per customer surface as a comma-separated cell or as a child related view, depending on how you configure the column.
Campaign send data lives in Mailchimp, not in WordPress, so SleekView doesn't render it directly. What it can show is subscriber state and the data EDD already stores about purchases, which is enough to segment for the next campaign.
 
Customer queries hit indexed columns on edd_customers. Aggregate columns (LTV, order count) use subqueries against edd_orders that EDD already indexes for. Keep aggregates off triage views and on detail views to keep query plans fast on large lists.
No. It's a view into the WordPress side of the EDD plus Mailchimp data. Mailchimp remains the source of truth for campaign sends, automations, and engagement metrics. SleekView's role is making the EDD side of the data trivial to segment and audit.
 Yes. A customer-rooted view with email, opt-in state, list membership, and order history in one row gives you the WordPress side of a Subject Access Request in a few seconds. You still need to pull engagement data from Mailchimp separately, but the bulk of the WP-side answer is one filtered view away.
 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 Colissimo
- Order Status Manager
- Woocommerce Quote Request
- Woocommerce Product Bundles
- Yith Woocommerce Product Add Ons
- Woocommerce Distance Rate
- Edd Aweber
- Woocommerce Print Invoices
- Wpc Frequently Bought Together
- Woocommerce Glsship
- Woocommerce Vertex Tax
- Woocommerce Coinbase Commerce
- Yith Woocommerce Sales Countdown
- Woocommerce Wholesale Order Form
- Woocommerce Gift Ultimate