Windsor brings all your Mailjet Email data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Mailjet Email Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| campaign__CampaignType | NUMERIC | campaign.CampaignType | campaign.CampaignType | campaign |
| campaign__ClickTracked | NUMERIC | campaign.ClickTracked | campaign.ClickTracked | campaign |
| campaign__CreatedAt | TEXT | campaign.CreatedAt | campaign.CreatedAt | campaign |
| campaign__CustomValue | TEXT | campaign.CustomValue | campaign.CustomValue | campaign |
| campaign__FirstMessageID | NUMERIC | campaign.FirstMessageID | campaign.FirstMessageID | campaign |
| campaign__FromEmail | TEXT | campaign.FromEmail | campaign.FromEmail | campaign |
| campaign__FromID | NUMERIC | campaign.FromID | campaign.FromID | campaign |
| campaign__FromName | TEXT | campaign.FromName | campaign.FromName | campaign |
| campaign__HasHtmlCount | NUMERIC | campaign.HasHtmlCount | campaign.HasHtmlCount | campaign |
| campaign__HasTxtCount | NUMERIC | campaign.HasTxtCount | campaign.HasTxtCount | campaign |
| campaign__ID | NUMERIC | campaign.ID | campaign.ID | campaign |
| campaign__IsDeleted | BOOLEAN | campaign.IsDeleted | campaign.IsDeleted | campaign |
| campaign__IsStarred | BOOLEAN | campaign.IsStarred | campaign.IsStarred | campaign |
| campaign__ListID | NUMERIC | campaign.ListID | campaign.ListID | campaign |
| campaign__NewsLetterID | NUMERIC | campaign.NewsLetterID | campaign.NewsLetterID | campaign |
| campaign__OpenTracked | NUMERIC | campaign.OpenTracked | campaign.OpenTracked | campaign |
| campaign__SendEndAt | TEXT | campaign.SendEndAt | campaign.SendEndAt | campaign |
| campaign__SendStartAt | TEXT | campaign.SendStartAt | campaign.SendStartAt | campaign |
| campaign__SpamassScore | NUMERIC | campaign.SpamassScore | campaign.SpamassScore | campaign |
| campaign__Status | NUMERIC | campaign.Status | campaign.Status | campaign |
| campaign__Subject | TEXT | campaign.Subject | campaign.Subject | campaign |
| campaign__UnsubscribeTrackedCount | NUMERIC | campaign.UnsubscribeTrackedCount | campaign.UnsubscribeTrackedCount | campaign |
| contacts__CreatedAt | TEXT | contacts.CreatedAt | contacts.CreatedAt | contacts |
| contacts__DeliveredCount | NUMERIC | contacts.DeliveredCount | contacts.DeliveredCount | contacts |
| contacts__Email | TEXT | contacts.Email | contacts.Email | contacts |
| contacts__ExclusionFromCampaignsUpdatedAt | DATE | contacts.ExclusionFromCampaignsUpdatedAt | contacts.ExclusionFromCampaignsUpdatedAt | contacts |
| contacts__ID | NUMERIC | contacts.ID | contacts.ID | contacts |
| contacts__IsExcludedFromCampaigns | BOOLEAN | contacts.IsExcludedFromCampaigns | contacts.IsExcludedFromCampaigns | contacts |
| contacts__IsOptInPending | BOOLEAN | contacts.IsOptInPending | contacts.IsOptInPending | contacts |
| contacts__IsSpamComplaining | BOOLEAN | contacts.IsSpamComplaining | contacts.IsSpamComplaining | contacts |
| contacts__LastActivityAt | DATE | contacts.LastActivityAt | contacts.LastActivityAt | contacts |
| contacts__LastUpdateAt | DATE | contacts.LastUpdateAt | contacts.LastUpdateAt | contacts |
| contacts__Name | TEXT | contacts.Name | contacts.Name | contacts |
| contacts__UnsubscribedAt | TEXT | contacts.UnsubscribedAt | contacts.UnsubscribedAt | contacts |
| contacts__UnsubscribedBy | TEXT | contacts.UnsubscribedBy | contacts.UnsubscribedBy | contacts |
| contactslist__Address | TEXT | contactslist.Address | contactslist.Address | contactslist |
| contactslist__CreatedAt | TEXT | contactslist.CreatedAt | contactslist.CreatedAt | contactslist |
| contactslist__ID | NUMERIC | contactslist.ID | contactslist.ID | contactslist |
| contactslist__IsDeleted | BOOLEAN | contactslist.IsDeleted | contactslist.IsDeleted | contactslist |
| contactslist__Name | TEXT | contactslist.Name | contactslist.Name | contactslist |
| contactslist__SubscriberCount | NUMERIC | contactslist.SubscriberCount | contactslist.SubscriberCount | contactslist |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| listrecipient__ContactID | NUMERIC | listrecipient.ContactID | listrecipient.ContactID | listrecipient |
| listrecipient__ID | NUMERIC | listrecipient.ID | listrecipient.ID | listrecipient |
| listrecipient__IsActive | BOOLEAN | listrecipient.IsActive | listrecipient.IsActive | listrecipient |
| listrecipient__IsUnsubscribed | BOOLEAN | listrecipient.IsUnsubscribed | listrecipient.IsUnsubscribed | listrecipient |
| listrecipient__ListID | NUMERIC | listrecipient.ListID | listrecipient.ListID | listrecipient |
| listrecipient__ListName | TEXT | listrecipient.ListName | listrecipient.ListName | listrecipient |
| listrecipient__SubscribedAt | TEXT | listrecipient.SubscribedAt | listrecipient.SubscribedAt | listrecipient |
| listrecipient__UnsubscribedAt | TEXT | listrecipient.UnsubscribedAt | listrecipient.UnsubscribedAt | listrecipient |
| message__ArrivedAt | TEXT | message.ArrivedAt | message.ArrivedAt | message |
| message__AttachmentCount | NUMERIC | message.AttachmentCount | message.AttachmentCount | message |
| message__AttemptCount | NUMERIC | message.AttemptCount | message.AttemptCount | message |
| message__CampaignID | NUMERIC | message.CampaignID | message.CampaignID | message |
| message__ContactAlt | TEXT | message.ContactAlt | message.ContactAlt | message |
| message__ContactID | NUMERIC | message.ContactID | message.ContactID | message |
| message__Delay | NUMERIC | message.Delay | message.Delay | message |
| message__DestinationID | NUMERIC | message.DestinationID | message.DestinationID | message |
| message__FilterTime | NUMERIC | message.FilterTime | message.FilterTime | message |
| message__ID | NUMERIC | message.ID | message.ID | message |
| message__IsClickTracked | BOOLEAN | message.IsClickTracked | message.IsClickTracked | message |
| message__IsHTMLPartIncluded | BOOLEAN | message.IsHTMLPartIncluded | message.IsHTMLPartIncluded | message |
| message__IsOpenTracked | BOOLEAN | message.IsOpenTracked | message.IsOpenTracked | message |
| message__IsTextPartIncluded | BOOLEAN | message.IsTextPartIncluded | message.IsTextPartIncluded | message |
| message__IsUnsubTracked | BOOLEAN | message.IsUnsubTracked | message.IsUnsubTracked | message |
| message__MessageSize | NUMERIC | message.MessageSize | message.MessageSize | message |
| message__SenderID | NUMERIC | message.SenderID | message.SenderID | message |
| message__SpamassRules | TEXT | message.SpamassRules | message.SpamassRules | message |
| message__SpamassassinScore | NUMERIC | message.SpamassassinScore | message.SpamassassinScore | message |
| message__StatePermanent | BOOLEAN | message.StatePermanent | message.StatePermanent | message |
| message__Status | TEXT | message.Status | message.Status | message |
| message__Subject | TEXT | message.Subject | message.Subject | message |
| message__UUID | TEXT | message.UUID | message.UUID | message |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| stats_api_lifetime_message__APIKeyID | NUMERIC | stats_api_lifetime_message.APIKeyID | stats_api_lifetime_message.APIKeyID | stats_api_lifetime_message |
| stats_api_lifetime_message__EventClickDelay | NUMERIC | stats_api_lifetime_message.EventClickDelay | stats_api_lifetime_message.EventClickDelay | stats_api_lifetime_message |
| stats_api_lifetime_message__EventClickedCount | NUMERIC | stats_api_lifetime_message.EventClickedCount | stats_api_lifetime_message.EventClickedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__EventOpenDelay | NUMERIC | stats_api_lifetime_message.EventOpenDelay | stats_api_lifetime_message.EventOpenDelay | stats_api_lifetime_message |
| stats_api_lifetime_message__EventOpenedCount | NUMERIC | stats_api_lifetime_message.EventOpenedCount | stats_api_lifetime_message.EventOpenedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__EventSpamCount | NUMERIC | stats_api_lifetime_message.EventSpamCount | stats_api_lifetime_message.EventSpamCount | stats_api_lifetime_message |
| stats_api_lifetime_message__EventUnsubscribedCount | NUMERIC | stats_api_lifetime_message.EventUnsubscribedCount | stats_api_lifetime_message.EventUnsubscribedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__EventWorkflowExitedCount | NUMERIC | stats_api_lifetime_message.EventWorkflowExitedCount | stats_api_lifetime_message.EventWorkflowExitedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageBlockedCount | NUMERIC | stats_api_lifetime_message.MessageBlockedCount | stats_api_lifetime_message.MessageBlockedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageClickedCount | NUMERIC | stats_api_lifetime_message.MessageClickedCount | stats_api_lifetime_message.MessageClickedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageDeferredCount | NUMERIC | stats_api_lifetime_message.MessageDeferredCount | stats_api_lifetime_message.MessageDeferredCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageHardBouncedCount | NUMERIC | stats_api_lifetime_message.MessageHardBouncedCount | stats_api_lifetime_message.MessageHardBouncedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageOpenedCount | NUMERIC | stats_api_lifetime_message.MessageOpenedCount | stats_api_lifetime_message.MessageOpenedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageQueuedCount | NUMERIC | stats_api_lifetime_message.MessageQueuedCount | stats_api_lifetime_message.MessageQueuedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageSentCount | NUMERIC | stats_api_lifetime_message.MessageSentCount | stats_api_lifetime_message.MessageSentCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageSoftBouncedCount | NUMERIC | stats_api_lifetime_message.MessageSoftBouncedCount | stats_api_lifetime_message.MessageSoftBouncedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageSpamCount | NUMERIC | stats_api_lifetime_message.MessageSpamCount | stats_api_lifetime_message.MessageSpamCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageUnsubscribedCount | NUMERIC | stats_api_lifetime_message.MessageUnsubscribedCount | stats_api_lifetime_message.MessageUnsubscribedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__MessageWorkFlowExitedCount | NUMERIC | stats_api_lifetime_message.MessageWorkFlowExitedCount | stats_api_lifetime_message.MessageWorkFlowExitedCount | stats_api_lifetime_message |
| stats_api_lifetime_message__SourceID | NUMERIC | stats_api_lifetime_message.SourceID | stats_api_lifetime_message.SourceID | stats_api_lifetime_message |
| stats_api_lifetime_message__Timeslice | TEXT | stats_api_lifetime_message.Timeslice | stats_api_lifetime_message.Timeslice | stats_api_lifetime_message |
| stats_api_lifetime_message__Total | NUMERIC | stats_api_lifetime_message.Total | stats_api_lifetime_message.Total | stats_api_lifetime_message |
| today | DATE | Today | Today's date |