Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Pinterest v2 connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Pinterest v2 connector:
AdAccountAnalytics
Provides access to analytics and insights for a Pinterest ad account, allowing businesses to track and measure the performance of their advertising campaigns. For more information, see AdAccountAnalytics.
Fields
| Field Name | Data Type |
|---|---|
TOTAL_VIDEO_P25_COMBINED | NUMERIC |
VIDEO_MRC_VIEWS_2 | NUMERIC |
TOTAL_VIDEO_P0_COMBINED | NUMERIC |
TOTAL_IMPRESSION | NUMERIC |
TOTAL_VIDEO_3SEC_VIEWS | NUMERIC |
VIDEO_P0_COMBINED_2 | NUMERIC |
VIDEO_3SEC_VIEWS_2 | NUMERIC |
TOTAL_VIDEO_MRC_VIEWS | NUMERIC |
TOTAL_IMPRESSION_FREQUENCY | BIGNUMERIC |
TOTAL_IMPRESSION_USER | NUMERIC |
VIDEO_P25_COMBINED_2 | NUMERIC |
TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND | NUMERIC |
ADVERTISER_ID | NUMERIC |
DATE | DATE |
IMPRESSION_2 | NUMERIC |
AD_ACCOUNT_ID | STRING |
AdgroupAnalytics
Businesses can retrieve analytics and performance data specific to ad groups within their Pinterest ad account, enabling in-depth analysis of individual campaign components. For more information, see AdgroupAnalytics.
Fields
| Field Name | Data Type |
|---|---|
AD_GROUP_ID | STRING |
CAMPAIGN_OBJECTIVE_TYPE | NUMERIC |
AD_GROUP_ENTITY_STATUS | NUMERIC |
VIDEO_MRC_VIEWS_2 | NUMERIC |
CAMPAIGN_ENTITY_STATUS | NUMERIC |
TOTAL_VIDEO_P0_COMBINED | NUMERIC |
TOTAL_IMPRESSION | NUMERIC |
VIDEO_P0_COMBINED_2 | NUMERIC |
TOTAL_VIDEO_MRC_VIEWS | NUMERIC |
TOTAL_IMPRESSION_FREQUENCY | NUMERIC |
CAMPAIGN_LIFETIME_SPEND_CAP | NUMERIC |
TOTAL_IMPRESSION_USER | NUMERIC |
TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND | NUMERIC |
CAMPAIGN_DAILY_SPEND_CAP | NUMERIC |
ADVERTISER_ID | NUMERIC |
DATE | DATE |
IMPRESSION_2 | NUMERIC |
AD_ACCOUNT_ID | NUMERIC |
CAMPAIGN_ID | NUMERIC |
CAMPAIGN_NAME | STRING |
Adgroup
Allows for the management and configuration of ad groups within a Pinterest ad account, facilitating the creation and optimization of targeted advertising campaigns. For more information, see Adgroup.
Fields
| Field Name | Data Type |
|---|---|
id | STRING |
created_time | NUMERIC |
updated_time | NUMERIC |
campaign_id | STRING |
ad_account_id | STRING |
auto_targeting_enabled | BOOLEAN |
type | STRING |
budget_type | STRING |
billable_event | STRING |
status | STRING |
lifetime_frequency_cap | NUMERIC |
targeting_spec | RECORD |
name | STRING |
placement_group | STRING |
pacing_delivery_type | STRING |
conversion_learning_mode_type | STRING |
summary_status | STRING |
feed_profile_id | STRING |
optimization_goal_metadata | RECORD |
bid_strategy_type | STRING |
Ads
Enables businesses to create, manage, and monitor individual ads within their Pinterest ad account, ensuring effective ad campaign management and optimization. For more information, see Ads.
Fields
| Field Name | Data Type |
|---|---|
id | STRING |
ad_group_id | STRING |
ad_account_id | STRING |
campaign_id | STRING |
created_time | NUMERIC |
creative_type | STRING |
destination_url | STRING |
is_pin_deleted | BOOLEAN |
is_removable | BOOLEAN |
name | STRING |
pin_id | STRING |
review_status | STRING |
status | STRING |
summary_status | STRING |
type | STRING |
updated_time | NUMERIC |
AdAnalytics
Businesses can access detailed analytics and performance data for individual ads, helping them assess ad effectiveness and make data-driven decisions. For more information, see AdAnalytics.
Fields
| Field Name | Data Type |
|---|---|
PIN_ID | NUMERIC |
AD_GROUP_ID | NUMERIC |
CAMPAIGN_OBJECTIVE_TYPE | NUMERIC |
AD_GROUP_ENTITY_STATUS | NUMERIC |
CAMPAIGN_ENTITY_STATUS | NUMERIC |
TOTAL_IMPRESSION | NUMERIC |
TOTAL_IMPRESSION_FREQUENCY | NUMERIC |
CAMPAIGN_LIFETIME_SPEND_CAP | NUMERIC |
TOTAL_IMPRESSION_USER | NUMERIC |
CAMPAIGN_DAILY_SPEND_CAP | NUMERIC |
AD_ID | STRING |
ADVERTISER_ID | NUMERIC |
PIN_PROMOTION_ID | NUMERIC |
DATE | DATE |
IMPRESSION_2 | NUMERIC |
AD_ACCOUNT_ID | NUMERIC |
CAMPAIGN_ID | NUMERIC |
CAMPAIGN_NAME | STRING |
Campaigns
Provides tools for managing and organizing advertising campaigns within a Pinterest ad account, simplifying the process of creating and tracking multiple campaigns. For more information, see Campaigns.
Fields
| Field Name | Data Type |
|---|---|
id | STRING |
ad_account_id | STRING |
name | STRING |
status | STRING |
objective_type | STRING |
lifetime_spend_cap | NUMERIC |
daily_spend_cap | NUMERIC |
created_time | NUMERIC |
updated_time | NUMERIC |
type | STRING |
is_flexible_daily_budgets | BOOLEAN |
summary_status | STRING |
is_campaign_budget_optimization | BOOLEAN |
start_time | NUMERIC |
CampaignAnalytics
Businesses can retrieve comprehensive analytics and performance data specific to their advertising campaigns, aiding in campaign optimization and decision-making. For more information, see CampaignAnalytics.
Fields
| Field Name | Data Type |
|---|---|
TOTAL_IMPRESSION_FREQUENCY | NUMERIC |
CAMPAIGN_LIFETIME_SPEND_CAP | NUMERIC |
TOTAL_IMPRESSION_USER | NUMERIC |
CAMPAIGN_ENTITY_STATUS | NUMERIC |
CAMPAIGN_DAILY_SPEND_CAP | NUMERIC |
ADVERTISER_ID | NUMERIC |
DATE | DATE |
IMPRESSION_2 | NUMERIC |
AD_ACCOUNT_ID | NUMERIC |
CAMPAIGN_ID | STRING |
CAMPAIGN_NAME | STRING |
Last updated