Loading
Intermittent Errors with Salesforce Trial Org Registration Read More
Journeys and Automations in Marketing Cloud Engagement
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Tracking Extract

            You are here:

            1. Salesforce Help
            2. Docs
            3. Engagement: Journey Builder and Automation Studio

            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
            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.
             
            Loading
            Salesforce Help | Article