Email campaign automation setup

I helped a company I worked for with setting up drip email campaign automation via Zapier.

I first wrote SQL queries that filter out the desired target audience from the database

Once these queries got verified for both the results and their performance with engineers, we then set up APIs to periodically run these queries to generate mailing lists

I then set up Mailchimp campaigns using said mailing lists via Zapier