Ads
Get a list of the ad_accounts that the User has access to.
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 supports the '=' operator.
- Id supports the '=,IN' operator.
- AdGroupId supports the '=,IN' operator.
- CampaignId supports the '=,IN' operator.
- Status supports the '=' operator.
SELECT * FROM Ads WHERE AdAccountId = '3457832451'
Columns
Name | Type | References | Description |
Id [KEY] | String | The ID of this ad. | |
AdAccountId | String |
AdAccounts.Id | Unique identifier of an ad account. |
AdGroupId | String |
AdGroups.Id | ID of the ad group that contains the ad. |
AndroidDeepLink | String | Deep link URL for Android devices. Not currently available. Using this field will generate an error. | |
CampaignId | String |
Campaigns.Id | ID of the ad campaign that contains this ad. |
CarouselAndroidDeepLinks | String | Comma-separated deep links for the carousel pin on Android. | |
CarouselDestinationUrls | String | Comma-separated destination URLs for the carousel pin to promote. | |
CarouselIosDeepLinks | String | Comma-separated deep links for the carousel pin on iOS. | |
ClickTrackingUrl | String | Tracking url for the ad clicks. | |
CollectionItemsDestinationUrlTemplate | String | Destination URL template for all items within a collections drawer. | |
CreatedTime | Datetime | Pin creation time. | |
CreativeType | String | Ad creative type
The allowed values are REGULAR, VIDEO, SHOPPING, CAROUSEL, MAX_VIDEO, SHOP_THE_PIN, COLLECTION, IDEA, SHOWCASE, QUIZ. | |
DestinationUrl | String | Destination URL. | |
IosDeepLink | String | Deep link URL for iOS devices. | |
IsPinDeleted | Boolean | Is original pin deleted? | |
IsRemovable | Boolean | Is pin repinnable? | |
Name | String | Name of the ad. | |
PinId | String | Pin ID. | |
RejectedReasons | String | Reason why the pin was rejected. | |
RejectionLabels | String | Text reason why the pin was rejected. | |
ReviewStatus | String | Ad review status
The allowed values are OTHER, PENDING, REJECTED, APPROVED. | |
Status | String | Entity status
The allowed values are ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
SummaryStatus | String | Ad summary status.
The allowed values are APPROVED, PAUSED, PENDING, REJECTED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
TrackingUrlsAudienceVerification | String | Tracking Urls Audience Verification. | |
TrackingUrlsBuyableButton | String | Tracking Urls Buyable Button. | |
TrackingUrlsClick | String | Tracking Urls Click. | |
TrackingUrlsEngagement | String | Tracking Urls Engagement. | |
TrackingUrlsImpression | String | Tracking Urls Impression. | |
Type | String | Type of ad. | |
UpdatedTime | Datetime | Last update time. | |
ViewTrackingUrl | String | Tracking URL for ad impressions. |