Instagram
User
Analytics
using MySQL.
Created by- Mainak Mukherjee
Email- [email protected]
Project Description:-
• The project involves extracting and analyzing data from an
Instagram database.
• Its aim is to understand Instagram user behavior and preferences.
• It seeks insights into user interests, demographics, and engagement
patterns.
• The objective is to enhance content strategies, boost engagement,
and optimize marketing efforts.
• The findings could influence future developments on one of the
world's leading social media platforms.
-| Approach |-
Data Exploration: Exploratory Data Analysis (EDA) is used to better understand
user demographics, post frequency and interaction trends.
SQL Queries and Analysis: Utilizing SQL queries, I extracted relevant subsets of
data from the database to address specific analytical questions.
Content Analysis: Analyzed the content of popular posts, including active
users, inactive users, best days for engagement, loyal users, and prominent
hashtags/captions.
Insights Generation: Through iterative analysis and interpretation of query
results, I derived actionable insights regarding user behavior, content
performance, and audience engagement.
Validation and Iteration: Iterative improvements were made to the analysis
methodology based on feedback and emerging trends in the Instagram
ecosystem.
-| Tech-Stack Used |-
For this project, I utilized the following software and versions:
❑ MySQL Workbench 8.0 CE
o MySQL Workbench was chosen as the primary tool for database
development and management due to its user-friendly interface,
robust query editor, and comprehensive features for database
design and administration.
o Version 8.0 CE was selected to leverage the latest enhancements,
bug fixes, and performance optimizations available in the MySQL
ecosystem.
-: Project Agenda :-
Marketing Analysis
1. Loyal User Reward: The marketing team wants to reward the most loyal users, i.e.,
those who have been using the platform for the longest time.
2. Inactive User Engagement: The team wants to encourage inactive users to start
posting by sending them promotional emails.
3. Contest Winner Declaration: The team has organized a contest where the user
with the most likes on a single photo wins.
4. Hashtag Research: A partner brand wants to know the most popular hashtags to
use in their posts to reach the most people.
5. Ad Campaign Launch: The team wants to know the best day of the week to
launch ads.
Investor Metrics
1. User Engagement: Investors want to know if users are still active and posting on
Instagram or if they are making fewer posts.
2. Bots & Fake Accounts: Investors want to know if the platform is crowded with
fake and dummy accounts.
Task 1:- Identify the five oldest users on Instagram.
Query-
Result-
❖ Insights:- The
results clearly show
that Darby Herzog,
Emilio Bernier,
Elenor, Nicole and
Jordyn Jacobson
are the oldest
Instagram users,
and so are eligible
for the rewards.
Task 2:- Identify users who have never posted a
single photo on Instagram.
Query-
❖ Insights:- The
results clearly
Result-
demonstrate that
these 26 users have
never posted a
single photo on
Instagram. Hence,
they might be
classified as
inactive or less
active users.
Task 3:- Determine the winner of the contest and
provide details.
Query-
❖ Insights:- From the
output of this query
Result- it is clearly evident
that Zack Kemmer
is the winner of the
contest since he has
48 likes on his
Instagram post.
Task 4:- Identify and suggest the top five most
commonly used hashtags on the platform.
Query-
Result- ❖ Insights:- The
result table indicates
that top 5 most
commonly used
hashtags are-
‘#smile’ ‘#beach’
‘#party’ ‘#fun’ &
‘#concert’
Task 5:- Determine the day of the week when most
users register on Instagram.
Query-
Result-
❖ Insights:- Based on
the query output,
Thursday and
Sunday are the
optimal days to run
Ad Campaigns.
Task 6:- Calculate the average number of posts per user on
Instagram. Also, provide the total number of photos on
Instagram divided by the total number of users.
Result 1-
Query 1-
Query 2-
Result 2-
❖ Insights:- On
average, each user
generates 2–3 posts
on Instagram.
Task 7:- Identify users (potential bots) who have liked
every single photo on the site.
Query-
Result-
❖ Insights:- There are
13 fake accounts
that like all
Instagram posts,
which might be
categorized as
potential bots.
