Freedom Debt Relief is an organization that helps individuals who have accrued significant debt as a result of unexpected hardship and are no longer able to meet their minimum monthly requirements. Upon enrolling in Freedom’s Debt Relief program, customers cease making payments to their creditors and instead make deposits they can afford into a new dedicated bank account with Freedom. Freedom uses these funds to negotiate with each of the client’s creditors to settle the debt, typically at only a fraction of what was originally owed. Freedom collects fees (proportional to the monthly deposited amount) from the client for agreements it successfully negotiates.
-
Provide a quantitative assessment of whether the marketing campaign was successful.
-
Based on the provided data, recommend ways the campaign strategy canalso be applied in the future to improve performance.
clients - Contains data regarding client's age, residence status, and geographical region
deposits - Contains data regarding client deposit behavior. These include deposit type, deposit amount, deposit cadence, and deposit date.
calendar - Contains calendar information in relation to deposit and client datasets.
In order to quantify the success of the marketing campaign, the monetary value of deposits over the course of the 5 month period was assessed. Below we can see that a substantial increase in total deposits was observed while the marketing campaign was running (month 3) and that total deposits remained high after the campaign ended (months 4 and 5).
On average, Freedom charges a fee of 21.5% of the total amount of debt that they are able to settle on behalf of their clients. Therefore, the total deposit amount per month was multiplied by 0.215 to calculate the profit per month.
On average, the profit per month before the campaign was ~$6.3 million while after the campaign it was ~$8.2 million. This indicates the marketing campaign increased profit ~$1.9 million per month.
To better understand the cost and benefits of the marketing campaign, hypothetical data was generated to show total profit over a 12 month period with/without the campaign. It was assumed that profit each month would reflect the average profit per month before and after the campaign (before = $6.3 million and after = $8.2 million). In addition, since the marketing campaign cost $5 million campaign began at -$5 million. We can see that by the 4th month the campaign would have increased profits by $700,000 and by the 12th month profits would be icnreased by $17,800,000.
Based on this data, it appears the marketing campaign will have been well worth the $5 million investment provided there isn't a significant increase in client churn or significant changes in client's depoist amounts.
The marketing campaign couuld be improved by targeting specific groups that enrolled as a result of the marketing strategy and also make higher value deposits each month.
First, clients were grouped based on age and the change in client's based on age was graphed. We can see that the marketing campaign was successful in generating new clients across most age groups. However, this was most prominent in individuals between 31-70 years of age.
We also observe that individuals who own homes were also more responsive to the marketing campaign.
We find similar trends when we look at the total number of Freedom's clients that are renters vs owners by age.
Based on this data, future marketing campaigns could be targeted at middle aged individuals and those who are home owners.
This project focused on analyzing the success of a marketing campaign and identifying ways to improve it during future iterations. The campaign was found to result in a ~$2 million per month increase in profits when compared to pre-campaign data. Even accounting for the cost of the campaign, if trends hold, it is expected an additional $16 million in profit would be generated 1 year after the campaign compared to if the campaign had not been run at all. Finally, the largest increases in clients as a result of the marketing campaign were from middle aged individuals and those who are home owners. Based on this, future campaigns could focus their efforts on targeting individuals belonging to these groups.