Loading...

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 report
    Each 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 detail
    The 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 supported
    Keys 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.