Ahmed ViquasBook a call

Travel platform engineering

Boat Trips Club

The technical backbone for a multi-location boat-tours business: a faster site, a faster CRM, and tracking that ties ad spend to real bookings.

Client
Boat Trips Club
Industry
Travel and tours
Year
2025-2026
Status
Live
Web performanceCRM engineeringAnalyticsProduct strategy

Built with WordPress, LiteSpeed Cache, Zoho CRM, WP-CLI, GA4, Meta Pixel, Bokun

boattripsclub.com
Boat Trips Club site: aerial-ocean hero with destination search.

Boat Trips Club runs boat tours across several destinations, with operations spread across locations like Cancun and Cabo San Lucas. We took on the parts of the business customers never see but the business depends on: a slow website, a tangled Zoho CRM, broken tracking, and a fragmented multi-domain setup. The goal was a fast, measurable platform the business could grow on, fixed without taking the live operation offline.

The situation

Four problems, all live at once.

  • The website ran slow. CPU stayed pinned for over a month, with no caching and failing Core Web Vitals
  • A migration from older location domains into boattripsclub.com had left hundreds of broken internal links and long redirect chains
  • The Zoho CRM took nearly 20 seconds to load a single customer record
  • Tracking was incomplete. Paid ad spend could not be connected to actual bookings

Website performance

We diagnosed the slowdown as a CPU problem, not memory or workers, and the data showed it was chronic, not a one-off spike.

We installed and configured LiteSpeed Cache and Autoptimize: page, object, and browser caching, CSS and JS minification, and deferred render-blocking assets. The Core Web Vitals issues resolved and the site stabilized after weeks of strain.

Domain consolidation and SEO

The migration into a single domain had broken the site's internal linking. We mapped 11 URL redirects from the old location domains into boattripsclub.com, fixed more than 350 broken internal links with WP-CLI search-replace across the full database, then cleaned the redirect chains caused by missing trailing slashes and wrong slugs. Every change was followed by a clean cache purge so the fixes held.

Zoho CRM engineering

The customer detail function in Zoho was taking 19.5 seconds to return one record. The cause was an N+1 query pattern: one API call per booking inside a loop, plus a referral lookup in the same loop. For a customer with 35 bookings, that was around 70 sequential API calls.

We rewrote it to batch the calls outside the loop. The result was 19.5 seconds down to 1.17 seconds, with identical output. We also fixed an HTML entity encoding bug in product names and a second function carrying the same N+1 problem.

Analytics and attribution

We implemented GA4 and Meta Pixel across the site and added GCLID and fbclid capture so every ad click can be traced to a booking. The key move was feeding booking revenue from Bokun and Zoho back into the ad platforms, so campaigns optimize for real return on ad spend, not clicks or form fills.

Strategy and roadmap

Beyond the fixes, we mapped where the business could go: a phased menu of services across customers, staff, operations, and marketing, then scoped a custom operating system to replace WordPress first, then Zoho, in stages. The guiding rule was simple, replace before adding. Every phase replaces something that exists today, so the live business never breaks.

Results

  • Customer lookup 17x faster, 19.5s down to 1.17s
  • Site performance fixed after a month of chronic CPU load
  • 11 location domains consolidated into one, 350+ links repaired
  • Paid ads now optimized against real booking revenue, not clicks

Next project

ItsWare