Problem & background

A marketing campaign is held to reach out to people who can be their customers and also their customers whom were inactive. This Marketing campaign data of 2,240 customers of Maven Marketing, including customer profiles, product preferences, campaign successes/failures, and channel performance. Our task is to determine how average customer looks like so we could target these categorical people in the society, another task is various factors that may influence sales on the web channel, and the last but not least to tell whether which campaign is most successful and which channel is underperforming.

Solution

A data of the customers and the result of various marketing campaign, is the data we are going to perform our analysis by using Microsoft Excel, as the data is not to large Excel is the perfect tool to work with, its feature called “Pivot Table” will help to generate insights from the data and answer our analysis related question.

Methodology & Project scope

Our final motive of this analysis is to calculate and answer some of the analysis questions and make this calculation logical and understandable.

• Firstly, the most important thing is to prepare a data dictionary, without understanding the data dictionary, it will be difficult to know about data, understanding the column names and what actual story the data tells you, this can only happen after knowing the data dictionary

•    Data dictionary contains 2 columns and a lot of important information about the data.

•   For initializing the calculation or analysis part, I am going to generate pivot tables and will perform required mathematical operations to understand the data and generate insights.

• Visualization is generated right after the pivot table and also answered some of the important questions of my analysis.

Conclusion

  This analysis will help the marketing company to know more about which type of campaign company must conduct, also by performing this analysis anyone can understand the best product company offers. Company will know which type of people in the society is the one to target, so company could generate more customer and eventually more profit.