Fields Reference · Instagram
Instagram Fields List
104 fields · 0 dimensions · 0 metrics · 16 groups
BigQuery| Field name | Label | Category | Description |
|---|---|---|---|
caption | Post caption | Posts | It’s the Media object Caption |
comments | Post’s first 3 comments | Posts | It’s the list of (first) 3 comments |
comments_count | Post comments count | Posts | Number of total comments on the media object |
engagement | Post engagement | Posts | Total number of likes and IG Comments on the IG Media object. |
feed_likes | Post likes | Posts | Number of likes on the feed post |
id | Post ID | Posts | Media Object ID |
ig_id | IG ID | Posts | Instagram account Unique Identifier |
is_comment_enabled | Post comment enabled | Posts | Shows either if users are allowed to comment a post or not |
like_count | Post total like count | Posts | Number of likes posts get |
media_product_type | Media product type | Posts | Surface where the media is published. Can be AD, FEED, STORY or REELS. |
media_type | Post type | Posts | It’s the Post type (IMAGE, VIDEO or CAROUSEL_ALBUM) |
media_url | Post image URL | Posts | Post image url |
media_url_ins | Post image | Posts | Post on Instagram |
month_timestamp | Post date month | Posts | Date when the post was published |
permalink | Post link | Posts | INSTAGRAM LINK |
post_count | Posts count | Posts | Posts count |
post_engagement_rate | Post engagement rate | Posts | Post engagement rate: post engagements/post impressions. |
post_impressions | Post impressions | Posts | Number of times a post is shown |
post_reach | Post reach | Posts | Number of people that have seen a post |
quarter_timestamp | Post date quarter | Posts | Date when the post was published |
reels_comments | Reels comments | Posts | Number of comments on the reel |
reels_likes | Reels likes | Posts | Number of likes on the reel |
reels_plays | Reels plays | Posts | Number of times the reels starts to play after an impression is already counted. This is defined as video sessions with 1 ms or more of playback and excludes replays. |
reels_shares | Reels shares | Posts | Number of shares of the reel. |
reels_total_interactions | Reels total interactions | Posts | Number of likes, saves, comments, and shares on the reel, minus the number of unlikes, unsaves, and deleted comments. |
saved | Post saves | Posts | Number of times a post is saved |
timestamp | Post date | Posts | Date when the post was published |
timestamp_hour | Post hour of day | Posts | Hour when the post was published |
username | Post Owner Username | Posts | Owner’s Username |
video_views | Post video views | Posts | Number of video plays for at least 3 seconds |
week_day_timestamp | Post date week day | Posts | Date when the post was published |
week_timestamp | Post date week | Posts | Date when the post was published |
year_timestamp | Post date year | Posts | Date when the post was published |
year_week_timestamp | Post date year week | Posts | Date when the post was published |
exits | Story exits | Story | Number of times someone exited the story IG Media object |
replies | Stories replies | Story | Total number of replies (IG Comments) on the story IG Media object. |
story_id | Story ID | Story | Story ID |
story_impressions | Story impressions | Story | Total number of times the story IG Media object has been seen. |
story_media_picture | Story picture | Story | Story Picture |
story_media_type | Story type | Story | It’s the story media type (IMAGE, VIDEO) |
story_media_url | Story URL | Story | URL of the post on Instagram |
story_reach | Story reach | Story | Total number of unique Instagram accounts that have seen the story IG Media object. |
story_timestamp | Story date | Story | Date when the story was published |
story_timestamp_hour | Story hour of day | Story | Hour when the story was published |
swipe_forward | Stories swipe (forward) | Story | Total number of swipes forward on this story. |
taps_back | Stories taps (backwards) | Story | Total number of taps to see this story IG Media object’s previous photo or video. |
taps_forward | Stories taps (forward) | Story | Total number of taps to see this story IG Media object’s next photo or video. |
date | Date | Date | Date dimension |
hour | Hour of day | Date | Hour of day |
month_date | Month | Date | Month |
quarter_date | Quarter | Date | Quarter |
week_date | Week | Date | Week |
week_day_date | Day of week (Mon – Sun) | Date | Day of week (Mon – Sun) |
year_date | Year | Date | Year |
year_month_date | Month and year | Date | Month and year |
year_quarter_date | Quarter and year | Date | Quarter and year |
year_week_date | Week and year | Date | Week and year |
email_contacts | Taps on email link | Account Insights | Total number of taps on the email link in the IG User’s profile. |
follower_count | Profile new followers | Account Insights | Total number of new followers each day within the specified range. |
get_directions_clicks | Taps on directions link | Account Insights | Total number of taps on the directions link in the IG User’s profile. |
impressions | Profile impressions | Account Insights | Total number of times the IG User’s IG Media objects (i.e. posts, stories and promotions) have been viewed. Includes ad activity generated through the API, Facebook ads interfaces, and the Promote feature. Does not include profile views. |
phone_call_clicks | Taps on phone link | Account Insights | Total number of taps on the call link in the IG User’s profile. |
profile_views | Profile views | Account Insights | Total number of users who have viewed the IG User’s profile within the specified period. |
reach | Profile reach | Account Insights | Total number of times the IG User’s media objects (i.e. posts, stories and promotions) have been uniquely viewed. Includes ad activity generated through the API, Facebook ads interfaces, and the Promote feature. |
text_message_clicks | Taps on text message link | Account Insights | Total number of taps on the text message link in the IG User’s profile. |
website_clicks | Taps on website link | Account Insights | Total number of taps on the website link in the IG User’s profile. |
name | Account name | Account Info | Name of IG profile |
profile_id | Account ID | Account Info | Profile ID |
profile_ig_id | Account IG ID | Account Info | Profile IG ID |
profile_picture | Account picture | Account Info | Profile Picture |
profile_picture_url | Account picture URL | Account Info | Profile Picture URL |
profile_username | Username | Account Info | Username |
biography | Account biography | Account Metrics | Biography |
followers_count | Total followers | Account Metrics | Number of Followers |
follows_count | Account follows | Account Metrics | Number of follows |
media_count | Account posts count | Account Metrics | Number of media posts |
story_date | Account date | Account Metrics | Date dimension |
website | Account website | Account Metrics | Website |
audience_country | Followers country (metric) | Audience Country | Audience countries |
audience_country_code_related | Followers country code | Audience Country | Countries code |
audience_country_code_related_icon | Followers country icon | Audience Country | Followers country icon |
audience_country_code_related_icon_url | Followers country icon url | Audience Country | Countries icon url |
audience_country_name_related | Followers country | Audience Country | Followers country name |
online_followers | Online followers | Online Followers | Total number of the IG User’s followers who were online during the specified range |
online_followers_date | Online followers date | Online Followers | Date of the IG User’s followers who were online during the specified range |
online_followers_date_hour | Online followers date and hour | Online Followers | Date and hour of the IG User’s followers who were online during the specified range |
online_followers_day | Online followers day of week | Online Followers | The day of the IG User’s followers who were online during the specified range |
online_followers_hour | Online followers hour of day | Online Followers | The hours of the IG User’s followers who were online during the specified range |
audience_gender | Followers gender (metric) | Followers Gender | Audience gender quantity |
audience_gender_related | Followers gender | Followers Gender | The gender and age distribution of followers for whom we have demographic data. |
audience_gender_related_icon | Followers gender icon | Followers Gender | Followers gender icon |
audience_gender_related_icon_url | Followers gender icon url | Followers Gender | The gender and age distribution of followers for whom we have demographic data. |
audience_city | Followers city (metric) | Audience City | Audience city |
audience_city_related | Followers city | Audience City | Cities list |
audience_locale | Followers country and language code (metric) | Audience Country and Language Code | Audience locale |
audience_locale_related | Followers country and language code | Audience Country and Language Code | The locales by country codes of the IG User’s followers. Does not include current day’s data |
audience_gender_age | Followers gender & age (Metric) | Audience Gender and Age | Audience gender & age quantity |
audience_gender_age_related | Followers gender & age | Audience Gender and Age | Audience gender & age type |
end_date | End date | End date | End date |
end_time | End time | End date | End date |
audience_age | Followers age (metric) | Followers Age | Audience age groups quantity |
audience_age_related | Followers age | Followers Age | Audience age group |
real_time | Real time | Real time API | Get your data directly from Meta’s API, this field will increase your loading time but will give the exact number from the business manager. |
start_date | Start date | Start date | Start date |