Windsor brings all your Courier data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Courier Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| message_history__channel | OBJECT | message_history.channel | message_history.channel | message_history |
| message_history__data | OBJECT | message_history.data | message_history.data | message_history |
| message_history__event | TEXT | message_history.event | message_history.event | message_history |
| message_history__event_id | TEXT | message_history.event_id | message_history.event_id | message_history |
| message_history__integration | OBJECT | message_history.integration | message_history.integration | message_history |
| message_history__merged_profile | OBJECT | message_history.merged_profile | message_history.merged_profile | message_history |
| message_history__message_id | TEXT | message_history.message_id | message_history.message_id | message_history |
| message_history__notification_id | TEXT | message_history.notification_id | message_history.notification_id | message_history |
| message_history__output | OBJECT | message_history.output | message_history.output | message_history |
| message_history__override | OBJECT | message_history.override | message_history.override | message_history |
| message_history__profile | OBJECT | message_history.profile | message_history.profile | message_history |
| message_history__reason | TEXT | message_history.reason | message_history.reason | message_history |
| message_history__reasonCode | TEXT | message_history.reasonCode | message_history.reasonCode | message_history |
| message_history__received_profile | OBJECT | message_history.received_profile | message_history.received_profile | message_history |
| message_history__recipient | TEXT | message_history.recipient | message_history.recipient | message_history |
| message_history__stored_profile | OBJECT | message_history.stored_profile | message_history.stored_profile | message_history |
| message_history__ts | NUMERIC | message_history.ts | message_history.ts | message_history |
| message_history__type | TEXT | message_history.type | message_history.type | message_history |
| message_info__clicked | NUMERIC | message_info.clicked | message_info.clicked | message_info |
| message_info__delivered | NUMERIC | message_info.delivered | message_info.delivered | message_info |
| message_info__enqueued | NUMERIC | message_info.enqueued | message_info.enqueued | message_info |
| message_info__error | TEXT | message_info.error | message_info.error | message_info |
| message_info__event | TEXT | message_info.event | message_info.event | message_info |
| message_info__id | TEXT | message_info.id | message_info.id | message_info |
| message_info__idempotencyKey | TEXT | message_info.idempotencyKey | message_info.idempotencyKey | message_info |
| message_info__listId | TEXT | message_info.listId | message_info.listId | message_info |
| message_info__listMessageId | TEXT | message_info.listMessageId | message_info.listMessageId | message_info |
| message_info__notification | TEXT | message_info.notification | message_info.notification | message_info |
| message_info__opened | NUMERIC | message_info.opened | message_info.opened | message_info |
| message_info__providers | OBJECT | message_info.providers | message_info.providers | message_info |
| message_info__reason | TEXT | message_info.reason | message_info.reason | message_info |
| message_info__reasonCode | TEXT | message_info.reasonCode | message_info.reasonCode | message_info |
| message_info__reasonDetails | TEXT | message_info.reasonDetails | message_info.reasonDetails | message_info |
| message_info__recipient | TEXT | message_info.recipient | message_info.recipient | message_info |
| message_info__runId | TEXT | message_info.runId | message_info.runId | message_info |
| message_info__sent | NUMERIC | message_info.sent | message_info.sent | message_info |
| message_info__status | TEXT | message_info.status | message_info.status | message_info |
| message_output__channel | TEXT | message_output.channel | message_output.channel | message_output |
| message_output__channel_id | TEXT | message_output.channel_id | message_output.channel_id | message_output |
| message_output__content | OBJECT | message_output.content | message_output.content | message_output |
| message_output__message_id | TEXT | message_output.message_id | message_output.message_id | message_output |
| messages__clicked | NUMERIC | messages.clicked | messages.clicked | messages |
| messages__delivered | NUMERIC | messages.delivered | messages.delivered | messages |
| messages__enqueued | NUMERIC | messages.enqueued | messages.enqueued | messages |
| messages__error | TEXT | messages.error | messages.error | messages |
| messages__event | TEXT | messages.event | messages.event | messages |
| messages__id | TEXT | messages.id | messages.id | messages |
| messages__idempotencyKey | TEXT | messages.idempotencyKey | messages.idempotencyKey | messages |
| messages__listId | TEXT | messages.listId | messages.listId | messages |
| messages__listMessageId | TEXT | messages.listMessageId | messages.listMessageId | messages |
| messages__notification | TEXT | messages.notification | messages.notification | messages |
| messages__opened | NUMERIC | messages.opened | messages.opened | messages |
| messages__providers | OBJECT | messages.providers | messages.providers | messages |
| messages__reason | TEXT | messages.reason | messages.reason | messages |
| messages__reasonCode | TEXT | messages.reasonCode | messages.reasonCode | messages |
| messages__reasonDetails | TEXT | messages.reasonDetails | messages.reasonDetails | messages |
| messages__recipient | TEXT | messages.recipient | messages.recipient | messages |
| messages__runId | TEXT | messages.runId | messages.runId | messages |
| messages__sent | NUMERIC | messages.sent | messages.sent | messages |
| messages__status | TEXT | messages.status | messages.status | messages |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |