JDBC Driver for Pinterest

Build 23.0.8839


Get account information for the operation user_account

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.
For example:
	SELECT * FROM Campaigns WHERE AdAccountId = '3457832451'


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


Campaign's Advertiser ID.
CreatedTime Datetime Campaign creation time.
DailySpendCap Integer Campaign total spending cap.
LifetimeSpendCap Integer Campaign daily spending cap.
Name String Campaign name.
ObjectiveType String Campaign objective type.
OrderLineId String Order line ID that appears on the invoice.
Status String Entity status.


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 campaign.
UpdatedTime Datetime Last update time.
StartTime Datetime Start time.
EndTime Datetime End time.
SummaryStatus String Summary status.
IsFlexibleDailyBudgets Boolean Is Flexible Daily Budgets.
IsCampaignBudgetOptimization Boolean Is Campaign Budget Optimization.

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