Pinterest Organic fields

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

Supermetrics brings all your Pinterest Organic data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

45 metrics80 dimensions

AD ACCOUNT

user_analytics__ad_account_name
Field label Ad account name
Description Ad account name
Field type dimension
Data type string.text.value
user_analytics__ad_account_id
Field label Ad account ID
Description Ad account ID
Field type dimension
Data type string.text.value
user_analytics__ad_account_country
Field label Ad account country
Description Country of the ad account
Field type dimension
Data type string.geo.country.twolettercode
top_pins__pin__ad_account_name
Field label Ad account name
Description Ad account name
Field type dimension
Data type string.text.value
top_pins__pin__ad_account_id
Field label Ad account ID
Description Ad account ID
Field type dimension
Data type string.text.value
top_pins__pin__ad_account_country
Field label Ad account country
Description Country of the ad account
Field type dimension
Data type string.geo.country.twolettercode
pin__ad_account_name
Field label Ad account name
Description Ad account name
Field type dimension
Data type string.text.value
pin__ad_account_id
Field label Ad account ID
Description Ad account ID
Field type dimension
Data type string.text.value
pin__ad_account_country
Field label Ad account country
Description Country of the ad account
Field type dimension
Data type string.geo.country.twolettercode

ALL PINS

user_analytics__impressions
Field label Impressions
Description The number of times your Pins were on screen
Field type metric
Data type int.number.value
user_analytics__engagements
Field label 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__engagement_rate
Field label Engagement rate
Description The ratio of engagements on a Pin to the number of times it was shown. (engagements/impressions)
Field type metric
Data type float.number.ratio
user_analytics__pin_clicks
Field label 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__pin_click_rate
Field label Pin click rate
Description The total number of clicks from your Pin or ad to content on or off Pinterest, divided by the total number of times your Pins or ads were on screen. (pin_clicks/impressions)
Field type metric
Data type float.number.ratio
user_analytics__outbound_clicks
Field label 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__outbound_click_rate
Field label Outbound click rate
Description The total number of clicks to the destination URL associated with your Pin divided by the total number of times your Pins were on screen. (outbound_clicks/impressions)
Field type metric
Data type float.number.ratio
user_analytics__saves
Field label Saves
Description The number of times people saved your Pin to a board
Field type metric
Data type int.number.value
user_analytics__save_rate
Field label Save rate
Description The total saves of your Pins divided by the total number of times your Pins were on screen. (saves/impressions)
Field type metric
Data type float.number.ratio

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

PIN

top_pins__pin_id
Field label 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__pin__pin_id
Field label Pin ID
Description Unique identifier of a Pin. Includes only Your (owned) pins
Field type dimension
Data type string.text.value
top_pins__pin__title
Field label Pin title
Description Title of the Pin
Field type dimension
Data type string.text.value
top_pins__pin__description
Field label Pin description
Description Description of the Pin
Field type dimension
Data type string.text.value
top_pins__pin__media_type
Field label 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__url_media_image
Field label Pin media image URL
Description The URL of the image associated with the Pin
Field type dimension
Data type string.text.url
top_pins__pin__media_image_url
Field label Pin media image
Description The media image displayed inside a cell in Google Sheets
Field type dimension
Data type string.text.url
Destinations Google Sheets
top_pins__pin__alt_text
Field label 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
Field label Pin created at datetime
Description Date and time when the Pin was created
Field type dimension
Data type string.time.datetime
top_pins__pin__created_at_date
Field label Pin created at date
Description Date when the Pin was created
Field type dimension
Data type string.time.date
top_pins__pin__dominant_color
Field label 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
Field label Is owner
Description Is owner of the Pin. [True, False]
Field type dimension
Data type bool
pin__pin_id
Field label Pin ID
Description Unique identifier of a Pin. Includes only Your (owned) pins
Field type dimension
Data type string.text.value
pin__title
Field label Pin title
Description Title of the Pin
Field type dimension
Data type string.text.value
pin__description
Field label Pin description
Description Description of the Pin
Field type dimension
Data type string.text.value
pin__media_type
Field label 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__url_media_image
Field label Pin media image URL
Description The URL of the image associated with the Pin
Field type dimension
Data type string.text.url
pin__media_image_url
Field label Pin media image
Description The media image displayed inside a cell in Google Sheets
Field type dimension
Data type string.text.url
Destinations Google Sheets
pin__alt_text
Field label Pin alt text
Description Alternative text for the image on the Pin
Field type dimension
Data type string.text.value
pin__created_at
Field label 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
Field label Pin created at date
Description Date when the Pin was created
Field type dimension
Data type string.time.date
pin__dominant_color
Field label Pin dominant color
Description The dominant color of the Pin's image
Field type dimension
Data type string.text.value
pin__is_owner
Field label Is owner
Description Is owner of the Pin. [True, False]
Field type dimension
Data type bool
top_pins__impressions
Field label Impressions
Description The number of times your Pins were on screen
Field type metric
Data type int.number.value
top_pins__engagements
Field label 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__engagement_rate
Field label Engagement rate
Description The ratio of engagements on a Pin to the number of times it was shown. (engagements/impressions)
Field type metric
Data type float.number.ratio
top_pins__pin_clicks
Field label 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_click_rate
Field label Pin click rate
Description The total number of clicks from your Pin or ad to content on or off Pinterest, divided by the total number of times your Pins or ads were on screen. (pin_clicks/impressions)
Field type metric
Data type float.number.ratio
top_pins__closeups
Field label 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__closeup_rate
Field label Closeup rate
Description The ratio of closeups on a Pin to the number of times it was shown. (closeups/impressions)
Field type metric
Data type float.number.ratio
top_pins__outbound_clicks
Field label 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__outbound_click_rate
Field label Outbound click rate
Description The total number of clicks to the destination URL associated with your Pin divided by the total number of times your Pins were on screen. (outbound_clicks/impressions)
Field type metric
Data type float.number.ratio
top_pins__saves
Field label Saves
Description The number of times people saved your Pin to a board
Field type metric
Data type int.number.value
top_pins__save_rate
Field label Save rate
Description The total saves of your Pins divided by the total number of times your Pins were on screen. (saves/impressions)
Field type metric
Data type float.number.ratio
pin__pin_analytics__impressions
Field label Impressions
Description The number of times your Pins were on screen
Field type metric
Data type int.number.value
pin__pin_analytics__pin_clicks
Field label 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__pin_click_rate
Field label Pin click rate
Description The total number of clicks from your Pin or ad to content on or off Pinterest, divided by the total number of times your Pins or ads were on screen. (pin_clicks/impressions)
Field type metric
Data type float.number.ratio
pin__pin_analytics__outbound_clicks
Field label 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__outbound_click_rate
Field label Outbound click rate
Description The total number of clicks to the destination URL associated with your Pin divided by the total number of times your Pins were on screen. (outbound_clicks/impressions)
Field type metric
Data type float.number.ratio
pin__pin_analytics__saves
Field label Saves
Description The number of times people saved your Pin to a board
Field type metric
Data type int.number.value
pin__pin_analytics__save_rate
Field label Save rate
Description The total saves of your Pins divided by the total number of times your Pins were on screen. (saves/impressions)
Field type metric
Data type float.number.ratio

PROFILE

user_analytics__user__username
Field label Username
Description Username of the Pinterest account
Field type dimension
Data type string.text.value
user_analytics__user__account_type
Field label User account type
Description User account type
Field type dimension
Data type string.text.value
user_analytics__user__business_name
Field label Business name
Description The name of the business
Field type dimension
Data type string.text.value
user_analytics__user__profile_image_gs
Field label Profile image
Description URL to the profile image
Field type dimension
Data type string.text.url
Destinations Google Sheets
user_analytics__user__profile_image
Field label Profile image
Description URL to the profile image
Field type dimension
Data type string.text.url
Destinations
user_analytics__user__website_url
Field label Website URL
Description URL to the website
Field type dimension
Data type string.text.url

PROFILE LIFETIME

user_analytics__user__follower_count
Field label Followers
Description The number of followers
Field type metric
Data type int.number.value
user_analytics__user__following_count
Field label Following
Description The number of accounts following
Field type metric
Data type int.number.value
user_analytics__user__pin_count
Field label Pins
Description The number of Pins owned
Field type metric
Data type int.number.value
user_analytics__user__board_count
Field label Boards
Description The number of boards owned
Field type metric
Data type int.number.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
user_analytics__year
Field label Year
Field type dimension
Data type string.time.year
user_analytics__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
user_analytics__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
user_analytics__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
user_analytics__month
Field label Month
Field type dimension
Data type string.time.month
user_analytics__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
user_analytics__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
user_analytics__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
user_analytics__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
user_analytics__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
user_analytics__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
user_analytics__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
user_analytics__date
Field label Date
Field type dimension
Data type string.time.date
user_analytics__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
pin__pin_analytics__year
Field label Year
Field type dimension
Data type string.time.year
pin__pin_analytics__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
pin__pin_analytics__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
pin__pin_analytics__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
pin__pin_analytics__month
Field label Month
Field type dimension
Data type string.time.month
pin__pin_analytics__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
pin__pin_analytics__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
pin__pin_analytics__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
pin__pin_analytics__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
pin__pin_analytics__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
pin__pin_analytics__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
pin__pin_analytics__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
pin__pin_analytics__date
Field label Date
Field type dimension
Data type string.time.date
pin__pin_analytics__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

VIDEO

top_pins__video_mrc_view
Field label 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_10s_view
Field label 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_quartile_95_percent_view
Field label 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_avg_watch_time
Field label Average video play time (ms)
Description The average time (ms) someone spent playing the video and static image cards included in your Pin
Field type metric
Data type float.number.value
top_pins__video_v50_watch_time
Field label Total play time (ms)
Description The total play time for your video in milliseconds
Field type metric
Data type string.time.minute
top_pins__video_start
Field label Video starts
Description The total number of video starts
Field type metric
Data type int.number.value
top_pins__full_screen_play
Field label 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
Field label 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
pin__pin_analytics__video_mrc_view
Field label 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_10s_view
Field label 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_quartile_95_percent_view
Field label 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_avg_watch_time
Field label Average video play time
Description The average time someone spent playing the video and static image cards included in your Pin
Field type metric
Data type float.number.value
pin__pin_analytics__video_v50_watch_time
Field label Total play time (minutes)
Description The total play time for your video in minutes
Field type metric
Data type string.time.minute
pin__pin_analytics__video_start
Field label Video starts
Description The total number of video starts
Field type metric
Data type int.number.value