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