JDBC Driver for Instagram

Build 22.0.8462

MediaInsights

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

Select

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

  • Impressions
  • Engagement (likes, comments, and saves)
  • Reach
  • Saved
  • Videoviews (only on a video object)
  • TapsForward (only on a story object)
  • TapsBack (only on a story object)
  • Exits (only on a story object)
  • Replies (only on a story object)
The driver will use the Instagram APIs to process filters by a MediaId and will process filters on other columns client-side within itself. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.

  • MediaInsights will return result of all media objects except reels object.
  • Return results for the following metrics, saved for all the image and carousel objects: impressions, engagement, and reach.
    SELECT * FROM MediaInsights
  • Query the MediaInsights view using a different object, for example, stories.

    SELECT TapsForward, TapsBack FROM MediaInsights WHERE MediaId="132155564886465" 

  • Query the MediaInsights view using a different object, for example, videos.

    SELECT Impressions, Engagement, Reach, Saved, VideoViews FROM MediaInsights WHERE MediaId="1321555648546465" 

Columns

Name Type Description
MediaId String The unique identifier of the insight.
Impressions Integer Total number of times the media object has been seen.
Engagement Integer Total number of likes and comments on the media object.
Reach Integer Total number of unique accounts that have seen the media object.
Saved Integer Total number of unique accounts that have saved the media object.
VideoViews Integer Total number of unique accounts that have viewed the video.
TapsForward Integer Total number of unique accounts that have tapped forward.
TapsBack Integer Total number of unique accounts that have tapped backwards.
Exits Integer Total number of exits from unique accounts.
Replies Integer Total number of unique accounts that have replied.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462