Promotions
Gets all promotions associated with an ad account ID that can be applied to an ad group.
Table Specific Information
Select
The connector 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 connector.
- 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'.
使用できる値は次のとおりです。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
使用できる値は次のとおりです。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
使用できる値は次のとおりです。OTHER, ACTIVE, PAUSED, SCHEDULED, EXPIRED | |
| Status | String | Entity status
使用できる値は次のとおりです。ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT |