JDBC Driver for Instagram

Build 24.0.9062

MediaInsightsStory

Allows you to get insights for an individual media object for Story. Requires the instagram_basic and instagram_manage_insights scopes.

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 本製品 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 The unique identifier of the insight.
Impressions Integer Total number of times the media object has been seen.
Reach Integer Total number of unique accounts that have seen the media object.
Follows Integer The number of accounts that started following you.
ProfileActivity Integer The number of actions people take when they visit your profile after engaging with your story.
ProfileVisits Integer The number of times your profile was visited.
Shares Integer The number of times your profile was visited.
TotalInteractions Integer The number of replies and shares for your story.
Navigation Integer Total number of actions taken from your story such as exits, taps forward, and taps back.

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