Introduction

Datasources and destinations

Fields listing for Pinterest Organic

User Account Type
Enum: "PINNER" "BUSINESS"
Field IDuser/account_type
TypeTEXT
Data Typedimension
User ID
User account ID.
Field IDuser/id
TypeTEXT
Data Typedimension
User Profile Image
Field IDuser/profile_image
TypeTEXT
Data Typedimension
User Website URL
Field IDuser/website_url
TypeTEXT
Data Typedimension
Username
Field IDuser/username
TypeTEXT
Data Typedimension
User About
Profile about description.
Field IDuser/about
TypeTEXT
Data Typedimension
User Business Name
Field IDuser/business_name
TypeTEXT
Data Typedimension
User Board Count
User account board count.
Field IDuser/board_count
TypeNUMBER
Data Typedimension
User Pin Count
User account pin count. This includes both created and saved pins.
Field IDuser/pin_count
TypeNUMBER
Data Typedimension
User Follower Count
User account follower count.
Field IDuser/follower_count
TypeNUMBER
Data Typedimension
User Following Count
User account following count.
Field IDuser/following_count
TypeNUMBER
Data Typedimension
User Monthly Views
User account monthly views.
Field IDuser/monthly_views
TypeNUMBER
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Save Rate
Field IDSAVE_RATE
TypePERCENT
Data Typemetric
Engagement Rate
Field IDENGAGEMENT_RATE
TypePERCENT
Data Typemetric
Impressions
Field IDIMPRESSION
TypeNUMBER
Data Typemetric
Outbound Click
Field IDOUTBOUND_CLICK
TypeNUMBER
Data Typemetric
Video Views
Field IDVIDEO_MRC_VIEW
TypeNUMBER
Data Typemetric
Total PlayTime (ms)
Field IDVIDEO_V50_WATCH_TIME
TypeNUMBER
Data Typemetric
Outbound click rate
Field IDOUTBOUND_CLICK_RATE
TypePERCENT
Data Typemetric
Video Start
Field IDVIDEO_START
TypeNUMBER
Data Typemetric
Pin click rate
Field IDPIN_CLICK_RATE
TypePERCENT
Data Typemetric
Average video play time (ms)
Field IDVIDEO_AVG_WATCH_TIME
TypeNUMBER
Data Typemetric
Pin Click
Field IDPIN_CLICK
TypeNUMBER
Data Typemetric
played to 95%
Field IDQUARTILE_95_PERCENT_VIEW
TypeNUMBER
Data Typemetric
Engagement
Field IDENGAGEMENT
TypeNUMBER
Data Typemetric
Save
Field IDSAVE
TypeNUMBER
Data Typemetric
Video 10s View
Field IDVIDEO_10S_VIEW
TypeNUMBER
Data Typemetric
App Type
Field IDAPP_TYPE
TypeTEXT
Data Typemetric
Owned Content
Field IDOWNED_CONTENT
TypeTEXT
Data Typemetric
Source
Field IDSOURCE
TypeTEXT
Data Typemetric
Pin Format
Field IDPIN_FORMAT
TypeTEXT
Data Typemetric
Pin ID
Field IDpin/id
TypeTEXT
Data Typedimension
Pin Created At
Field IDpin/created_at
TypeYEAR_MONTH_DAY
Data Typedimension
Pin Link
Field IDpin/link
TypeTEXT
Data Typedimension
Pin Title
Field IDpin/title
TypeTEXT
Data Typedimension
Pin Description
Field IDpin/description
TypeTEXT
Data Typedimension
Pin Dominant Color
Dominant pin color. Hex number, e.g. "#6E7874".
Field IDpin/dominant_color
TypeTEXT
Data Typedimension
Pin Alt Text
Field IDpin/alt_text
TypeTEXT
Data Typedimension
Pin Creative Type
Enum: "REGULAR" "VIDEO" "SHOPPING" "CAROUSEL" "MAX_VIDEO" "SHOP_THE_PIN" "COLLECTION" "IDEA" "SHOWCASE" "QUIZ"Ad creative type enum. For update, only draft ads may update creative type.Note: SHOP_THE_PIN has been deprecated. Please use COLLECTION instead.
Field IDpin/creative_type
TypeTEXT
Data Typedimension
Pin Board ID
The board to which this Pin belongs.
Field IDpin/board_id
TypeTEXT
Data Typedimension
Pin Board Section ID
The board section to which this Pin belongs.
Field IDpin/board_section_id
TypeTEXT
Data Typedimension
Pin Board Owner Username
Field IDpin/board_owner.username
TypeTEXT
Data Typedimension
Pin Is Owner
Whether the "operation user_account" is the Pin owner.
Field IDpin/is_owner
TypeBOOLEAN
Data Typedimension
Pin Parent ID
The source pin id if this pin was saved from another pin.
Field IDpin/parent_pin_id
TypeTEXT
Data Typedimension
Pin Is Standard
Whether the Pin is standard or not. See documentation on Changes to Pin creation for more information.
Field IDpin/is_standard
TypeBOOLEAN
Data Typedimension
Pin Has Been Promoted
Whether the Pin has been promoted or not.
Field IDpin/has_been_promoted
TypeBOOLEAN
Data Typedimension
Pin Note
Private note for this Pin
Field IDpin/note
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension