An analysis of Facebook Ad campaigns to track the effectiveness of each campaign using SQL. There are three different campaigns in the dataset as seen below:
The age group with the highest audience is 30 - 34.
There isn't much difference between the female and male gender count.
For the gender count by age group, it is discovered that the age group 30 - 34 has the highest male and female count.
The gender count by interest reveals that interest 16 is common among both genders.
This reveals that interests 16, 10 and 29 are the only interests in the top ten that lead to a purchase.
Campaign C has the highest Ad spend.
