---
schema_version: "1"
id: 2f9a7fdbc1b1057368e70378f35c71648493356f65744e3ec496eba383dabaef
title: API Data Extract Options
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_api_data_extract_options.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_api_data_extract_options.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bd60144a88a6dcadc2e0339ec3e4e7033b9772f797e51b367c1d87f099d432a4
description: To better organize Email Studio data extracts, use these categories for your SQL database. You can retrieve up to 6 months of data.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# API Data Extract Options

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