Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Export raw data from Mailchimp lists and campaigns.
'''A python script to export the raw data from mailchimp lists and campaigns.
The output of this script will be a CSV file with the open and click rates for each campaign
and each list member (identified by an email.) You can use this data for further analysis
as seen here:
http://www.silota.com/docs/recipes/sql-email-customer-list-segmentation-lead-scoring.html
Written by Ganesh, 2017.
'''
import requests
API_KEY = "MAILCHIMP_API_KEY"
LISTS = ["LIST_ID"]
session = requests.Session()
session.headers.update({"Authorization": "apikey %s" % API_KEY})
def quote(x):
return '"%s"' % x
def get_campaigns():
'''Return an enriched data structure of all campaigns in this account'''
r = session.get("https://us7.api.mailchimp.com/3.0/campaigns/")
fields = ["id", "send_time", "emails_sent"]
ret = []
print ",".join(fields), ", title"
for c in r.json()["campaigns"]:
print ",".join([str(c[x]) for x in fields]), ",", quote(c["settings"]["subject_line"])
ret.append((c["id"], c["send_time"], c["emails_sent"],
c["settings"]["subject_line"]))
return ret
def click_reports():
campaigns = get_campaigns()
print "id, campaign_id, sent_time, subject, email, open_count, click_count"
for c in campaigns:
n, offset = 0, 0
while True:
r = session.get(
"https://us7.api.mailchimp.com/3.0/reports/%s/email-activity/?fields=emails.campaign_id,emails.email_address,emails.activity&count=100&offset=%d" % (c[0], offset))
for e in r.json()["emails"]:
open_count, click_count = 0, 0
for a in e["activity"]:
if a["action"] == "open":
open_count += 1
elif a["action"] == "click":
click_count += 1
print ",".join("%s" % x for x in [n, e["campaign_id"], quote(c[1]), quote(c[3]), e["email_address"], open_count, click_count])
n += 1
if n < (offset + 100 - 1):
break
offset += 100
click_reports()
@radumchristian
Copy link

radumchristian commented Mar 29, 2018

hello Sir, what is the usage of this?
I added my API key and the list ID and when i run the script i get the following:
[root@cpanel14518051 ~]# ./mailchimp.py
./mailchimp.py: line 7: A python script to export the raw data from mailchimp lists and campaigns.
The output of this script will be a CSV file with the open and click rates for each campaign
and each list member (identified by an email.) You can use this data for further analysis
as seen here:
http://www.silota.com/docs/recipes/sql-email-customer-list-segmentation-lead-scoring.html
Written by Ganesh, 2017.
: File name too long
import: unable to open X server ' @ error/import.c/ImportImageCommand/369. ./mailchimp.py: line 11: API_KEY: command not found ./mailchimp.py: line 13: LISTS: command not found ./mailchimp.py: line 15: syntax error near unexpected token ('
./mailchimp.py: line 15: `session = requests.Session()'
[root@cpanel14518051 ~]#

am i doing something wrong? thanks!

@jvaldiviac13
Copy link

jvaldiviac13 commented Nov 12, 2019

Did your script work?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment