Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Instagram Insights data to
Instagram Insights Connector Reference
50 metrics48 dimensions
Query sample
https://connectors.windsor.ai/instagram?api_key=[your API key]&date_preset=last_7d&fields=date,user_name,account_id,website,followers_count,follows_count,media_count,media_id,media_type,media_url,media_comments_count,media_like_count,media_impressions,media_reach,media_engagement,carousel_album_engagement&_renderer=csv
The Instagram Insights connector exposes 98 fields (50 metrics, 48 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available actions
Create Carousel Post Publish a multi-image carousel post to a connected Instagram Business or Creator account. Provide 2 to 10 publicly accessible image URLs (JPEG, at most 8 MB each, aspect ratio between 4:5 and 1.91:1) and an optional caption; images are shown in the given order. Video carousel items are not supported. For other formats use create_image_post, create_video_post or create_story.
Publish a multi-image carousel post to a connected Instagram Business or Creator account. Provide 2 to 10 publicly accessible image URLs (JPEG, at most 8 MB each, aspect ratio between 4:5 and 1.91:1) and an optional caption; images are shown in the given order. Video carousel items are not supported. For other formats use create_image_post, create_video_post or create_story.
Parameters
image_urlsarrayRequiredcaptionstring
Create Comment Post a comment on a media object (post, reel) of a connected Instagram Business or Creator account. media_id is an Instagram media object id, as returned by the media_id read field. The comment is public and is attributed to the account. Comments on live videos are not supported, and the media must have comments enabled.
Post a comment on a media object (post, reel) of a connected Instagram Business or Creator account. media_id is an Instagram media object id, as returned by the media_id read field. The comment is public and is attributed to the account. Comments on live videos are not supported, and the media must have comments enabled.
Parameters
media_idstringRequiredmessagestringRequired
Create Image Post Publish a single image post (feed photo) to a connected Instagram Business or Creator account. Provide a publicly accessible image URL and an optional caption. The image must be a JPEG, at most 8 MB, with an aspect ratio between 4:5 and 1.91:1. For other formats use create_video_post, create_story or create_carousel_post.
Publish a single image post (feed photo) to a connected Instagram Business or Creator account. Provide a publicly accessible image URL and an optional caption. The image must be a JPEG, at most 8 MB, with an aspect ratio between 4:5 and 1.91:1. For other formats use create_video_post, create_story or create_carousel_post.
Parameters
image_urlstringRequiredcaptionstring
Create Story Publish a story to a connected Instagram Business or Creator account. Provide exactly one of image_url (JPEG, at most 8 MB) or video_url (MP4 or MOV, at most 100 MB, 3 to 60 seconds long), publicly accessible; a 9:16 aspect ratio is recommended. Stories do not support captions and disappear after 24 hours. For feed posts use create_image_post, create_video_post or create_carousel_post.
Publish a story to a connected Instagram Business or Creator account. Provide exactly one of image_url (JPEG, at most 8 MB) or video_url (MP4 or MOV, at most 100 MB, 3 to 60 seconds long), publicly accessible; a 9:16 aspect ratio is recommended. Stories do not support captions and disappear after 24 hours. For feed posts use create_image_post, create_video_post or create_carousel_post.
Parameters
image_urlstringvideo_urlstring
Create Video Post Publish a single video post to a connected Instagram Business or Creator account. Instagram publishes all single-video feed posts as Reels. Provide a publicly accessible video URL and an optional caption. The video must be an MP4 or MOV, at most 1 GB, between 3 seconds and 15 minutes long; a 9:16 aspect ratio is recommended. The cover image defaults to the first frame and can be overridden with either cover_url (a publicly accessible JPEG URL) or thumb_offset (frame position in milliseconds), but not both. share_to_feed controls whether the Reel also appears in the main feed (Instagram defaults to showing it there). For other formats use create_image_post, create_story or create_carousel_post.
Publish a single video post to a connected Instagram Business or Creator account. Instagram publishes all single-video feed posts as Reels. Provide a publicly accessible video URL and an optional caption. The video must be an MP4 or MOV, at most 1 GB, between 3 seconds and 15 minutes long; a 9:16 aspect ratio is recommended. The cover image defaults to the first frame and can be overridden with either cover_url (a publicly accessible JPEG URL) or thumb_offset (frame position in milliseconds), but not both. share_to_feed controls whether the Reel also appears in the main feed (Instagram defaults to showing it there). For other formats use create_image_post, create_story or create_carousel_post.
Parameters
video_urlstringRequiredcaptionstringcover_urlstringthumb_offsetstringshare_to_feedstring
Delete Comment Delete a comment on a media object of a connected Instagram Business or Creator account. comment_id is an Instagram comment id, as returned by the comment_id read field. Works on any comment on the account's own media, including other users' comments. This is permanent; to only restrict visibility use hide_comment instead.
Delete a comment on a media object of a connected Instagram Business or Creator account. comment_id is an Instagram comment id, as returned by the comment_id read field. Works on any comment on the account's own media, including other users' comments. This is permanent; to only restrict visibility use hide_comment instead.
Parameters
comment_idstringRequired
Hide Comment Hide a comment on a media object of a connected Instagram Business or Creator account, leaving it visible only to its author and the account. comment_id is an Instagram comment id, as returned by the comment_id read field. Works on any comment on the account's own media, including other users' comments. Reversible with unhide_comment.
Hide a comment on a media object of a connected Instagram Business or Creator account, leaving it visible only to its author and the account. comment_id is an Instagram comment id, as returned by the comment_id read field. Works on any comment on the account's own media, including other users' comments. Reversible with unhide_comment.
Parameters
comment_idstringRequired
Reply to Comment Reply to a comment on a media object of a connected Instagram Business or Creator account. comment_id is an Instagram comment id, as returned by the comment_id read field. The reply is public and attributed to the account. To comment on the media itself rather than reply to a comment, use create_comment.
Reply to a comment on a media object of a connected Instagram Business or Creator account. comment_id is an Instagram comment id, as returned by the comment_id read field. The reply is public and attributed to the account. To comment on the media itself rather than reply to a comment, use create_comment.
Parameters
comment_idstringRequiredmessagestringRequired
Unhide Comment Unhide a previously hidden comment on a media object of a connected Instagram Business or Creator account, making it publicly visible again. comment_id is an Instagram comment id, as returned by the comment_id read field. Reversible with hide_comment.
Unhide a previously hidden comment on a media object of a connected Instagram Business or Creator account, making it publicly visible again. comment_id is an Instagram comment id, as returned by the comment_id read field. Reversible with hide_comment.
Parameters
comment_idstringRequired
Instagram Insights Fields
Instagram Insights comments fields
The comments report of the Instagram Insights connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| comment_id | TEXT | Comment ID | Unique ID linked to an Instagram comment. |
| comment_like_count | NUMERIC | Comment Like Count | The number of like reactions on the comment. |
| comment_parent_id | TEXT | Comment Parent ID | Unique ID associated with the Instagram comment if the comment was shared as a reply. Non existent field if comment has no parent comment. |
| comment_reply_count | NUMERIC | Comment Reply Count | The total number of replies to a comment. |
| comment_text | TEXT | Comment Text | The text of the Instagram comment. Tags are excluded. |
| comment_timestamp | Comment Timestamp | The time the Instagram comment was created. |
Instagram Insights media_info fields
The media_info report of the Instagram Insights connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| media_caption | TEXT | Media caption | Caption of the post |
| media_collaborators | TEXT | Media collaborators | Usernames of accounts co-authoring the post (Instagram Collab), comma separated. Empty for posts without collaborators. |
| media_comments_count | NUMERIC | Comments count | Count of comments on the media. Excludes comments on album child media and the media's caption. Includes replies on comments. |
| media_id | TEXT | Media ID | Media object ID. |
| media_is_comment_enabled | TEXT | Media comments enabled | Whether or not the comments are enabled |
| media_like_count | NUMERIC | Media Like Count | Count of likes on the media. Excludes likes on album child media and likes on promoted posts created from the media. Includes replies on comments. |
| media_permalink | TEXT | Media permalink | URL of the post on Instagram |
| media_product_type | TEXT | Media product type | Surface where the media is published. Can be AD, FEED, IGTV, or STORY |
| media_shortcode | TEXT | Media shortcode | Shortcode of the post on Instagram |
| media_thumbnail_url | IMAGE_URL | Video thumbnail URL | URL of the video thumbnail |
| media_type | TEXT | Media type | Type of the media object (IMAGE, VIDEO, CAROUSEL_ALBUM, REEL) |
| media_url | IMAGE_URL | Media URL | URL of the media object |
| timestamp | Media created | Date and time when media was added. For stories, use the Story Created (story_timestamp) field instead. |
Instagram Insights media_insights fields
The media_insights report of the Instagram Insights connector includes 22 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| carousel_album_engagement | NUMERIC | Carousel album engagement | Total number of likes and comments on the carousel album |
| carousel_album_impressions | NUMERIC | (Deprecated) Carousel album impressions | Total number of times the carousel album has been seen |
| carousel_album_reach | NUMERIC | Carousel album reach | Total number of unique Instagram accounts that have seen the carousel album |
| carousel_album_saved | NUMERIC | Carousel album saved | Total number of unique accounts that have saved the carousel album |
| carousel_album_video_views | NUMERIC | (Deprecated) Carousel album video views | Total number of unique Instagram accounts that have viewed video within the carousel album. |
| media_all_plays | NUMERIC | (Deprecated) Media plays + replays | Total number of times the Instagram reels object has been played or replayed |
| media_engagement | NUMERIC | Media engagement | Sum of likes, comments, saved and shares count on the Instagram media object |
| media_follows | NUMERIC | Media follows | Number of accounts that started following the profile after viewing this media. Identifies the content that drives follows. Not supported for reels. |
| media_impressions | NUMERIC | (Deprecated) Media impressions | Total number of times the Instagram media object has been seen |
| media_plays | NUMERIC | (Deprecated) Media plays | Total number of times the Instagram reels object has been played |
| media_profile_activity | NUMERIC | Media profile activity | Sum of profile actions (such as bio link taps, calls, and direction requests) taken after this media was viewed. Not supported for reels. |
| media_profile_visits | NUMERIC | Media profile visits | Number of times the profile was visited after this media was viewed. Not supported for reels. |
| media_reach | NUMERIC | Media reach | Total number of unique Instagram accounts that have seen the Instagram media object. |
| media_reel_avg_watch_time | NUMERIC | Media reel average watch time | Average watch time for the Instagram reel in milliseconds |
| media_reel_skip_rate | PERCENT | Media reel skip rate | Percentage of views where the viewer skipped the Instagram reel within the first 3 seconds |
| media_reel_total_interactions | NUMERIC | Media reel total interactions | Number of likes, saves, comments, and shares on the Instagram reel, minus the number of unlikes, unsaves, and deleted comments |
| media_reel_total_watch_time | NUMERIC | Media reel total watch time | Total amount of time the reel was played, including any time spent replaying the reel. Value is in milliseconds. |
| media_reel_video_views | NUMERIC | (Deprecated) Media reel video views | (Deprecated) Total amount of time the reel was played, including any time spent replaying the reel. Value is in milliseconds. Use media_reel_total_watch_time instead. |
| media_saved | NUMERIC | Media saved | Total number of unique Instagram accounts that have saved the Instagram media object |
| media_shares | NUMERIC | Media shares | Total number of times the Instagram media object has been shared |
| media_video_views | NUMERIC | (Deprecated) Media video views | Total number of times the video Instagram Media has been seen. For album Instagram media, the number of times all videos within the album have been seen. |
| media_views | NUMERIC | Media views | Total number of times the Instagram media has been seen |
Instagram Insights story_insights fields
The story_insights report of the Instagram Insights connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| story_impressions | NUMERIC | (Deprecated) Story impressions | Total number of times the story has been seen. Stories are only available for 24 hours. |
| story_interactions | NUMERIC | Story Interactions | Sum of likes, comments, saved and shares count on the story |
| story_reach | NUMERIC | Story reach | Total number of unique accounts that have seen the story. Stories are only available for 24 hours. |
| story_replies | NUMERIC | Story replies | Total number of replies to the story. Stories are only available for 24 hours. |
| story_shares | NUMERIC | Story shares | Total number of times the Story has been shared. |
| story_views | NUMERIC | Story views | Total number of times the story has been seen. Stories are only available for 24 hours. |
Instagram Insights user_info fields
The user_info report of the Instagram Insights connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Alias for Instagram user ID |
| account_name | TEXT | Account Name | Instagram user name |
| biography | TEXT | Instagram profile (account) biography | Instagram profile (account) biography |
| followers_count | NUMERIC | Profile followers | Total number of unique accounts following this profile. Does not provide historical data. Provides the count for today. |
| follows_count | NUMERIC | Profile follows | Total number of accounts this profile is following |
| legacy_user_id | TEXT | Legacy Instagram user ID | Legacy Instagram user ID |
| media_count | NUMERIC | Profile media count | Total number of media for this profile. Provides the count for today. |
| name | TEXT | Instagram profile (account) name | Instagram profile (account) name |
| user_id | TEXT | Instagram user ID | Instagram user ID |
| user_name | TEXT | Instagram user name (alias) | Alias for Instagram user name |
| username | TEXT | Instagram user name | Instagram user name |
| website | TEXT | Linked website | Link to your website that is displayed on your Instagram profile page |
Instagram Insights user_insights_day fields
The user_insights_day report of the Instagram Insights connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| clicks | NUMERIC | (Deprecated) Total clicks | Total number of taps on directions, call, text message, website links in the Instagram user's profile within a day |
| email_contacts_1d | NUMERIC | (Deprecated) Email contacts (1 day) | Total number of taps on the email link in the Instagram user's profile within a day |
| follower_count | NUMERIC | New followers | Alias for New followers (1 day) |
| follower_count_1d | NUMERIC | New followers (1 day) | Total number of new followers within a day. Not available on users with fewer than 100 followers. Supports querying data for the last 30 days excluding the current day. |
| get_directions_clicks_1d | NUMERIC | (Deprecated) Get directions clicks (1 day) | Total number of taps on the directions link in the Instagram user's profile within a day. |
| impressions | NUMERIC | (Deprecated) Alias for Impressions (1 day) | Alias for Impressions (1 day) |
| impressions_1d | NUMERIC | (Deprecated) Impressions (1 day) | Total number of times the Instagram user's Instagram Media have been viewed within a day. Does not include profile views. |
| phone_call_clicks_1d | NUMERIC | (Deprecated) Phone call clicks (1 day) | Total number of taps on the call link in Instagram user's profile within a day |
| profile_views | NUMERIC | (Deprecated) Profile Views (1 day) | Total number of users who have viewed the Business Account's profile within the specified period |
| profile_views_1d | NUMERIC | (Deprecated) Profile views (1 day) | Total number of users who have viewed the Instagram user's profile within a day |
| reach | NUMERIC | Reach | Alias for Profile reach (1 day) |
| reach_1d | NUMERIC | Profile reach (1 day) | Total number of unique users who have viewed at least one of the Instagram user's Instagram Media |
| text_message_clicks_1d | NUMERIC | (Deprecated) Text message clicks (1 day) | Total number of taps on the text message link in the Instagram user's profile within a day |
| website_clicks_1d | NUMERIC | (Deprecated) Linked website clicks (1 day) | Total number of taps on the website link in the Instagram user's profile |
Instagram Insights user_insights_day_total_value fields
The user_insights_day_total_value report of the Instagram Insights connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| accounts_engaged | NUMERIC | Accounts engaged | Number of accounts that have interacted with your content, including in ads. Content includes posts, stories, reels, videos, and live videos. |
| comments | NUMERIC | Comments | Number of comments on your posts, reels, videos, and live videos. |
| likes | NUMERIC | Likes | Number of likes on your posts, reels, and videos. |
| profile_links_taps | NUMERIC | Profile links taps | Number of taps on your business address, call button, email button, and text button. |
| replies | NUMERIC | Replies | Number of replies you received from your story, including text replies and quick reaction replies. |
| reposts | NUMERIC | Reposts | Number of reposts of your posts, stories, reels, and videos. |
| saves | NUMERIC | Saves | Number of saves of your posts, reels, and videos. |
| shares | NUMERIC | Shares | Number of shares of your posts, stories, reels, videos, and live videos. |
| total_interactions | NUMERIC | Total interactions | Total number of post interactions, story interactions, reels interactions, video interactions, and live video interactions, including any interactions on boosted content. |
| views | NUMERIC | Views | Total number of times your content was played or displayed. Content includes reels, posts, and stories. |
Instagram Insights other fields
The Instagram Insights connector has 37 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| audience_age_name | TEXT | Age group name | Age group name | user_insights_lifetime_age |
| audience_age_size | NUMERIC | Number of followers of a age group | The lifetime number of an Instagram profile followers who belong to a age group | user_insights_lifetime_age |
| audience_city_size | NUMERIC | Number of followers from a city | The lifetime number of an Instagram profile followers from a city | user_insights_lifetime_city |
| audience_country_name | COUNTRY | Audience Country Name | Follower's country code | user_insights_lifetime_country |
| audience_country_size | NUMERIC | Number of followers from a country | The lifetime number of an Instagram profile followers from a country | user_insights_lifetime_country |
| audience_gender_age_name | TEXT | Gender/Age group name | Gender/age group name | user_insights_lifetime_gender_age |
| audience_gender_age_size | NUMERIC | Number of followers of a gender/age group | The lifetime number of an Instagram profile followers who belong to a gender/age group | user_insights_lifetime_gender_age |
| audience_gender_name | TEXT | Gender group name | Gender group name | user_insights_lifetime_gender |
| audience_gender_size | NUMERIC | Number of followers of a gender group | The lifetime number of an Instagram profile followers who belong to a gender group | user_insights_lifetime_gender |
| audience_locale_name | TEXT | (Deprecated) Locale name | Instagram API doesn't support it anymore | Deprecated |
| audience_locale_size | NUMERIC | (Deprecated) Number of followers for a locale | Instagram API doesn't support it anymore | Deprecated |
| city | CITY | City | Follower's city | user_insights_lifetime_city |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date | Time |
| day_of_month | TEXT | Day of month | Day of the month | |
| end_date | DATE | The current latest date of a lifetime period | The current latest date for lifetime metrics | Time |
| follows_and_unfollows | NUMERIC | Follows and unfollows | Number of accounts that followed you and the number of accounts that unfollowed you or left Instagram in the selected time period. | user_insights_day_total_value_breakdown |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| story_id | TEXT | Story ID | Story ID. Stories are only available for 24 hours. | story_info |
| story_permalink | TEXT | Permanent URL to the media. | Total number of taps to see this story's previous photo or video. Stories are only available for 24 hours. | ig_media_info |
| story_thumbnail_url | IMAGE_URL | Story thumbnail URL | URL of the story thumbnail image. Available for video stories. Stories are only available for 24 hours. | ig_media_info |
| story_timestamp | Story Created | Date and time when the story was published. Stories are only available for 24 hours. | story_info | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |