To better organize Email Studio data extracts, use these categories for your SQL database. You can retrieve up to 6 months of data.
Output File Options
- OutputFileName
- Format
- FileFormat
- QuoteText
- TextQualifier
- ColumnDelimiter
- UnicodeOutput
- CharacterEncoding
Notifications
- NotificationEmail
Date Options
- StartDate
- EndDate
- Timezone
- UseLocalTZinQuerypublic
- IncludeMilliseconds
Qualifiers
- AccountIDs
- Attributes
- SendIDs
- EmailSendDefinitionExternalKey
Subscribers
- ExtractSubscribers
- IncludeAllSubscribers
- ExtractAttributes
- extractStatusChanges
Send Job
- ExtractSendJobs
- ExtractSendJobImpressions
Sent
- ExtractSent
- ExtractNotSent
- ExtractSendData
- ExtractSendImpressions
- IncludeTestSends
- IncludeCampaignID
Opens
- ExtractOpens
- IncludeUniqueOpens
- IncludeInferredOpens
- IncludeGEO
- IncludeUserAgentInformation
Clicks
- ExtractClicks
- ExtractClickImpressions
- IncludeUniqueClicks
- IncludeUniqueForURLClicks
Bounces
- ExtractBounces
Unsubscribes
- ExtractUnsubs
- IncludeUnsubReason
- ExtractSpamComplaints
Lists and Data Extensions
- extractListMembershipChanges
- extractLists
- IncludeAllListMembers
- ExtractMultipleDataExtensionListData
Conversions and Surveys
- ExtractConversions
- ExtractSurveyResponses