Schema Information for Pinterest

This subtopic provides a structured reference to assist you in working with Daton's Pinterest connector and the associated fields and tables.

Pulse
Daton

Need help with something?

Talk to data expert

Schema Information for Pinterest

This subtopic provides a structured reference to assist you in working with Daton's Pinterest connector and the associated fields and tables.

In this article, we will look at the schema information of the supported APIs and tables for Pinterest.

Find the links to other articles related to Pinterest Below:

Tables/APIs

The following is the list of tables or APIs associated with the Pinterest connector:

campaigns

Purpose: Get a specific campaign for a Pinterest ad account.

Source API Documentation: Pinterest- Campaigns API

Field Name	Data Type
id	STRING
ad_account_id	STRING
name	STRING
status	STRING
lifetime_spend_cap	INTEGER
daily_spend_cap	INTEGER
order_line_id	STRING
tracking_urls	RECORD
objective_type	STRING
created_time	INTEGER
updated_time	INTEGER
type	STRING
start_time	INTEGER
is_flexible_daily_budgets	BOOLEAN
is_campaign_budget_optimization	BOOLEAN
summary_status	STRING
CONVERSION_REPORT_TIME	STRING
daily_spend_cap_nu	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

ad_groups

Purpose: Get a specific ad group for a Pinterest ad account.

Source API Documentation: Pinterest- Ad Groups API

Field Name	Data Type
name	STRING
status	STRING
budget_in_micro_currency	INTEGER
bid_in_micro_currency	INTEGER
budget_type	STRING
start_time	NUMERIC
end_time	NUMERIC
targeting_spec	RECORD
lifetime_frequency_cap	INTEGER
tracking_urls	RECORD
auto_targeting_enabled	BOOLEAN
placement_group	STRING
pacing_delivery_type	STRING
conversion_learning_mode_type	STRING
summary_status	STRING
feed_profile_id	STRING
campaign_id	STRING
billable_event	STRING
id	STRING
type	STRING
ad_account_id	STRING
created_time	INTEGER
updated_time	INTEGER
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Purpose: Get a specific ad for a Pinterest ad account.

Source API Documentation: Pinterest- ads API

Field Name	Data Type
ad_group_id	STRING
android_deep_link	STRING
carousel_android_deep_links	STRING
carousel_destination_urls	STRING
carousel_ios_deep_links	STRING
click_tracking_url	STRING
creative_type	STRING
destination_url	STRING
ios_deep_link	STRING
is_pin_deleted	BOOLEAN
is_removable	BOOLEAN
name	STRING
pin_id	STRING
status	STRING
tracking_urls	RECORD
view_tracking_url	STRING
ad_account_id	STRING
campaign_id	STRING
collection_items_destination_url_template	STRING
created_time	INTEGER
id	STRING
rejected_reasons	STRING
rejection_labels	STRING
review_status	STRING
type	STRING
updated_time	INTEGER
summary_status	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

ad_accounts_analytics

Purpose: Get analytics for a Pinterest ad account.

Source API Documentation: Pinterest- Ad Accounts Analytics API

Field Name	Data Type
AD_ACCOUNT_ID	STRING
CHECKOUT_ROAS	NUMERIC
CLICKTHROUGH_1	NUMERIC
CLICKTHROUGH_1_GROSS	NUMERIC
CLICKTHROUGH_2	NUMERIC
CPC_IN_MICRO_DOLLAR	NUMERIC
CPM_IN_DOLLAR	NUMERIC
CPM_IN_MICRO_DOLLAR	NUMERIC
CTR	NUMERIC
CTR_2	NUMERIC
ECPCV_IN_DOLLAR	NUMERIC
ECPCV_P95_IN_DOLLAR	NUMERIC
ECPC_IN_DOLLAR	NUMERIC
ECPC_IN_MICRO_DOLLAR	NUMERIC
ECPE_IN_DOLLAR	NUMERIC
ECPM_IN_MICRO_DOLLAR	NUMERIC
ECPV_IN_DOLLAR	NUMERIC
ECTR	NUMERIC
EENGAGEMENT_RATE	NUMERIC
ENGAGEMENT_1	NUMERIC
ENGAGEMENT_2	NUMERIC
ENGAGEMENT_RATE	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_1	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_2	NUMERIC
IMPRESSION_1	NUMERIC
IMPRESSION_1_GROSS	NUMERIC
IMPRESSION_2	NUMERIC
INAPP_CHECKOUT_COST_PER_ACTION	NUMERIC
OUTBOUND_CLICK_1	NUMERIC
OUTBOUND_CLICK_2	NUMERIC
PAGE_VISIT_COST_PER_ACTION	NUMERIC
PAGE_VISIT_ROAS	NUMERIC
PAID_IMPRESSION	NUMERIC
PIN_ID	NUMERIC
REPIN_1	NUMERIC
REPIN_2	NUMERIC
REPIN_RATE	NUMERIC
SPEND_IN_DOLLAR	NUMERIC
SPEND_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CHECKOUT	NUMERIC
TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICKTHROUGH	NUMERIC
TOTAL_CLICK_CHECKOUT	NUMERIC
TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICK_SIGNUP	NUMERIC
TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CONVERSIONS	NUMERIC
TOTAL_CUSTOM	NUMERIC
TOTAL_ENGAGEMENT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT	NUMERIC
TOTAL_IMPRESSION_FREQUENCY	NUMERIC
TOTAL_IMPRESSION_USER	NUMERIC
TOTAL_LEAD	NUMERIC
TOTAL_PAGE_VISIT	NUMERIC
TOTAL_REPIN_RATE	NUMERIC
TOTAL_SIGNUP	NUMERIC
TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIDEO_3SEC_VIEWS	NUMERIC
TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND	NUMERIC
TOTAL_VIDEO_MRC_VIEWS	NUMERIC
TOTAL_VIDEO_P0_COMBINED	NUMERIC
TOTAL_VIDEO_P100_COMPLETE	NUMERIC
TOTAL_VIDEO_P25_COMBINED	NUMERIC
TOTAL_VIDEO_P50_COMBINED	NUMERIC
TOTAL_VIDEO_P75_COMBINED	NUMERIC
TOTAL_VIDEO_P95_COMBINED	NUMERIC
TOTAL_VIEW_CHECKOUT	NUMERIC
TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIEW_SIGNUP	NUMERIC
TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CHECKOUT	NUMERIC
TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
VIDEO_3SEC_VIEWS_2	NUMERIC
VIDEO_LENGTH	NUMERIC
VIDEO_MRC_VIEWS_2	NUMERIC
VIDEO_P0_COMBINED_2	NUMERIC
VIDEO_P100_COMPLETE_2	NUMERIC
VIDEO_P25_COMBINED_2	NUMERIC
VIDEO_P50_COMBINED_2	NUMERIC
VIDEO_P75_COMBINED_2	NUMERIC
VIDEO_P95_COMBINED_2	NUMERIC
WEB_CHECKOUT_COST_PER_ACTION	NUMERIC
WEB_CHECKOUT_ROAS	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

campaigns_analytics

Purpose: Get analytics for the specified campaigns for a Pinterest ad account.

Source API Documentation: Pinterest- Campaigns Analytics API

Field Name	Data Type
AD_ACCOUNT_ID	NUMERIC
CAMPAIGN_DAILY_SPEND_CAP	NUMERIC
CAMPAIGN_ENTITY_STATUS	NUMERIC
CAMPAIGN_ID	STRING
CAMPAIGN_LIFETIME_SPEND_CAP	NUMERIC
CAMPAIGN_NAME	STRING
CHECKOUT_ROAS	NUMERIC
CLICKTHROUGH_1	NUMERIC
CLICKTHROUGH_1_GROSS	NUMERIC
CLICKTHROUGH_2	NUMERIC
CPC_IN_MICRO_DOLLAR	NUMERIC
CPM_IN_DOLLAR	NUMERIC
CPM_IN_MICRO_DOLLAR	NUMERIC
CTR	NUMERIC
CTR_2	NUMERIC
ECPCV_IN_DOLLAR	NUMERIC
ECPCV_P95_IN_DOLLAR	NUMERIC
ECPC_IN_DOLLAR	NUMERIC
ECPC_IN_MICRO_DOLLAR	NUMERIC
ECPE_IN_DOLLAR	NUMERIC
ECPM_IN_MICRO_DOLLAR	NUMERIC
ECPV_IN_DOLLAR	NUMERIC
ECTR	NUMERIC
EENGAGEMENT_RATE	NUMERIC
ENGAGEMENT_1	NUMERIC
ENGAGEMENT_2	NUMERIC
ENGAGEMENT_RATE	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_1	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_2	NUMERIC
IMPRESSION_1	NUMERIC
IMPRESSION_1_GROSS	NUMERIC
IMPRESSION_2	NUMERIC
INAPP_CHECKOUT_COST_PER_ACTION	NUMERIC
OUTBOUND_CLICK_1	NUMERIC
OUTBOUND_CLICK_2	NUMERIC
PAGE_VISIT_COST_PER_ACTION	NUMERIC
PAGE_VISIT_ROAS	NUMERIC
PAID_IMPRESSION	NUMERIC
PIN_ID	NUMERIC
REPIN_1	NUMERIC
REPIN_2	NUMERIC
REPIN_RATE	NUMERIC
SPEND_IN_DOLLAR	NUMERIC
SPEND_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CHECKOUT	NUMERIC
TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICKTHROUGH	NUMERIC
TOTAL_CLICK_CHECKOUT	NUMERIC
TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICK_SIGNUP	NUMERIC
TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CONVERSIONS	NUMERIC
TOTAL_CUSTOM	NUMERIC
TOTAL_ENGAGEMENT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT	NUMERIC
TOTAL_IMPRESSION_FREQUENCY	NUMERIC
TOTAL_IMPRESSION_USER	NUMERIC
TOTAL_LEAD	NUMERIC
TOTAL_PAGE_VISIT	NUMERIC
TOTAL_REPIN_RATE	NUMERIC
TOTAL_SIGNUP	NUMERIC
TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIDEO_3SEC_VIEWS	NUMERIC
TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND	NUMERIC
TOTAL_VIDEO_MRC_VIEWS	NUMERIC
TOTAL_VIDEO_P0_COMBINED	NUMERIC
TOTAL_VIDEO_P100_COMPLETE	NUMERIC
TOTAL_VIDEO_P25_COMBINED	NUMERIC
TOTAL_VIDEO_P50_COMBINED	NUMERIC
TOTAL_VIDEO_P75_COMBINED	NUMERIC
TOTAL_VIDEO_P95_COMBINED	NUMERIC
TOTAL_VIEW_CHECKOUT	NUMERIC
TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIEW_SIGNUP	NUMERIC
TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CHECKOUT	NUMERIC
TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
VIDEO_3SEC_VIEWS_2	NUMERIC
VIDEO_LENGTH	NUMERIC
VIDEO_MRC_VIEWS_2	NUMERIC
VIDEO_P0_COMBINED_2	NUMERIC
VIDEO_P100_COMPLETE_2	NUMERIC
VIDEO_P25_COMBINED_2	NUMERIC
VIDEO_P50_COMBINED_2	NUMERIC
VIDEO_P75_COMBINED_2	NUMERIC
VIDEO_P95_COMBINED_2	NUMERIC
WEB_CHECKOUT_COST_PER_ACTION	NUMERIC
WEB_CHECKOUT_ROAS	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

ad_groups_analytics

Purpose: Get analytics for the specified ad groups for a Pinterest ad account.

Source API Documentation: Pinterest- Ad Groups Analytics API

Field Name	Data Type
AD_ACCOUNT_ID	NUMERIC
AD_GROUP_ENTITY_STATUS	NUMERIC
AD_GROUP_ID	STRING
CAMPAIGN_DAILY_SPEND_CAP	NUMERIC
CAMPAIGN_ENTITY_STATUS	NUMERIC
CAMPAIGN_ID	NUMERIC
CAMPAIGN_LIFETIME_SPEND_CAP	NUMERIC
CAMPAIGN_NAME	STRING
CHECKOUT_ROAS	NUMERIC
CLICKTHROUGH_1	NUMERIC
CLICKTHROUGH_1_GROSS	NUMERIC
CLICKTHROUGH_2	NUMERIC
CPC_IN_MICRO_DOLLAR	NUMERIC
CPM_IN_DOLLAR	NUMERIC
CPM_IN_MICRO_DOLLAR	NUMERIC
CTR	NUMERIC
CTR_2	NUMERIC
ECPCV_IN_DOLLAR	NUMERIC
ECPCV_P95_IN_DOLLAR	NUMERIC
ECPC_IN_DOLLAR	NUMERIC
ECPC_IN_MICRO_DOLLAR	NUMERIC
ECPE_IN_DOLLAR	NUMERIC
ECPM_IN_MICRO_DOLLAR	NUMERIC
ECPV_IN_DOLLAR	NUMERIC
ECTR	NUMERIC
EENGAGEMENT_RATE	NUMERIC
ENGAGEMENT_1	NUMERIC
ENGAGEMENT_2	NUMERIC
ENGAGEMENT_RATE	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_1	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_2	NUMERIC
IMPRESSION_1	NUMERIC
IMPRESSION_1_GROSS	NUMERIC
IMPRESSION_2	NUMERIC
INAPP_CHECKOUT_COST_PER_ACTION	NUMERIC
OUTBOUND_CLICK_1	NUMERIC
OUTBOUND_CLICK_2	NUMERIC
PAGE_VISIT_COST_PER_ACTION	NUMERIC
PAGE_VISIT_ROAS	NUMERIC
PAID_IMPRESSION	NUMERIC
PIN_ID	NUMERIC
REPIN_1	NUMERIC
REPIN_2	NUMERIC
REPIN_RATE	NUMERIC
SPEND_IN_DOLLAR	NUMERIC
SPEND_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CHECKOUT	NUMERIC
TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICKTHROUGH	NUMERIC
TOTAL_CLICK_CHECKOUT	NUMERIC
TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICK_SIGNUP	NUMERIC
TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CONVERSIONS	NUMERIC
TOTAL_CUSTOM	NUMERIC
TOTAL_ENGAGEMENT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT	NUMERIC
TOTAL_IMPRESSION_FREQUENCY	NUMERIC
TOTAL_IMPRESSION_USER	NUMERIC
TOTAL_LEAD	NUMERIC
TOTAL_PAGE_VISIT	NUMERIC
TOTAL_REPIN_RATE	NUMERIC
TOTAL_SIGNUP	NUMERIC
TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIDEO_3SEC_VIEWS	NUMERIC
TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND	NUMERIC
TOTAL_VIDEO_MRC_VIEWS	NUMERIC
TOTAL_VIDEO_P0_COMBINED	NUMERIC
TOTAL_VIDEO_P100_COMPLETE	NUMERIC
TOTAL_VIDEO_P25_COMBINED	NUMERIC
TOTAL_VIDEO_P50_COMBINED	NUMERIC
TOTAL_VIDEO_P75_COMBINED	NUMERIC
TOTAL_VIDEO_P95_COMBINED	NUMERIC
TOTAL_VIEW_CHECKOUT	NUMERIC
TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIEW_SIGNUP	NUMERIC
TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CHECKOUT	NUMERIC
TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
VIDEO_3SEC_VIEWS_2	NUMERIC
VIDEO_LENGTH	NUMERIC
VIDEO_MRC_VIEWS_2	NUMERIC
VIDEO_P0_COMBINED_2	NUMERIC
VIDEO_P100_COMPLETE_2	NUMERIC
VIDEO_P25_COMBINED_2	NUMERIC
VIDEO_P50_COMBINED_2	NUMERIC
VIDEO_P75_COMBINED_2	NUMERIC
VIDEO_P95_COMBINED_2	NUMERIC
WEB_CHECKOUT_COST_PER_ACTION	NUMERIC
WEB_CHECKOUT_ROAS	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

ad_analytics

Purpose: Get analytics for the specified ads for a Pinterest ad account.

Source API Documentation: Pinterest- Ads Analytics API

Field Name	Data Type
AD_ACCOUNT_ID	NUMERIC
AD_GROUP_ENTITY_STATUS	NUMERIC
AD_GROUP_ID	NUMERIC
AD_ID	STRING
CAMPAIGN_DAILY_SPEND_CAP	NUMERIC
CAMPAIGN_ENTITY_STATUS	NUMERIC
CAMPAIGN_ID	NUMERIC
CAMPAIGN_LIFETIME_SPEND_CAP	NUMERIC
CAMPAIGN_NAME	STRING
CHECKOUT_ROAS	NUMERIC
CLICKTHROUGH_1	NUMERIC
CLICKTHROUGH_1_GROSS	NUMERIC
CLICKTHROUGH_2	NUMERIC
CPC_IN_MICRO_DOLLAR	NUMERIC
CPM_IN_DOLLAR	NUMERIC
CPM_IN_MICRO_DOLLAR	NUMERIC
CTR	NUMERIC
CTR_2	NUMERIC
ECPCV_IN_DOLLAR	NUMERIC
ECPCV_P95_IN_DOLLAR	NUMERIC
ECPC_IN_DOLLAR	NUMERIC
ECPC_IN_MICRO_DOLLAR	NUMERIC
ECPE_IN_DOLLAR	NUMERIC
ECPM_IN_MICRO_DOLLAR	NUMERIC
ECPV_IN_DOLLAR	NUMERIC
ECTR	NUMERIC
EENGAGEMENT_RATE	NUMERIC
ENGAGEMENT_1	NUMERIC
ENGAGEMENT_2	NUMERIC
ENGAGEMENT_RATE	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_1	NUMERIC
IDEA_PIN_PRODUCT_TAG_VISIT_2	NUMERIC
IMPRESSION_1	NUMERIC
IMPRESSION_1_GROSS	NUMERIC
IMPRESSION_2	NUMERIC
INAPP_CHECKOUT_COST_PER_ACTION	NUMERIC
OUTBOUND_CLICK_1	NUMERIC
OUTBOUND_CLICK_2	NUMERIC
PAGE_VISIT_COST_PER_ACTION	NUMERIC
PAGE_VISIT_ROAS	NUMERIC
PAID_IMPRESSION	NUMERIC
PIN_ID	NUMERIC
REPIN_1	NUMERIC
REPIN_2	NUMERIC
REPIN_RATE	NUMERIC
SPEND_IN_DOLLAR	NUMERIC
SPEND_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CHECKOUT	NUMERIC
TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICKTHROUGH	NUMERIC
TOTAL_CLICK_CHECKOUT	NUMERIC
TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CLICK_SIGNUP	NUMERIC
TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_CONVERSIONS	NUMERIC
TOTAL_CUSTOM	NUMERIC
TOTAL_ENGAGEMENT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP	NUMERIC
TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT	NUMERIC
TOTAL_IMPRESSION_FREQUENCY	NUMERIC
TOTAL_IMPRESSION_USER	NUMERIC
TOTAL_LEAD	NUMERIC
TOTAL_PAGE_VISIT	NUMERIC
TOTAL_REPIN_RATE	NUMERIC
TOTAL_SIGNUP	NUMERIC
TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIDEO_3SEC_VIEWS	NUMERIC
TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND	NUMERIC
TOTAL_VIDEO_MRC_VIEWS	NUMERIC
TOTAL_VIDEO_P0_COMBINED	NUMERIC
TOTAL_VIDEO_P100_COMPLETE	NUMERIC
TOTAL_VIDEO_P25_COMBINED	NUMERIC
TOTAL_VIDEO_P50_COMBINED	NUMERIC
TOTAL_VIDEO_P75_COMBINED	NUMERIC
TOTAL_VIDEO_P95_COMBINED	NUMERIC
TOTAL_VIEW_CHECKOUT	NUMERIC
TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_VIEW_SIGNUP	NUMERIC
TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CHECKOUT	NUMERIC
TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT	NUMERIC
TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT	NUMERIC
TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT	NUMERIC
TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR	NUMERIC
VIDEO_3SEC_VIEWS_2	NUMERIC
VIDEO_LENGTH	NUMERIC
VIDEO_MRC_VIEWS_2	NUMERIC
VIDEO_P0_COMBINED_2	NUMERIC
VIDEO_P100_COMPLETE_2	NUMERIC
VIDEO_P25_COMBINED_2	NUMERIC
VIDEO_P50_COMBINED_2	NUMERIC
VIDEO_P75_COMBINED_2	NUMERIC
VIDEO_P95_COMBINED_2	NUMERIC
WEB_CHECKOUT_COST_PER_ACTION	NUMERIC
WEB_CHECKOUT_ROAS	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Table of Contents

Tables/APIs campaigns ad_groups ads ad_accounts_analytics campaigns_analytics ad_groups_analytics ad_analytics

Schema Information for Pinterest

Pulse

Daton

Schema Information for Pinterest