What is the database marketing?
Database marketing is a form of direct marketing. It involves collecting customer data like names, addresses, emails, phone numbers, transaction histories, customer support tickets, and so on. This information is then analyzed and used to create a personalized experience for each customer, or to attract potential customers.
Today’s marketers have access to more customer data than ever before. That’s why database marketing is once again becoming so important. It’s all about using that sea of data to create more relevant marketing messages that better resonate with customers — both current and potential.
My project
What I want to do
Not long ago, I created a brand of women's clothing. I use ethnic fabrics from West Africa to design my clothes. In parallel with my permanent collection, I have put jackets on sale in a limited collection. I would like to know in this limited collection which items have been most bought in order to sell them permanently.
Notre Univers
How can I code it?
We need to have a database looking like this. With the filled area.
For example _id stand for identifiant, so that every jacket will have an unique id. Moreover we have all other information we need in our database: couleur, modèle, nom, sale.
Here an example of code to add some datas regarding new jackets in our database
Here is an example of code to select only sales with more 80 sal.
Conslusion