JDBC Driver for Instagram

Build 25.0.9434

MediaInsights

Provides performance insights for any media object published by the account. The metrics include reach, engagement, and interactions across different content types. This view aids in developing data-driven content strategies by revealing how individual posts perform across various user segments. The permissions required for this analysis are instagram_basic and instagram_manage_insights.

Select

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

  • Views
  • TotalInteractions (likes, comments, shares, and saves)
  • Reach
  • Saved
  • Replies (only on a story object)
The driver 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: views, engagement, and reach.
    SELECT * FROM MediaInsights
  • Query the MediaInsights view using a different object, for example, videos.

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

Columns

Name Type Description
MediaId String A system-generated string that uniquely identifies the media content associated with the insight, used for data tracking and retrieval across reports and analytics systems.
Views Integer The total number of times the media object was visible to users on the Instagram platform. This metric excludes bot activity and includes multiple views by the same user.
TotalInteractions Integer The combined total of all engagement actions taken on the media object, including likes, comments, shares, and saves. This metric provides a comprehensive measure of audience interaction.
Reach Integer The total count of unique Instagram accounts that have viewed the media object at least once, indicating the breadth of the content's audience exposure.
Saved Integer The number of distinct users who saved the media object to their profile collection, signaling the perceived value or interest in revisiting the content.
Replies Integer The count of unique responses or replies submitted by users, typically applicable for Stories or Reels where direct responses are enabled.
InstagramBusinessAccountId String A unique identifier string that links the insight data to the corresponding Instagram Business Account. This is used for organizational segmentation and reporting.

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