Mailchimp API <> Google Sheets
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Mailchimp API - Get Campaign Data
By Ben Collins
http://www.benlcollins.com/
Chart Data
2
3
IDCampaign Sent DateCampaign TitleCampaign Subject lineRecipientsEmails SentUnique opensClicksOpen RateClick RateCampaign Sent DateOpen RateClick RateAverage Open RateAverage Click Rate
4
02015-08-24Test newsletter
Welcome to benlcollins
111010008/24/20151000389
5
12016-01-13First Newsletter
Happy New Year! Tricks for importing social media data into Google sheets
6262314506.4516129031/13/2016413389
6
22016-01-13
First Newsletter (to additional subscribers)
Happy New Year! Tricks for importing social media data into Google sheets
16165031.2501/17/20164928389
7
32016-01-17ebook_launch
Spice Up Your Sheet Life with my new ebook
8383412349.3975903627.710843371/18/20161717389
8
42016-01-18
ebook_launch (copy 01)
Spice Up Your Sheet Life with my new ebook
661116.6666666716.666666671/25/20163010389
9
52016-01-25
ebook_launch (copy 02)
Spice Up Your Sheet Life with my new ebook
10103130102/23/2016277389
10
62016-02-23
February Newsletter
Data Visualization techniques in Google Sheets
195195521326.666666676.6666666673/24/20165126389
11
72016-03-24Missing Ebook
In case you missed it, here's my ebook: Spice Up Your Sheet Life
164164834250.609756125.60975614/19/20163911389
12
82016-04-19
April Newsletter - Google Apps Script
Build your own Slack bot with Google Sheets and Apps Script
4544541794839.4273127810.572687227/5/2016309389
13
9Not sentJune newsletter
5 tricks with the index formula; Upcoming Google teaching sessions
31860N/aN/aN/aN/a8/31/20163810389
14
102016-07-05
Missing Ebook (copy 01) #2
In case you missed it, here's my ebook: Spice Up Your Sheet Life
158158341121.518987346.96202531611/21/2016418389
15
112016-07-05
Summer newsletter - Google Data Studio
Summer's here! So is Google's new dashboard tool: Data Studio
1069106940412737.7923292811.8802619312/19/2016297389
16
122016-08-31
Facebook page intro newsletter
Whoa, this Google Sheet trick blew my mind! What's your favorite Google Sheet formula or hack?
1567156759416437.9068283310.4658583312/22/2016327389
17
132016-11-21
Waterfall Charts newsletter
Waterfall Charts in Google Sheets with shareable templates for you to use
2214221490017240.65040657.7687443541/12/20173515389
18
142016-12-19
benlcollins - 2016 Survey email
undefined2455245570716228.798370676.5987780041/20/2017347389
19
15Not sentundefined31860N/aN/aN/aN/a2/7/2017339389
20
162016-12-22
Survey Results and blog round up
undefined2459245978716432.004880036.6693777962/14/2017333389
21
172017-01-12
Google Resources Newsletter
The ultimate list of resources for Google Sheets, Apps Script and Data Studio
2617261791839935.0783339715.246465422/16/2017336389
22
182017-01-20
Create Index Sheet newsletter
Quick Apps Script trick when working with large Google Sheets
2664266491118634.19669676.9819819822/20/2017317389
23
192017-02-07
Beginner guide to API
Beginner guide to APIs! Use Apps Script to get data into your Google Sheets
2877287794426532.81195699.2109836642/22/2017323389
24
202017-02-14
Dashboard Launch #1 Email #1
5 lessons I've learnt since I built my first dashboard
295029509607532.542372882.5423728812/24/20175110389
25
212017-02-16
Dashboard Launch #1 Email #2
5 Google Sheet techniques to take your dashboards to the next level
2947294796217532.643366145.938242283/8/2017327389
26
222017-02-20
Dashboard Launch #1 Email #3
undefined2974297493420131.405514466.758574311
27
232017-02-22
Dashboard Launch #1 Email #4
undefined299829989618632.054703142.868579053
28
242017-02-24
Dashboard Launch #1 Email #5
undefined302330238466727.985444922.216341383
29
252017-02-24
Final launch email for new signups
Launch offer today for my new Google Sheets Dashboard course
16161237518.75
30
262017-03-08
Update to Import article
undefined3074307497322231.652569947.221860768
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...