This project revolves around leveraging three years' worth of transactional data collected by a manufacturer of automobile components. The primary objective is to harness this valuable historical data to generate personalized marketing plans tailored to different client categories.
The manufacturer faces the challenge of optimizing its marketing strategies and resources to cater to various client segments effectively. To address this, I have implemented RFM (Recency, Frequency, Monetary) analysis, a powerful technique in customer segmentation and targeting.
RFM analysis involves assessing the following aspects for each customer:
- Recency: How recently did the customer make a purchase?
- Frequency: How often does the customer make purchases?
- Monetary: How much does the customer spend?
By evaluating these parameters, we can categorize customers into different segments based on their buying behavior. This information is invaluable for crafting personalized marketing strategies for each group, such as tailored promotions, recommendations, or communication channels.
- Utilized three years' worth of transactional data for insights.
- Implemented RFM analysis using KNIME to segment customers effectively.
- Developed personalized marketing plans for each customer category.
- Optimized marketing strategies and resource allocation.
- Enhanced customer engagement and satisfaction.
To explore the project and its findings, refer to the provided Business Report in this repository. You can follow the steps outlined to replicate the RFM analysis and personalized marketing plans for your datasets or adapt the approach to other industries.
![image](https://private-user-images.githubusercontent.com/104824947/293692317-a4196180-cd72-4658-bc8f-bd96e75dba8b.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQzOTg4MzYsIm5iZiI6MTcyNDM5ODUzNiwicGF0aCI6Ii8xMDQ4MjQ5NDcvMjkzNjkyMzE3LWE0MTk2MTgwLWNkNzItNDY1OC1iYzhmLWJkOTZlNzVkYmE4Yi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyM1QwNzM1MzZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1kYWRmODg2NTVkY2IxYzg0YThlMGNkYjdjZDM2YTc4MzMxNmNhZjAwZjkzNzJiYzk0MjBiODQ1ZjM4NzZlYjk0JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.BBqeINv6BnZMhZqg7lw2LkZG-k7nhcdr5libGwOUpU8)
![image](https://private-user-images.githubusercontent.com/104824947/293692379-2bcb62f0-0808-4596-b699-16365e6db38c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQzOTg4MzYsIm5iZiI6MTcyNDM5ODUzNiwicGF0aCI6Ii8xMDQ4MjQ5NDcvMjkzNjkyMzc5LTJiY2I2MmYwLTA4MDgtNDU5Ni1iNjk5LTE2MzY1ZTZkYjM4Yy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyM1QwNzM1MzZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT05NTgxYjhiM2RlMGZlYjM4NmE0MGNiZWU1NTg3NWJjZDAyYWQ1YTgwOWRmNjdlOWU0NWY3MmIyYzhmMDAwNzdhJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.uFJ_Rp1WuoBawxL4dSq3tfqwErOYDnrd_W-SsQXdlY8)
![image](https://private-user-images.githubusercontent.com/104824947/293689337-e181d32a-2714-4b40-bb4a-d6aadfd5b19a.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQzOTg4MzYsIm5iZiI6MTcyNDM5ODUzNiwicGF0aCI6Ii8xMDQ4MjQ5NDcvMjkzNjg5MzM3LWUxODFkMzJhLTI3MTQtNGI0MC1iYjRhLWQ2YWFkZmQ1YjE5YS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyM1QwNzM1MzZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT01YzYxNjU4OWMxMjgxOGY2ZWU3MjdjZTdhYmMwOTE4Mjg5ZWUzYzczM2FiODNhZjcxYmExZDBkYzhlNWI3MjU1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.K8kO78kFpSObTTdGB7vWIb5pbf3dpCa2aqlktkc-v1M)
![image](https://private-user-images.githubusercontent.com/104824947/293689191-5c3a0279-f7bc-4169-bc80-e58c00ce3bdc.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQzOTg4MzYsIm5iZiI6MTcyNDM5ODUzNiwicGF0aCI6Ii8xMDQ4MjQ5NDcvMjkzNjg5MTkxLTVjM2EwMjc5LWY3YmMtNDE2OS1iYzgwLWU1OGMwMGNlM2JkYy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyM1QwNzM1MzZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0xOTRmZDgzOTdmMjRkMTdlODE0MDUwMGFhNGRmOTc2Mzc0OGY2ZjlmMmQwMmU3NjI3YmY4MmIwZDdkYTQwZDgxJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.s7P6Ti3uACPyfG8c5nvBrr-BqJkeNkjB3p6Y6GzHF8U)
![image](https://private-user-images.githubusercontent.com/104824947/293689456-11fc1d6f-85cc-4afb-a7de-867ce5a7d49c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQzOTg4MzYsIm5iZiI6MTcyNDM5ODUzNiwicGF0aCI6Ii8xMDQ4MjQ5NDcvMjkzNjg5NDU2LTExZmMxZDZmLTg1Y2MtNGFmYi1hN2RlLTg2N2NlNWE3ZDQ5Yy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyM1QwNzM1MzZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00M2JlNmFjMjlmN2VkZjUzNWZlMjc0NDUyNDY4MzQwOTJhNjAwM2IxOGQ1NDNkMzMzMDYxYmI0YzcxMDA1MTRlJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.yOjF1zfAEhVhgtPjYKuZn_B-E_GBYMRVwXULRXuqUbU)