Your booking platform tells you who reserved a table. It never tells you who sat at it. CaptiFi matches your reservations against the guests who join your WiFi, so every booking resolves to attended or no-show on its own, and your review requests only ever reach people who really came in. Included on the Growth plan and above.
Every 15 min
bookings matched against WiFi sign-ins
-30 min to +3 hr
the attendance window
7 days
lookback for late imports
30 days
of attendance stats per venue
What CaptiFi does about itCovers booked and covers served are different numbers, and most venues only have the first one. Your booking system closes the night with every reservation still marked as booked, so no-show rates are guesswork, and automated review requests go out to people who cancelled at the door.
Import your OpenTable export or add bookings by hand, and CaptiFi compares them against WiFi sign-ins at that venue every 15 minutes. A booking whose email or phone number appears on your WiFi is marked attended; one that never appears resolves to no-show once its window passes. You can override any row by hand, and the check-in source column always shows how the result was reached.
Automatic attendance from WiFi sign-ins, checked every 15 minutes with no staff involvement
A guest counts as attended from 30 minutes before the booking to 3 hours after it, so late arrivals still match
Import an OpenTable CSV straight in, or any spreadsheet with a date and a name, email or phone column
Re-importing an updated export never duplicates a booking: rows match on confirmation number and update in place
Booked, attended and no-show counts plus your attendance rate for the last 30 days, per venue
Ask only real diners for reviews: review requests can be held back unless the guest matched an attended booking
Reservation check-in matches the bookings you took against the guests who joined your WiFi. You import your OpenTable export, upload another spreadsheet or add bookings by hand, and every 15 minutes CaptiFi compares those bookings with WiFi sign-ins at the same venue. A match marks the booking attended; a booking with contact details and no match resolves to no-show. It is included on the Growth plan and above.
On the email address or the phone number, at the same venue, inside a window that opens 30 minutes before the booking and closes 3 hours after it. Phone numbers are converted to international format on import so they line up with the numbers your WiFi collects. Nothing is matched across venues.
No. Late imports are matched against WiFi connections up to 7 days back before anything is called a no-show, so a Friday export uploaded on Monday still produces the right attendance for the weekend.
CaptiFi is a guest WiFi marketing platform for venues, restaurants, hotels, cafés, retail spaces and short-term rentals. It turns branded WiFi logins into first-party customer data, automated Google review requests, repeat visitor insights and email marketing lists.
In the dashboard, open Integrations and switch on Reservations under Dashboard features. Reservations appears in your sidebar. It is included on the Growth plan and above.
Export your reservation list from OpenTable as a CSV, open Reservations, click Import CSV, choose the venue and upload the file. Any other spreadsheet works too: choose Other spreadsheet as the source. You can also add a booking by hand with Add reservation.
Every 15 minutes CaptiFi compares booked reservations against WiFi sign-ins at the venue. A booking whose email or phone number connects between 30 minutes before and 3 hours after its time is marked attended; one with contact details and no matching connection resolves to no-show once the window has passed.
Bookings with only a name and no contact details are never resolved automatically. Use Mark attended or Mark no-show on the row. The check-in source column shows whether each result came from WiFi presence, the booking platform or a person.
Read your attendance rate on the Reservations page, turn on Only ask guests with an attended reservation in your Google Reviews settings, and trigger SMS follow-ups from the reservation attended event.
Matcher runs
Every 15 min
Attendance appears through the service rather than at the end of the night.
Attendance window
-30 min to +3 hr
Early arrivals and long dinners both still match their booking.
Late import lookback
7 days
Upload yesterday or last week and the matcher still checks the right evening.
Attendance stats
Last 30 days
Booked, attended and no-show counts plus your attendance rate, per venue.
Duplicate imports
Upserted
OpenTable rows match on their confirmation number and update in place, never duplicate.
Matched on
Email or phone
Either identifier is enough. Name-only bookings are left for you to resolve by hand.
Your Google Reviews settings can hold a review request back unless the guest matched an attended booking. A no-show is never invited to review a meal they did not eat, which is the kind of request that earns a one-star answer.
SMS automations can fire from the reservation attended trigger, so a thank-you or an offer goes out to people who actually came in. Guests still need SMS consent, and SMS marketing is its own feature.
Booked, attended and no-show counts with an attendance rate over the last 30 days, per venue. A number you can act on when you are deciding whether to take deposits or overbook a Saturday.
The person who booked the table becomes a guest in your database with a visit behind them, so your marketing stops treating a regular as a stranger because they booked through a platform.
Reservation check-in is on Growth and above and works from the OpenTable export or spreadsheet you already produce. It is not a booking system and does not replace one, so there is nothing new to pay per cover.
CaptiFi completely changed my business. Before, every guest was a one-time booking. Now I have a direct line to thousands of people who've stayed in the plane. I can offer them return deals, send updates about new features, and keep them engaged. My repeat booking rate went from almost zero to 35%. It's been incredible.
Owner, PytchAir Boeing 727 Airbnb
Get more Google, TripAdvisor and Yelp reviews automatically, without asking staff to remember.
Learn more
Turn anonymous foot traffic into identified customers automatically.
Learn more
Real-time WiFi analytics that actually make sense.
Learn more
Start your 30-day free trial today. Hardware included (refundable hold), no setup costs, cancel anytime.