Project goal:To compile a database of pre-planned safaris for rapid client responses
What was done:
Designed a Google Sheet containing typical safaris, classified by parameters such as country, duration, type, budget, and season, with hotel and activity details.
Automatically input the calculated costs for safaris (1 to 6 people) for both the current and upcoming year (from the SUMMARY SAFARI SALES CALCULATOR).
Developed a filtering system for easy tour search.
Implemented a system to quickly generate the Safari Sales Calculator for new clients based on the selected itinerary.
Achievements:
Established a centralized tour database that speeds up initial client proposals.
The filtering tool simplified agents' search process for the right safari.
Automated price calculations and updates for subsequent years reduced manual work and kept the database accurate.
The quick setup of a new Safari Sales Calculator from a standard tour now takes minutes, increasing lead conversions as agents can respond to clients immediately!
