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

Select

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

• Reach
• Comments
• Likes
• Saved
• Plays
• Shares
• TotalInteractions

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

• MediaInsightReels will only return the result of reels object.
• Return results for the following metrics, saved for all the reels objects: Reach, Saved, Comments, Likes, Plays, Shares and TotalInteractions.
  

       SELECT * FROM MediaInsightReels WHERE MediaId = 17905513811523370"
  
       SELECT Reach, Saved, Comments, Likes, Plays, Shares, TotalInteractions FROM MediaInsightReels WHERE MediaId = 17905513811523370 
  
      

Columns

Name	Type	Description
MediaId	String	The unique identifier of the insight.
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.
Comments	Integer	Total number of unique accounts that have Comments on the media object.
Likes	Integer	Total number of unique accounts that have likes the media object.
Plays	Integer	Total number of unique accounts that have plays the media object.
Shares	Integer	Total number of unique accounts that have Shared the media object.
TotalInteractions	Integer	Total number of unique accounts that involved in the media object.
InstagramBusinessAccountId	String	The unique identifier for the Instagram business account Id.