PublicationSubscriber
Describes subscribers who are associated with a publication list in Salesforce Marketing Cloud. Each record defines a subscriber's status, preferences, and linkage to a specific publication for audience management and compliance tracking.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM PublicationSubscriber WHERE Publication_ID = 123 SELECT * FROM PublicationSubscriber WHERE Publication_ID IN (123, 456) SELECT * FROM PublicationSubscriber WHERE Publication_CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| Publication_ID | Int | Specifies the system-defined identifier (Id) that uniquely identifies the publication associated with the subscriber. |
| Publication_PartnerKey | String | Specifies the partner-supplied unique Id that external systems use to correlate publication records during API-driven integrations. |
| Publication_CreatedDate | Datetime | Specifies the read-only date and time when the publication that is associated with this subscriber was created. |
| Publication_ModifiedDate | Datetime | Specifies the date and time when the publication record associated with this subscriber was most recently modified. |
| Publication_Client_ID | Int | Specifies the Id of the client account that owns the publication that is associated with this subscriber. |
| Publication_Client_PartnerClientKey | String | Specifies the partner-defined key that associates the publication with a specific client context for integration or reporting purposes. |
| Client_ID | Int | Specifies the Id of the client account that owns or manages the subscriber record. |
| Client_PartnerClientKey | String | The partner-defined key that links the subscriber record to an external client integration context. |
| Publication_Name | String | Specifies the user-defined name of the publication to which the subscriber is linked. |
| Publication_Category | Int | Specifies the Id of the folder in which the publication is organized, which helps categorize publication assets within the account's folder hierarchy. |
| Subscriber_ID | Int | Specifies the system-defined Id that uniquely identifies the subscriber record. |
| Subscriber_SubscriberKey | String | The subscriber key that uniquely identifies the individual subscriber across Salesforce Marketing Cloud channels. |
| Subscriber_PrimarySMSAddress_AddressType | String | Provides the type of Short Message Service (SMS) address that is associated with the subscriber's primary mobile messaging profile, such as a short code or long code. |
| Subscriber_PrimarySMSAddress_Address | String | Specifies the mobile number or code value that is used as the subscriber's primary SMS address for publication-based messaging. |
| Subscriber_PrimarySMSAddress_Carrier | String | Specifies the mobile carrier that is associated with the subscriber's primary SMS address. This information can be used for routing, reporting, or compliance checks. |
| Subscriber_PrimarySMSPublicationStatus | String | Specifies the subscriber's SMS publication status, which indicates whether the subscriber is opted in, opted out, pending confirmation, or restricted from receiving publication messages. |