Instagram Public Data fields

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

Supermetrics brings all your Instagram Public Data data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

8 metrics42 dimensions

ACCOUNT

ig_id
Field label Instagram ID
Description Profile's Instagram ID
Field type dimension
Data type string.text.value
username
Field label Username
Description Profile's username
Field type dimension
Data type string.text.value
name
Field label Name
Description Profile's name
Field type dimension
Data type string.text.value
biography
Field label Biography
Description Profile's biography
Field type dimension
Data type string.text.value
profile_picture_url
Field label Profile picture URL
Description URL to profile picture
Field type dimension
Data type string.text.value
website
Field label Website
Description Profile's website
Field type dimension
Data type string.text.url
followers
Field label Profile followers
Description Total number of unique accounts following this profile
Field type metric
Data type int.number.value
follows
Field label Profile follows
Description Total number of accounts this profile is following
Field type metric
Data type int.number.value
total_post_count
Field label Profile post count
Description Total number of posts for this profile
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

MEDIA

post_id
Field label Post ID
Description Graph ID of the post
Field type dimension
Data type string.text.value
post_timestamp
Field label Post created
Description Date and time post was added
Field type dimension
Data type string.time.datetime
post_type
Field label Post type
Description Type of post. PHOTO, VIDEO, etc
Field type dimension
Data type string.text.value
post_media_url
Field label Post media URL
Description URL to the post's media object
Field type dimension
Data type string.text.url
post_caption
Field label Post caption
Description Caption of the post
Field type dimension
Data type string.text.value
hashtag_name
Field label Matching hashtags
Description Hashtags from the post caption that match the hashtags supplied for the search
Field type dimension
Data type string.text.value
found_hashtags
Field label Hashtags
Description Hashtags included the post caption
Field type dimension
Data type string.text.value
hashtag_count
Field label Number of hashtags
Description The total number of hashtags found in the post caption
Field type dimension
Data type int.number.value
caption_length
Field label Caption length
Description The length of the post caption
Field type dimension
Data type int.number.value
caption_length_no_hashtags
Field label Caption length (not incl. hashtags)
Description The length of the post caption without the hashtags
Field type dimension
Data type int.number.value
post_comments
Field label Comments
Description Total number of comments on the post, including replies
Field type metric
Data type int.number.value
post_likes
Field label Likes
Description Total number of likes on the post, including replies
Field type metric
Data type int.number.value

POST METRICS

likes_per_post
Field label Likes per post
Description Count of likes per post
Field type metric
Data type float.number.value
comments_per_post
Field label Comments per post
Description Count of comments per post
Field type metric
Data type float.number.value
posts
Field label Posts
Description Posts
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
year
Field label Year
Field type dimension
Data type string.time.year
yearOfWeek
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
yearOfWeekIso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
yearMonth
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
yearWeek
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
yearWeekIso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
weekIso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
dayOfMonth
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
dayOfWeekName
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
dayOfWeekNameIso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date