Case study

Ecotourism Operator

Data intelligence and automation for an operator that was growing on gut feeling

An ecotourism operator in Rio de Janeiro, with R$1.2 million (BRL) in annual revenue and 7–8 freelance guides, went from chaotic spreadsheets and zero financial visibility to a full dashboard, automated sales capture and 6 years of data consolidated for the first time.

IndustryEcotourism (Rio de Janeiro)
Duration7 months (ongoing retainer)
PeriodApr 2025 — Jan 2026

The challenge

An ecotourism operator in Rio de Janeiro running hikes, rafting and diving trips, with R$1.2 million (BRL) in annual revenue. The owner managed everything alone with 7–8 freelance guides — but all of the business knowledge lived in his head.

What we did

01
Full operational dashboard
A consolidated view of the entire operation from 2017 to the present, in Looker Studio.
02
Financial breakdown
The first structured analysis of revenue, costs and profit by category, guide and period.
03
Automated sales capture
Updated the Google Apps Script to capture bookings from multiple platforms, including cancellations.
04
Interactive pickup map
Geolocation of client pickup points to build optimized routes with fixed meeting points.
05
NLP review analysis
Web scraping + sentiment analysis of each guide's reviews, focusing on ratings below 5 stars.
06
CRM and per-guide reports
Monthly tracking of individual performance based on real client data.
07
3 operational SOPs
Procedure manuals so the company can run without the owner.

Results

* All metrics below are conservative estimates based on the delivered scope.

10-15h/wkTime saved on operational management
6+ yearsOf data consolidated for the first time
100%Structured financial visibility
0 → 1First data-driven guide evaluation system
3 SOPsManuals that remove dependence on the owner
RoutesLogistics optimized with an interactive map

Tools used

Python Looker Studio Google Sheets Google Apps Script APIs Jupyter Notebook NLP (sentiment analysis)

How it worked

Faster management
The owner stopped opening spreadsheet after spreadsheet. Everything lives in one dashboard.
Protected bookings
Cancellations and changes are captured automatically, eliminating losses.
Targeted marketing
Real data on customer profiles and seasonality led to sharper campaigns.
Optimized logistics
Fixed pickup points replaced hotel-by-hotel pickups.
Growing revenue
The company grew during the project, with data-driven decisions.

Want something like this for your business?

A quick 20-minute call to understand your operation. No commitment.

Message me on WhatsApp Send an email