EmailOctopus
Stats for your EmailOctopus email campaigns: sends, bounces, opens, clicks, unsubscribes, spam complaints.
The EmailOctopus connector brings your account's email campaign stats into the sheet: one row per sent campaign, with the counts provided by EmailOctopus and the rates calculated from those counts.
The connection does not use a Google login: you enter an EmailOctopus API Key, created from Account settings > Developer > API keys (emailoctopus.com/developer/api-keys), and a name of your choice for the connection (EmailOctopus does not expose the account name through its API). Keys marked as "legacy" do not work with the current API: generate a new one.
Only already-sent campaigns (status "sent") are included: drafts, campaigns being sent and campaigns in error do not appear.
Available metrics
| Metric | Period | Aggregation | Note |
|---|---|---|---|
| Sent | campaign | sum | Number of contacts the campaign was sent to. |
| Delivered | campaign | sum | Calculated: Sent minus total bounces. |
| Hard Bounces | campaign | sum | |
| Soft Bounces | campaign | sum | |
| Total Bounces | campaign | sum | Hard + soft. |
| Bounce Rate (%) | campaign | ratio | Total bounces / Sent x 100. |
| Total Opens | campaign | sum | |
| Unique Opens | campaign | sum | |
| Open Rate (%) | campaign | ratio | Unique opens / Sent x 100. It can differ slightly from the EmailOctopus dashboard if that uses a different base. |
| Total Clicks | campaign | sum | |
| Unique Clicks | campaign | sum | |
| Click Rate (%) | campaign | ratio | Unique clicks / Sent x 100. |
| Click-to-Open Rate (%) | campaign | ratio | Unique clicks / Unique opens x 100. |
| Unsubscribes | campaign | sum | |
| Unsubscribe Rate (%) | campaign | ratio | Unsubscribes / Sent x 100. |
| Spam Complaints | campaign | sum | |
| Spam Complaint Rate (%) | campaign | ratio | Spam complaints / Sent x 100. |
Available dimensions
| Dimension | Note |
|---|---|
| Date (Sent) | Campaign send date, in the sheet timezone. One row per campaign: this is not a daily series. |
| Sent At | Full send date and time, in the sheet timezone. |
| Created At | Campaign creation date and time. |
| Campaign ID | |
| Campaign Name | The campaign's internal name, not the email subject. |
| Subject | |
| Preview Text | Empty if the campaign has none. |
| From Name | |
| From Email | |
| List ID(s) | The campaign's recipient lists, comma separated. |
| List Name(s) | Current names of the recipient lists (a deleted list shows its ID). |
Known limits
- Max 1,000 campaigns per reportEach campaign needs a dedicated API call for its metrics: to stay within Google Sheets execution time the connector includes at most the 1,000 most recent campaigns in the period, and flags it in the sheet with a warning. Narrow the period if you have more.
- Sent campaigns only, no per-link or per-contact detailThe report includes only campaigns with status "sent" and their aggregate metrics. Per-link click detail and per-contact detail are not included in this version.
- "Legacy" API keys not supportedKeys created for the old v1.6 API (marked "legacy" in EmailOctopus) do not work: the connection rejects them with an explicit message. Generate a new one from Developer > API keys.
Execution notes
The report period filters campaigns by send date (sent_at), in the sheet timezone. The EmailOctopus API cannot filter by date, so the connector reads the full campaign list and applies the filter afterwards.
Each campaign's metrics require a dedicated API call: the connector runs them in parallel in groups of 10, respecting the EmailOctopus limit (10 requests per second). With hundreds of campaigns in the period a run can take a few dozen seconds.
Rates (Open Rate, Click Rate, Bounce Rate, Unsubscribe Rate, Spam Complaint Rate) are calculated on the number of emails sent (Sent), Click-to-Open Rate on unique opens; they range from 0 to 100 and in the totals row they are recalculated on the summed counts, not as an average of the per-row percentages.