Marketing Campaign Data Analysis

Major Insights:

·3 entries comprise age group greater than 100 which was deleted in order to execute a perfect analysis.

·Overall, the enrolment rate is almost same in the first and second quarter of 2014.There is a 27% increase the enrolment rate towards the second quarter of 2014 compared to third quarter of 2012.

·Canada shows a 32% decline in the enrolment rate towards the second quarter of 2014.

·Spain has retained the enrolment rate in the last quarter of 2013 towards the second quarter of 2014, after a dip in the enrolment rate in the first quarter of 2014.

·Customers with high Education status comes in majority web purchases. The Education level of top users are Graduates (4649) followed by PhD (2146), Masters (1492), 2n Cycle (754) and Basic (102).

·The last campaign was the best performing campaign with a success/acceptance rate of 14.9%. This is followed by Campaign 4 (7.5%), Campaign 3 (7.3%), Campaign 5 (7.2%), Campaign 1 (6.4%). The least performed campaign was Campaign 2 with an acceptance rate 1.3%.

·Campaign 2 was a failure in Australia, Mexico, and USA with an Acceptance rate of 0%.

·Campaign 1, 4 and 5 was an unsuccessful one in Mexico with a Success Rate of 0%.

·Wine records the highest Amount sales which records approx. 50% of the sales followed by Meat (27.6%), Gold (7.3%), Fish (6.2%), Sweet (4.5%) and Fruits (4.3%).

·In houses with number of teen teenagers 2 majority sales amount was spend for wine which is approx. 61%. Followed by Houses with 1 teenager (approx.59%) and with 0 teenagers (44%).

·The Store purchase is the Channel that records the highest sales.

·The Website records the second highest sales with a conversion rate of approx. 77%. Followed by Catalogue purchase.

·Spain records the highest number of Discount, Website and Store purchases