Promotions
Gets all promotions associated with an ad account ID that can be applied to an ad group.
Table Specific Information
Select
The server will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the server.
- AdAccountId supports the '=' operator.
SELECT * FROM Promotions where AdAccountId='549768561505';
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Promotion ID | |
| AdAccountId | String |
AdAccounts.Id | The Ad Account ID that this promotion belongs to |
| ExternalId | String | Platform-specific ID for this promotion. Will be null for promotions first created within Pinterest. | |
| PlatformType | String | The source integration platform used when creating the promotion. Currently supported values are 'DEFAULT' and 'SHOPIFY'.
The allowed values are DEFAULT, SHOPIFY. | |
| PromotionTitle | String | Internal name for the promotion. | |
| PromotionCode | String | Code that can be used to redeem a promotion. | |
| StartTime | Datetime | Promotion start time. Unix timestamp in seconds. Independent of campaign start time. | |
| EndTime | Datetime | Promotion end time. Unix timestamp in seconds. Independent of campaign end time. | |
| PromotionType | String | Determines the displayed promotion text along with what parameters (if any) are needed to complete the template. This list is not finalized, and will be updated as new types are supported
The allowed values are VARIABLE, SITEWIDE, CHECKOUT, SAVE_X_ON_Y, BUY_X_GET_Y, SPEND_X_SAVE_Y, FREE_SHIPPING, FREE_SHIPPING_MINIMUM, FREE_SHIPPING_WITH_DISCOUNT, SITEWIDE_IN_STORES, EXTRA_PERCENT_OFF, GIFT_WITH_PURCHASE, GIFT_WITH_PURCHASE_MINIMUM, FIXED, PERCENT_OFF_CLEARANCE, X_OFF_Y, GIFT_WITH_FIRST_PURCHASE, BUY_X_GET_ONE_FREE, CASH_BACK, POINTS_ON_ALL_PURCHASES, BONUS, POINTS_WITH_PURCHASE. | |
| TemplateValues | String | Numeric value of the specific template. | |
| DiscountStatus | String | Discount status based on the current time and start and end time of discount
The allowed values are OTHER, ACTIVE, PAUSED, SCHEDULED, EXPIRED. | |
| Status | String | Entity status
The allowed values are ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT. |