JDBC Driver for Instagram

Build 22.0.8462

MediaInsightReels

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 driver will use the Instagram APIs to process filters by a MediaId and will process filters on other columns client-side within itself. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.

  • 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
    
         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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462