Recent pages

Edit
page

New
page

Print
page
Page last modified 10:13, 19 May 2011 by Admin
2
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Interactions > Activities > Data Extract Activity > Extract Types > Tracking Extract > Tracking Extract Output > StatusChanges

StatusChanges

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. OldStatus
        1. 3.5.1. Data Type
        2. 3.5.2. Length
      6. 3.6. NewStatus
        1. 3.6.1. Data Type
        2. 3.6.2. Length
      7. 3.7. DateChanged
        1. 3.7.1. Data Type
        2. 3.7.2. Length
      8. 3.8. Schema Relationship

    Description

    The StatusChanges file shows instances of change in a subscriber's status.

    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

    Specifes 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 

    OldStatus

    The old status of the subscriber.  Possible values include:

    • Normal
    • Held
    • Unsub
    • Deleted

    Data Type

    String

    Length

    10

    NewStatus

    The new status of the subscriber.  Possible values include:

    • Normal
    • Held
    • Unsub
    • Deleted

    Data Type

    String

    Length

    10

    DateChanged

    The time and date that the subscriber change occurred.

    Data Type

    datetime

    Length

    Schema Relationship

    sr.png

    This page was last updated by Josh Cloud on Thu, 19 May 2011 14:13:18 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 10340 backwards:
       
    Tags: (Edit tags)
    • No tags
    Attach file or image
    Files (2)
    FileSizeDateAttached by 
     sr.png
    No description
    		61.82 kB10:13, 19 May 2011AdminActions
     statuschange_schema.png
    No description
    		3 kB09:21, 24 Jun 2009AdminActions
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin