Tracking Extract

Tracking extracts provide granular tracking data for import from Email Studio into external systems. Use tracking extracts to export granular data regarding several different aspects of email send jobs, such as clicks, bounces, and survey data. Then, import that information into an automation or system.

Tracking extracts retrieve data before sends execute. The data includes information on any subscriber listed as undeliverable or excluded by List Detective. You can also schedule tracking extracts via an automation. Tracking extracts also include column heading information.

Use a .zip file extension for the output file when creating a data extract. The application returns tracking extract data in a zip file. The size of that file can vary depending on the amount of activity, the accounts involved, and the types of data requested. The output file's suffix must match.

Name	Description
SendID	Identifier for the associated send. Found in Tracking as JobID.
ClientID	Account identifier. Datasets contain multiple ClientID values when extracting multiple subaccounts.
SubscriberID	Internal subscriber identifier
SubscriberKey	Subscriber identifier, defaults to email address
Email Address	Default unique identifier for a standard account configuration

Primary Key Tables

Attributes
Lists
ListMembership
SendJobs
- ClientID
- SendID
- SubscriberKey
- EventDate
- BatchID
Sent
Subscribers
- SubscriberID
StatusChange

Event Tables

Soft Keys
- ClientID
- SendID
- SubscriberKey
- EventDate
- BatchID
Bounces
Clicks
Conversions
Opens
Surveys
Unsubs

Note Event tables sometimes include duplicate rows due to differences in time by seconds or larger.

Tracking Extract Configuration in Automation Studio
You can create a data extract activity in Automation Studio using the Extract Type dropdown. To specify the data you want to include, configure the tracking extract fields. See the example at the end of this section for a categorization of extraction objects. When you’ve configured it, start your activity to produce results.
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.
Tracking Extract Output
Tracking extracts output several types of data related to an email send.