So when you send out a campaign, Mailchimp tracks how many people opened the emails and which links were clicked within the email. So this information might not be available in a format you might like. So we will utilize the power of Mailchimp API and Google Sheets to put it in a format that we desire.
Source: Analyzing Mailchimp Campaigns using Google Apps Script — PART II
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.