Instagram User Analytics

Description:

User analysis is the process by which we track how users engage and interact with our digital product (software or mobile application) in an attempt to derive business insights for marketing, product & development teams.

These insights are then used by teams across the business to launch a new marketing campaign, decide on features to build for an app, track the success of the app by measuring user engagement and improve the experience altogether while helping the business grow.

We are working with the product team of Instagram and the product manager has asked us to provide insights on the questions asked by the management team.

Objective:

We are required to provide a detailed report answering the questions below :

A) Marketing: The marketing team wants to launch some campaigns, and they need our help with the following

1. Find the 5 oldest users of the Instagram from the database provided.
2. Find the users who have never posted a single photo on Instagram.
3. Find the user who gets the most likes on a single photo.
4. Identify and suggest the top 5 most commonly used hashtags on the platform.
5. What day of the week do most users register on? Provide insights on when to schedule an ad campaign.

B) Investor Metrics: Our investors want to know if Instagram is performing well and they want to assess the app on the following grounds

1. Provide how many times does average user posts on Instagram. Also, provide the total number of photos on Instagram/total number of users.
2. Provide data on users (bots) who have liked every single photo on the site (since any normal user would not be able to do this).

Insights:

There are some of the insights that we have gained through this project. Which are as follows:

A) 1.

A) 2.

A) 3.

A) 4.

A) 5.

B) 1.

B) 2.

Result:

Through working on this project, We have gained many of the insights like 5 oldest users, users who have never posted a single photo, user who gets the most likes, top 5 commonly used hashtags, Fake users and many more. Through this project, we have gained more practical knowledge about SQL concepts and MySQL workbench.