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.
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 |
ads
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 |
