Recent pages

Edit
page

New
page

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

ListMembershipChanges

From $1

    Table of contents
    1. 1. Description
    2. 2. Output Types
    3. 3. Columns 
      1. 3.1. ClientID
        1. 3.1.1. Data Type
        2. 3.1.2. 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. ListID
        1. 3.5.1. Data Type
        2. 3.5.2. Length
      6. 3.6. ListName
        1. 3.6.1. Data Type
        2. 3.6.2. Length
      7. 3.7. DateJoined
        1. 3.7.1. Data Type
        2. 3.7.2. Length
      8. 3.8. JoinType
        1. 3.8.1. Possible Values
        2. 3.8.2. Data Type
        3. 3.8.3. Length
      9. 3.9. DateUnsubscribed
        1. 3.9.1. Data Type
        2. 3.9.2. Length
      10. 3.10. UnsubscribeReason
        1. 3.10.1. Data Type
        2. 3.10.2. Length
    4. 4. Schema Relationship

    Description

    The ListMembershipChanges file includes rows that contain information on the subscriber, list, and status data change for every event.

    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

    Specifies the customer-specified subscriber unique identifier associated with attribute set. By default, the value is the same as EmailAddress.

    Data Type

    String

    Length

    100

    EmailAddress

    EmailAddress specifies the subscriber email address identifier associated with attribute set.

    Data Type

    String

    Length

    100

    SubscriberID

    The ExactTarget-generated subscriber unique identifier associated with attribute set.

    SubscriberID relates to the Subscriber's SubscriberID column.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    ListID

    ListID is the ExactTarget identified for the list that the job was sent to.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    ListName

    Data Type

    String

    Length

    50

    DateJoined

    Date the subscriber joined the list

    Data Type

    datetime

    Length

    Small

    JoinType

    Specifies the way the subscriber joined the list

    Possible Values

    • API: Joined via the API
    • Application: Joined via UI wizard
    • CustomObject: Joined via a send to a data extension
    • FTAF: Foward to a Friend
    • Import: Joined via an file based import
    • Move/Copy: Result of a move/copy in UI
    • SalesForce: Joined via Salesforce
    • Segmentation: Joined by being segmented onto a list
    • WebCollect: Joined via WebCollect
    • Unspecified: Unspecified join

    Data Type

    String

    Length

    20

    DateUnsubscribed

    The date the subscriber moved to unsub status.

    Data Type

    datetime

    Length

    Small

    UnsubscribeReason

    Data Type

    String

    Length

    100

    Schema Relationship

    listmembershipchanges_schema.png

    This page was last updated on Thu, 19 May 2011 13:36:33 GMT.

    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 21855 backwards:
       

     

    Tags: (Edit tags)
    • No tags
    Attach file or image
    Files (1)
    FileSizeDateAttached by 
     listmembershipchanges_schema.png
    No description
    		5.01 kB09:15, 24 Jun 2009AdminActions
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin