This guide provides a breakdown of the features of Kondado's Organic Instagram Report. If you need help integrating your data into the Report, follow the steps in this guide to set up the integration with Instagram and take advantage of all the features of a customizable Report.
📹 Instagram Power BI
Watch the video below to learn more about this dashboard:
Overview Page
This report page is designed to provide an overview of essential metrics for an Instagram profile. It serves as a starting point for quickly understanding the overall account performance and identifying trends in engagement and reach.
The scorecards display key information such as the total number of followers, Reels plays, likes, shares, and saves, enabling instant analysis of audience engagement. Users can track follower growth over the past 30 days and view the audience engagement journey through the "Reach Funnel" chart, showing metrics from impressions to new followers based on the selected period.
Additionally, monthly insights on reach and new followers are provided, allowing consistent comparisons and the identification of performance patterns.
Below, a detailed description of each field is provided, along with images and examples.
Filters:
Instagram Username Filter: This is the filter where you can select which Instagram profile's data you want to view.
- Type: Filter.
- Data Source: Table “instagram_account_daily_insights”; columns: “ig_username”.
Date Filter: This is the filter where you can select the date range for displaying the data.
- Type: Period Control
- Data Source: Table: “instagram_account_daily_insights”; Column: “metric_date”.
- Note: In this visual, only the Reach Funnel chart and the Reach vs. New Followers chart are affected by the date filter.
Charts:
Followers: Total number of followers for the profile.
- Type: Overview
- Data Source: Table: “instagram_profiles”; Columns: “followers_count”
Reels Plays : The number of Reels plays for the profile.
- Type: Overview
- Data Source: Table: “instagram_media_insights”; Column: “reels_plays”.
Likes: Total number of likes on the profile's posts..
- Type: Overview
- Data Source: Table: “instagram_media_insights”; Column: “likes”.
Shares: Total number of shares for the profile's posts..
- Type: Overview
- Data Source: Table: “instagram_media_insights”; Column: “shares”.
Saved: Saved posts for the profile..
- Type: Overview
- Data Source: Table: “instagram_media_insights”; Column: “saved”.
New Followers Last 30 days Chart: Line chart that allows analyzing the daily number of new followers for the profile over the past 30 days based on the data integration..
- Type: Line Chart
- Data Source: Table: “instagram_account_daily_insights”; Columns: “metric_date”, “followers_count”.
- Note: Due to limitations of the Instagram API being used, metric data may have a delay of up to 48 hours during retrieval.
Outreach Funnel Chart: Funnel chart displaying the number of Impressions, Reach, and New Followers based on the selected period..
- Type: Funnel Chart
- Data Source: Table: “instagram_account_daily_insights”; Columns: “impressions”, “reach”, “followers_count”.
Reach x New Followers Chart: Bar and line chart that shows the monthly number of people reached by the posts and new followers, based on the selected period.
- Type: Bar and Line Chart
- Data Source: Table: “instagram_account_daily_insights”; Columns: “metric_date”, “reach”, “followers_count”.
Posts Page
The Posts report page allows you to explore detailed metrics for your posts, such as likes and comments. With a detailed table that includes the featured image, text, and engagement metrics for each post, you can identify patterns and trends. Use the filters to segment by media type, content, and specific periods. Connect your Instagram data with Kondado and gain valuable insights to enhance your digital strategies.
Filters:
Media product type Filter: Filter that allows viewing data based on content type, such as "Feed," "Reels," or "Story."
- Type: Filter
- Data Source: Table: “instagram_media_insights”; Column: “media_product_type”
Media type Filter: Filter that allows selecting the media type of posts, such as Image, Video, or Carousel.
- Type: Filter
- Data Source: Table: “instagram_media”; Column: “media_type”
Year & Month Filter: Filter that allows selecting the date range of the data in Year/Month format.
- Type: Filter
- Data Source: Table: “instagram_media_with_effective_url”; Column: “timestamp”
Charts:
Hashtag Trends Word Cloud Chart: Word Cloud Chart that highlights the hashtags from your posts with the most likes, allowing you to identify trends and themes with greater relevance featured on your profile.
- Type: Word Cloud Chart
- Data Source: Table: “instagram_media_with_effective_url”; Columns: “like_count”, “filtered_hashtags”.
Performance Table: Understand which traffic sources drive the most visits by visualizing the number of sessions, and optimize your acquisition strategies.
- Type: Table
- Data Source: Table: “instagram_media_with_effective_url”; Columns: “like_count”, “effective_media_url”, “caption”, “comments_count”.
Set Up Kondado's Organic Instagram Power BI Report
Follow these steps to integrate your Instagram data and start using Kondado's customizable Power BI template for organic Instagram analytics.
Connect Instagram as a data source
Start by integrating your Instagram profile data into Kondado. Use the data integration features to pull metrics from tables like instagram_account_daily_insights and instagram_media_insights, keeping in mind that Instagram API data may have up to a 48-hour delay.
Configure your Power BI destination
Set up Power BI as your visualization destination so the report can render your Instagram metrics. You can explore other destinations if you want to send data elsewhere, but Power BI is required for this template.
Apply filters for your analysis
Use the Instagram Username Filter and Date Filter on the Overview page to segment your data. Only the Reach Funnel and Reach vs. New Followers charts respond to the date filter, so adjust your selections accordingly.
Analyze engagement and reach metrics
Review scorecards for followers, Reels plays, likes, shares, and saves. Use the New Followers Last 30 days chart and Outreach Funnel to track audience growth and impressions-to-follower conversion.
Drill into post-level performance
Navigate to the Posts page and apply the Media product type, Media type, and Year & Month filters. Examine the Hashtag Trends Word Cloud and Performance Table to identify top-performing content themes and optimize your digital strategies.
