Diagnostic
Business economics, starting point and constraints.
Home / Case Studies / Restaurants
From Google Search to a Booked Table: 395 Web Reservation Requests for Restaurante 3 Soles
We connected local SEO, paid campaigns and a custom web reservation form to help people planning a day out near Bogotá find Restaurante 3 Soles. From May 14 to September 30, the form received 395 unique requests, while Google organic impressions reached 43,079 in September.
395Unique web reservation requests · May 14–Sep 30, 2026
The context
The business before the intervention.
Restaurante 3 Soles is a countryside restaurant on the Chía–Cota road, serving a fusion of Colombian, Mexican and Peruvian cuisine. It offers private kiosks, an events hall and a pet-friendly experience. Most guests come from Bogotá and the surrounding Sabana looking for a weekend outing or a place to celebrate.
In April 2026, the challenge was to connect that intent to a simple, measurable reservation: appear in local searches, make it easy to request a table on mobile and understand which channel generated each inquiry.
The hypothesis
A structure connected to the business outcome.
We built an integrated system around one action: making a reservation. The strategy combined local search visibility, Google and Meta campaigns, useful content, a custom reservation form with campaign parameters, an optimized Google Business Profile and GA4 measurement. We reviewed requests weekly and compared them with the restaurant’s reservation log.
Design
Hypothesis, priorities and measurement architecture.
Operation
Coordinated execution across channels and capabilities.
Optimization
Experiments, learning and periodic decisions.
Results
Metrics with platform and period.
The website received 395 unique reservation requests from May 14 to September 30. Of these, 237 (60%) carried an identifiable Google Ads click. Organic impressions grew from 9,669 in May to 43,079 in September. In a partial reconciliation for May and June, 78 of 118 valid web requests appeared in the restaurant’s log.
Across a sample of 29 attended reservations, 8 had a confirmed web origin and 4 more were probable matches. The restaurant reported an average ticket of COP $185,000 per person. Applied to the 54 guests in the 8 confirmed reservations, this implies estimated sales of COP $9,990,000. Including the 4 probable matches (76 guests total) gives COP $14,060,000.
| Sample scenario | Reservations | Guests | Estimated sales | Estimated ROAS |
|---|---|---|---|---|
| Confirmed web origin | 8 | 54 | COP $9,990,000 | 1.67× |
| Confirmed + probable matches | 12 | 76 | COP $14,060,000 | 2.34× |
How to read this estimate: it uses an average ticket of COP $185,000 per person and compares it with COP $6,000,000 in advertising spend for the quarter. These are not POS-reconciled sales or a full ROAS calculation. They are a floor estimate based on a partial sample of attended reservations.
Web forms · May 14–Sep 30
Unique reservation requests by month
A unique request is the same phone number on the same day. Test submissions were excluded.
Source: web form exports; May starts on the 14th.
Google Search Console · web search
Organic impressions by month
Impressions rose from 9,669 in May to 43,079 in September.
Source: Google Search Console. April covers Apr 8–30.
The website became a reservation channel
After the form launched, the site received requests every day. July was the busiest month, with 110 unique requests. May begins on the 14th. A unique request means the same phone number on the same day; test submissions were excluded.
From inquiry to attended reservation
To understand how many inquiries reached the restaurant, we matched web requests against its reservation log by name, phone, date and time. In May and June, 78 of 118 valid web requests (66%) appeared in that log. In June, 67 of 83 reservations with attendance data were marked as attended (81%).
We also reviewed a sample of 29 attended reservations: 8 had a confirmed web origin and 4 additional matches were probable. The restaurant reported an average ticket of COP $185,000 per person. For the 54 guests in the 8 confirmed reservations, that implies estimated sales of COP $9,990,000. Adding the 4 probable matches, or 76 guests in total, raises the estimate to COP $14,060,000.
| Sample scenario | Bookings | Guests | Estimated sales | Estimated ROAS |
|---|---|---|---|---|
| Confirmed web only | 8 | 54 | COP $9,990,000 | 1.67× |
| Confirmed + probable matches | 12 | 76 | COP $14,060,000 | 2.34× |
Interpretation: the estimate applies an average ticket of COP $185,000 per person and compares it with COP $6,000,000 in quarterly ad spend. It is not revenue reconciled against the POS or a complete ROAS figure. It is a floor estimate from a partial sample of attended reservations.
Organic search expanded local reach
Google organic impressions rose from 9,669 in May to 43,079 in September. From April 8 to October 5, Search Console recorded 2,781 clicks and 132,043 impressions. Blog articles generated 1,363 of 2,806 organic clicks (49%).
| Non-branded query | Average position | CTR or impressions |
|---|---|---|
| Pet-friendly restaurants in Bogotá’s Sabana | 3.4 | 9.8% CTR |
| Where to watch Colombia’s match in Chía | 3.4 | 12.5% CTR |
| Restaurants outside Bogotá | 9.4 | 999 impressions |
| Country restaurants near Bogotá | 9.9 | 2,352 impressions |
The five articles with the most clicks were Restaurants near Bogotá (292), A romantic plan in Chía (235), Pet-friendly restaurants in Chía and the Sabana (170), Pet-friendly places near northern Bogotá (150), and Colombia matches, June 2026 (74).
Channels played different roles
GA4 data for April–September 2026 shows different patterns in volume, engagement and key events by channel. Paid search generated the most key events in this table; organic search, referrals and AI assistants showed notable engagement or event rates.
| Channel | Sessions | Engagement | Key events | Event rate |
|---|---|---|---|---|
| Paid search (Google Ads) | 5,534 | 59.2% | 547 | 8.2% |
| Direct | 3,573 | 43.8% | 92 | 2.3% |
| Organic search | 3,179 | 68.5% | 183 | 4.9% |
| Organic social | 2,251 | 80.5% | 65 | 2.8% |
| Referrals | 406 | 60.6% | 40 | 5.9% |
| AI assistants | 203 | 71.9% | 19 | 7.9% |
| Other | 151 | 62.9% | 10 | 5.3% |
From April to June, Meta Ads started 1,064 WhatsApp conversations at a reported COP $2,237 per conversation. Google Ads recorded 2,514 clicks and a 10.5% CTR. Google Business Profile gained 37 reviews (+236%); all were answered, and direction clicks rose 46%.
What we learned and what comes next
Celebrations are a clear opportunity: 33 of the 111 reservations logged in June were for birthdays, anniversaries, graduations or proposals. A reel filmed at the restaurant earned 3,400 views and 37 shares during the quarter.
The next stage is to record each reservation’s source, document attendance and revenue, and optimize spend around confirmed bookings. These targets for the next 90 days are goals, not achieved results:
- Record the source of more than 90% of reservations.
- Respond to every inquiry in under 2 hours.
- Keep cost per confirmed reservation below COP $50,000.
- Exceed 3× real ROAS by day 90, after reconciling sales amounts.
Sources: GA4 (Apr 1–Sep 30, 2026); Google Search Console (Apr 8–Oct 5, 2026); web reservation forms (May 14–Sep 30, 2026); web-to-confirmed reservation comparison (May–June); July 2026 strategy review. Digisap calculated figures from these records.
The next case