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

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

Setup Manual

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

Last updated