Recent pages

Edit
page

New
page

Print
page
Page last modified 14:27, 31 Jan 2012 by Admin
0
Page Notifications Off
Documentation Wiki > ExactTarget > Interactions > Activities > Query Activity > Data View: EnterpriseAttribute

Data View: EnterpriseAttribute

From $1

    Table of contents
    1. 1. Columns  

    This job-related view contains the subscribers in your Enterprise account and their statuses. Use the following _Subscribers data view with the Query Activity. For Enterprise 2.0, subscriber attributes are avialable in this view.

    Note: If you are using Person Model, the _EnterpriseAttribute table is renamed to match the master list name, and the view subsequently is named accordingly.  Therefore, each BU has a different name for its master list table.

    Columns  

    Name Description DataType Data Extension Data Type Nullable
    SubscriberID The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. bigint Number  
    DateUndeliverable The date an email for the subscriber was returned as undeliverable smalldatetime Date X
    DateJoined The date the subscriber joined your list smalldatetime Date X
    DateUnsubscribed The date the subscriber unsubscribed from your list smalldatetime Date X
    Domain The domain of the subscriber varchar(250) Text X
    EmailAddress The subscriber's email address varchar(100) Text  
    BounceCount The total number of bounces accrued by the subscriber smallint Number  
    SubscriberKey The subscriber key for the affected subscriber varchar(100) Text  
    SubscriberType The subscriber type for the affected subscriber varchar(100) Text  
    Status The status of the subscriber: active, held, unsubscribed, or bounced. varchar(15) Text X
    Locale The locale code for the subscriber varchar(5) Locale X

    This page was last updated by Josh Cloud on Tue, 31 Jan 2012 18:27:48 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 18330 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