Courier Connector Reference

11 metrics54 dimensions

Fields

The Courier connector exposes 65 fields (11 metrics, 54 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Courier Fields

Courier message_history fields

The message_history report of the Courier connector includes 18 fields.

ID	Type	Name	Description
message_history__channel	OBJECT	message_history.channel	message_history.channel
message_history__data	OBJECT	message_history.data	message_history.data
message_history__event	TEXT	message_history.event	message_history.event
message_history__event_id	TEXT	message_history.event_id	message_history.event_id
message_history__integration	OBJECT	message_history.integration	message_history.integration
message_history__merged_profile	OBJECT	message_history.merged_profile	message_history.merged_profile
message_history__message_id	TEXT	message_history.message_id	message_history.message_id
message_history__notification_id	TEXT	message_history.notification_id	message_history.notification_id
message_history__output	OBJECT	message_history.output	message_history.output
message_history__override	OBJECT	message_history.override	message_history.override
message_history__profile	OBJECT	message_history.profile	message_history.profile
message_history__reason	TEXT	message_history.reason	message_history.reason
message_history__reasonCode	TEXT	message_history.reasonCode	message_history.reasonCode
message_history__received_profile	OBJECT	message_history.received_profile	message_history.received_profile
message_history__recipient	TEXT	message_history.recipient	message_history.recipient
message_history__stored_profile	OBJECT	message_history.stored_profile	message_history.stored_profile
message_history__ts	NUMERIC	message_history.ts	message_history.ts
message_history__type	TEXT	message_history.type	message_history.type

Courier message_info fields

The message_info report of the Courier connector includes 19 fields.

ID	Type	Name	Description
message_info__clicked	NUMERIC	message_info.clicked	message_info.clicked
message_info__delivered	NUMERIC	message_info.delivered	message_info.delivered
message_info__enqueued	NUMERIC	message_info.enqueued	message_info.enqueued
message_info__error	TEXT	message_info.error	message_info.error
message_info__event	TEXT	message_info.event	message_info.event
message_info__id	TEXT	message_info.id	message_info.id
message_info__idempotencyKey	TEXT	message_info.idempotencyKey	message_info.idempotencyKey
message_info__listId	TEXT	message_info.listId	message_info.listId
message_info__listMessageId	TEXT	message_info.listMessageId	message_info.listMessageId
message_info__notification	TEXT	message_info.notification	message_info.notification
message_info__opened	NUMERIC	message_info.opened	message_info.opened
message_info__providers	OBJECT	message_info.providers	message_info.providers
message_info__reason	TEXT	message_info.reason	message_info.reason
message_info__reasonCode	TEXT	message_info.reasonCode	message_info.reasonCode
message_info__reasonDetails	TEXT	message_info.reasonDetails	message_info.reasonDetails
message_info__recipient	TEXT	message_info.recipient	message_info.recipient
message_info__runId	TEXT	message_info.runId	message_info.runId
message_info__sent	NUMERIC	message_info.sent	message_info.sent
message_info__status	TEXT	message_info.status	message_info.status

Courier message_output fields

The message_output report of the Courier connector includes 4 fields.

ID	Type	Name	Description
message_output__channel	TEXT	message_output.channel	message_output.channel
message_output__channel_id	TEXT	message_output.channel_id	message_output.channel_id
message_output__content	OBJECT	message_output.content	message_output.content
message_output__message_id	TEXT	message_output.message_id	message_output.message_id

Courier messages fields

The messages report of the Courier connector includes 19 fields.

ID	Type	Name	Description
messages__clicked	NUMERIC	messages.clicked	messages.clicked
messages__delivered	NUMERIC	messages.delivered	messages.delivered
messages__enqueued	NUMERIC	messages.enqueued	messages.enqueued
messages__error	TEXT	messages.error	messages.error
messages__event	TEXT	messages.event	messages.event
messages__id	TEXT	messages.id	messages.id
messages__idempotencyKey	TEXT	messages.idempotencyKey	messages.idempotencyKey
messages__listId	TEXT	messages.listId	messages.listId
messages__listMessageId	TEXT	messages.listMessageId	messages.listMessageId
messages__notification	TEXT	messages.notification	messages.notification
messages__opened	NUMERIC	messages.opened	messages.opened
messages__providers	OBJECT	messages.providers	messages.providers
messages__reason	TEXT	messages.reason	messages.reason
messages__reasonCode	TEXT	messages.reasonCode	messages.reasonCode
messages__reasonDetails	TEXT	messages.reasonDetails	messages.reasonDetails
messages__recipient	TEXT	messages.recipient	messages.recipient
messages__runId	TEXT	messages.runId	messages.runId
messages__sent	NUMERIC	messages.sent	messages.sent
messages__status	TEXT	messages.status	messages.status

Courier other fields

The Courier 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
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

API Connectors