Introduction

Datasources and destinations

Fields listing for Pinterest Organic

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

20 metrics43 dimensions

63 fields

All fields
FieldDetails
App Type
Field IDAPP_TYPE
DimensionTEXT
Average video play time (ms)
Field IDVIDEO_AVG_WATCH_TIME
MetricNUMBER
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Engagement
Field IDENGAGEMENT
MetricNUMBER
Engagement Rate
Field IDENGAGEMENT_RATE
MetricPERCENT
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Impressions
Field IDIMPRESSION
MetricNUMBER
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Outbound Click
Field IDOUTBOUND_CLICK
MetricNUMBER
Outbound click rate
Field IDOUTBOUND_CLICK_RATE
MetricPERCENT
Owned Content
Field IDOWNED_CONTENT
DimensionTEXT
Pin Alt Text
Field IDpin/alt_text
DimensionTEXT
Pin Board ID
The board to which this Pin belongs.
Field IDpin/board_id
DimensionTEXT
Pin Board Owner Username
Field IDpin/board_owner.username
DimensionTEXT
Pin Board Section ID
The board section to which this Pin belongs.
Field IDpin/board_section_id
DimensionTEXT
Pin Click
Field IDPIN_CLICK
MetricNUMBER
Pin click rate
Field IDPIN_CLICK_RATE
MetricPERCENT
Pin Created At
Field IDpin/created_at
DimensionYEAR_MONTH_DAY
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
DimensionTEXT
Pin Description
Field IDpin/description
DimensionTEXT
Pin Dominant Color
Dominant pin color. Hex number, e.g. "#6E7874".
Field IDpin/dominant_color
DimensionTEXT
Pin Format
Field IDPIN_FORMAT
DimensionTEXT
Pin Has Been Promoted
Whether the Pin has been promoted or not.
Field IDpin/has_been_promoted
DimensionBOOLEAN
Pin ID
Field IDpin/id
DimensionTEXT
Pin Is Owner
Whether the "operation user_account" is the Pin owner.
Field IDpin/is_owner
DimensionBOOLEAN
Pin Is Standard
Whether the Pin is standard or not. See documentation on Changes to Pin creation for more information.
Field IDpin/is_standard
DimensionBOOLEAN
Pin Link
Field IDpin/link
DimensionTEXT
Pin Media Type
Field IDpin/media_type
DimensionTEXT
Pin Note
Private note for this Pin
Field IDpin/note
DimensionTEXT
Pin Parent ID
The source pin id if this pin was saved from another pin.
Field IDpin/parent_pin_id
DimensionTEXT
Pin Title
Field IDpin/title
DimensionTEXT
Pin URL Media Image
Field IDpin/url_media_image
DimensionTEXT
played to 95%
Field IDQUARTILE_95_PERCENT_VIEW
MetricNUMBER
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Save
Field IDSAVE
MetricNUMBER
Save Rate
Field IDSAVE_RATE
MetricPERCENT
Source
Field IDSOURCE
DimensionTEXT
Total PlayTime (ms)
Field IDVIDEO_V50_WATCH_TIME
MetricNUMBER
User About
Profile about description.
Field IDuser/about
DimensionTEXT
User Account Type
Enum: "PINNER" "BUSINESS"
Field IDuser/account_type
DimensionTEXT
User Board Count
User account board count.
Field IDuser/board_count
MetricNUMBER
User Business Name
Field IDuser/business_name
DimensionTEXT
User Follower Count
User account follower count.
Field IDuser/follower_count
MetricNUMBER
User Following Count
User account following count.
Field IDuser/following_count
MetricNUMBER
User ID
User account ID.
Field IDuser/id
DimensionTEXT
User Monthly Views
User account monthly views.
Field IDuser/monthly_views
MetricNUMBER
User Pin Count
User account pin count. This includes both created and saved pins.
Field IDuser/pin_count
MetricNUMBER
User Profile Image
Field IDuser/profile_image
DimensionTEXT
User Website URL
Field IDuser/website_url
DimensionTEXT
Username
Field IDuser/username
DimensionTEXT
Video 10s View
Field IDVIDEO_10S_VIEW
MetricNUMBER
Video Start
Field IDVIDEO_START
MetricNUMBER
Video Views
Field IDVIDEO_MRC_VIEW
MetricNUMBER
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.