ProfilesSubscriptions
Lists all subscription data for profiles, including consent status and channel-specific preferences.
Select
The connector uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the connector.
- Id supports the operators: =, IN
For example, the following query is processed server-side:
SELECT * FROM ProfilesSubscriptions
WHERE Id = 'id-1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the profile, automatically generated by Klaviyo. | |
| EmailMarketingCanReceiveEmailMarketing | Bool | Indicates whether the profile can receive email marketing messages. True if the profile does not have any global suppressions. | |
| EmailMarketingConsent | String | Specifies the consent status for receiving email marketing communications. | |
| EmailMarketingConsentTimestamp | Datetime | The date and time when consent for email marketing was recorded or last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| EmailMarketingLastUpdated | Datetime | The date and time when any field in the email marketing consent record was last modified, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| EmailMarketingMethod | String | Specifies the method by which the profile subscribed to email marketing, such as through a signup form or manual import. | |
| EmailMarketingMethodDetail | String | Provides additional details about how the profile subscribed to email marketing, if available. | |
| EmailMarketingCustomMethodDetail | String | Includes custom information provided by the caller at the time the profile was subscribed to email marketing, if applicable. | |
| EmailMarketingDoubleOptin | Bool | Indicates whether the profile subscribed to email marketing using a double opt-in process. | |
| EmailMarketingSuppression | String | Specifies the reason the profile was suppressed from email marketing. Possible values include HARD_BOUNCE, INVALID_EMAIL, SPAM_COMPLAINT, UNSUBSCRIBE, and USER_SUPPRESSED. | |
| EmailMarketingListSuppression | String | Specifies the reason the profile was suppressed from a specific list within email marketing. | |
| MobilePushMarketingCanReceiveRushMarketing | Bool | Indicates whether the profile is subscribed to receive mobile push marketing messages. | |
| MobilePushMarketingConsent | String | Specifies the consent status for receiving mobile push marketing messages. | |
| MobilePushMarketingConsentTimestamp | Datetime | The date and time when consent for mobile push marketing was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| SMSMarketingCanReceiveSMSMarketing | Bool | Indicates whether the profile is subscribed to receive SMS marketing messages. | |
| SMSMarketingConsent | String | Specifies the consent status for receiving SMS marketing messages. | |
| SMSMarketingConsentTimestamp | Datetime | The date and time when consent for SMS marketing was recorded or updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| SMSMarketingMethod | String | Specifies the method by which the profile subscribed to SMS marketing, such as via form, keyword, or manual opt-in. | |
| SMSMarketingMethodDetail | String | Provides additional details about how the profile subscribed to SMS marketing, if available. | |
| SMSMarketingLastUpdated | Datetime | The date and time when the SMS marketing consent record was last modified, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| SMSTransactionalCanReceiveSMSTransactional | Bool | Indicates whether the profile is subscribed to receive transactional SMS messages. | |
| SMSTransactionalConsent | String | Specifies the consent status for receiving transactional SMS messages. | |
| SMSTransactionalConsentTimestamp | Datetime | The date and time when consent for transactional SMS was recorded or updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| SMSTransactionalMethod | String | Specifies the method by which the profile was subscribed to transactional SMS messaging. | |
| SMSTransactionalMethodDetail | String | Provides additional details about how the profile subscribed to transactional SMS messaging, if available. | |
| SMSTransactionalLastUpdated | Datetime | The date and time when the transactional SMS consent record was last modified, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). |