OpenTable data reference

OpenTable data reference

Estimated 6 minute read

Updated Mar 24, 2026, 12:00 AM EST

Table of contents

You will learn
How to view your data
Metrics
Synced guest data

You will learn

Learn what data syncs from OpenTable to Klaviyo and where to view it. This includes data related to reservation creation, confirmation, and cancellation.

If you have not already, read our guide on getting started with OpenTable for step-by-step instructions on integrating, before continuing with this article.

OpenTable allows you to import guests into the restaurant's systems. These guests do not have reservation dates until a reservation is made for their profile.

Klaviyo syncs email addresses and email consent from OpenTable. While phone numbers are synced, SMS consent is not. You must collect SMS consent separately before sending marketing text messages to these guests.

How to view your data

To view your OpenTable data:

Click the Analytics dropdown in the left-hand navigation sidebar.
Select Metrics. Here, you can view all of the metrics in your account. The metrics labeled “OpenTable” represent all of the metrics synced from your OpenTable integration.
Select OpenTable in the Integration filter to show only OpenTable metrics.

Click a metric name to view its details.

Metrics

A $value property is included when OpenTable provides a nonzero POS total for the reservation. To sync POS totals, your POS system (e.g., Square, Toast, or Lightspeed) must be connected to OpenTable.

Created Reservation

This event records a reservation created in OpenTable.

Created Date The timestamp of when the reservation was created in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Scheduled Time The timestamp of the scheduled reservation date in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Table Number The table number associated with the reservation, assigned by the restaurant in OpenTable.
Party Size The party size specified by the guest.
Visit Tags Any tags associated with the visit such as those related to specific types of service or seating, e.g., birthday, anniversary, window seating, etc.
Reservation Origin The source of the reservation, i.e., Phone, Walk-in, or Web.
Guest Request Any requests specified by the guest during the reservation process.
Table Category The table category associated with the reservation, assigned by the restaurant in OpenTable, i.e., Bar, Hightop, Outdoor, etc.
Server The name of the server associated with the reservation.
Currency Code The currency code provided by OpenTable for the reservation.
Restaurant ID The ID of the restaurant associated with the reservation.
Restaurant Name The name of the restaurant associated with the reservation.

Confirmed Reservation

This event occurs when a reservation is marked as confirmed in OpenTable.

Created Date The timestamp of when the reservation was created in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Scheduled Time The timestamp of the scheduled reservation date in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Table Number The table number associated with the reservation, assigned by the restaurant in OpenTable.
Party Size The party size specified by the guest.
Visit Tags Any tags associated with the visit such as those related to specific types of service or seating, e.g., birthday, anniversary, window seating, etc.
Reservation Origin The source of the reservation, i.e., Phone, Walk-in, or Web.
Guest Request Any requests specified by the guest during the reservation process.
Table Category The table category associated with the reservation, assigned by the restaurant in OpenTable, i.e., Bar, Hightop, Outdoor, etc.
Server The name of the server associated with the reservation.
Currency Code The currency code provided by OpenTable for the reservation.
Restaurant ID The ID of the restaurant associated with the reservation.
Restaurant Name The name of the restaurant associated with the reservation.

Completed Reservation

This event occurs when OpenTable marks a reservation as done, assumed done, or assumed seated.

Created Date The timestamp of when the reservation was created in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Scheduled Time The timestamp of the scheduled reservation date in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Table Number The table number associated with the reservation, assigned by the restaurant in OpenTable.
Party Size The party size specified by the guest.
Visit Tags Any tags associated with the visit such as those related to specific types of service or seating, e.g., birthday, anniversary, window seating, etc.
Reservation Origin The source of the reservation, i.e., Phone, Walk-in, or Web.
Table Category The table category associated with the reservation, assigned by the restaurant in OpenTable, e.g., Bar, Hightop, Outdoor, etc.
Guest Request Any requests specified by the guest during the reservation process.
Server The name of the server associated with the reservation.
Currency Code The currency code provided by OpenTable for the reservation.
Restaurant ID The ID of the restaurant associated with the reservation.
Restaurant Name The name of the restaurant associated with the reservation.

Cancelled Reservation

This event occurs when a reservation is marked as canceled in OpenTable.

Created Date The timestamp of when the reservation was created in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Scheduled Time The timestamp of the scheduled reservation date in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Table Number The table number associated with the reservation, assigned by the restaurant in OpenTable.
Party Size The party size specified by the guest.
Visit Tags Any tags associated with the visit such as those related to specific types of service or seating, e.g., birthday, anniversary, window seating, etc.
Reservation Origin The source of the reservation, i.e., Phone, Walk-in, or Web.
Table Category The table category associated with the reservation, assigned by the restaurant in OpenTable, e.g., Bar, Hightop, Outdoor, etc.
Guest Request Any requests specified by the guest during the reservation process.
Server The name of the server associated with the reservation.
Currency Code The currency code provided by OpenTable for the reservation.
Restaurant ID The ID of the restaurant associated with the reservation.
Restaurant Name The name of the restaurant associated with the reservation.

No Showed Reservation

This event occurs when a reservation is marked as a no-show in OpenTable.

Created Date The timestamp of when the reservation was created in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Scheduled Time The timestamp of the scheduled reservation date in UTC format, i.e., YYYY-MM-DDThh:mmTZD.
Table Number The table number associated with the reservation, assigned by the restaurant in OpenTable.
Party Size The party size specified by the guest.
Visit Tags Any tags associated with the visit such as those related to specific types of service or seating, e.g., birthday, anniversary, window seating, etc.
Reservation Origin The source of the reservation, i.e., Phone, Walk-in, or Web.
Table Category The table category associated with the reservation, assigned by the restaurant in OpenTable, e.g., Bar, Hightop, Outdoor, etc.
Guest Request Any requests specified by the guest during the reservation process.
Server The name of the server associated with the reservation.
Currency Code The currency code provided by OpenTable for the reservation.
Restaurant ID The ID of the restaurant associated with the reservation.
Restaurant Name The name of the restaurant associated with the reservation.

Synced guest data

In addition to the metrics Klaviyo syncs from OpenTable, Klaviyo creates or updates a profile for each synced guest with an email address or phone number. Contact information and custom properties can be added to the profile. You can use these properties in segments and in flows. Synced properties include:

Email
Phone Number
First Name
Last Name
Birthday
Note: If OpenTable does not include the year associated with a guest's birthday, the birthday year will default to 1904.
OpenTable Birthday Month
OpenTable Birthday Day
OpenTable Guest IDs
OpenTable Restaurants Visited

Klaviyo syncs email consent from OpenTable. For accounts with the Sync your OpenTable email subscribers to Klaviyo setting, email consent sync requires that option to be enabled and a list selected. In this setup, an OpenTable opt-in does not resubscribe someone who has unsubscribed in Klaviyo. An OpenTable opt-out removes email consent only when the guest’s current Klaviyo subscription came from the OpenTable integration.

While phone numbers are synced, SMS consent is not. You must collect SMS consent separately before sending marketing text messages to these guests.

Was this article helpful?

YesNo

Use this form only for article feedback. Learn how to contact support.