Instagram User Analytics
Instagram User Analytics
DURATION
2 Weeks
DURATION
2 Weeks
CLIENT
Engagement Unfiltered: Analyzing Instagram User Behavior and Trends
CLIENT
Engagement Unfiltered: Analyzing Instagram User Behavior and Trends
SQL Query Writing & Optimization
SQL Query Writing & Optimization
Data Exploration & User Segmentation
Data Exploration & User Segmentation
Engagement & Loyalty Analysis
Engagement & Loyalty Analysis
EDA
EDA
PROJECT OVERVIEW
PROJECT OVERVIEW
In this project, I collaborated with a simulated product team to assess Instagram’s user engagement and performance. The analysis provided data-backed decisions for user re-engagement, ad targeting, and bot detection strategies.
In this project, I collaborated with a simulated product team to assess Instagram’s user engagement and performance. The analysis provided data-backed decisions for user re-engagement, ad targeting, and bot detection strategies.
The Challenge
The Challenge
Ensuring query logic correctly captured diverse user activity while avoiding misleading signals from bots and inactive users.
Ensuring query logic correctly captured diverse user activity while avoiding misleading signals from bots and inactive users.
WHAT WE DID
WHAT WE DID
Executed complex SQL queries in MySQL Workbench to explore user behavior, posting patterns, and engagement metrics. Delivered insights to support marketing campaigns, feature planning, and investor reporting on platform health.
Executed complex SQL queries in MySQL Workbench to explore user behavior, posting patterns, and engagement metrics. Delivered insights to support marketing campaigns, feature planning, and investor reporting on platform health.
🔍 What I Learned / Gained:
Gained experience working with real-world user behavior data and advanced SQL queries.
Understood how to measure user engagement, retention, and activity trends.
🛠️ Tools & Technologies Used:
Advanced SQL | MySQL/PostgreSQL | Excel | Tableau (optional) | Data Studio
🔍 What I Learned / Gained:
Gained experience working with real-world user behavior data and advanced SQL queries.
Understood how to measure user engagement, retention, and activity trends.
🛠️ Tools & Technologies Used:
Advanced SQL | MySQL/PostgreSQL | Excel | Tableau (optional) | Data Studio
Tannu Antil
Tannu Antil
