The Ultimate Member Mailchimp add-on syncs profile fields and registration opt-ins with Mailchimp audiences. Each member's list memberships and opt-in state are stored as usermeta keys (commonly _um_mailchimp_lists or per-list flags) tied to the Mailchimp list_id, with the registration timestamp from wp_users.user_registered acting as the opt-in date. The default surface is a per-profile Mailchimp panel, which is right for one-member-at-a-time review and unhelpful for understanding the audience footprint across the community.

SleekView reads the Ultimate Member Mailchimp usermeta joined with wp_users and renders each list subscription as a row in an audit table. Filter to last-30-days opt-ins for campaign attribution, sort by list_id to confirm distribution, group by opt_in_status to surface pending consents that need follow-up. The same dataset the chart view aggregates becomes a row-level surface for marketers, compliance and community managers.

The add-on keeps owning the Mailchimp API sync and the profile-side opt-in UI. The table view owns the audit surface, so the list state the add-on already writes to usermeta stops hiding inside per-profile panels.

Ultimate Member Mailchimp captures the data marketers and compliance need: who opted in, to which list, with what status, when. The default surface places that data inside per-profile Mailchimp panels, which is right for one-member-at-a-time review and unhelpful for almost everything operators do at the cohort level. A queryable opt-in table answers the questions teams actually ask: who is the campaign cohort this month, which pending consents need follow-up, which list carries the audience.

Same usermeta rows, same registration timestamps, completely different decision posture. The table renders the audience the add-on already maintains as an auditable cohort, which is the difference between knowing the site has subscribers and knowing how the audience is shaped this quarter.