CData Python Connector for Instagram

Build 25.0.9454

MediaInsightsReels

Compiles performance metrics specifically for Instagram Reels. It provides detailed insights, including the number of plays, likes, comments, saves, and shares. This analysis is designed to help you examine engagement trends over time for short-form video content. The required permissions for access are instagram_basic and instagram_manage_insights.

Select

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

  • Reach
  • Comments
  • Likes
  • Saved
  • Views
  • 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.

  • MediaInsightsReels will only return the result of reels object.
  • Return results for the following metrics, saved for all the reels objects: Reach, Saved, Comments, Likes, Views, Shares and TotalInteractions.
         SELECT * FROM MediaInsightsReels WHERE MediaId = 17905513811523370"
    
         SELECT Reach, Saved, Comments, Likes, Views, Shares, TotalInteractions FROM MediaInsightsReels WHERE MediaId = 17905513811523370 
    
        

Columns

Name Type Description
MediaId String A unique string that identifies the specific Instagram media object (reel) associated with the insight record. Used as the primary reference key for analytics.
Reach Integer The total count of distinct Instagram accounts that viewed the reel at least once. This metric reflects the unique reach and exposure of the media.
Saved Integer The total count of unique Instagram accounts that bookmarked or saved the reel for later viewing is recorded. This metric indicates strong content relevance and a clear intent to revisit.
Comments Integer The total number of unique Instagram users who commented on the reel reflects user engagement. It also captures feedback through written responses.
Likes Integer The total number of unique Instagram accounts that liked the reel indicates positive sentiment. This metric also demonstrates the level of engagement from the audience.
Shares Integer The total number of unique accounts that shared the reel with others, either through direct messages or their own stories, indicates organic distribution and content amplification.
TotalInteractions Integer The total number of unique accounts that engaged with the reel through any combination of likes, comments, shares, or saves. Measures overall engagement volume.
Views Integer The total number of times the reel was viewed, regardless of whether the same user viewed it multiple times. This reflects total exposure including repeat views.
InstagramBusinessAccountId String The unique identifier of the Instagram business account that owns or published the reel. This is used to link media insights back to the originating business profile.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454