Skip to main content
Skip table of contents

Pinterest Ads - Structure

Overview

Vendor/Partner

Pinterest

Version

v5

API Documentation

https://developers.pinterest.com/docs/getting-started/migration/

Sunset Date

None as of 10/03/2024

Channel(s)

Social

Refresh Time (CST)

5am / Real Time

Default backfill

Alli Data Library

(error)

Getting Started

Required Authorization

Limitations

  • This datasource requires all dimension and metric columns to be selected, but will only populate the columns relevant to the report type that has been selected.

Define your Data

Understanding Pinterest metrics: https://developers.pinterest.com/docs/ads/ad-analytics-reporting/#Mapping%20API%20metrics%20to%20Ads%20Manager

Dimensions

Name

ACTION

ENTITY_TYPE

CAMPAIGN_ID

CAMPAIGN_NAME

CAMPAIGN_STATUS

LIFETIME_SPEND_CAP

DAILY_SPEND_CAP

ORDER_LINE_ID

CAMPAIGN_TRACKING_URLS

CAMPAIGN_HOLDOUT_EXPERIMENT

CAMPAIGN_HOLDOUT_EXPERIMENT_CELL

CAMPAIGN_HOLDOUT_SURVEY

IS_CBO

DEFAULT_AD_GROUP_BUDGET_IN_MICRO_CURRENCY

CAMPAIGN_START_DATE

CAMPAIGN_START_TIME

CAMPAIGN_END_DATE

CAMPAIGN_END_TIME

IS_FDB

CAMPAIGN_BRAND_SFDC_ACCOUNT_ID

BID_TYPE

CAMPAIGN_CREATED_TIME

CAMPAIGN_UPDATED_TIME

CAMPAIGN_OBJECTIVE_TYPE

AD_GROUP_ID

AD_GROUP_NAME

AD_GROUP_START_TIME

AD_GROUP_END_TIME

AD_GROUP_BUDGET

AD_GROUP_PACING_TYPE

AD_GROUP_BUDGET_TYPE

AD_GROUP_STATUS

BID

LIFETIME_FREQUENCY_CAP

AD_GROUP_TRACKING_URLS

AUTO_TARGETING_ENABLED

AD_GROUP_PLACEMENT

CPA_GOAL_VALUE_IN_MICROCURRENCY

CONVERSION_TAG_ID

CONVERSION_EVENT

ATTRIBUTION_WINDOWS_CLICK

ATTRIBUTION_WINDOWS_ENGAGEMENT

ATTRIBUTION_WINDOWS_VIEW

FREQUENCY_TARGET_TIME_RANGE

FREQUENCY_TARGET

BID_STRATEGY_TYPE

AD_GROUP_CREATED_TIME

AD_GROUP_UPDATED_TIME

AD_GROUP_BILLABLE_EVENT

TARGETING_SPEC_LOCATIONS

TARGETING_SPEC_GEOS

TARGETING_SPEC_GENDERS

TARGETING_SPEC_AGE_BUCKETS

TARGETING_SPEC_LANGUAGES

TARGETING_SPEC_DEVICES

TARGETING_SPEC_INTERESTS

TARGETING_SPEC_INCLUDED_AUDIENCES

TARGETING_SPEC_EXCLUDED_AUDIENCES

TARGETING_SPEC_SHOPPING_LOOKBACK_WINDOW

TARGETING_SPEC_SHOPPING_EXCLUSION_WINDOW

TARGETING_SPEC_SHOPPING_EVENT_TAGS

ORGANIC_PIN_ID

IMAGE_FILE_NAME

PIN_TITLE

PIN_DESCRIPTION

ORGANIC_PIN_URL

PIN_PROMOTION_STATUS

PIN_PROMOTION_ID

PIN_PROMOTION_CREATIVE_TYPE

PIN_PROMOTION_NAME

PIN_PROMOTION_URL

PP_TRACKING_URLS

PIN_PROMOTION_IS_REMOVABLE

CAROUSEL_SLOT_1_IMAGE_FILE_NAME

CAROUSEL_SLOT_1_TITLE

CAROUSEL_SLOT_1_PIN_DESCRIPTION

CAROUSEL_SLOT_1_ORGANIC_PIN_URL

CAROUSEL_SLOT_1_PIN_PROMOTION_URL

CAROUSEL_SLOT_1_ANDROID_DEEP_LINK

CAROUSEL_SLOT_1_IOS_DEEP_LINK

CAROUSEL_SLOT_2_IMAGE_FILE_NAME

CAROUSEL_SLOT_2_TITLE

CAROUSEL_SLOT_2_PIN_DESCRIPTION

CAROUSEL_SLOT_2_ORGANIC_PIN_URL

CAROUSEL_SLOT_2_PIN_PROMOTION_URL

CAROUSEL_SLOT_2_ANDROID_DEEP_LINK

CAROUSEL_SLOT_2_IOS_DEEP_LINK

CAROUSEL_SLOT_3_IMAGE_FILE_NAME

CAROUSEL_SLOT_3_TITLE

CAROUSEL_SLOT_3_PIN_DESCRIPTION

CAROUSEL_SLOT_3_ORGANIC_PIN_URL

CAROUSEL_SLOT_3_PIN_PROMOTION_URL

CAROUSEL_SLOT_3_ANDROID_DEEP_LINK

CAROUSEL_SLOT_3_IOS_DEEP_LINK

CAROUSEL_SLOT_4_IMAGE_FILE_NAME

CAROUSEL_SLOT_4_TITLE

CAROUSEL_SLOT_4_PIN_DESCRIPTION

CAROUSEL_SLOT_4_ORGANIC_PIN_URL

CAROUSEL_SLOT_4_PIN_PROMOTION_URL

CAROUSEL_SLOT_4_ANDROID_DEEP_LINK

CAROUSEL_SLOT_4_IOS_DEEP_LINK

CAROUSEL_SLOT_5_IMAGE_FILE_NAME

CAROUSEL_SLOT_5_TITLE

CAROUSEL_SLOT_5_PIN_DESCRIPTION

CAROUSEL_SLOT_5_ORGANIC_PIN_URL

CAROUSEL_SLOT_5_PIN_PROMOTION_URL

CAROUSEL_SLOT_5_ANDROID_DEEP_LINK

CAROUSEL_SLOT_5_IOS_DEEP_LINK

COLLECTION_ITEMS_DESTINATION_URL_TEMPLATE

PIN_PROMOTION_REVIEW_STATUS

PIN_PROMOTION_REJECTED_REASONS

ORGANIC_PIN_DELETED

PIN_PROMOTION_CREATED_TIME

PIN_PROMOTION_UPDATED_TIME

KEYWORD_ID

KEYWORDS

MATCH_TYPE

KEYWORD_STATUS

PRODUCT_GROUP_ID

PRODUCT_GROUP_REF_ID

PRODUCT_GROUP_NAME

PRODUCT_GROUP_ACTIVE

PRODUCT_GROUP_TRACKING_URL

COLLECTIONS_HERO_PIN_ID

COLLECTIONS_HERO_DESTINATION_URL

SLIDESHOW_COLLECTIONS_TITLE

SLIDESHOW_COLLECTIONS_DESCRIPTION

STATUS

Metrics

Name

None

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.