Recent pages

Edit
page

New
page

Print
page
Page last modified 09:01, 3 May 2011 by Admin
1
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Interactions > Activities > Data Extract Activity > Extract Types > Tracking Extract > Tracking Extract Output > Subscribers

Subscribers

From $1

    Table of contents
    1. 1. Description
    2. 2. Output Types
    3. 3. Columns
      1. 3.1. ClientID
        1. 3.1.1. Possible Values
        2. 3.1.2. Data Type
        3. 3.1.3. Length
      2. 3.2. SubscriberKey
        1. 3.2.1. Data Type
        2. 3.2.2. Length
      3. 3.3. EmailAddress
        1. 3.3.1. Data Type
        2. 3.3.2. Length
      4. 3.4. SubscriberID
        1. 3.4.1. Data Type
        2. 3.4.2. Length
      5. 3.5. Status
        1. 3.5.1. Data Type
        2. 3.5.2. Length
      6. 3.6. DateHeld
        1. 3.6.1. Data Type
        2. 3.6.2. Length
      7. 3.7. DateCreated
        1. 3.7.1. Data Type
        2. 3.7.2. Length
      8. 3.8. DateUnsubscribed
        1. 3.8.1. Data Type
        2. 3.8.2. Length
      9. 3.9. Schema Relationship

    Description

    The Subscribers file contains subscribers with a tracking event occuring during a specified data range.

    Output Types

    • CSV
    • TAB

    Columns

    ClientID

    Specifies the ExactTarget account identifier associated with attribute set.

    Possible Values

    -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    SubscriberKey

    Identifies the subscriber.  If you do not identify your subscribers with a subscriber key, this value is the same as the email address.

    Data Type

    String

    Length

    100

    EmailAddress

    Specifies the subscriber email address.

    Data Type

    String

    Length

    100

    SubscriberID

    The  ExactTarget-generated subscriber unique identifier for a subscriber.

    SubscriberID relates to the Subscriber's SubscriberID column.

    Data Type

    Number

    Length

    Maximum Number / Big Integer 

    Status

    Contains the status of the subscriber.  Possible values include:

    • Active: Normal
    • Bounced: 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.

    Data Type

    String

    Length

    20

    DateHeld

    The date the subscriber moved to held status.

    Data Type

    datetime

    Length

    Small

    DateCreated

    The date the subscriber was added to the application.

    Data Type

    datetime

    Length

    Small

    DateUnsubscribed

    The date the subscriber moved to unsub status.

    Data Type

    datetime

    Length

    Small

    Schema Relationship

     

    This page was last updated by Josh Cloud on Tue, 03 May 2011 13:01:21 GMT.

    If you're having an application issue, please contact Global Support. To send Josh direct feedback, fill out the form below:

    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 6815 backwards:
       
    Tags: (Edit tags)
    • No tags
    Attach file or image
    Files (1)
    FileSizeDateAttached by 
     subscribers_schema.png
    No description
    		29.67 kB09:23, 24 Jun 2009AdminActions
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin