Active subscribers
SQL query for Mailchimp
Get the number of active subscribers (subscribed within the last 30 days).
SELECT COUNT(*) FROM Lists WHERE last_subscribed_date >= DATEADD(DAY, -30, GETDATE())
Mailchimp data model
Campaigns
Lists
Audiences
Contacts
List Tags
Members
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed