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

• AdgroupAnalytics

• Adgroup

• Ads

• AdAnalytics

• Campaigns

• CampaignAnalytics

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