Pinterest Public Data fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Pinterest Public Data data into Google Sheets, Looker Studio, Power BI, Excel

8 metrics42 dimensions

ACCOUNT

id
Field label ID
Field type dimension
Data type int.number.value
full_name
Field label Name
Field type dimension
Data type string.text.value
about
Field label About
Field type dimension
Data type string.text.value
location
Field label Location
Field type dimension
Data type string.text.value
profile_url
Field label Link to profile
Field type dimension
Data type string.text.url
image_small_url
Field label Small image URL
Field type dimension
Data type string.text.url

ACCOUNT METRICS

pin_count
Field label Pin count
Field type metric
Data type int.number.value
follower_count
Field label Follower count
Field type metric
Data type int.number.value

ATTRIBUTION

attribution_author_name
Field label Attribution author name
Field type dimension
Data type string.text.value
attribution_title
Field label Attribution title
Field type dimension
Data type string.text.value
attribution_provider_name
Field label Attribution provider name
Field type dimension
Data type string.text.value
attribution_url
Field label Attribution URL
Field type dimension
Data type string.text.url
attribution_author_url
Field label Attribution author URL
Field type dimension
Data type string.text.url
attribution_provider_favicon_url
Field label Attribution provider favicon URL
Field type dimension
Data type string.text.url

BOARD

board_id
Field label Board ID
Field type dimension
Data type string.text.value
board_name
Field label Board name
Field type dimension
Data type string.text.value
board_description
Field label Board description
Field type dimension
Data type string.text.value
board_url
Field label Board URL
Field type dimension
Data type string.text.url
board_image_thumbnail_url
Field label Board thumbnail URL
Field type dimension
Data type string.text.url

BOARD METRICS

board_follower_count
Field label Board follower count
Field type metric
Data type int.number.value
board_pin_count
Field label Board pin count
Field type metric
Data type int.number.value

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

description
Field label Description
Field type dimension
Data type string.text.value
pinnedImageUrl
Field label Pinned image URL
Field type dimension
Data type string.text.url
pinnedImage
Field label Pinned image
Field type dimension
Data type string.text.formula
Destinations Google Sheets
domain
Field label Domain
Field type dimension
Data type string.text.value
is_video
Field label Is video
Field type dimension
Data type bool

PIN METRICS

repin_count
Field label Repin count
Field type metric
Data type int.number.value

PINNER

pinner_id
Field label Pinner ID
Field type dimension
Data type string.text.value
pinner_full_name
Field label Pinner full name
Field type dimension
Data type string.text.value
pinner_about
Field label Pinner about
Field type dimension
Data type string.text.value
pinner_location
Field label Pinner location
Field type dimension
Data type string.text.value
pinner_profile_url
Field label Pinner profile URL
Field type dimension
Data type string.text.url
pinner_image_small_url
Field label Pinner image small URL
Field type dimension
Data type string.text.url

PINNER METRICS

pinner_follower_count
Field label Pinner follower count
Field type metric
Data type int.number.value
pinner_pin_count
Field label Pinner pin count
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

URL SHARE

url
Field label URL
Field type dimension
Data type string.text.url

URL SHARE METRICS

count
Field label Times pinned
Field type metric
Data type int.number.value