Column Name

Description

Does it show on preview?

Name

The client's name.

Yes

Email

The client's email.

Yes

Date Purchased

The date and time of this booking purchase.

Yes

Type

Type of purchase applied to this booking (subscription, package, drop in, etc).

Yes

Class Name

The name of the class or offering that was booked.

Yes

Class Time

The date & time of the class that was booked.

Yes

Instructor

Who was the instructor for this booking.

Yes

Purchase Type

What type of purchase this booking was made with - Intro Offer, subscription, package, drop in, bundle, on demand.

Yes

Location Name

What location this booking was in (if applicable).

Yes

Estimated Net Revenue

What is the estimated net revenue balance for this booking.

Yes

Coupon Code

will show what promo code was used for this booking (if applicable).

Yes

Package Name

What package type was used for this booking.

Yes

Id

The booking Id.

No

Booking Location

Where the booking was made from - app, widget, dashboard.

No

Canceled

If the booking was canceled or not.

No

Canceled_at

When this booking was canceled (if applicable).

No

Canceled_by

Who canceled the booking - client, administrator, team member.

No

Deleted

If the booking was deleted by administrator.

No

First Name

Client's first name.

Yes

Last Name

Client's last name.

Yes

Email

Client's email.

Yes

Phone

Client's phone number (if applicable)

No

Marketing Opt In

Labeled 'TRUE' if client has opted in to marketing communications. Labeled 'FALSE' of not.

No

Created

Data created.

No

Date Created

When this booking was created by the client or administrator.

Yes

Date Time Created

Specific time the booking was created.

No

Class Start Time

Data for when the class started.

No

Class Deleted

Will be labeled 'TRUE' if class was deleted, will be labeled 'FALSE' if not.

No

Class Cancelled

will be labeled 'TRUE' if class was canceled, will be labeled 'FALSE' if not.

No

Class Start

The date and time the booked service began.

No

Class Start Date

Data for when the class or service booked began with date.

Yes

Paid

Will be labeled 'yes' for paid, will be labeled 'no' if client has not completed payment.

No

Amount Paid

Will reflect what the Stripe payment is set for this booking.

No

Class Name

The name of the class, video or service booked.

Yes

Class ID

Data for the specific service or video.

No

Duration

How many minutes the video or service was.

No

Instructor

Who was the instructor for this service.

Yes

Purchase ID

Date for specific purchase ID.

No

Purchase name

The name of the pricing option used on this reservation.

No

Purchase Period Start

When this purchase type began (helpful for pricing options with expiration or a rental with an expiration time set).

No

Reservation Type

What type of pricing option was used for this booking (subscription, package, bundle, etc).

Yes

Late Cancel

Did this client or administrator late cancel this booking. Will be labeled 'TRUE' if late canceled, will be labeled 'FALSE' if not.

No

Location

Where was this booking created, map location from Google will be linked if applicable.

No

Location Id

The location Id data (if applicable).

No

Location Type

Was this booking for in person or on demand. Will be labeled 'ondemand' if video and 'inperson' if client joined in person.

No

Location Name

State or providence of the booking, for example NY for New York based bookings.

No

Location Address

Will show the location of the in person booking if applicable. This would be your studio or business address.

No

Categories

Date for categorized bookings (if applicable).

No

Checked In

Was this client checked in for their booking, will be labeled 'FALSE' if not and labeled 'TRUE' if yes.

No

User Id

User Id data.

No

Client Id

Client Id data.

No

Coupon Code

Will have the promo code used listed here (if applicable).

Yes

Milestone Count

Will show the client's milestone total (if applicable).

No

Payment Gross Amount

The gross $ amount paid on this booking.

No

Payment Net Amount

The net $ amount paid on this booking.

No

Payment Application Fee

The payment application $ amount paid on this booking (if applicable).

No

Recurring Reservation Id

If this booking is a recurring booking, the data Id will show here.

No

Created Date

When the booking was created.

No