# Marketing Funnel by Olist Welcome! This is a marketing funnel dataset from sellers that filled-in requests of contact to sell their products on [Olist Store](http://www.olist.com). The dataset has information of 8k Marketing Qualified Leads (MQLs) that requested contact between Jun. 1st 2017 and Jun 1st 2018. They were randomly sampled from the total of MQLs. Its features allows viewing a sales process from multiple dimensions: lead category, catalog size, behaviour profile, etc. This is real data, it has been anonymized and sampled from the original dataset. ## Joining with Brazilian E-Commerce Public Dataset by Olist This dataset can also be linked to the [Brazilian E-Commerce Public Dataset by Olist](https://www.kaggle.com/olistbr/brazilian-ecommerce/home) using seller_id. There you will find information of 100k orders, price, payment, freight performance, customer location, product attributes and finally reviews written by customers. **Instructions on joining are available on this [Kernel](https://www.kaggle.com/andresionek/joining-marketing-funnel-with-brazilian-e-commerce).** ## Context This dataset was generously provided by Olist, the largest department store in Brazilian marketplaces. Olist connects small businesses from all over Brazil to channels without hassle and with a single contract. Those merchants are able to sell their products through the Olist Store and ship them directly to the customers using Olist logistics partners. See more on our website: [www.olist.com](https://www.olist.com) **A seller join Olist through a marketing and sales funnel that was made public at this dataset. Description of steps:** 1. Sign-up at a landing page. 1. Get contacted by a Sales development Representative (SDR), confirm some information and schedule a consultancy. 1. Consultancy is made by a Sales Representative (SR). The SR may close the deal (lead sing up) or lose the deal (led leaves without sign in) 1. Lead becomes a seller and starts building his catalog on Olist. 1. His products are published on marketplaces and ready to sell! Attention 1. A seller MQL might come from multiple sources (he might subscribe on two different landing pages, for instance). Examples of Landing Pages   ## Data Schema The data is divided in multiple datasets for better understanding and organization. Please refer to the following data schema when working with it:  ## Inspiration Here are some inspiration for possible outcomes from this dataset. **Customer Lifetime Value:**
How much a customer will bring in future revenue? **SR/SDR Optimization:**
Which SR or SDR should talk with each kind of lead? **Closing Prediction:**
Which deals will be closed? **EDA:**
Just Have Fun! ## Acknowledgements Thanks to Olist for releasing this dataset.