Configure a Tracking Extract

Use tracking extracts to output data related to an email send in Email Studio.

1. In a data extract activity, select the Tracking Extract extract type.
2. Specify the range of time to include in the tracking extract.
   • To update the range of dates each time the tracking extract runs, select Rolling Range and choose 1, 7, 30, 60, or 90 days.
   • To run the tracking extract on specific dates, select Specific Range and enter the start and end dates. You can select up to 30 days.
3. Enter the accounts used to extract tracking information.
   • To extract information from the account running the extract, leave the field blank.
   • To extract information from all accounts and subaccounts in an Enterprise account, enter an asterisk.
   • To extract information from multiple accounts with an Enterprise account, enter a comma-delimited list of account ID numbers, including the parent EID.
4. Enter the accounts for which you want to include the Attributes file if ExtractAttributes is enabled for your account.
   • To return no attributes, leave the field blank.
   • To return specific attributes for the selected accounts, enter a comma-delimited list of attribute names. If the attribute doesn’t exist for an account or subaccount, this action returns no attributes.
5. Enter an email send definition external key to filter data from a specific send.
6. Select the outputs to include.
   • Attributes
   • Bounces
   • ClickImpressions
   • Clicks
   • Conversions
   • ListMembershipChanges
   • Lists
   • NotSent
   • Opens
   • SendJobImpressions
   • SendJobs
   • Sent
   • SentImpression
   • StatusChanges
   • Subscribers
   • SurveyResponses
   • Unsubs
7. Choose the extract range.
   A blank field uses the date range associated with the tracking extract. Previous Month overrides any other information and creates the tracking extract from the previous month's data.
8. Enter the format in which you want the tracking extract to be created.
   • CSV returns a comma-delimited file. The tracking extract defaults to this value.
   • Tab returns a tab-delimited file.
   • XML returns an XML file where supported.

   

   Note Review Tracking Extract Output to determine if XML is a valid option.

   

   Note Don’t use .txt to indicate a tab-delimited file. Although .txt is the file extension for a tab-delimited file, entering txt as the format can cause errors.
9. Select IncludeAllListMembers to include all list members in the tracking extract.
   To include only list members with activity during the specified period, don’t select IncludeAllListMembers.
10. Select IncludeAllSubscribers to include all subscribers in the tracking extract’s Subscribers file.
    To include only subscribers with activity corresponding to the events included in the extract, don’t select IncludeAllSubscribers.
11. Select IncludeInferredOpens to include inferred opens, which are clicks in an email without a recorded open.
    To include only opens where the email was clicked and rendered, don’t select IncludeInferredOpens.
12. Select Include User Agent Information to include user agent data related to the open or click, such as operating system, email client, browser, or device.
13. Select QuoteText to surround text with double quotation marks.
    This process replaces existing double quotes in the tracking extract by two single quotation marks.
14. To filter the tracking extract, enter a comma-delimited list of SendIDs.
    If you specify the external key of an email send definition in the extract, the extract includes information from all SendIDs and the email send definition.
15. Enter a character to use as a text qualifier.
    The default value is a double quotation mark.
16. To save the extract in UTF-16 format instead of ASCII, select UnicodeOutput.
17. Save the activity.