Marketing Mix Data Analysis

Client Background

Client: A leading tech firm in the USA

Industry Type: IT Services

Services: Marketing Solutions

Organization Size: 100+

The objective for Marketing Mix Data Analysis

The objective of the project to predict the number of conversions per day and understand the effectiveness of marketing channels as well as other internal/external factors.

Project Description

The project is based on the marketing mix data analysis to predict the number of conversions per day using different spending channels. There are 11 spending channels, 1 promotions column,2 internal factors column, and a date column. We have done exploratory data analysis and created multiple models using different machine learning algorithms.

Our Solution for Marketing Mix Data Analysis

We have done some Exploratory data Analysis on the data after that we have applied some feature engineering to remove outliers and scaling the data and created different models using different machine learning algorithms and compared them to find the best model.

Exploratory Data Analysis

• Correlation Heatmap

• Distribution Plot
• 

• Probability Density function (PDF) and Cumulative Density Function(CDF)

• Box Plot

Observations

• Target conversions shows a very high correlation with spend_channel_8, spend_channel_1, spend_channel_2
• We can see that feature spend_channel_5, spend_channel_7, spend_channel_9 have most of the values is equal to zero or close to zero
• Data is very skewed and has very high variance and contains outliers.

Feature Engineering

1. Added more features

We have extracted day and day of week features from the date. It can be useful since it is possible that spending is more on weekdays or end of the month.

2. Removed Outliers

From the above analysis, we can clearly see the presence of outliers in the data. Since data is not normally distributed so we have used IQR to remove the outliers.

3. Standard Scaling

Since we can see that there are few features that have 6 digit values and few have only one digit. So we are scaling using a Standard scaler. It will improve model performance.

A leading tech firm in the USA

Project Deliverables

1. Project Report
2. Excel Sheet Containing statistical information, Model results, and insights about features.
3. IPython Notebook

Tools used for Marketing Mix Data Analysis

1. Numpy
2. Pandas
3. Matplotlib
4. Seaborn
5. Scikit-Learn
6. Scipy

Language

Python3

Models used

1. Linear Regression
2. Decision Tree
3. Random Forest
4. Support Vector Regressor
5. Gradient Boosting
6. XGBoost

Model Results for Marketing Mix Data Analysis