You are here:
Extract Outputs Reference
This table describes the outputs available for the Tracking Extract extract type.
Note Extract types must be provisioned for your account. Contact your Marketing
Cloud representative for more information.
Data extracts with Include options selected provide that data within one of the compressed files produced by the activity. For example, if you create an extract that includes Extract Clicks, then select Include Unique Clicks, the unique clicks data appears in the Clicks file produced by the process. The activity does not produce a separate file labeled Unique Clicks.
Note Each extract output type produces a single file within the
zipped file. Each data extract labeled Include appears within an extract file within
the zipped file.
| Tracking Extract Output | Description |
|---|---|
| Extract Attributes | Contains the attributes associated with subscribers in an account. The system only outputs data for subscribers who received one of these events over the specified extract range: Bounce, Click, Forward To A Friend, Open, Send, Survey, Unsubscribe. |
| ExtractBounces | Shows all hard and soft bounces occurring within a specified date range. The events in this report can relate to all sends for subscribers on a list, or to a particular send. |
| ExtractClickImpressions | Shows all of instances of link clicks in an email occurring within the specified date range. The file also includes the impression region name associated with the click event. The events in this report can relate to all sends for subscribers on a list, or to a particular send. |
| ExtractClicks | Shows all instances of a link in an email being clicked occurring within the specified date range. The events in this report can relate to all sends for subscribers on a list, or to a particular send. |
| ExtractConversions | Contains a row for each conversion event associated to a subscriber related to an email send job. |
| ExtractListMembershipChanges | Includes rows that contain information on the subscriber, list, and status data change for every event. |
| ExtractLists | Contains rows including name, description, and other information for a unique list. |
| ExtractNotSent | Contains information on send jobs and messages that were not sent. |
| ExtractOpens | Shows instances of an HTML email being opened that occurred during the date range. The open events in this report can relate to all sends for subscribers on a list, or to a particular send. |
| ExtractSendJobImpressions | Shows all impression tracking information from sendswith logged activity for the extract timeframe. This list reflects only jobs that have already processed. Sends scheduled for the future do not appear in this list. |
| Extract SendJobs | Shows all sends that have activity logged against them for the extract timeframe. Only jobs that have already processed are included. Sends scheduled for the future do not appear in this list. |
| Extract Sent | Shows instances of an email being sent occurring during a specified date range. The send events in this report can relate to all sends for subscribers on a list, or to a particular send. |
| Extract SentImpression | Shows instances of an email being sent occurring during a specified date range. The file also includes the impression region name associated with the click event. The send events in this report can relate to all sends for subscribers on a list, or to a particular send. |
| Extract Spam Complaints | Shows subscriber, list, and domain data, including sendID and date, for subscribers who received an email and report it as spam. |
| Extract StatusChanges | Shows instances of change in a subscriber's status. |
| Extract Subscribers | Contains subscribers with a tracking event occurring during a specified data range. |
| Extract SurveyResponses | Contains information on responses to surveys included in email sends. |
| Extract Unsubs | Includes information on unsubscriptions during a specified date range. The unsubscribe events in this report can relate to all sends for subscribers on a list, or to a particular send. |
These tracking extract options are available in addition to each tracking extract's output. Data extracts with Include options selected provide that data within one of the compressed files produced by the activity.
| "Includes" Option | Description |
|---|---|
| Include All Subscribers | Include all subscribers in the Subscribers file of the tracking extract. If unchecked, the extract only includes subscribers with activity corresponding to the events you select to include in the extract. |
| Include GEO | Include geolocation data Note If you purchased a Sender
Authentication Package (SAP) through Salesforce, your Marketing
Cloud org doesn't populate geolocation data. |
| Include Milliseconds | Include timestamps that display time up to the millisecond |
| Include Unique Clicks | Includes a count of the first time a single subscriber clicks any link in an email. If the same subscriber returns to the email and clicks again, that does not count as a unique click. Include Unique Clicks measures how many people clicked within the email as opposed to how many total clicks occurred. |
| Include Unique Opens | Includes a count of the first time a single subscriber opens an email, measuring how many unique subscribers opened the email. |
| Include User Agent Information | Include user agent data related to the open or click to see, for example, Operating System, Email Client, Browser, or Device information. |
| Include All List Members | Include all list members in the tracking extract. If unselected, the extract only includes list members with activity during the specified time. |
| Include Campaign ID | Include the Campaign ID of the campaign each subscriber is part of. |
| Include Inferred Opens | Include all inferred opens, or clicks an email without a recorded open. If unselected, the extract only includes specific opens where the email was clicked and rendered. |
| Include Test Sends | Include test sends in send totals. |
| Include Unique For URL Clicks | Include a count of the first time each link within an email is clicked. If there are three separate URLs included in the email, a single subscriber could have up to three separate unique clicks. |
| Include Unsub Reason | Include the user-specified Unsubscribe Reason, including custom Unsubscribe Reasons if applicable. |
| Quote Text | Surround all text with double quotation marks. This parameter replaces existing double quotes in the tracking extract with two single quotation marks. |
| Unicode Output | Save the extract in UTF-16 format instead of ASCII. |
| Use Local TZ in Query | Show timestamps in the output file in the local timezone. |
Did this article solve your issue?
Let us know so we can improve!
