EmailOctopus Connector Reference

The EmailOctopus connector exposes 19 fields (0 metrics, 19 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

EmailOctopus Fields

EmailOctopus campaigns fields

The campaigns report of the EmailOctopus connector includes 8 fields.

ID	Type	Name	Description
campaigns__created_at	TEXT	campaigns.created_at	campaigns.created_at
campaigns__from	OBJECT	campaigns.from	campaigns.from
campaigns__id	TEXT	campaigns.id	campaigns.id
campaigns__name	TEXT	campaigns.name	campaigns.name
campaigns__sent_at	TEXT	campaigns.sent_at	campaigns.sent_at
campaigns__status	TEXT	campaigns.status	campaigns.status
campaigns__subject	TEXT	campaigns.subject	campaigns.subject
campaigns__to	OBJECT	campaigns.to	campaigns.to

EmailOctopus lists fields

The lists report of the EmailOctopus connector includes 6 fields.

ID	Type	Name	Description
lists__counts	OBJECT	lists.counts	lists.counts
lists__created_at	TEXT	lists.created_at	lists.created_at
lists__double_opt_in	BOOLEAN	lists.double_opt_in	lists.double_opt_in
lists__fields	OBJECT	lists.fields	lists.fields
lists__id	TEXT	lists.id	lists.id
lists__name	TEXT	lists.name	lists.name

EmailOctopus other fields

The EmailOctopus connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date