This project is the final project of the Ironhack Data Analysis Bootcamp. In this project, we worked with the database from Refyld.
Refyld is a company that sells, at cost price, natural, sustainable and 100% rechargeable hygienic products thanks to a simple annual membership.
Our task was to conduct a leads analysis to find some insights about their clients and to better understand their social media performance. The main questions that drove us were: Who are their clients? How many subscribers in the newsletter? What are their social media metrics? Which publication has more interactions?
- Profiling Users
- Social Media Analysis
- Dashboard Development
The main hindrance in this project was the time constraints. One week to retrieve, gather, clean, and analyze the data. With multiple sources of data, we spent a significant amount of time selecting and collecting the information that would be useful. The development of the dashboard was not possible for the presentation, however, it's under construction.
To accomplish our task, we used the following dataset :
- Users' information (gender, location, type of membership, turnover, etc.)
- Ads information (gender, age, location, click rate, etc.)
- Newsletter (subscribers, unsubscribers, opening rate, etc.)
- Facebook Page Insights (impression, reach, engagement, likes, talking about, etc.)
- Facebook Post (numbers of likes, audience, publication type, etc.)
- Instagram (followers, impressions, reach)
- Data Gathering
- Separating data and responsibility
- Data Cleaning
- Defining KPI
- Data Analysis and Data Visualization
- Powerpoint presentation
- Dashboard creation
Users are mostly women and the audience is principally women between the age of 24 and 35 years old.
