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 provider 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 provider. 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. |