Mailchimp API
Track email campaign performance and subscriber engagement over time
Pull campaigns, audiences, and per-campaign reports from the Mailchimp Marketing API. Track open rates, click rates, and unsubscribe trends across months. Identify which segments drive revenue and which audiences are going cold.
Free plan: 500 contacts, 1,000 sends/month. API included.
How it works with Loony
Describe it.
Deploy it.
Query it.
Managed database.
Your Mailchimp data lives in its own Postgres instance. Zero config. Data accumulates over time.
Scheduled syncs.
Cron jobs run on Loony infra. Every minute on free. Your data stays fresh without you thinking about it.
REST + MCP endpoints.
Query from your agent, your dashboard, or connect BI tools directly. Full OpenAPI spec included.
$ "Pull all my Mailchimp campaigns and per-campaign reports for the last 6 months. Break down open rate, click rate, and unsubscribes by audience segment and week." ✓ Schema validated ✓ Database provisioned ✓ Scripts deployed ✓ Schedules registered Done. # Your data is now at: REST /data/v1/mailchimp/query MCP /mcp/v1/mailchimp/mcp SQL psql $DATABASE_URL
What you get
Mailchimp's dashboard shows you one campaign at a time. Loony accumulates every send into a Postgres database so you can query across months, compare segments, and spot trends the UI hides. Scheduled syncs keep the data fresh without cron jobs. Your agent can answer 'Which subject-line pattern gets the best click rate?' because the history is all in one place.
mv_campaign_performance campaign_id text -- Mailchimp campaign ID send_date date -- date the campaign was sent subject_line text -- email subject line list_name text -- audience / list name emails_sent integer -- total recipients open_rate numeric -- proportion opened click_rate numeric -- proportion clicked unsubscribes integer -- count per campaign
Even better together
Join Mailchimp campaign data with HubSpot contacts to tie email engagement to deal stage. Add Stripe to attribute revenue to specific sends. Combine with Google Analytics to follow the click-to-conversion funnel.
