Pinterest Organic data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: PROFILE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
user_analytics__user__account_type
Display name User account type
Description User account type
Field type dimension
Data type string.text.value
user_analytics__user__board_count
Display name Boards
Description The number of boards owned
Field type metric
Data type int.number.value
user_analytics__user__business_name
Display name Business name
Description The name of the business
Field type dimension
Data type string.text.value
user_analytics__user__follower_count
Display name Followers
Description The number of followers
Field type metric
Data type int.number.value
user_analytics__user__following_count
Display name Following
Description The number of accounts following
Field type metric
Data type int.number.value
user_analytics__user__pin_count
Display name Pins
Description The number of Pins owned
Field type metric
Data type int.number.value
user_analytics__user__profile_image
Display name Profile image
Description URL to the profile image
Field type dimension
Data type string.text.url
user_analytics__user__username
Display name Username
Description Username of the Pinterest account
Field type dimension
Data type string.text.value
user_analytics__user__website_url
Display name Website URL
Description URL to the website
Field type dimension
Data type string.text.url

Table: TOP_PIN

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
top_pins__closeups
Display name Close ups
Description The number of times a Pin was clicked to view it in a larger size
Field type metric
Data type int.number.value
top_pins__engagements
Display name Engagements
Description The number of engagements on a Pin, including closeups, saves, and outbound clicks
Field type metric
Data type int.number.value
top_pins__full_screen_play
Display name Full screen play
Description The number of times a video Pin was played in full screen mode
Field type metric
Data type int.number.value
top_pins__full_screen_playtime
Display name Full screen playtime (ms)
Description The total amount of time (ms) a video Pin was played in full screen mode
Field type metric
Data type int.number.value
top_pins__impressions
Display name Impressions
Description The number of times your Pins were on screen
Field type metric
Data type int.number.value
top_pins__outbound_clicks
Display name Outbound clicks
Description The number of times people perform actions that lead them to a destination off Pinterest
Field type metric
Data type int.number.value
top_pins__pin__ad_account_country
Display name Ad account country
Description Country of the ad account
Field type dimension
Data type string.geo.country.twolettercode
top_pins__pin__ad_account_id
Display name Ad account ID
Description Ad account ID
Field type dimension
Data type string.text.value
top_pins__pin__ad_account_name
Display name Ad account name
Description Ad account name
Field type dimension
Data type string.text.value
top_pins__pin__alt_text
Display name Pin alt text
Description Alternative text for the image on the Pin
Field type dimension
Data type string.text.value
top_pins__pin__created_at
Display name Pin created at datetime
Description Date and time when the Pin was created
Field type dimension
Data type string.time.datetime
top_pins__pin__description
Display name Pin description
Description Description of the Pin
Field type dimension
Data type string.text.value
top_pins__pin__dominant_color
Display name Pin dominant color
Description The dominant color of the Pin's image
Field type dimension
Data type string.text.value
top_pins__pin__is_owner
Display name Is owner
Description Is owner of the Pin. [True, False]
Field type dimension
Data type bool
top_pins__pin__media_type
Display name Pin media type
Description The type of media associated with the Pin (e.g. image, video)
Field type dimension
Data type string.text.value
top_pins__pin__title
Display name Pin title
Description Title of the Pin
Field type dimension
Data type string.text.value
top_pins__pin_clicks
Display name Pin clicks
Description The total number of clicks on your Pin so it opens in closeup
Field type metric
Data type int.number.value
top_pins__pin_id
Display name Pin ID (all sources)
Description The unique identifier of a Pin including Other pins from e.g. claimed content
Field type dimension
Data type string.text.value
top_pins__saves
Display name Saves
Description The number of times people saved your Pin to a board
Field type metric
Data type int.number.value
top_pins__video_10s_view
Display name 10-second plays
Description The number of times your video was viewed for at least 10 seconds
Field type metric
Data type int.number.value
top_pins__video_mrc_view
Display name Video views
Description The amount of views for at least 2 seconds with 50% of video in view
Field type metric
Data type int.number.value
top_pins__video_quartile_95_percent_view
Display name Played to 95%
Description The number of times your video was viewed to 95% of its length
Field type metric
Data type int.number.value
top_pins__video_start
Display name Video starts
Description The total number of video starts
Field type metric
Data type int.number.value
top_pins__video_v50_watch_time
Display name Total play time (ms)
Description The total play time for your video in milliseconds
Field type metric
Data type string.time.minute

Table: OWNED_PIN

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
pin__ad_account_country
Display name Ad account country
Description Country of the ad account
Field type dimension
Data type string.geo.country.twolettercode
pin__ad_account_id
Display name Ad account ID
Description Ad account ID
Field type dimension
Data type string.text.value
pin__ad_account_name
Display name Ad account name
Description Ad account name
Field type dimension
Data type string.text.value
pin__alt_text
Display name Pin alt text
Description Alternative text for the image on the Pin
Field type dimension
Data type string.text.value
pin__created_at
Display name Pin created at datetime
Description Date and time when the Pin was created
Field type dimension
Data type string.time.datetime
pin__created_at_date
Display name Pin created at date
Description Date when the Pin was created
Field type dimension
Data type string.time.date
pin__description
Display name Pin description
Description Description of the Pin
Field type dimension
Data type string.text.value
pin__dominant_color
Display name Pin dominant color
Description The dominant color of the Pin's image
Field type dimension
Data type string.text.value
pin__media_type
Display name Pin media type
Description The type of media associated with the Pin (e.g. image, video)
Field type dimension
Data type string.text.value
pin__pin_analytics__date
Display name Date
Field type dimension
Data type string.time.date
pin__pin_analytics__impressions
Display name Impressions
Description The number of times your Pins were on screen
Field type metric
Data type int.number.value
pin__pin_analytics__outbound_clicks
Display name Outbound clicks
Description The number of times people perform actions that lead them to a destination off Pinterest
Field type metric
Data type int.number.value
pin__pin_analytics__pin_clicks
Display name Pin clicks
Description The total number of clicks on your Pin so it opens in closeup
Field type metric
Data type int.number.value
pin__pin_analytics__saves
Display name Saves
Description The number of times people saved your Pin to a board
Field type metric
Data type int.number.value
pin__pin_analytics__video_10s_view
Display name 10-second plays
Description The number of times your video was viewed for at least 10 seconds
Field type metric
Data type int.number.value
pin__pin_analytics__video_mrc_view
Display name Video views
Description The amount of views for at least 2 seconds with 50% of video in view
Field type metric
Data type int.number.value
pin__pin_analytics__video_quartile_95_percent_view
Display name Played to 95%
Description The number of times your video was viewed to 95% of its length
Field type metric
Data type int.number.value
pin__pin_analytics__video_start
Display name Video starts
Description The total number of video starts
Field type metric
Data type int.number.value
pin__pin_analytics__video_v50_watch_time
Display name Total play time (minutes)
Description The total play time for your video in minutes
Field type metric
Data type string.time.minute
pin__pin_id
Display name Pin ID
Description Unique identifier of a Pin. Includes only Your (owned) pins
Field type dimension
Data type string.text.value
pin__title
Display name Pin title
Description Title of the Pin
Field type dimension
Data type string.text.value

Table: PIN_OVERVIEW

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
user_analytics__ad_account_country
Display name Ad account country
Description Country of the ad account
Field type dimension
Data type string.geo.country.twolettercode
user_analytics__ad_account_id
Display name Ad account ID
Description Ad account ID
Field type dimension
Data type string.text.value
user_analytics__ad_account_name
Display name Ad account name
Description Ad account name
Field type dimension
Data type string.text.value
user_analytics__date
Display name Date
Field type dimension
Data type string.time.date
user_analytics__engagements
Display name Engagements
Description The total number of engagements on your Pins. This includes saves, Pin clicks, outbound clicks, carousel card swipes, secondary creative (collections) clicks and Idea Pin forward/backward swipes
Field type metric
Data type int.number.value
user_analytics__impressions
Display name Impressions
Description The number of times your Pins were on screen
Field type metric
Data type int.number.value
user_analytics__outbound_clicks
Display name Outbound clicks
Description The number of times people perform actions that lead them to a destination off Pinterest
Field type metric
Data type int.number.value
user_analytics__pin_clicks
Display name Pin clicks
Description The total number of clicks on your Pin so it opens in closeup
Field type metric
Data type int.number.value
user_analytics__saves
Display name Saves
Description The number of times people saved your Pin to a board
Field type metric
Data type int.number.value
user_analytics__user__account_type
Display name User account type
Description User account type
Field type dimension
Data type string.text.value
user_analytics__user__business_name
Display name Business name
Description The name of the business
Field type dimension
Data type string.text.value
user_analytics__user__profile_image
Display name Profile image
Description URL to the profile image
Field type dimension
Data type string.text.url
user_analytics__user__username
Display name Username
Description Username of the Pinterest account
Field type dimension
Data type string.text.value
user_analytics__user__website_url
Display name Website URL
Description URL to the website
Field type dimension
Data type string.text.url