Tried to analyse facebook ad data to find best ad campaigns and target groups for a particular ad.
We found the dataset on kaggle. Link: https://www.kaggle.com/loveall/clicks-conversion-tracking
We answered some business related questions from the insights that we got after analysing the data.
-
How to optimize the social ad campaigns for the highest conversion rate possible? (Attain best Reach to Conversion ratios/Click to Conversion ratios)
-
Finding the perfect target demographics with the appropriate click through rates
-
Understanding the ideal turnaround/decision making time per age group to convert and re-target future social campaigns
-
Comparing the individual campaign performance so the best creative/campaign can be run again with adjusted audiences.
- Did data cleaning and data preparing activities.
- Ran descriptive analytics on the prepared data and plotted tables, charts and graphs.
- Interpreted the charts and graphs and listed out the insights.
- Used Kmeans algorithm, Elbow technique to find optimal number of clusters and various different libraries and frameworks like pandas, numpy, seaborn, matplotlib, sklearn, etc. to run the descriptive analytics.