Ads
Get a list of the ad_accounts that the User has access to.
View-Specific Information
SELECT
The provider uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the provider.
| Column | Supported Operators |
| AdAccountId | = |
| Id | =, IN |
| AdGroupId | =, IN |
| CampaignId | =, IN |
| Status | = |
For example:
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, COLLAGE, MAX_WIDTH_REGULAR_COLLECTION, MAX_WIDTH_VIDEO_COLLECTION. | |
| DestinationUrl | String | Destination URL. | |
| DisclosureType | String | Type of disclosure displayed with the ad.
The allowed values are IMPORTANT_SAFETY_INFO, MED_GUIDE, PATIENT_INFORMATION, NO_DISCLOSURE, PRESCRIBING_INFORMATION, PRESCRIBING_INFORMATION_BOX_WARNING. | |
| DisclosureUrl | String | URL of the disclosure document associated with the ad. | |
| 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. | |
| LeadFormId | String | Lead form ID for lead ad generation. | |
| GridClickType | String | Where a user is taken after clicking on an ad in grid.
The allowed values are CLOSEUP, DIRECT_TO_DESTINATION. | |
| CustomizableCTAType | String | Select a call to action (CTA) to display below your ad. | |
| QuizPinDataQuestions | String | A specific quiz inquiry. | |
| QuizPinDataResults | String | The result, and link out, based on the user’s choice. | |
| QuizPinDataTieBreakerType | String | Quiz ad tie breaker type, default is RANDOM
The allowed values are RANDOM, CUSTOM. | |
| QuizPinDataTieBreakerCustomResultAndroidDeepLink | String | Quiz Pin Data Tie Breaker Custom Result Android Deep Link | |
| QuizPinDataTieBreakerCustomResultDestinationURL | String | Quiz Pin Data Tie Breaker Custom Result Destination URL | |
| QuizPinDataTieBreakerCustomResultIosDeepLink | String | Quiz Pin Data Tie Breaker Custom Result IOS Deep Link | |
| QuizPinDataTieBreakerCustomResultOrganicPinId | String | Quiz Pin Data Tie Breaker Custom Result Organic Pin ID | |
| QuizPinDataTieBreakerCustomResultId | Integer | Quiz Pin Data Tie Breaker Custom Result Id |