Excel Add-In for Pinterest

Build 24.0.9060

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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060