JDBC Driver for Instagram

Build 23.0.8868

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.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8868