Recent pages

Edit
page

New
page

Print
page
Page last modified 08:18, 19 Apr 2011 by Admin
0
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Interactions > Activities > Query Activity > Data View: PublicationSubscriber

Data View: PublicationSubscriber

From $1

    Table of contents
    1. 1. Columns  

    This view contains information about a publication list. Use the following _PublicationSubscriber data view with the Query Activity.

    NOTE: You can only use this data view with SMS messages.

    Columns  

    Name Description  DataType Data Extension Data Type Nullable
    PublicationID The ID of the publication list bigint Number  
    ListName The name of the publication list nvarchar(50) Text  
    SubscriberId The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. bigint Number  
    TransactionalOptIn Whether the subscriber has opted in for transaction emails bit Boolean  
    TransactionalOptInDate The date of the transactional opt-in datetime Date  
    TransactionalOptOutDate The date of any transactional opt-out datetime Date X
    MarketingOptIn Whether the subscriber has opted in for marketing emails bit Boolean  
    MarketingOptInDate The date of the marketing opt-in datetime Date  
    MarketingOptOutDate The date of the marketing opt-out datetime Date X 

    This page was last updated by Josh Cloud on Tue, 19 Apr 2011 12:18:28 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 12690 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