ODBC Driver for Instagram

Build 24.0.9060

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, only on version < 18.0)
  • TotalInteractions (likes, comments, shares, and saves, only on version >= 18.0)
  • Reach
  • Saved
  • Videoviews (only on a video 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.

  • 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, 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.
TotalInteractions Integer Total number of likes, comments, saves, and shares 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.
Replies Integer Total number of unique accounts that have replied.
InstagramBusinessAccountId String The unique identifier for the Instagram business account Id.

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