Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData JDBC Driver for Instagram Views


Name	Description
AccountContactButtonType	Provides detailed engagement metrics for the contact buttons (DIRECTION, CALL, EMAIL) displayed on an Instagram business profile during a specific time range. It tracks the total interactions for each type of contact button tapped, allowing for in-depth analysis using the 'contact_button_type' dimension. The permissions needed for access are Instagram_basic and Instagram_manage_insights.
AccountFollowType	Captures follower dynamics by reporting the number of new followers, unfollows, and users who deactivated accounts over a defined period. This data is aggregated under the 'follow_type' breakdown and can be used to understand audience growth trends. The permissions required are instagram_basic and instagram_manage_insights.
AccountInsights	Aggregates key performance metrics for an Instagram business account, including reach, engagement, and profile activity data. This summary serves as a central view for tracking account-level trends over time. The permissions required are instagram_basic and instagram_manage_insights.
AccountMediaProductType	Analyzes content performance by media type, including standard posts and IGTV videos, over a chosen time period. Metrics are categorized by media_product_type and offer insights into which formats enhance user engagement. The permissions required are instagram_basic and instagram_manage_insights permissions.
AccountTimeSeriesFollowType	Provides time-based metrics on follower changes, tracking the fluctuations of follows and unfollows over specific intervals. This view uses follow_type as a breakdown dimension and facilitates time-series analysis for identifying trends. The permissions required include instagram_basic and instagram_manage_insights.
AccountTimeSeriesMediaProductType	Provides chronological data on various media types, such as Posts, Stories, IGTV, shared from an Instagram business account. It helps visualize performance trends over time by using media_product_type as a breakdown dimension and supports time-series metric evaluation. The required scopes include instagram_basic and instagram_manage_insights.
AccountTimeSeriesWithoutBreakdown	Returns time-series metrics without a specific breakdown dimension, making it useful for monitoring aggregated metrics like reach over time. It includes end-time and value pairs for temporal analysis. This requires the instagram_basic and instagram_manage_insights scopes.
AccountWithoutBreakdown	Summarizes cumulative Instagram performance metrics, including total views and engagements across various content types like posts, stories, and reels. No breakdown is provided, making it suitable for overall metric tracking. The permissions required are instagram_basic and instagram_manage_insights.
AudienceInsights	Analyzes comprehensive demographic and behavioral data of followers for an Instagram business account, including age, gender, location, and active times. This analysis is crucial for effectively understanding and targeting audience segments. The permissions required are instagram_basic and instagram_manage_insights.
IGMedia	Represents all media types published via an Instagram business account, including photos, videos, reels, stories, albums, and IGTV. This allows for querying and performance analysis at the media object level, requiring appropriate permissions based on media access.
InstagramBusinessProfile	Retrieves metadata and configuration details for an Instagram Business profile, such as username, profile picture, bio, and linked Facebook page. This view is foundational for mapping the Instagram presence of a business. The required permissions are instagram_basic, business_management, and manage_pages.
InstagramPages	Offers visibility into Facebook Pages linked to an Instagram Business account. This is helpful for verifying page connections and managing cross-platform presence. It requires the instagram_basic scope.
Media	Offers a complete overview of all media objects published on an Instagram Business or Creator account, including images, videos, and carousel posts. It is essential for retrieving metadata such as captions, media types, timestamps, and permalinks. To access this information, the required permissions are instagram_basic and instagram_content_publish.
MediaInsights	Provides performance insights for any media object published by the account. The metrics include reach, engagement, and interactions across different content types. This view aids in developing data-driven content strategies by revealing how individual posts perform across various user segments. The permissions required for this analysis are instagram_basic and instagram_manage_insights.
MediaInsightsPost	Provides insights specifically for photo and video posts, while excluding stories and reels. It delivers detailed metrics such as post reach, save counts, and engagement ratios. This tool is intended for evaluating the performance of static content and traditional video posts. The required permissions for access are instagram_basic and instagram_manage_insights.
MediaInsightsPostAlbum	Offers comprehensive analytics for individual carousel album posts shared on Instagram. It includes metrics such as reach, engagement, and saves. To access this information, the application must have the instagram_basic and instagram_manage_insights OAuth scopes, which allow it to retrieve performance data for content posted by the user.
MediaInsightsReels	Compiles performance metrics specifically for Instagram Reels. It provides detailed insights, including the number of plays, likes, comments, saves, and shares. This analysis is designed to help you examine engagement trends over time for short-form video content. The required permissions for access are instagram_basic and instagram_manage_insights.
MediaInsightsStory	Provides performance insights for Instagram Stories, analyzing metrics such as reach, exits, replies, and taps forward/backward. This perspective allows for detailed analysis of temporary content and requires both the instagram_basic and instagram_manage_insights OAuth scopes for data access.
OnlineFollowers	Aggregates hourly breakdowns of when a user's Instagram followers are typically online, helping to identify the best posting times for maximum visibility and engagement. This requires the instagram_basic and instagram_manage_insights scopes to access follower activity patterns.
Pages	Retrieves detailed metadata about Facebook Pages that are linked to an Instagram Business account. The information includes the page name, category, verification status, and any connected Instagram profiles. To access this data, you need permissions from a custom OAuth app, including either pages_read_engagement or approval for Page Public Content Access or Page Public Metadata Access.
Permissions	Lists the specific permissions granted by a user to the application, such as access to media, insights, or account metadata. This information is useful for auditing user consent and ensuring that the app operates within its authorized scope.
Stories	Offers a filtered view of Instagram Story content linked to a specific account. It includes metadata such as timestamps, viewer counts, and interaction metrics. This view facilitates the extraction of insights and performance analysis for temporary story posts. To access this feature, both instagram_basic and instagram_manage_insights permissions are required.
Tags	Provides a read-only interface to access hashtags and tagged media metadata, including related posts, captions, and tagging users. This view aids in analyzing user-generated tags and community trends and requires the instagram_basic and instagram_manage_comments permissions for access.