ABCDEFGHIJKLM
1
Hello! Welcome to the Iterable email metrics source sheet, an automatic way for you to export your campaign metrics and pivot them however you want. There is a little bit of leg work to set this up, but after that it is pretty easy-going. Please read the following instructions to set up this source table:

1. Add this sheet to your Drive and make a copy of it (organize it however you like).

2. Go to the APP SETTINGS sheet and input your API Key and the desired date interval (the time period your report will cover each time it pulls data from Iterable).

3. Open the Campaigns sheet and add all of the campaignIds (active campaigns only) and their corresponding email titles to the columns. CampaignIds can be found in the URL of Iterable's Campaing Editor (not to be confused with templateId or workflowId), OR they can be found in the main table in the "Campaigns" view in Iterable. It is recommended that you use one metrics spreadsheet per workflow, or per email type (i.e. 'Onboarding' emails, Abandoned Cart Workflow Emails, etc.) Just duplicated this sheet and repeat the process for each.

4. Navigate in this sheet to Tools > Script Editor. Click the Select a Function dropdown and select runEmailDataFunction. Then press the Play triangle icon to the left of the dropdown. You will be prompted to allow the app to access your sheet and contact an external source. Approve these prompts. If you are using a personal gmail account, you will, at frist, be blocked from running the function, but there's a very subtle link in the prompt that will allow you to proceed anyway. This action will populate fields on this sheet. If you experience an error, you most likely put an invalid value in one of the previous steps, like campaignId or API Key.

5. Add a Project Trigger – Go to https://script.google.com/home and select the 'Get Iterable Campaign Metrics' project. Select menu icon in Project Details and navigate to Triggers. Click the Add Trigger button near the bottom-right of the screen.

6. Set Up Project Trigger – Function to run: runEmailDataFunction || Select event source: Time-based Trigger || Type: choose "daily timer," "weekly timer," or "monthly timer." || Time of day: Generally the options between midnight and 3am are solid choices.

7. Check out the pre-made pivot tables in this spreadsheet. feel free to add to, edit, or delete them as you wish. Do not edit the Master sheet as it will affect the data you see in the pivot tables. If you are experiencing errors, or don't see your desired metric in this spreadsheet (hint: iterable purchase events, hosted unsubscribes...) please reach out to the creator at hello(at)moonvillage.works.

8. Delete this row (this wall of text ain't helping you get your metrics!) and enjoy!
2
Looking for more help with Email Marketing, CRM, or Iterable needs? Look no further. Shoot an email to hello(at)moonvillage.works for a free 30-minute consultation.Let's chat! -->
3
campaign_idcampaign_namestart_dateend_datesentdeliveredunique_openstotal_opensunique_clickstotal_clicksbouncesunsubscribesconversions
4
651731Sample Email Name2019-08-292019-09-051312142612100
5
6
7
8
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