Recent pages

Edit
page

New
page

Print
page
Page last modified 16:57, 19 Feb 2010 by Admin
0
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Interactions > Activities > Query Activity > Data View: SubscriberSMS

Data View: SubscriberSMS

From $1

    Table of contents
    1. 1. Columns  

    This view contains information about your SMS subscribers. Use the following _SubscriberSMS data view with the Query Activity. Information from this query relates to either the owner of a private short code or long code or a client using a shared short code to which the subscriber has opted in.

    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  
    SubscriberKey The subscriber key for the affected subscriber varchar(100) Text  
    MobileNumber The subscriber's mobile number varchar(50) Phone  
    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 
    SmsCarrierName Name of carrier for SMS messages varchar(50) Text  

     

    This page was last updated on Fri, 19 Feb 2010 20:57:35 GMT.

    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 17390 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