I’m trying to connect Mailchimp email data (opens, clicks, etc.) to Tableau so I can make a tracking/analysis dashboard. I’m brand new (today) to Zapier, so I’ve just opened it up to play around a bit.
I know there is no native Tableau connector at this time.
Q1) I figure one way I could go would be to have Zapier upload MailChimp data to a database (BigQuery/Cloud? Google sheets?) and then connect Tableau to that. Does that make sense?
Q2) Our MailChimp campaigns are one-offs; meaning we build them for each send weekly. I wanted to figure out a way to have Zapier dump any opens and clicks to my that database (ie; adding a line of data.) However, it looks like I have to set up new Zaps for each new campaign, rather than have it send for clicks or opens from any campaign we send. Is that correct, or is there a way to set up what I’d like to do?
Best answer by robschmidtView original