JDBC Driver for Pinterest

Build 23.0.8839


Get a list of the ad_accounts that the User has access to.

Table Specific Information


The 本製品 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 本製品.

  • AdAccountId supports the '=' operator.
  • Id supports the '=,IN' operator.
  • Status supports the '=' operator.
  • TranslateInterestsToNames supports the '=' operator.
For example:
	SELECT * FROM AdGroups WHERE AdAccountId = '3457832451'


Name Type References Description
Id [KEY] String Advertiser ID.
AdAccountId String


Ad Account ID.
CampaignId String


Campaign ID of the ad group.
FeedProfileId String Feed Profile ID associated to the adgroup.
AutoTargetingEnabled Boolean Enable auto-targeting for ad group.
BidInMicroCurrency Integer Bid price in micro currency.
BillableEvent String Ad group billable event type.
BudgetInMicroCurrency Integer Budget in micro currency.
BudgetType String Budget type
ConversionLearningModeType String oCPM learn mode
CreatedTime Datetime Ad group creation time.
EndTime Datetime Ad group end time.
LifetimeFrequencyCap Integer Set a limit to the number of times a promoted pin from this campaign can be impressed by a pinner within the past rolling 30 days.
Name String Ad group name.
PacingDeliveryType String PacingDeliveryType
PlacementGroup String PlacementGroup
StartTime Datetime Ad group start time
Status String Ad group/entity status.


SummaryStatus String Ad group summary status.
TargetingSpec String Ad group targeting specification defining the ad group target audience.
TrackingUrlsAudienceVerification String Third-party tracking URLs.
TrackingUrlsBuyableButton String Third-party tracking URLs.
TrackingUrlsClick String Third-party tracking URLs.
TrackingUrlsEngagement String Third-party tracking URLs.
TrackingUrlsImpression String Third-party tracking URLs.
Type String Type of ad group.
UpdatedTime Datetime Ad group last update time.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
TranslateInterestsToNames Boolean Return interests as text names and not topic IDs?

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