JDBC Driver for Instagram

Build 25.0.9434

MediaInsightsStory

Provides performance insights for Instagram Stories, analyzing metrics such as reach, exits, replies, and taps forward/backward. This perspective allows for detailed analysis of temporary content and requires both the instagram_basic and instagram_manage_insights OAuth scopes for data access.

Select

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

  • Follows
  • ProfileActivity
  • ProfileVisits
  • Shares
  • TotalInteractions
  • TapsForward (only on version < 18.0)
  • TapsBack (only on version < 18.0)
  • Exits (only on version < 18.0)
  • Navigation (only on version >= 18.0)
The driver will use the Instagram APIs to process filters by a MediaId and will process filters on other columns client-side within itself. Please note that following the nature of Stories on Instagram, insights and metrics related to stories expire after 24 hours.

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

Columns

Name Type Description
MediaId String A unique identifier representing the specific story media object for which the insight data is being collected. This ID can be used to link metrics back to the original content.
Views Integer The number of times the story was viewed across all users, counting each view regardless of whether it came from the same or different users.
Reach Integer The total count of unique Instagram accounts that viewed the story at least once. This metric helps gauge the breadth of audience exposure.
Follows Integer The number of new followers acquired as a direct result of viewing the story. This can indicate how compelling the story content was in converting viewers into followers.
ProfileActivity Integer The total number of actions users took on your profile after interacting with the story, such as visiting your profile, clicking links, or initiating messages.
ProfileVisits Integer The number of distinct visits to your Instagram profile that occurred after users viewed your story. It reflects how many viewers were motivated to explore your full profile.
Shares Integer The number of times the story content was shared by viewers through Instagram's share features. This value is currently misattributed and should not represent profile visits.
TotalInteractions Integer The aggregate count of user interactions with the story, including replies and shares. It is an indicator of how engaging the content was.
Navigation Integer The sum of navigational actions taken on the story, including exiting the story, tapping forward to the next story, or tapping back to the previous one. These behaviors reflect user engagement flow.

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