ODBC Driver for Instagram

Build 23.0.8868

MediaInsightsPost

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

Select

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

  • Comments
  • Follows
  • Likes
  • ProfileActivity
  • ProfileVisits
  • Shares
  • TotalInteractions
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 POSTs 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 of the insight.
Comments Integer The number of comments on your post.
Follows Integer The number of accounts that started following you.
Likes Integer The number of likes on your post.
ProfileActivity Integer The number of actions people take when they visit your profile after engaging with your post.
ProfileVisits Integer The number of times your profile was visited.
Shares Integer The number of shares of your post.
TotalInteractions Integer The number of likes, saves, comments and shares on your post minus the number of unlikes, unsaves and deleted comments.

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