Mailchimp Report for Israel 365

Israel 365 wanted to know open and click rates for all of its newsletter subscribers. Mailchimp gives this data only on a per subscriber basis.

I created a script to import the mailchimp export (~5000 csv files) into an SQL database and was then able to create the report for Israel 365.