Recent pages

Edit
page

New
page

Print
page
Page last modified 10:16, 24 Aug 2011 by Admin
0
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Tracking > Data Extract

Data Extract

From $1

    This document contains conceptual and procedural information that you can use for understanding data extract.

    The data extract feature gives you the ability to export tracking information from the ExactTarget database.

    What Is Data Extract

    Data extract is a feature you can use to export your tracking information from the application database. The application exports the data to a CSV file, compresses the data into a ZIP file, and makes the file available to you on the enhanced FTP server. The application also provides a UTF-16 to ASCII conversion package.

    The scope of the data that appears in the CSV report is limited either to the events related to a group of subscribers that you specify or the events related to a send. If you extract data for a list of subscribers, you must provide a CSV file that contains the subscribers for which to extract the data. If you extract data for a send, you select one or more sends when you define the extract information.

    You also limit the scope of the data to events that occur within a date range. For example, you could extract data on clicks that occurred between June 10 and June 15 for a send that occurred on June 1.

    When you define a data extract, you choose the events you want to extract. The application creates a separate CSV file for each event and includes them together in the ZIP file. The following sections describe the content of each file:

    Two files are included in the ZIP file to provide the detail you need to act on the Sends and Subscribers referenced in the other extract files. The following sections describe the content of each file:

    When you define a data extract, you choose the subscriber attributes that appear in the CSV file for each event. For example, you could extract the Full Name for each subscriber who clicked a link related to an email send.

    What Is a Bounce Event Extract File

    A bounce event extract file shows all of the hard and soft bounces that occurred during the date range. The events in this report can be related to all sends for subscribers on a list or related to a particular send.

    The Bounce Event Extract File contains the following information:

    Column Format Description
    SendID Integer Identifies the send that resulted in the bounce event.
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers with a subscriber key, this value is the same as the email address.
    EventDate Short Date Time The date the bounce event occurred.
    EventType String (6) Identifies the event type. For this extract file, this field contains Bounce.
    BounceCategory Integer

    Identifies the bounce type. Valid values include:

    • HardBounce
    • SoftBounce
    • OtherBounce
    SMTP Code Short Integer The SMTP code related to the bounce. Valid values available at this location: http://www.greenend.org.uk/rjk/2000/05/21/smtp-replies.html
    SMTP Reason Text The detailed reason for the bounce

    What Is a Click Event Extract File

    A click event extract file shows all of the instances of a link in an email being clicked that occurred during the date range. The events in this report can be related to all sends for subscribers on a list or related to a particular send.

    The Click Event Extract File contains the following information:

    Column Format Description
    SendID Integer Identifies the send related to the click
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers with a subscriber key, this value is the same as the email address.
    EventDate Short Date Time The date the click occurred.
    EventType String (6) Identifies the event type. For this extract file, this field contains Click.
    BatchID Long Integer (64) Identifies the batch associated with a triggered email send event, if the link that was clicked appeared in a batched triggered email.
    URLID Integer Contains a value used by the application database to identify the target URL of the link.
    URL String (8000) Contains the target URL of the link.
    Alias String (500) Contains the value in the Alias attribute of the link.

    What Is a Conversions Event Extract File

    A conversions event extract file shows all of the conversions that occurred during the date range. The events in this report can be related to all sends for subscribers on a list or related to a particular send. This file is available only if you have conversion tracking enabled on your account.

    The Conversion Event Extract File contains the following information:

    Column Format Description
    SendID Integer Identifies the send related to the conversion
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers with a subscriber key, this value is th same as the email address.
    EventDate Short Date Time The date the conversion occurred.
    EventType String (6) Identifies the event type. For this extract file, this field contains Conversion.
    ReferringURL String (8000) Identifies the URL that originated the conversion event.
    LinkAlias String (100) Contains the value of the Alias attribute of the link that originated the conversion event
    ConversionData String (8000) An XML string that contains transaction data about the conversion.
    BatchID Long Integer (64) Identifies the batch associated with a triggered email send event, if the link that originated the conversion event appeared in a batched triggered email.

    What Is an Open Event Extract File

    An Open event extract file shows instances of an HTML email being opened that occurred during the date range. The open events can be related to all sends for subscribers on a list or to a particular send.

    The Open Event Extract File contains the following information:

    Column Format Description
    SendID Integer Identifies the send related to the open.
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers with a subscriber key, this value is the same as the email address.
    EventDate Short Date Time The date the open occurred.
    EventType String (10) Identifies the event type. For this extract file, this field contains Open.
    BatchID Long Integer (64-bit) Identifies the batch associated with a triggered email send event, if the email message was a batched triggered email.

    What Is a Sent Event Extract File

    A Sent event extract file shows instances an email being sent that occurred during a date range that you specify. The sent events can be related to all sends for subscribers on a list or to a particular send.

    kThe Sent Event Extract File contains the following information:

    Column Format Description
    Send ID

    Integer

    		 Identifies the associated send.
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers witha  subscriber key, this value is the same as the email address.
    EventDate Short DateTime The date the sent event occurred.
    EventType String (10) Identifies the event type. For this extract file, thsi field contains Sent.
    BatchID Long Integer (64) Identifies the batch associated with a triggered email sent event, if the email message was a batched triggered email.

    What Is a Survey Response Event Extract File

    A Survey Response event extract file shows surveys that were completed during the date range that you specify by subscriber for a send.

    The Subscriber Extract File contains the following information:

    Column Format Description
    SendID Integer Identifies the associated send.
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers with a subscriber key, this value is the same as the email address.
    EventDate Short DateTime The date the survey event occurred.
    EventType String (11) Identifies the event type. For this extract file, this field contains Survey.
    Question String (8000) Contains the survey question.
    Answer String (8000) Contains the survey answer. Answers not chosen are also included for radio button and checkbox groups.
    BatchID Long Integer (64) Identifies the batch associated with a triggered email that contained the survey, if the email message was a batched triggered email.

    What Is an Unsubscribe Event Extract File

    An Unsubscribe event extract file shows instances of subscriber unsubscribing that occurred during a date range that you specify. The unsubscribe events can be related to all sends for subscribers on a list or to a particular send.

    The Unsubscribe Event Extract File contains the following information:

    Column Format Description
    SendID Integer Identifies the associated send
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers with a subscriber key, this value is the same as the email address.
    EventDate Short DateTime The date the unsubscribe occurred.
    EventType String (11) Identifies the event type. For this extract file, this field contains Unsubscribe.
    BatchID Long Integer (64) Identifies the batch associated with a triggered email unsubscribe event, if the email message was a batched triggered email.

    What Is a Send Extract File

    A Send extract file shows email sends that appear in the extract files that you requested. This file is included automatically when you extract data to provide actionable information for the SendID values referenced in other files.

    The Send Extract File contains the following information:

    Column Format Description
    SendID Integer Identifies the send.
    FromName String (130) Contains the from name associated with the send. For On Your Behalf sends, this value is the ChannelMember replacement strings.
    FromEmail String (100) Contains the from email associated with the send. For On Your Behalf sends, this value is the ChannelMember replacement strings.
    SchedTime Short DateTime Contains the schedules date and time for the send.
    SendDate Short DateTime Contains the message delivery date and time to the ExactTarget MTAs
    Subject String (200) Contains the subject line of the email associated with the send.
    EmailName String (100) Contains the name of the email associated with the send.

    What Is a Subscriber Extract File

    A Subscriber extract file shows subscribers that appear in the extract files that you requested. This file is included automatically when you extract data to provide actionable information for the SubscriberKey values referenced in other files.

    The Subscriber Extract File contains the following information:

    Column Format Description
    SubscriberKey String (100) Identifies the subscriber. If you do not identify your subscribers with a subscriber key, this value is the same as the email address.
    ID Long Integer (64) Contains the ExactTarget ID of the subscriber.
    Email String (100) Contains the email address of the subscriber
    Status String (8)

    Contains the status of the subscriber. Valid values include:

    • Active - Normal
    • Bounce - Message attempts have bounced but the subscriber does not qualify as Held.
    • Held - Three or more sequential message attempts have bounced and the first and last sequential bounces were more than 14 days apart.
    • Unsub - Subscriber has unsubscribed from the message send.
    Additional Attributes Varchar (200) Contains attributes specific to an account. one or more of these columns may appear and can be conditionally retrieved.

    Why Use Data Extract

    Use data extract to export tracking data about sends or subscriber lists from the application database. You can use the extracted data to compare the performance of sends or lists.

    How to Extract Send-Based Tracking Data

    Use the following steps to extract data related to a particular send from the application database.

    1. Click the Tracking tab on the navigation bar.
    2. Click my data.
      The my data workspace appears.
    3. Click Send-based Tracking Data.
    4. Enter the date range that contains the date when the desired send occurred and click the Filter button.
      The date range can be no greater than 31 days. Sends that occurred during the specified range appear in the grid.
    5. Click the checkbox next to one or more sends for which to extract data.
    6. Enter the date range that contains the date when the desired events occurred. This range does not necessarily contain the date of the sends.
    7. Click the checkboxes next to the events for which to extract data in the Events section.
    8. Click the checkboxes next to the subscriber attributes to include in the extract data in the Subscriber Attributes section.
    9. Complete the information in the Delivery section:
      File Name Enter the file name ZIP file to contain all of the data extract CSV files. The system delivers the extract data to the enhanced FTP server with this filename with the ZIP extension appended.
      Send Confirmation to Enter the email address to which the system should send confirmation that the extract file is available.
    10. Click Save.
      If you configured the data extract correctly, you'll see a confirmation page.

    How to Extract Subscriber-Based Tracking Data

    Before you perform this procedure, you need a CSV file that contains the list of subscribers for which to run the report. Use the following steps to extract data related to a group of subscribers that you specify.

    1. Click the Tracking tab on the navigation bar.
    2. Click my data.
      The my data workspace appears.
    3. Click Subscriber-based Tracking Data.
    4. Select the CSV file that contains the subscribers for which to extract data.
    5. Enter the date range that contains the date when the desired events occurred. This range does not necessary contain the date of the sends.
    6. Click the checkboxes next to the events for which to extract data in the Events section.
    7. Click the checkboxes next to the subscriber attributes to include in the extract data in the Subscriber Attributes section.
    8. Complete the information in the Delivery section:
      File Name Enter the file name ZIP file to contain all of the data extract CSV files. The system delivers the extract data to the enhanced FTP server with this filename with the ZIP extension appended
      Send Confirmation to Enter the email address to which the system should send confirmation that the extract file is available.
    9. Click Save.
      If you configured the data extract correctly, you'll see a confirmation page. 

    This page was last updated by Adam Evans on Wed, 24 Aug 2011 14:16:10 GMT.

    If you require assistance with the ExactTarget application, please contact Global Support. If you wish to send Adam direct feedback, fill out the form below:

    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 9870 backwards:
       
    Tags: (Edit tags)
    • No tags
    Attach file or image
    Files (0)
     
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin