Campaigns
Get account information for the operation user_account
Table Specific Information
Select
The connector 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 connector.
- AdAccountId supports the '=' operator.
- Id supports the '=,IN' operator.
- Status supports the '=' operator.
SELECT * FROM Campaigns WHERE AdAccountId = '3457832451'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Campaign ID. | |
| AdAccountId | String |
AdAccounts.Id | 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.
使用できる値は次のとおりです。AWARENESS, CONSIDERATION, VIDEO_VIEW, WEB_CONVERSION, CATALOG_SALES, WEB_SESSIONS, VIDEO_COMPLETION | |
| OrderLineId | String | Order line ID that appears on the invoice. | |
| Status | String | Entity status.
使用できる値は次のとおりです。ACTIVE, PAUSED, 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 campaign. | |
| UpdatedTime | Datetime | Last update time. | |
| StartTime | Datetime | Start time. | |
| EndTime | Datetime | End time. | |
| SummaryStatus | String | Summary status.
使用できる値は次のとおりです。RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT | |
| IsFlexibleDailyBudgets | Boolean | Is Flexible Daily Budgets. | |
| IsCampaignBudgetOptimization | Boolean | Is Campaign Budget Optimization. |