_Coupon
Coupon definitions for Content Builder Block SDK live content. Requires Block SDK coupons.
Schema last reviewed 2026-06-17
Opens _Coupon in the interactive canvas with SQL Sandbox.
Coupon definitions for Content Builder Block SDK live content. Requires Block SDK coupons.
Schema last reviewed 2026-06-17
Opens _Coupon in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
Name |
Text(128) | PK | — | Coupon name. |
ExternalKey |
Text(36) | PK | — | API external key. |
Description |
Text | NULL | — | Coupon description. |
BeginDate |
Date | — | — | Coupon valid-from date. |
ExpirationDate |
Date | — | — | Coupon expiration date. |
SELECT TOP 100
Name, ExternalKey, Description, BeginDate, ExpirationDate
FROM _CouponValid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.