Campaigns sent last month - Mailchimp SQL Query - Peliqan

Campaigns sent last month

SQL query for Mailchimp

Get the number of campaigns sent last month.

SELECT COUNT(*) FROM Campaigns WHERE sent_date >= DATEADD(MONTH, -1, 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.