BEHIND THE SCENES
Stitch’s Mailchimp Integration
Alright, so this is a follow up on last week’s story on how to automatically transfer Mailchimp data from source to your own data lake. With the help of the good folks at Fishtown Analytics, creators of the most excellent dbt ETL (and much more) tool, I got into Stitch’s Mailchimp integration Beta program.
Win! 🥳

If you’re familiar with Stitch, this is a thing of beauty! You get to replicate 8 source tables (automations, campaigns, list_members, list_segment_members, list_segments, lists, reports_email_activity, unsubscribes). I’ve started adding some of those to my ETL, which feeds my data warehouse and it’s all the data I was hoping for!
Of course, there are bugs along the way (as you can see in the screen capture above), but it’s a Beta program after all. And the guys at Stitch have been really responsive so far.
In next week’s edition, I’ll show you how my ETL is looking so far. It’s starting to become very interesting with the addition of Mailchimp. 🤩
|