Skip to content

This project conducts a comprehensive analysis of Instagram user engagement, focusing on registration patterns, posting frequency, and user interactions with the help of SQL.

Notifications You must be signed in to change notification settings

Rohit2350/User_Engagement_Analytics_by_SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 

Repository files navigation

This project conducts a comprehensive analysis of Instagram user engagement, focusing on registration patterns, posting frequency, and user interactions with the help of SQL.

Summary of Instagram User Analysis

1. Longest Active Instagram Users

Score Username Score Username
80 Darby_Herzog 95 Nicole71
67 Emilio_Bernier52 38 Jordyn.Jacobson2
63 Elenor88

2. User Registration by Day

Question: What day of the week do most users register on?
Insight: According to our analysis, the majority of users register on:

  • Thursday: 16 users
  • Sunday: 16 users

This information can guide us in scheduling our ad campaign.


3. Targeting Inactive Users

Objective: Identify users who have never posted a photo.
Finding: There are 26 users who have never posted photos on Instagram. We can target these users with an email campaign.


4. Contest for Likes on a Single Photo

Question: Who won the contest for the most likes on a single photo?
Winner: The winner is Zack_Kemmer93 with 145 likes. You can view their profile here.


5. Average User Post Frequency

Investors Inquiry: How many times does the average user post?
Calculation Formula: Total number of photos / Total number of users
Result: According to our analysis, the average comes out to approximately 2.57 (rounded to 3) posts per user.


6. User Rankings by Photo Postings

Analysis Insight:

  • The highest number of photos posted by a user is 74.
  • The lowest number of photos posted is 1.

7. Total Users Who Have Posted

Finding: There are 74 users who have posted at least once on the platform.


8. Most Commonly Used Hashtags

A brand wants to know which hashtags to use in a post. Here are the top 5 most commonly used hashtags:

Keyword Count Keyword Count
smile 59 hair 23
beach 42 happy 22
party 39 beauty 20
fun 38 dreamy 20
food 24 sunset 19
lol 24 fashion 19
concert 24 drunk 19
sunrise 17 photography 16
landscape 17 stunning 16
style 17 delicious 15
foodie 11

9. Identifying Bot Activity

Issue: We have a small problem with bots on our site.
Finding: Here are the users who have liked every single photo on the site:

Rank Username Score Rank Username Score
5 Aniya_Hackett 257 41 Mckenna17 257
14 Jaclyn81 257 54 Duane60 257
21 Rocio33 257 57 Julien_Schmidt 257
24 Maxwell.Halvorson 257 66 Mike.Auer39 257
36 Ollie_Ledner37 257 71 Nia_Haag 257
75 Leslie67 257 76 Janelle.Nikolaus81 257
91 Bethany20 257

About

This project conducts a comprehensive analysis of Instagram user engagement, focusing on registration patterns, posting frequency, and user interactions with the help of SQL.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published