Preparing sales information
In this chapter, we are presenting a marketing campaign divided into several tasks:
- Detect the best moment to launch the campaign
- Generate individual codes to be sent to potential customers
- Send the codes directly to users over their preferred channel, text message or email
- Collect the results of the campaign
- Generate a sales report with an analysis of the results
This recipe shows task 4 of the campaign.
After sending the information to users, we need to collect the sales logs from the shops to monitor how it is going and how big the campaign's impact is.
The sales logs are reported as individual files from each of the associated shops, so in this recipe, we'll see how to aggregate all the info into a spreadsheet to be able to treat the information as a whole.
Getting ready
For this recipe, we need to install the following modules:
$ echo "openpyxl==3.0.3" >>...