Created an App Script in Google Sheets which connect's to the MailerLite API and pulls statistics from all the active campaigns. The report runs automatically every day and it feeds into Looker Studio, creating a dynamic filterable report with live data.