---
schema_version: "1"
id: dab4c8f7cf4668aa431ae6d6533791db61176457f82c04adb7b61b613938641a
title: Tracking Extract
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_tracking_extract.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_tracking_extract.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d2d0856c8b61c07b4ccefe101717ebc17dbdd0f7d40a78802c894bcc309679bd
description: 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.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png)

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

- **[Tracking Extract Configuration in Automation Studio](https://help.salesforce.com/s/articleView?id=mktg.mc_as_tracking_extract_config.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_api_data_extract_options.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_tracking_extract_output.htm&release=264.0.0&type=5)**  
    Tracking extracts output several types of data related to an email send.