Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Quarter | Quarter | dim | Quarter, e.g. 1 | |
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| ACCOUNT | Profile ID | account_id | dim | Profile's ID |
| Instagram ID | ig_id | dim | Profile's Instagram ID | |
| Username | username | dim | Profile's username | |
| Name | name | dim | Profile's name | |
| Biography | biography | dim | Profile's biography | |
| Website | website | dim | Profile's website | |
| PHOTO & VIDEO | Media ID | media_id | dim | Graph ID of the media object |
| Media created | timestamp | dim | Date and time media was added | |
| Media type | media_type | dim | Type of the media object. PHOTO, VIDEO, ... | |
| Media URL | media_url | dim | URL of the media object | |
| Media permalink | media_permalink | dim | URL of the post on Instagram | |
| Media product type | media_product_type | dim | Surface where the media is published. Can be AD, FEED, STORY, or REELS | |
| Media shortcode | media_shortcode | dim | Shortcode of the post on Instagram | |
| Video thumbnail URL | media_thumbnail_url | dim | URL of the video thumbnail | |
| Media caption | media_caption | dim | Caption of the post | |
| Media comments enabled | media_is_comment_enabled | dim | Whether or not the comments are enabled | |
| FOLLOWERS | Gender | audience_gender | dim | The gender distribution of this profile's followers |
| Age | audience_age | dim | The age distribution of this profile's followers | |
| Country | audience_country_dim | dim | The countries of this profile's followers | |
| Area & city | audience_city_dim | dim | The cities of this profile's followers with area information | |
| Area | audience_area_only_dim | dim | The areas of this profile's followers | |
| City | audience_city_only_dim | dim | The cities of this profile's followers | |
| DEPRECATED | IGTV video title | media_video_title | dim | Title of IGTV media object. Please note that this field will be removed on 2022-07-28 |
| Locale | audience_locale_dim | dim | The locales by country codes of this profile's followers. Please note that this field will be removed on 2023-12-11 | |
| ACCOUNT LIFETIME | Profile followers | followers_count | met | Total number of unique accounts following this profile |
| Profile follows | follows_count | met | Total number of accounts this profile is following | |
| Profile media count | media_count | met | Total number of media for this profile | |
| ACCOUNT INSIGHTS | New followers | follower_count | met | Total number of new followers each day within the specified range |
| Profile views | profile_views | met | Total number of unique accounts that have viewed this profile within the specified period | |
| Profile impressions | impressions | met | Total number of times this profile has been seen within the specified period | |
| Profile reach | reach | met | Total number of unique accounts that have seen this profile within the specified period. NOTE: When reach is split by month, reach will display last 28 days of month | |
| Email contacts | email_contacts | met | Total number of taps on the email link in this profile within the specified period | |
| Phone call clicks | phone_call_clicks | met | Total number of taps on the call link in this profile within the specified period | |
| Text message clicks | text_message_clicks | met | Total number of taps on the text message link in this profile within the specified period | |
| Get directions clicks | get_directions_clicks | met | Total number of taps on the directions link in this profile within the specified period | |
| Website clicks | website_clicks | met | Total number of taps on the website link in this profile within the specified period | |
| Profile replies | profile_replies | met | The number of replies you received from your story, including text replies and quick reaction replies, within the specified period | |
| PHOTO & VIDEO | Media count | number_of_media | met | Total number of media objects |
| Interactions | interactions | met | The number of likes, saves, comments and shares on your media minus the number of unlikes, unsaves, and deleted comments | |
| Comments count | media_comments_count | met | Total number of comments on the media object including replies | |
| Like count | media_like_count | met | Total number of likes on the media object including replies | |
| Media impressions | media_impressions | met | Total number of impressions of the media object | |
| Media reach | media_reach | met | Total reach of the media object | |
| Unique saves | media_saved | met | Total number of unique accounts that have saved the media object | |
| Shares | media_shares | met | The number of shares of your post. Album carousels and IGTV are not supported | |
| Profile visits | media_profile_visits | met | The number of times your profile was visited. Does not support Album carousels or IGTV | |
| Follows | media_follows | met | The number of accounts that started following you. Does not support Album carousels or IGTV | |
| PROFILE ACTIVITY FROM MEDIA | Profile activity total | media_profile_activity | met | Total number of actions people take when they visit your profile after engaging with your media. Does not support Album carousel, IGTV, or Reels |
| Profile activity: bio link clicks | media_bio_link_click | met | Number of bio link click actions people take when they visit your profile after engaging with your media. Does not support Album carousels, IGTV, or Reels | |
| Profile activity: phone call clicks | media_call_click | met | Number of phone call click actions people take when they visit your profile after engaging with your media. Does not support Album carousels, IGTV, or Reels | |
| Profile activity: get directions clicks | media_direction_click | met | Number of get direction click actions people take when they visit your profile after engaging with your media. Does not support Album carousels, IGTV, or Reels | |
| Profile activity: email clicks | media_email_click | met | Number of email click actions people take when they visit your profile after engaging with your media. Does not support Album carousels, IGTV, or Reels | |
| Profile activity: other clicks | media_other_click | met | Number of other click actions people take when they visit your profile after engaging with your media. Does not support Album carousels, IGTV, or Reels | |
| Profile activity: text message clicks | media_text_click | met | Number of text message click actions people take when they visit your profile after engaging with your media. Does not support Album carousels, IGTV, or Reels | |
| VIDEO | Video views | media_video_views | met | Total number of times the video has been seen. Returns 0 for videos in carousel albums |
| CAROUSEL | Carousel album impressions | media_carousel_album_impressions | met | Total number of times the carousel album has been seen |
| Carousel album reach | media_carousel_album_reach | met | Total number of unique accounts that have seen the carousel album | |
| Carousel album saved | media_carousel_album_saved | met | Total number of unique accounts that have saved the carousel album | |
| STORY (AVAIL. FOR LAST 24 H) | Story exits | media_story_exits | met | Number of times someone exited the story |
| Story impressions | media_story_impressions | met | Total number of times the story has been seen | |
| Story reach | media_story_reach | met | Total number of unique accounts that have seen the story | |
| Story replies | media_story_replies | met | Total number of replies to the story | |
| Taps forward | media_story_taps_forward | met | Total number of taps to see this story's next photo or video | |
| Taps back | media_story_taps_back | met | Total number of taps to see this story's previous photo or video | |
| REELS | Reel plays | media_reel_plays | met | 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 |
| Reel shares | media_reel_shares | met | Number of shares of the reel | |
| Total reel interactions | media_reel_total_interactions | met | Number of likes, saves, comments, and shares on the reel, minus the number of unlikes, unsaves, and deleted comments | |
| Reels average minutes watched | media_reel_avg_watch_time | met | The average amount of time spent playing the reel. This includes replays in a single instance, so the value may exceed the total duration of the video due to this | |
| Reels minutes viewed | media_reel_video_views | met | The total amount of time the reel was played, including any time spent replaying the reel | |
| DEPRECATED | Engagement | media_engagement | met | Total number of likes, comments, and saves on the media object |
| Carousel album engagement | media_carousel_album_engagement | met | Total number of likes and comments on the carousel album |