ODBC Driver for Instagram

Build 23.0.8868

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.

  • 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.
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.
TapsForward Integer Total number of unique accounts that have tapped forward. Only available when Version< 18.0.
TapsBack Integer Total number of unique accounts that have tapped backwards. Only available when Version< 18.0.
Exits Integer Total number of exits from unique accounts. Only available when Version< 18.0.
Navigation Integer Total number of actions taken from your story such as exits, taps forward, and taps back. Only available when Version >= 18.0

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