AdGroupPreview
Query records for one or more ad groups. Returns all active previews associated with the provided ad group IDs. Each ad group is processed independently; individual failures do not block other previews.
Table Specific Information
Select
The add-in 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 add-in. AdAccountId and AdGroupId are required columns to access this table.
- AdAccountId supports the '=' operator.
- AdGroupId supports the '=,IN' operator.
SELECT * FROM AdGroupPreview WHERE AdAccountId = '549755885175' AND AdGroupId = '2680060704746'
SELECT * FROM AdGroupPreview WHERE AdAccountId = '549755885175' AND AdGroupId IN ('2680060704746', '2680060704747')
Columns
| Name | Type | References | Description |
| AdAccountId [KEY] | String |
AdAccounts.Id | Unique identifier of an ad account. |
| AdGroupId [KEY] | String |
AdGroups.Id | Unique identifier of the ad group. |
| Uuid [KEY] | String | Unique identifier of the ad preview record. | |
| Url | String | Preview URL for the ad group. Expires after the time indicated in ExpiresAt. Can be used in an iframe. | |
| ExpiresAt | Datetime | Unix timestamp (seconds) when the preview URL expires. | |
| ClientId | String | Client ID associated with the ad preview. | |
| UserId | String | User ID associated with the ad preview. | |
| PinId | String |
Pins.Id | Pin ID associated with the ad preview. |
| PinPromotionId | String | Pin promotion ID associated with the ad preview. | |
| PromotedProductGroupId | String | Promoted product group ID associated with the ad preview. | |
| IsActive | Boolean | Indicates whether the ad preview is currently active. |