Windsor brings all your Instagram data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Instagram Field Reference
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
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Alias for Instagram user ID | user_info |
| account_name | TEXT | Account Name | Instagram user name | user_info |
| 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_user_insights_lifetime |
| audience_locale_size | NUMERIC | (Deprecated) Number of followers for a locale | Instagram API doesn't support it anymore | deprecated_user_insights_lifetime |
| biography | TEXT | Instagram profile (account) biography | Instagram profile (account) biography | user_info |
| carousel_album_engagement | NUMERIC | Carousel album engagement | Total number of likes and comments on the carousel album | media_insights |
| carousel_album_impressions | NUMERIC | Carousel album impressions | Total number of times the carousel album has been seen | media_insights |
| carousel_album_reach | NUMERIC | Carousel album reach | Total number of unique Instagram accounts that have seen the carousel album | media_insights |
| carousel_album_saved | NUMERIC | Carousel album saved | Total number of unique accounts that have saved the carousel album | media_insights |
| carousel_album_video_views | NUMERIC | Carousel album video views | Total number of unique Instagram accounts that have viewed video within the carousel album. | media_insights |
| city | CITY | City | Follower's city | user_insights_lifetime_city |
| clicks | NUMERIC | Total clicks | Total number of taps on directions, call, text message, website links in the Instagram user's profile within a day | user_insights_day |
| 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 | |
| email_contacts_1d | NUMERIC | Email contacts (1 day) | Total number of taps on the email link in the Instagram user's profile within a day | user_insights_day |
| end_date | DATE | The current latest date of a lifetime period | The current latest date for lifetime metrics | Time |
| 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. | user_insights_day |
| followers_count | NUMERIC | Profile followers | Total number of unique accounts following this profile. Does not provide historical data. Provides the count for today. | user_info |
| follows_count | NUMERIC | Profile follows | Total number of accounts this profile is following | user_info |
| get_directions_clicks_1d | NUMERIC | Get directions clicks (1 day) | Total number of taps on the directions link in the Instagram user's profile within a day. | user_insights_day |
| impressions | NUMERIC | Alias for Impressions (1 day) | Alias for Impressions (1 day) | user_insights_day |
| impressions_1d | NUMERIC | Impressions (1 day) | Total number of times the Instagram user's Instagram Media have been viewed within a day. Does not include profile views. | user_insights_day |
| legacy_user_id | TEXT | Legacy Instagram user ID | Legacy Instagram user ID | user_info |
| media_caption | TEXT | Media caption | Caption of the post | media_info |
| 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_info |
| media_count | NUMERIC | Profile media count | Total number of media for this profile | user_info |
| media_engagement | NUMERIC | Media engagement | Sum of likes, comments, saved and shares count on the Instagram media object | media_insights |
| media_id | TEXT | Media ID | Media object ID. | media_info |
| media_impressions | NUMERIC | Media impressions | Total number of times the Instagram media object has been seen | media_insights |
| media_is_comment_enabled | TEXT | Media comments enabled | Whether or not the comments are enabled | media_info |
| 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_info |
| media_permalink | TEXT | Media permalink | URL of the post on Instagram | media_info |
| media_plays | NUMERIC | Media plays | Total number of times the Instagram reels object has been played | media_insights |
| media_product_type | TEXT | Media product type | Surface where the media is published. Can be AD, FEED, IGTV, or STORY | media_info |
| media_reach | NUMERIC | Media reach | Total number of unique Instagram accounts that have seen the Instagram media object. | media_insights |
| media_saved | NUMERIC | Media saved | Total number of unique Instagram accounts that have saved the Instagram media object | media_insights |
| media_shortcode | TEXT | Media shortcode | Shortcode of the post on Instagram | media_info |
| media_thumbnail_url | IMAGE_URL | Video thumbnail URL | URL of the video thumbnail | media_info |
| media_type | TEXT | Media type | Type of the media object (IMAGE, VIDEO, CAROUSEL_ALBUM, REEL) | media_info |
| media_url | IMAGE_URL | Media URL | URL of the media object | media_info |
| media_video_views | NUMERIC | 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_insights |
| month | TEXT | Month | Number of the month | |
| name | TEXT | Instagram profile (account) name | Instagram profile (account) name | user_info |
| phone_call_clicks_1d | NUMERIC | Phone call clicks (1 day) | Total number of taps on the call link in Instagram user's profile within a day | user_insights_day |
| profile_views | NUMERIC | Profile Views (1 day) | Total number of users who have viewed the Business Account's profile within the specified period | user_insights_day |
| profile_views_1d | NUMERIC | Profile views (1 day) | Total number of users who have viewed the Instagram user's profile within a day | user_insights_day |
| reach | NUMERIC | Reach | Alias for Profile reach (1 day) | user_insights_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 | user_insights_day |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| story_exits | NUMERIC | Story exits | Number of times someone exited the story. Stories are only available for 24 hours. | story_insights (navigation) |
| story_id | TEXT | Story ID | Story ID. Stories are only available for 24 hours. | story_info |
| story_impressions | NUMERIC | Story impressions | Total number of times the story has been seen. Stories are only available for 24 hours. | story_insights |
| 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_reach | NUMERIC | Story reach | Total number of unique accounts that have seen the story. Stories are only available for 24 hours. | story_insights |
| story_replies | NUMERIC | Story replies | Total number of replies to the story. Stories are only available for 24 hours. | story_insights |
| story_swipe_forward | NUMERIC | Story swipe forward | Total number of swipes forward. Stories are only available for 24 hours. | story_insights (navigation) |
| story_taps_back | NUMERIC | Story taps back | Total number of taps to see this story's previous photo or video. Stories are only available for 24 hours. | story_insights (navigation) |
| story_taps_forward | NUMERIC | Story taps forward | Total number of taps to see this story's next photo or video. Stories are only available for 24 hours. | story_insights (navigation) |
| text_message_clicks_1d | NUMERIC | Text message clicks (1 day) | Total number of taps on the text message link in the Instagram user's profile within a day | user_insights_day |
| timestamp | TIMESTAMP | Media created | Date and time when media was added | media_info |
| today | DATE | Today | Today's date | |
| user_id | TEXT | Instagram user ID | Instagram user ID | user_info |
| user_name | TEXT | Instagram user name (alias) | Alias for Instagram user name | user_info |
| username | TEXT | Instagram user name | Instagram user name | user_info |
| website | TEXT | Linked website | Link to your website that is displayed on your Instagram profile page | user_info |
| website_clicks_1d | NUMERIC | Linked website clicks (1 day) | Total number of taps on the website link in the Instagram user's profile | user_insights_day |
| 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_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 |