Data Export Specifications
Email Subscriber Data
Email Unsubscribe Data
Email Activity Data
Email Aggregate Data
Exports at 3 A.M. EST, containing all contacts to have ever subscribed to the list (report includes both subscribers and unsubscribers). The initial export may take up to two days to complete. After the initial file has been exported, a new version will be exported each day, where only the changed values will be updated. Each export will include the full set of both current subscribed and unsubscribed contacts. Report also includes lifetime email engagement values for each contact on the specified lists. Exported fields contains lifetime analytics
Available Fields
- EmailAddress – email address of the contact
- CurrentOptInStatus – Current subscription status to the specified list
- OrigionalEmailOptIn – Original date of subscription to the list
- MostRecentEmailOptIn – Most recent Subscribe date to the list
- MostRecentEmailOptOut – Most recent unsubscribe date to the list
- EmailEngagementInL12M - Boolean value; true indicates contact has engaged in last 12 months.
- EngagementsQuantity -
- MessagesSentQuantity – Total lifetime message send count for the contact for the specified list.
- CampaignSentQuantity –
- TriggerSentQuantity -
- OpensQuantity - Total lifetime message open count for the contact for the specified list.
- CampaignOpensQuantity -
- TriggerOpensQuantity -
- ClicksQuantity - Total lifetime message click count for the contact for the specified list.
- CampaignClickQuantity -
- TriggerClicksQuantity -
- LifetimeEmailOpenRate -
- LifetimeEmailClickRate -
- LifetimeCampaignEmailOpenRate -
- LifetimeCampaignEmailClickRate -
- LifetimeTriggerEmailOpenRate -
- LifetimeTriggerEmailClickRate -
- FirstEngagementDate -
- LastEngagementDate -
- FirstSentDate – First sent message date for the contact on the specified list
- LastSentDate – Most recent message send date for the contact on the specified list
- FirstOpenDate – First message opened date by the contact on the specified list
- LastOpenDate - Most recent message open date by the contact on the specified list
- FirstClickDate – Date of first message clicked by contact on the specified list
- LastClickDate - Most recent message click date for the contact on the specified list
.png){kind=icon}
