ProfileCouponCodes
Manages coupon codes linked to customer profiles. Supports querying, creating, and updating profile-level coupon associations.
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.
- ProfileId supports the operators: =, IN
- ExpiresAt supports the operators: >=, >, <=, <
- Status supports the operator: =
For example, the following queries are processed server-side:
SELECT * FROM ProfileCouponCodes
WHERE ProfileId IN ('profile-id-1', 'profile-id-2', 'profile-id-3')
SELECT * FROM ProfileCouponCodes
WHERE Status = 'USED'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the coupon code. This Id is a composite value that combines the coupon's unique code with the Id of the associated coupon. | |
| ExpiresAt | Datetime | The date and time when the coupon code expires. If not specified or set to null, the expiration date defaults to one year from creation. | |
| Status | String | Indicates the current status of the coupon code. Supported values include ASSIGNED_TO_PROFILE, DELETING, PROCESSING, UNASSIGNED, USED, and VERSION_NOT_ACTIVE. | |
| UniqueCode | String | The unique string value assigned to an individual customer or profile that represents a single-use or profile-specific coupon. | |
| ProfileId | String |
Profiles.Id | The unique identifier of the profile associated with this coupon code. Use this value to retrieve all coupon codes assigned to a specific profile. |