JDBC Driver for Instagram

Build 25.0.9434

MediaInsightsPost

Provides insights specifically for photo and video posts, while excluding stories and reels. It delivers detailed metrics such as post reach, save counts, and engagement ratios. This tool is intended for evaluating the performance of static content and traditional video posts. The required permissions for access are instagram_basic and instagram_manage_insights.

Select

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

  • Comments
  • Follows
  • Likes
  • ProfileActivity
  • ProfileVisits
  • 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.

  • Return results for the following metrics, saved for all the POSTs image and video objects: Comments, Follows, Likes, ProfileActivity, ProfileVisits, Shares and TotalInteractions.
         SELECT * FROM MediaInsightsPost WHERE MediaId = 17945732813652602"
    
         SELECT Comments, Follows, Likes, ProfileActivity, ProfileVisits, Shares, TotalInteractions FROM MediaInsightsPost WHERE MediaId = 17945732813652602 
    
        

Columns

Name Type Description
MediaId String The unique identifier assigned to each media insight record. This ID helps in tracking specific media objects across reporting and analytical workflows.
Comments Integer The total count of user-generated comments posted in response to the associated media content, representing audience engagement through direct textual feedback.
Follows Integer The number of new followers who began following the account as a direct result of interactions with this specific post, indicating its effectiveness in attracting new audiences.
Likes Integer The total number of likes received on the post, reflecting user approval or positive sentiment toward the content shared.
ProfileActivity Integer The total count of actions performed on the profile page, such as taps on contact buttons or story highlights, after a user viewed or interacted with the post.
ProfileVisits Integer The total number of times users navigated to the account's profile from the media post, indicating interest in learning more about the account or viewing additional content.
Shares Integer The number of times the media post was shared by users to others through direct messages or stories, amplifying content reach and visibility.
TotalInteractions Integer The net total of engagement actions including likes, saves, comments, and shares, adjusted by subtracting negative actions such as unlikes, unsaves, and deleted comments to reflect true interaction performance.
Views Integer The total number of times the media object has been displayed on users' screens, regardless of unique viewers, serving as a measure of total content exposure.

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