[{"id":"account_id","name":"Account ID","type":"TEXT","description":"Alias for Instagram user ID","table":"user_info","upstream_api_request_name":"id","upstream_api_response_name":"id"},{"id":"account_name","name":"Account Name","type":"TEXT","description":"Instagram user name","table":"user_info","upstream_api_request_name":"username","upstream_api_response_name":"username"},{"id":"accounts_engaged","name":"Accounts engaged","type":"NUMERIC","description":"Number of accounts that have interacted with your content, including in ads. Content includes posts, stories, reels, videos, and live videos.","table":"user_insights_day_total_value","upstream_api_request_name":"accounts_engaged","upstream_api_response_name":"accounts_engaged"},{"id":"audience_age_name","name":"Age group name","type":"TEXT","description":"Age group name","table":"user_insights_lifetime_age","cached":false,"upstream_api_request_name":"follower_demographics__age__name","upstream_api_response_name":"follower_demographics__age__name"},{"id":"audience_age_size","name":"Number of followers of a age group","type":"NUMERIC","description":"The lifetime number of an Instagram profile followers who belong to a age group","table":"user_insights_lifetime_age","cached":false,"upstream_api_request_name":"follower_demographics__age__size","upstream_api_response_name":"follower_demographics__age__size"},{"id":"audience_city_size","name":"Number of followers from a city","type":"NUMERIC","description":"The lifetime number of an Instagram profile followers from a city","table":"user_insights_lifetime_city","cached":false,"upstream_api_request_name":"follower_demographics__city__size","upstream_api_response_name":"follower_demographics__city__size"},{"id":"audience_country_name","name":"Audience Country Name","type":"COUNTRY","description":"Follower's country code","table":"user_insights_lifetime_country","cached":false,"upstream_api_request_name":"follower_demographics__country__name","upstream_api_response_name":"follower_demographics__country__name"},{"id":"audience_country_size","name":"Number of followers from a country","type":"NUMERIC","description":"The lifetime number of an Instagram profile followers from a country","table":"user_insights_lifetime_country","cached":false,"upstream_api_request_name":"follower_demographics__country__size","upstream_api_response_name":"follower_demographics__country__size"},{"id":"audience_gender_age_name","name":"Gender/Age group name","type":"TEXT","description":"Gender/age group name","table":"user_insights_lifetime_gender_age","cached":false,"upstream_api_request_name":"follower_demographics__age,gender__name","upstream_api_response_name":"follower_demographics__age_gender__name"},{"id":"audience_gender_age_size","name":"Number of followers of a gender/age group","type":"NUMERIC","description":"The lifetime number of an Instagram profile followers who belong to a gender/age group","table":"user_insights_lifetime_gender_age","cached":false,"upstream_api_request_name":"follower_demographics__age,gender__size","upstream_api_response_name":"follower_demographics__age_gender__size"},{"id":"audience_gender_name","name":"Gender group name","type":"TEXT","description":"Gender group name","table":"user_insights_lifetime_gender","cached":false,"upstream_api_request_name":"follower_demographics__gender__name","upstream_api_response_name":"follower_demographics__gender__name"},{"id":"audience_gender_size","name":"Number of followers of a gender group","type":"NUMERIC","description":"The lifetime number of an Instagram profile followers who belong to a gender group","table":"user_insights_lifetime_gender","cached":false,"upstream_api_request_name":"follower_demographics__gender__size","upstream_api_response_name":"follower_demographics__gender__size"},{"id":"audience_locale_name","name":"(Deprecated) Locale name","type":"TEXT","description":"Instagram API doesn't support it anymore","cached":false,"table":"Deprecated","upstream_api_request_name":"audience_locale_name","upstream_api_response_name":"audience_locale_name"},{"id":"audience_locale_size","name":"(Deprecated) Number of followers for a locale","type":"NUMERIC","description":"Instagram API doesn't support it anymore","cached":false,"table":"Deprecated","upstream_api_request_name":"audience_locale_size","upstream_api_response_name":"audience_locale_size"},{"id":"biography","name":"Instagram profile (account) biography","type":"TEXT","description":"Instagram profile (account) biography","table":"user_info","upstream_api_request_name":"biography","upstream_api_response_name":"biography"},{"id":"carousel_album_engagement","name":"Carousel album engagement","type":"NUMERIC","description":"Total number of likes and comments on the carousel album","table":"media_insights","media_types":["CAROUSEL_ALBUM"],"upstream_api_request_name":"total_interactions","upstream_api_response_name":"total_interactions","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"carousel_album_impressions","name":"(Deprecated) Carousel album impressions","type":"NUMERIC","description":"Total number of times the carousel album has been seen","table":"media_insights","media_types":["CAROUSEL_ALBUM"],"upstream_api_request_name":"impressions","upstream_api_response_name":"impressions","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"carousel_album_reach","name":"Carousel album reach","type":"NUMERIC","aggregate_formula":null,"description":"Total number of unique Instagram accounts that have seen the carousel album","table":"media_insights","media_types":["CAROUSEL_ALBUM"],"upstream_api_request_name":"reach","upstream_api_response_name":"reach","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"carousel_album_saved","name":"Carousel album saved","type":"NUMERIC","description":"Total number of unique accounts that have saved the carousel album","table":"media_insights","media_types":["CAROUSEL_ALBUM"],"upstream_api_request_name":"saved","upstream_api_response_name":"saved","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"carousel_album_video_views","name":"(Deprecated) Carousel album video views","type":"NUMERIC","description":"Total number of unique Instagram accounts that have viewed video within the carousel album.","table":"media_insights","media_types":["CAROUSEL_ALBUM"],"upstream_api_request_name":"video_views","upstream_api_response_name":"video_views","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"city","name":"City","type":"CITY","description":"Follower's city","table":"user_insights_lifetime_city","cached":false,"upstream_api_request_name":"follower_demographics__city__name","upstream_api_response_name":"follower_demographics__city__name"},{"id":"clicks","name":"(Deprecated) Total clicks","type":"NUMERIC","description":"Total number of taps on directions, call, text message, website links in the Instagram user's profile within a day","formula":"to_int(user_insights_day_get_directions_clicks) + to_int(user_insights_day_phone_call_clicks) + to_int(user_insights_day_text_message_clicks) + to_int(user_insights_day_website_clicks)","table":"user_insights_day","upstream_api_request_name":"clicks","upstream_api_response_name":"clicks"},{"id":"comment_id","name":"Comment ID","type":"TEXT","description":"Unique ID linked to an Instagram comment.","table":"comments","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"id","upstream_api_response_name":"id","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"comment_like_count","name":"Comment Like Count","type":"NUMERIC","description":"The number of like reactions on the comment.","table":"comments","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"like_count","upstream_api_response_name":"like_count","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"comment_parent_id","name":"Comment Parent ID","type":"TEXT","description":"Unique ID associated with the Instagram comment if the comment was shared as a reply. Non existent field if comment has no parent comment.","table":"comments","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"parent_id","upstream_api_response_name":"parent_id","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"comment_reply_count","name":"Comment Reply Count","type":"NUMERIC","description":"The total number of replies to a comment.","table":"comments","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"replies","upstream_api_response_name":"reply_count","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"comment_text","name":"Comment Text","type":"TEXT","description":"The text of the Instagram comment. Tags are excluded.","table":"comments","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"text","upstream_api_response_name":"text","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"comment_timestamp","name":"Comment Timestamp","type":"TIMESTAMP","description":"The time the Instagram comment was created.","table":"comments","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"timestamp","upstream_api_response_name":"timestamp","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"comment_username","name":"Comment Username","type":"TEXT","description":"Username of the Instagram user who wrote the comment. Empty unless the connected user can moderate comments on the Facebook Page linked to the Instagram account.","table":"comments","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"username","upstream_api_response_name":"username","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"comments","name":"Comments","type":"NUMERIC","description":"Number of comments on your posts, reels, videos, and live videos.","table":"user_insights_day_total_value","upstream_api_request_name":"comments","upstream_api_response_name":"comments"},{"id":"data_fetched_at","name":"Data fetched at","description":"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.","type":"TIMESTAMP","aggregate_formula":null,"windsor_custom_field":true},{"id":"datasource","name":"Data Source","type":"TEXT","description":"The name of the Windsor connector returning the row","windsor_custom_field":true},{"id":"date","name":"Date","type":"DATE","description":"Date. For media, story and comment rows, the date the media was published. The date range selects media by this date.","table":"Time","upstream_api_request_name":"date","upstream_api_response_name":"date"},{"id":"day_of_month","name":"Day of month","description":"Day of the month","type":"TEXT","date_aggregation_type":"date","windsor_custom_field":true},{"id":"email_contacts_1d","name":"(Deprecated) Email contacts (1 day)","type":"NUMERIC","description":"Total number of taps on the email link in the Instagram user's profile within a day","table":"user_insights_day","upstream_api_request_name":"email_contacts","upstream_api_response_name":"email_contacts"},{"id":"end_date","name":"The current latest date of a lifetime period","type":"DATE","description":"The current latest date for lifetime metrics","table":"Time","upstream_api_request_name":"end_date","upstream_api_response_name":"end_date"},{"id":"follower_count","name":"New followers","type":"NUMERIC","description":"Alias for New followers (1 day)","table":"user_insights_day","upstream_api_request_name":"follower_count","upstream_api_response_name":"follower_count"},{"id":"follower_count_1d","name":"New followers (1 day)","type":"NUMERIC","description":"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.","table":"user_insights_day","upstream_api_request_name":"follower_count","upstream_api_response_name":"follower_count"},{"id":"followers_count","name":"Profile followers","type":"NUMERIC","description":"Total number of unique accounts following this profile. Does not provide historical data. Provides the count for today.","table":"user_info","upstream_api_request_name":"followers_count","upstream_api_response_name":"followers_count","aggregate_formula":null},{"id":"follows_and_unfollows","name":"Follows and unfollows","type":"NUMERIC","description":"Number of accounts that followed you and the number of accounts that unfollowed you or left Instagram in the selected time period.","table":"user_insights_day_total_value_breakdown","upstream_api_request_name":"follows_and_unfollows__follow_type","upstream_api_response_name":"follows_and_unfollows"},{"id":"follows_count","name":"Profile follows","type":"NUMERIC","description":"Total number of accounts this profile is following","table":"user_info","upstream_api_request_name":"follows_count","upstream_api_response_name":"follows_count","aggregate_formula":null},{"id":"get_directions_clicks_1d","name":"(Deprecated) Get directions clicks (1 day)","type":"NUMERIC","description":"Total number of taps on the directions link in the Instagram user's profile within a day.","table":"user_insights_day","upstream_api_request_name":"get_directions_clicks","upstream_api_response_name":"get_directions_clicks"},{"id":"impressions","name":"(Deprecated) Alias for Impressions (1 day)","type":"NUMERIC","description":"Alias for Impressions (1 day)","table":"user_insights_day","upstream_api_request_name":"impressions","upstream_api_response_name":"impressions"},{"id":"impressions_1d","name":"(Deprecated) Impressions (1 day)","type":"NUMERIC","description":"Total number of times the Instagram user's Instagram Media have been viewed within a day. Does not include profile views.","table":"user_insights_day","upstream_api_request_name":"impressions","upstream_api_response_name":"impressions"},{"id":"legacy_user_id","name":"Legacy Instagram user ID","type":"TEXT","description":"Legacy Instagram user ID","table":"user_info","upstream_api_request_name":"ig_id","upstream_api_response_name":"ig_id"},{"id":"likes","name":"Likes","type":"NUMERIC","description":"Number of likes on your posts, reels, and videos.","table":"user_insights_day_total_value","upstream_api_request_name":"likes","upstream_api_response_name":"likes"},{"id":"media_all_plays","name":"(Deprecated) Media plays + replays","type":"NUMERIC","description":"Total number of times the Instagram reels object has been played or replayed","table":"media_insights","media_types":["REELS"],"upstream_api_request_name":"ig_reels_aggregated_all_plays_count","upstream_api_response_name":"ig_reels_aggregated_all_plays_count","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_caption","name":"Media caption","type":"TEXT","description":"Caption of the post","table":"media_info","upstream_api_request_name":"caption","upstream_api_response_name":"caption"},{"id":"media_collaborator_id","name":"Media collaborator ID","type":"TEXT","description":"App-scoped Instagram account ID of an account invited to co-author the post (Instagram Collab). One row per collaborator; empty for posts without collaborators.","table":"collaborators","upstream_api_request_name":"id","upstream_api_response_name":"id","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_collaborator_invite_status","name":"Media collaborator invite status","type":"TEXT","description":"Status of the collaboration invite: Accepted or Pending. One row per collaborator; empty for posts without collaborators.","table":"collaborators","upstream_api_request_name":"invite_status","upstream_api_response_name":"invite_status","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_collaborator_username","name":"Media collaborator username","type":"TEXT","description":"Username of an account invited to co-author the post (Instagram Collab). One row per collaborator; empty for posts without collaborators.","table":"collaborators","upstream_api_request_name":"username","upstream_api_response_name":"username","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_collaborators","name":"Media collaborators","type":"TEXT","description":"Usernames of accounts invited to co-author the post (Instagram Collab), comma separated. Includes both accepted and pending invites. Empty for posts without collaborators.","table":"media_info","upstream_api_request_name":"collaborators{id,username,invite_status}","upstream_api_response_name":"collaborators","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_comments_count","name":"Comments count","type":"NUMERIC","description":"Count of comments on the media. Excludes comments on album child media and the media's caption. Includes replies on comments. The Instagram app also counts boosted and cross-posted engagement. To match the app total, use media_total_comments_count.","table":"media_info","upstream_api_request_name":"comments_count","upstream_api_response_name":"comments_count","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_count","name":"Profile media count","type":"NUMERIC","description":"Total number of media for this profile. Provides the count for today.","table":"user_info","cached":false,"upstream_api_request_name":"media_count","upstream_api_response_name":"media_count"},{"id":"media_engagement","name":"Media engagement","type":"NUMERIC","description":"Sum of likes, comments, saved and shares count on the Instagram media object","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","REELS"],"upstream_api_request_name":"total_interactions","upstream_api_response_name":"total_interactions","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_follows","name":"Media follows","type":"NUMERIC","description":"Number of accounts that started following the profile after viewing this media. Identifies the content that drives follows. Not supported for reels.","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO"],"upstream_api_request_name":"follows","upstream_api_response_name":"follows","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_id","name":"Media ID","type":"TEXT","description":"Media object ID.","table":"media_info","upstream_api_request_name":"id","upstream_api_response_name":"id"},{"id":"media_impressions","name":"(Deprecated) Media impressions","type":"NUMERIC","description":"Total number of times the Instagram media object has been seen","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO"],"upstream_api_request_name":"impressions","upstream_api_response_name":"impressions","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_is_comment_enabled","name":"Media comments enabled","type":"TEXT","description":"Whether or not the comments are enabled","table":"media_info","upstream_api_request_name":"is_comment_enabled","upstream_api_response_name":"is_comment_enabled"},{"id":"media_like_count","name":"Media Like Count","type":"NUMERIC","description":"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. The Instagram app also counts boosted and cross-posted engagement. To match the app total, use media_total_like_count.","table":"media_info","upstream_api_request_name":"like_count","upstream_api_response_name":"like_count","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_owner_username","name":"Media Owner Username","type":"TEXT","description":"Username of the account that published the post. For collaborative posts this is the other account, not the connected one.","table":"media_info","upstream_api_request_name":"username","upstream_api_response_name":"username"},{"id":"media_permalink","name":"Media permalink","type":"TEXT","description":"URL of the post on Instagram","table":"media_info","upstream_api_request_name":"permalink","upstream_api_response_name":"permalink"},{"id":"media_plays","name":"(Deprecated) Media plays","type":"NUMERIC","description":"Total number of times the Instagram reels object has been played","table":"media_insights","media_types":["REELS"],"upstream_api_request_name":"plays","upstream_api_response_name":"plays","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_product_type","name":"Media product type","type":"TEXT","description":"Surface where the media is published. Can be AD, FEED, IGTV, or STORY","table":"media_info","upstream_api_request_name":"media_product_type","upstream_api_response_name":"media_product_type"},{"id":"media_profile_activity","name":"Media profile activity","type":"NUMERIC","description":"Sum of profile actions (such as bio link taps, calls, and direction requests) taken after this media was viewed. Not supported for reels.","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO"],"upstream_api_request_name":"profile_activity","upstream_api_response_name":"profile_activity","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_profile_visits","name":"Media profile visits","type":"NUMERIC","description":"Number of times the profile was visited after this media was viewed. Not supported for reels.","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO"],"upstream_api_request_name":"profile_visits","upstream_api_response_name":"profile_visits","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_reach","name":"Media reach","type":"NUMERIC","aggregate_formula":null,"description":"Total number of unique Instagram accounts that have seen the Instagram media object.","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO","REELS"],"upstream_api_request_name":"reach","upstream_api_response_name":"reach","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_reel_avg_watch_time","name":"Media reel average watch time","type":"NUMERIC","description":"Average watch time for the Instagram reel in milliseconds","table":"media_insights","media_types":["REELS"],"upstream_api_request_name":"ig_reels_avg_watch_time","upstream_api_response_name":"ig_reels_avg_watch_time","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_reel_skip_rate","name":"Media reel skip rate","type":"PERCENT","description":"Percentage of views where the viewer skipped the Instagram reel within the first 3 seconds","formula":"to_float(media_insights_reels_skip_rate) / 100","aggregate_formula":null,"table":"media_insights","media_types":["REELS"],"upstream_api_request_name":"reels_skip_rate","upstream_api_response_name":"reels_skip_rate","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_reel_total_interactions","name":"Media reel total interactions","type":"NUMERIC","description":"Number of likes, saves, comments, and shares on the Instagram reel, minus the number of unlikes, unsaves, and deleted comments","table":"media_insights","media_types":["REELS"],"upstream_api_request_name":"total_interactions","upstream_api_response_name":"total_interactions","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_reel_total_watch_time","name":"Media reel total watch time","type":"NUMERIC","description":"Total amount of time the reel was played, including any time spent replaying the reel. Value is in milliseconds.","table":"media_insights","media_types":["REELS"],"upstream_api_request_name":"ig_reels_video_view_total_time","upstream_api_response_name":"ig_reels_video_view_total_time","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_reel_video_views","name":"(Deprecated) Media reel video views","type":"NUMERIC","description":"(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.","table":"media_insights","media_types":["REELS"],"upstream_api_request_name":"ig_reels_video_view_total_time","upstream_api_response_name":"","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_relationship","name":"Media Relationship","type":"TEXT","description":"How the account relates to the post: owned (published by the account) or collaborative (the account is a Collab co-author). Collaborative posts are returned only when the media_relationship option includes collaborative. Insights such as reach are empty for them.","table":"media_info","upstream_api_request_name":"media_relationship","upstream_api_response_name":"media_relationship"},{"id":"media_reposts","name":"Media reposts","type":"NUMERIC","aggregate_formula":null,"description":"Total number of times the Instagram media object has been reposted.","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO","REELS"],"upstream_api_request_name":"reposts","upstream_api_response_name":"reposts","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_saved","name":"Media saved","type":"NUMERIC","description":"Total number of unique Instagram accounts that have saved the Instagram media object","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO","REELS"],"upstream_api_request_name":"saved","upstream_api_response_name":"saved","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_shares","name":"Media shares","type":"NUMERIC","description":"Total number of times the Instagram media object has been shared","table":"media_insights","media_types":["CAROUSEL_ALBUM","IMAGE","VIDEO","REELS"],"upstream_api_request_name":"shares","upstream_api_response_name":"shares","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_shortcode","name":"Media shortcode","type":"TEXT","description":"Shortcode of the post on Instagram","table":"media_info","upstream_api_request_name":"shortcode","upstream_api_response_name":"shortcode"},{"id":"media_thumbnail_url","name":"Video thumbnail URL","type":"IMAGE_URL","description":"URL of the video thumbnail","table":"media_info","cached":false,"upstream_api_request_name":"thumbnail_url","upstream_api_response_name":"thumbnail_url"},{"id":"media_total_comments_count","name":"Media Total Comments Count","type":"NUMERIC","description":"Total count of comments on the media across all placements. Includes boosted and cross-posted engagement, so it matches the count shown in the Instagram app. Available for feed posts and reels.","table":"media_info","upstream_api_request_name":"total_comments_count","upstream_api_response_name":"total_comments_count","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_total_like_count","name":"Media Total Like Count","type":"NUMERIC","description":"Total count of likes on the media across all placements. Includes boosted and cross-posted engagement, so it matches the count shown in the Instagram app. Available for feed posts and reels.","table":"media_info","upstream_api_request_name":"total_like_count","upstream_api_response_name":"total_like_count","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_type","name":"Media type","type":"TEXT","description":"Type of the media object (IMAGE, VIDEO, CAROUSEL_ALBUM, REEL)","table":"media_info","upstream_api_request_name":"media_type","upstream_api_response_name":"media_type"},{"id":"media_url","name":"Media URL","type":"IMAGE_URL","description":"URL of the media object","table":"media_info","cached":false,"upstream_api_request_name":"media_url","upstream_api_response_name":"media_url"},{"id":"media_video_views","name":"(Deprecated) Media video views","type":"NUMERIC","description":"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_types":["CAROUSEL_ALBUM","VIDEO"],"table":"media_insights","upstream_api_request_name":"video_views","upstream_api_response_name":"video_views","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"media_views","name":"Media views","type":"NUMERIC","description":"Total number of times the Instagram media has been seen","table":"media_insights","media_types":["CAROUSEL_ALBUM","REELS","STORY","IMAGE","VIDEO"],"upstream_api_request_name":"views","upstream_api_response_name":"views","stable_cache_days":60,"cache_refresh_tiers":[[4,12],[7,24],[14,96],[30,168]]},{"id":"month","name":"Month","description":"Number of the month","type":"TEXT","date_aggregation_type":"month","windsor_custom_field":true},{"id":"name","name":"Instagram profile (account) name","type":"TEXT","description":"Instagram profile (account) name","table":"user_info","upstream_api_request_name":"name","upstream_api_response_name":"name"},{"id":"now","name":"Now","description":"Current timestamp","type":"TIMESTAMP","windsor_custom_field":true},{"id":"phone_call_clicks_1d","name":"(Deprecated) Phone call clicks (1 day)","type":"NUMERIC","description":"Total number of taps on the call link in Instagram user's profile within a day","table":"user_insights_day","upstream_api_request_name":"phone_call_clicks","upstream_api_response_name":"phone_call_clicks"},{"id":"profile_links_taps","name":"Profile links taps","type":"NUMERIC","description":"Number of taps on your business address, call button, email button, and text button.","table":"user_insights_day_total_value","upstream_api_request_name":"profile_links_taps","upstream_api_response_name":"profile_links_taps"},{"id":"profile_views","name":"(Deprecated) Profile Views (1 day)","type":"NUMERIC","description":"Total number of users who have viewed the Business Account's profile within the specified period","table":"user_insights_day","upstream_api_request_name":"profile_views","upstream_api_response_name":"profile_views"},{"id":"profile_views_1d","name":"(Deprecated) Profile views (1 day)","type":"NUMERIC","description":"Total number of users who have viewed the Instagram user's profile within a day","table":"user_insights_day","upstream_api_request_name":"profile_views","upstream_api_response_name":"profile_views"},{"id":"reach","name":"Reach","type":"NUMERIC","description":"Alias for Profile reach (1 day)","table":"user_insights_day","upstream_api_request_name":"reach","upstream_api_response_name":"reach","aggregate_formula":null},{"id":"reach_1d","name":"Profile reach (1 day)","type":"NUMERIC","description":"Total number of unique users who have viewed at least one of the Instagram user's Instagram Media","table":"user_insights_day","upstream_api_request_name":"reach","upstream_api_response_name":"reach","aggregate_formula":null},{"id":"reach_followers","name":"Reach from followers","type":"NUMERIC","aggregate_formula":null,"description":"Number of unique accounts that follow you and saw your content. Follower and non-follower reach can total less than total reach, because Meta reports reach as an estimate.","table":"user_insights_day_total_value_breakdown","upstream_api_request_name":"reach__follow_type","upstream_api_response_name":"reach__FOLLOWER"},{"id":"reach_non_followers","name":"Reach from non-followers","type":"NUMERIC","aggregate_formula":null,"description":"Number of unique accounts that do not follow you and saw your content. Follower and non-follower reach can total less than total reach, because Meta reports reach as an estimate.","table":"user_insights_day_total_value_breakdown","upstream_api_request_name":"reach__follow_type","upstream_api_response_name":"reach__NON_FOLLOWER"},{"id":"replies","name":"Replies","type":"NUMERIC","description":"Number of replies you received from your story, including text replies and quick reaction replies.","table":"user_insights_day_total_value","upstream_api_request_name":"replies","upstream_api_response_name":"replies"},{"id":"reposts","name":"Reposts","type":"NUMERIC","description":"Number of reposts of your posts, stories, reels, and videos.","table":"user_insights_day_total_value","upstream_api_request_name":"reposts","upstream_api_response_name":"reposts"},{"id":"saves","name":"Saves","type":"NUMERIC","description":"Number of saves of your posts, reels, and videos.","table":"user_insights_day_total_value","upstream_api_request_name":"saves","upstream_api_response_name":"saves"},{"id":"shares","name":"Shares","type":"NUMERIC","description":"Number of shares of your posts, stories, reels, videos, and live videos.","table":"user_insights_day_total_value","upstream_api_request_name":"shares","upstream_api_response_name":"shares"},{"id":"source","name":"Source","type":"TEXT","description":"The name of the Windsor connector returning the row","windsor_custom_field":true},{"id":"story_exits","name":"Story exits","type":"NUMERIC","description":"Number of times someone exited the story. Stories are only available for 24 hours.","table":"story_insights (navigation)","upstream_api_request_name":"navigation__story_navigation_action_type","upstream_api_response_name":"navigation__tap_exit"},{"id":"story_id","name":"Story ID","type":"TEXT","description":"Story ID. Stories are only available for 24 hours.","table":"story_info","upstream_api_request_name":"id","upstream_api_response_name":"id"},{"id":"story_impressions","name":"(Deprecated) Story impressions","type":"NUMERIC","description":"Total number of times the story has been seen. Stories are only available for 24 hours.","table":"story_insights","upstream_api_request_name":"impressions","upstream_api_response_name":"impressions"},{"id":"story_interactions","name":"Story Interactions","type":"NUMERIC","description":"Sum of likes, comments, saved and shares count on the story","table":"story_insights","upstream_api_request_name":"total_interactions","upstream_api_response_name":"total_interactions"},{"id":"story_permalink","name":"Permanent URL to the media.","type":"TEXT","description":"Total number of taps to see this story's previous photo or video. Stories are only available for 24 hours.","table":"ig_media_info","media_types":["STORY"],"upstream_api_request_name":"permalink","upstream_api_response_name":"permalink"},{"id":"story_reach","name":"Story reach","type":"NUMERIC","aggregate_formula":null,"description":"Total number of unique accounts that have seen the story. Stories are only available for 24 hours.","table":"story_insights","upstream_api_request_name":"reach","upstream_api_response_name":"reach"},{"id":"story_replies","name":"Story replies","type":"NUMERIC","description":"Total number of replies to the story. Stories are only available for 24 hours.","table":"story_insights","upstream_api_request_name":"replies","upstream_api_response_name":"replies"},{"id":"story_shares","name":"Story shares","type":"NUMERIC","aggregate_formula":null,"description":"Total number of times the Story has been shared.","table":"story_insights","upstream_api_request_name":"shares","upstream_api_response_name":"shares"},{"id":"story_swipe_forward","name":"Story swipe forward","type":"NUMERIC","description":"Total number of swipes forward. Stories are only available for 24 hours.","table":"story_insights (navigation)","upstream_api_request_name":"navigation__story_navigation_action_type","upstream_api_response_name":"navigation__swipe_forward"},{"id":"story_taps_back","name":"Story taps back","type":"NUMERIC","description":"Total number of taps to see this story's previous photo or video. Stories are only available for 24 hours.","table":"story_insights (navigation)","upstream_api_request_name":"navigation__story_navigation_action_type","upstream_api_response_name":"navigation__tap_back"},{"id":"story_taps_forward","name":"Story taps forward","type":"NUMERIC","description":"Total number of taps to see this story's next photo or video. Stories are only available for 24 hours.","table":"story_insights (navigation)","upstream_api_request_name":"navigation__story_navigation_action_type","upstream_api_response_name":"navigation__tap_forward"},{"id":"story_thumbnail_url","name":"Story thumbnail URL","type":"IMAGE_URL","description":"URL of the story thumbnail image. Available for video stories. Stories are only available for 24 hours.","table":"ig_media_info","media_types":["STORY"],"cached":false,"upstream_api_request_name":"thumbnail_url","upstream_api_response_name":"thumbnail_url"},{"id":"story_timestamp","name":"Story Created","type":"TIMESTAMP","description":"Date and time when the story was published. Stories are only available for 24 hours.","table":"story_info","upstream_api_request_name":"timestamp","upstream_api_response_name":"timestamp"},{"id":"story_views","name":"Story views","type":"NUMERIC","description":"Total number of times the story has been seen. Stories are only available for 24 hours.","table":"story_insights","upstream_api_request_name":"views","upstream_api_response_name":"views"},{"id":"text_message_clicks_1d","name":"(Deprecated) Text message clicks (1 day)","type":"NUMERIC","description":"Total number of taps on the text message link in the Instagram user's profile within a day","table":"user_insights_day","upstream_api_request_name":"text_message_clicks","upstream_api_response_name":"text_message_clicks"},{"id":"timestamp","name":"Media created","type":"TIMESTAMP","description":"Date and time when media was added. For stories, use the Story Created (story_timestamp) field instead.","table":"media_info","media_types":["STORY"],"upstream_api_request_name":"timestamp","upstream_api_response_name":"timestamp"},{"id":"today","name":"Today","description":"Today's date","type":"DATE","windsor_custom_field":true},{"id":"total_interactions","name":"Total interactions","type":"NUMERIC","description":"Total number of post interactions, story interactions, reels interactions, video interactions, and live video interactions, including any interactions on boosted content.","table":"user_insights_day_total_value","upstream_api_request_name":"total_interactions","upstream_api_response_name":"total_interactions"},{"id":"user_id","name":"Instagram user ID","type":"TEXT","description":"Instagram user ID","table":"user_info","upstream_api_request_name":"id","upstream_api_response_name":"id"},{"id":"user_name","name":"Instagram user name (alias)","type":"TEXT","description":"Alias for Instagram user name","table":"user_info","upstream_api_request_name":"username","upstream_api_response_name":"username"},{"id":"username","name":"Instagram user name","type":"TEXT","description":"Instagram user name","table":"user_info","upstream_api_request_name":"username","upstream_api_response_name":"username"},{"id":"views","name":"Views","type":"NUMERIC","description":"Total number of times your content was played or displayed. Content includes reels, posts, and stories.","table":"user_insights_day_total_value","upstream_api_request_name":"views","upstream_api_response_name":"views"},{"id":"views_followers","name":"Views from followers","type":"NUMERIC","description":"Number of times your content was viewed by accounts that follow you. Follower and non-follower views can total less than all views, because Meta reports a small unknown-follower-status share separately.","table":"user_insights_day_total_value_breakdown","upstream_api_request_name":"views__follow_type","upstream_api_response_name":"views__FOLLOWER"},{"id":"views_non_followers","name":"Views from non-followers","type":"NUMERIC","description":"Number of times your content was viewed by accounts that do not follow you. Follower and non-follower views can total less than all views, because Meta reports a small unknown-follower-status share separately.","table":"user_insights_day_total_value_breakdown","upstream_api_request_name":"views__follow_type","upstream_api_response_name":"views__NON_FOLLOWER"},{"id":"website","name":"Linked website","type":"TEXT","description":"Link to your website that is displayed on your Instagram profile page","table":"user_info","upstream_api_request_name":"website","upstream_api_response_name":"website"},{"id":"website_clicks_1d","name":"(Deprecated) Linked website clicks (1 day)","type":"NUMERIC","description":"Total number of taps on the website link in the Instagram user's profile","table":"user_insights_day","upstream_api_request_name":"website_clicks","upstream_api_response_name":"website_clicks"},{"id":"week","name":"Week","description":"Week (Sun-Sat).","type":"TEXT","date_aggregation_type":"week","windsor_custom_field":true},{"id":"week_day","name":"Day of week and day number","description":"Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.","type":"TEXT","date_aggregation_type":"date","windsor_custom_field":true},{"id":"week_day_iso","name":"Day of week and day number, ISO","description":"Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7","type":"TEXT","date_aggregation_type":"date","windsor_custom_field":true},{"id":"week_iso","name":"Week ISO","description":"Week, ISO format (Mon-Sun).","type":"TEXT","date_aggregation_type":"week","windsor_custom_field":true},{"id":"year","name":"Year","description":"Year","type":"TEXT","date_aggregation_type":"year","windsor_custom_field":true},{"id":"year_month","name":"Yearmonth","description":"Year and month, e.g. 2024|3","type":"TEXT","date_aggregation_type":"month","windsor_custom_field":true},{"id":"year_month_name","name":"Year month name","description":"Year and month with the month name written out, e.g. \"Jan 2025\".","type":"TEXT","date_aggregation_type":"month","windsor_custom_field":true},{"id":"year_of_week","name":"Year of week","description":"The year that contains first day of the week (Sun-Sat).","type":"TEXT","date_aggregation_type":"week","aggregate_formula":null,"windsor_custom_field":true},{"id":"year_of_week_iso","name":"Year of week, ISO","description":"The year that contains first day of the ISO week (Mon-Sun).","type":"TEXT","date_aggregation_type":"week","aggregate_formula":null,"windsor_custom_field":true},{"id":"year_week","name":"Year week","description":"Year and week for US weeks (Sun-Sat), e.g. 2024|15","type":"TEXT","date_aggregation_type":"week","windsor_custom_field":true},{"id":"year_week_iso","name":"Year week ISO","description":"Year and week for ISO weeks (Mon-Sun), e.g. 2024|20","type":"TEXT","date_aggregation_type":"week","windsor_custom_field":true}]