Instagram User Analytics

Data-Driven Insights for User Engagement & Growth

Profile Picture

Anirudh Chaudhary

Data Analyst | SQL Specialist

This project analyzes Instagram's user data to uncover valuable insights about user behavior, engagement patterns, and platform growth opportunities. Using SQL and MySQL Workbench, I extracted key metrics to help Instagram's marketing, product, and investor teams make data-driven decisions to enhance user experience and business performance.

Oldest Users
5
Identified since 2016
Inactive Users
26
Never posted content
Contest Winner
Zack_Kemmer93
48 likes on one photo
Top Hashtag
#smile
Used 59 times
Instagram Analytics Dashboard
Download Full Project Report

Marketing Analysis Insights

+

The marketing analysis uncovered several key insights that can drive user engagement and platform growth:

Loyal User Identification

Identified the five oldest users on Instagram who have been with the platform since 2016. These loyal users are ideal candidates for exclusive rewards and retention strategies.

Username Join Date
Darby_Herzog 2016-05-06
Emilio_Bernier52 2016-05-06
Elenor88 2016-05-08
Nicole71 2016-05-09
Jordyn.Jacobson2 2016-05-14
Inactive User Engagement

Discovered 26 inactive users who have never posted content. These users represent a significant opportunity for re-engagement campaigns through targeted promotions and content encouragement.

Optimal Ad Campaign Timing

Analysis revealed that Thursday and Sunday are the most popular days for new user registrations (16 each), making them ideal for launching new ad campaigns to maximize reach and engagement.

Day Registrations
Thursday 16
Sunday 16
Friday 15
Tuesday 14
Monday 14

Content Engagement Analysis

+

Analysis of content engagement revealed valuable patterns for optimizing user experience:

Contest Winner

Identified Zack_Kemmer93 as the contest winner with 48 likes on a single photo. Recognizing such high-performing content helps drive engagement and encourages participation in future campaigns.

Top Hashtags

The most popular hashtags were identified, with #smile leading at 59 uses. These trending hashtags are valuable for brand partnerships to increase content visibility.

Hashtag Usage Count
#smile 59
#beach 42
#party 39
#fun 38
#concert 24

Investor Metrics

+

Key metrics for investors assessing platform health and growth potential:

User Engagement

The average user posts 2.57 photos, with a total of 257 photos across 100 users. This indicates a healthy level of user engagement and content creation.

Bot Detection

Identified 13 potential bot accounts that liked every single photo on the platform (257 likes each). These accounts should be reviewed to maintain platform integrity.

Username Total Likes
Aniya_Hackett 257
Bethany20 257
Duane60 257
Jadyn81 257

Strategic Recommendations

+

Based on the comprehensive data analysis, the following strategic actions are recommended:

User Engagement Strategy

1. Implement a loyalty program targeting the oldest users to increase retention
2. Launch re-engagement campaigns for inactive users with content creation incentives
3. Schedule major marketing campaigns for Thursdays and Sundays when user activity peaks

Content Strategy

1. Promote trending hashtags to brands for sponsored content opportunities
2. Highlight high-performing content like the contest winner to encourage participation
3. Develop content creation guides focusing on popular themes (smiles, beaches, parties)

Platform Integrity

1. Review and potentially remove identified bot accounts to maintain authentic engagement
2. Implement safeguards to detect and prevent future bot activity
3. Monitor average posts per user as a key health metric

Technical Skills Applied

SQL

Complex queries, joins, aggregations, and data extraction

MySQL Workbench

Database management and query execution

Data Analysis

User behavior analysis and pattern recognition

Business Insights

Translating data into actionable strategies

Blinkit Operations Dashboard

This interactive dashboard provides comprehensive insights into Blinkit's quick commerce operations, analyzing delivery performance, order patterns, and customer behavior metrics.

View Blinkit Dashboard