Allows you to get insights for an individual media object. Requires the instagram_basic and instagram_manage_insights scopes.

Select

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

• Impressions
• Engagement (likes, comments, and saves, only on version < 18.0)
• TotalInteractions (likes, comments, shares, and saves, only on version >= 18.0)
• Reach
• Saved
• Videoviews (only on a video object)
• 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: impressions, engagement, and reach.
  

  SELECT * FROM MediaInsights

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

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

Columns

Name	Type	Description
MediaId	String	The unique identifier of the insight.
Impressions	Integer	Total number of times the media object has been seen.
Engagement	Integer	Total number of likes and comments on the media object. Only available when Version< 18.0
TotalInteractions	Integer	Total number of likes, comments, saves, and shares on the media object. Only available when Version >= 18.0
Reach	Integer	Total number of unique accounts that have seen the media object.
Saved	Integer	Total number of unique accounts that have saved the media object.
VideoViews	Integer	Total number of unique accounts that have viewed the video.
Replies	Integer	Total number of unique accounts that have replied.
InstagramBusinessAccountId	String	The unique identifier for the Instagram business account Id.