---
title: "Analyzing Mailchimp Campaigns using Google Apps Script — PART II"
author: "Martin Hawksey"
date: 2020-01-04T09:40:00+00:00
modified: 2020-01-03T21:58:50+00:00
canonical_url: https://pulse.appsscript.info/p/2020/01/analyzing-mailchimp-campaigns-using-google-apps-script-part-ii/
markdown_url: https://pulse.appsscript.info/p/2020/01/analyzing-mailchimp-campaigns-using-google-apps-script-part-ii.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "Medium"
  - "Urwa.Shabir"
description: "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..."
---

# Analyzing Mailchimp Campaigns using Google Apps Script — PART II

> 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*](https://medium.com/@Urwa.Shabir/analyzing-mailchimp-campaigns-using-google-apps-script-part-ii-d73405ddd1f6)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/01/analyzing-mailchimp-campaigns-using-google-apps-script-part-ii/](https://pulse.appsscript.info/p/2020/01/analyzing-mailchimp-campaigns-using-google-apps-script-part-ii/)*