E-commerce Multichannel Direct Messaging 2021-2023

About

This dataset contains multi-channel messages of medium sized online store for 2 years.

Channels: email, web push, mobile push, SMS.

Campaign types: bulk, triggers, transactional.

Notice: this dataset contains messages-demo.csv file limited to 10M messages. The full file with 721M messages is available here: messages.csv (21.5Gb).

Data collected by REES46 CDP project.

Files description

Here is a brief description of files. You can find the detailed description of every property in this notebook.

holidays.csv

Bulk campaigns usually set before holidays and sale outs. This file contains not full list of Russian holidays and commerce activities so you can see how bulk campaigns are related to these dates.

campaigns.csv

All messages are related to some kind of campaigns:

1. Bulk campaigns are sent for sale outs and before holidays to stimulate sales and bring back customers.
2. Trigger messages (like abandoned cart) are sent automatically based on user's behavior. More users visited website/app – more trigger messages are sent.
3. Transactional messages are used for some kind of information delivery process: bonuses added, order delivery status changed, etc.

Keep in mind: campaign_id is unique only for the specific campaign_type. Two campaigns with different campaign_type can have the same campaign_id. So the unique campaign identifier is campaign_type + campaign_id.

Additional properties are added to every campaign to describe its meaning (topic) or subject parameters (emoji, call to action, etc).

messages.csv or messages-demo.csv

Messages table contains a list of all messages sent with its statuses and meta info:

1. Campaign
2. Channel
3. Type
4. Opened (when)
5. Clicked (when)
6. Purchase
7. Etc. See attached dataset for detailed info of every property

client_first_purchase_date.csv

The file has 2 columns:

1. Client ID
2. Date of the first purchase ever

More datasets

Checkout another datasets:

1. https://www.kaggle.com/mkechinov/ecommerce-behavior-data-from-multi-category-store
2. https://www.kaggle.com/mkechinov/ecommerce-purchase-history-from-electronics-store
3. https://www.kaggle.com/mkechinov/ecommerce-events-history-in-cosmetics-shop
4. https://www.kaggle.com/mkechinov/ecommerce-purchase-history-from-jewelry-store
5. https://www.kaggle.com/mkechinov/ecommerce-events-history-in-electronics-store
6. https://www.kaggle.com/datasets/mkechinov/ecommerce-purchase-history-from-jewelry-store
7. [NEW] https://www.kaggle.com/datasets/mkechinov/direct-messaging - you're reading it right now

Many thanks

Thanks to REES46 Marketing Platform for this dataset.

Using datasets in your works, books, education materials

You can use this dataset for free. Just mention the source of it: link to this page and link to REES46 Marketing Platform.