Pinterest

Pinterest is a visual discovery and bookmarking platform that allows users to save and share multimedia content. A Pinterest ad account allows businesses to create and manage advertising campaigns on the platform. Advertisers can set campaign objectives, define targeting parameters based on demographics, interests, and search terms, and track the performance of their ads through metrics such as impressions, clicks, conversions, and engagement.

This section includes:

• Snapshot

• Tables/APIs Supported

• Setup Manual

• Schema Information

Snapshot

Features	Details
Release Status	Released
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Pinterest Email Pinterest Password
Suggested Replication Frequency	24 hrs

Tables/APIs Supported

Table Name
campaigns
ad_groups
ads
ad_accounts_analytics
campaigns_analytics
ad_groups_analytics
ads_analytics

Setup Manual

• Prerequisites
• Integrate Your Pinterest account with Daton
• Workflow

Prerequisites

To integrate Pinterest into Daton, a user will require the following:

• A Pinterest Ads account with Admin access to the Pins and Boards of other linked accounts.

• An Advertiser under that account.

Integrate Your Pinterest account with Daton

• Sign in to your existing Daton account.
• Search for Pinterest in the list of Connectors and click on the 'Configure' button.

  
• Provide the necessary Integration Name, Replication Frequency, and Replication Start Date data and click on the 'Authenticate' button. Please Note, the Integration Name would be used in creating tables for the integration and cannot be changed later.

  
• You will now be redirected to log in to your Pinterest ad account.

  
• Now select all or select specific accounts from all your existing Pinterest Ad accounts whose data you want to replicate. And click on the 'Next' button.

  
• Post successful authentication, you will be prompted to choose from the list of available tables. Add the required Tables and click on 'Next.'

  
• Select all the columns or at least one column from each of the Selected tables and Submit the integration.

  
• Once submitted, you will be prompted to select the destination for your data to replicate. Select your favorite destination and click on 'Confirm.' You will now receive a popup saying 'Integration Successful.' Congrats! Your Ad Account has been integrated with Daton.

Workflow

1. Integrations would be in the Pending state initially and will be moved to the Active state as soon as the first job loads data successfully into the configured warehouse.

2. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.

3. Users can Re-Authenticate, Edit, Clone, Pause or Delete the integration at any given time by clicking on the settings You can also edit the integration to change frequency and history.

4. Each table in your integration can be accessed by clicking on the integration on the 'Sources' page. Here you may find the status of each table, the last replicated time, and Reload access buttons.

Schema Information

campaigns

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

Source API Documentation: Pinterest- Campaigns API

FIELDS

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

FIELDS

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

FIELDS

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

FIELDS

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

FIELDS

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

FIELDS

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

FIELDS

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