🧑🤝🧑 Customers: Eastern-European expat's living in Indonesia
I created a fully custom business intelligence system on Google Sheets to be able to track very specific key data for each specific product offering. Items (per product!) such as:
- customer location
- customer nationality
- purchase value
- recurring purchase rate
- complaints
- day of the week
- language
This in turn was vital to fully understanding the customers and the performance of each product offering. This data and system was paramount in justifying the investment spent on each "bet" (each inventory item). The operations team also uses the system as a ERP to track other information such as customer complaint data. It still is a vital part of the operations of the business today.