ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
How This Resource Works:
4
This spreadsheet relies on two functions to retrieve campaign information and metrics:

GETCAMPAIGNINFO( campaignId ) - This function retrieves the campaign name based on a given campaign ID

campaignId: The unique ID assigned to an email campaign in Iterable. Campaign IDs can be found in the URL of Iterable's Campaign Editor (not to be confused with template ID or workflow ID), OR they can be found in the main table in the "Campaigns" view in Iterable.


GETITERABLEMETRICS( startDate, endDate, timeZone, campaignId ) - This function retrieves the metrics for a given campaign ID.

startDate: The starting point of the date range you want to measure for a given campaign. The hour will be 12:00 am. i.e. 2019-09-01 will translate to Iterable as "2019-09-01 00:00:00" in whatever timezone you have configured in Iterable.
endDate: The ending point of the date range you want to measure for a given campaign. The hour will be 12:00 am. i.e. 2019-09-01 will translate to Iterable as "2019-09-01 00:00:00" in whatever timezone you have configured in Iterable.
timeZone: The time zone you live in, or wish to retrieve data from Iterable in. Generally, this should match whatever you have configured in Iterable.
campaignId: The unique ID assigned to an email campaign in Iterable. Campaign IDs can be found in the URL of Iterable's Campaign Editor (not to be confused with template ID or workflow ID), OR they can be found in the main table in the "Campaigns" view in Iterable.
5
6
7
Using the Metrics Dashboard
8

Duplicate this spreadsheet into your drive.

Before using the dashboard, be sure to add your API KEY to the APP SETTINGS sheet, then hide that sheet.
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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