Provides performance insights for any media object published by the account. The metrics include reach, engagement, and interactions across different content types. This view aids in developing data-driven content strategies by revealing how individual posts perform across various user segments. The permissions required for this analysis are instagram_basic and instagram_manage_insights.

Select

You can query the following metrics using server-side processing:

• Views
• TotalInteractions (likes, comments, shares, and saves)
• Reach
• Saved
• Replies (only on a story object)

The connector will use the Instagram APIs to process filters by a MediaId and will process filters on other columns client-side within itself.

• MediaInsights will return result of all media objects except reels object.
• Return results for the following metrics, saved for all the image and carousel objects: views, engagement, and reach.
  

  SELECT * FROM MediaInsights

• Query the MediaInsights view using a different object, for example, videos.
  

  SELECT Views, Engagement, Reach, Saved FROM MediaInsights WHERE MediaId = "1321555648546465" 

Columns

Name	Type	Description
MediaId	String	A system-generated string that uniquely identifies the media content associated with the insight, used for data tracking and retrieval across reports and analytics systems.
Views	Integer	The total number of times the media object was visible to users on the Instagram platform. This metric excludes bot activity and includes multiple views by the same user.
TotalInteractions	Integer	The combined total of all engagement actions taken on the media object, including likes, comments, shares, and saves. This metric provides a comprehensive measure of audience interaction.
Reach	Integer	The total count of unique Instagram accounts that have viewed the media object at least once, indicating the breadth of the content's audience exposure.
Saved	Integer	The number of distinct users who saved the media object to their profile collection, signaling the perceived value or interest in revisiting the content.
Replies	Integer	The count of unique responses or replies submitted by users, typically applicable for Stories or Reels where direct responses are enabled.
InstagramBusinessAccountId	String	A unique identifier string that links the insight data to the corresponding Instagram Business Account. This is used for organizational segmentation and reporting.