Category – Operator – Value List
Purpose:
This session explains the segment categories in detail, along with their operators and values.
| Category | Operator | Value / Input |
| Membership | = | Member / Non-member |
| Membership Program | in | Select membership program |
| Joined Facilities | in | Select property |
| Register Date | =, >=, <=, Between | Date / Previous day / Last N days |
| Membership Rank | in | Select membership rank |
| Registration Status | in | Not Registered / Registered / Email Pending |
| Language | in | Japanese / English / Traditional Chinese / Simplified Chinese / Korean / Other |
| Messenger Channel | in | LINE/Facebook |
| Email Provided | = | Opted-in / Not opted-in |
| Latest Booking Amount | =, >=, <=, Between | Enter amount |
| Latest Booking Facilities | in | Select property |
| First / Lastest Booking Date | =, >=, <=, Between | Date / Previous day / Last 〇 days |
| First / Lastest Checkin Date | =, >=, <=, Between | Date / Previous day / Last 〇 days |
| First / Lastest Checkout Date | =, >=, <=, Between | Date / Previous day / Last 〇 days |
| Checkout Times (30 days / 1 year / total) | =, >=, <=, Between | Enter count |
| Booking Facilities (30 days / 1 year / total) | =, >=, <=, Between | Enter count |
| Checkout Room_Nights (30 days / 1 year / total) | =, >=, <=, Between | Enter count |
| Average Adults / Average Children | =, >=, <=, Between | Enter count |
| Average Checkout Value (30 days / 1 year / total) | =, >=, <=, Between | Enter amount |
| Maximum checkout Value (30 days / 1 year / total) | =, >=, <=, Between | Enter amount |
| Day Use (30 days / 1 year / total) | =, >=, <=, Between | Enter count |
| Latest Payment Methods | in | Pay at Hotel / Credit Card / Postpaid (Credit Required) |
| Latest Cancel Reason | in | Other / Trip Canceled / Found Cheaper / Change in Party Size / Booked Other Hotel / Fee Change |
| Latest Cancel / Checkout Date | =, >=, <=, Between | Date / Previous day / Last N days |
| Latest Cancel Facility | in | Select property |
| Life Time Value (30 days / 1 year / total) | =, >=, <=, Between | Enter amount |
| Booking Facilities (90 days) | in | Select property |
| Booking Facilities (180 days) | in | Select property |
| Booking Facility (90 days / 180 days) | =, >=, <=, Between | Enter count |
| Checkout Room Nights (90 days / 180 days) | =, >=, <=, Between | Enter count |
| Average Checkout Value (90 days / 180 days) | =, >=, <=, Between | Enter amount |
| Maximum Checkout Value (90 days / 180 days) | =, >=, <=, Between | Enter amount |
| Day Use (90 days / 180 days) | =, >=, <=, Between | Enter count |
| Life Time Value (90 days / 180 days) | =, >=, <=, Between | Enter amount |
| Checkout Times (in a year from Jan - Dec) | =, >=, <=, Between | Enter count |
| Checkin (Tomorrow / 3 days / 7 days / 14 days) | =, >=, <=, Between | Enter count |
| Checked Out (7 days Ago / 30 days Ago / 90 Days Ago / 180 Days Ago) | =, >=, <=, Between | Enter count |
| Checkout Years | =, >=, <=, Between | Enter count |
| First & Latest Visiting Date | =, >=, <=, Between | Date / Previous day / Last 〇 days |
| Number of Visits (7 days / 30 days / 90 days / 180 days / 1- 10 years / Total) | =, >=, <=, Between | Enter count |
| PV Number (7 days / 30 days / Total) | =, >=, <=, Between | Enter count |
| Login Times (7 days / 30 days) | =, >=, <=, Between | Enter count |
| Point Update Date | =, >=, <=, Between | Date / Previous day / Last 〇 days |
| Latest Redeem Date | =, >=, <=, Between | Date / Previous day / Last 〇 days |
| Point Expire Within (1 day / 7 days) | = | Yes /No |
| Latest Obtained Points | =, >=, <=, Between | Enter count |
| Total Obtained Points | =, >=, <=, Between | Enter point |
| Latest Redeem Points | =, >=, <=, Between | Enter count |
| Total Redeem Points | =, >=, <=, Between | Enter points |
| Available Points | =, >=, <=, Between | Enter points |
| Point Expiration Within (30 days / 90 days / 180 days) | =, >=, <=, Between | Yes / No |
| Points Expiring (Tomorrow / on the 7 days / 30 days / 90 days / 180 days) | = | Yes / No |
| No Mailing Records | =, >=, <=, Between | Yes / No |
| Mail Open Number (7 days / 30 days / 1 year) | =, >=, <=, Between | Enter count |
| Latest Mailing Date | =, >=, <=, Between | Date / Previous day / Last N days |
| Mail Click Count (7 days, 30 days,1 year) | =, >=, <=, Between | Enter count |
| Latest Mail Click Date | =, >=, <=, Between | Date / Previous day / Last N days |
| Birthday | = | Date / Previous day / Last N days |
| Gender | = | Male / Female / Other |
| Birthday Month | in | Select month |
| Prefecture | in | Select prefecture |
| Age | =, >=, <=, Between | Enter age |
▼Example Configuration:
Conditions may be configured using OR or AND, with the option to control the connection by applying parentheses ‘( )’
Examples:
For “a and b, or c”:
→ (a AND b) OR c
For “a and b, or c and d”:
→ (a AND b) OR (c AND d)
For “a and b and c, or d”:
→ (a AND b AND c) OR d
When a date-based condition is set, the search is performed using data as of the previous day.
▼Example:
If the period is set from August 22 to September 21, the data from August 22 to September 20 (30 days) is used.
Related Articles
Customer Segment V2 – Category List
Purpose: This section explains the categories available in Segment V2. Past reservation data excludes canceled reservations. If a reservation has been modified or updated, the most recent data is used. Multiple segment conditions can be combined. For ...Chat List
Purpose This section is to explain how to view chatbot inquiry history. Inquiries received via the chatbot can be viewed in a list and downloaded as a CSV file. Inquiry history can be checked for up to one year, excluding the most recent four weeks. ...Reservation List CSV Fields
Purpose: This section explains the definitions of the CSV file fields in the reservation list. ▼Sample id Definition created_at Reservation Date facility_name Property Name reservation_no Reservation Number status Reservation Status booking_name ...Reservation List
Purpose: This section explains how to manage customer reservations, make changes, cancel bookings, and resend confirmation emails from the reservation list page. ⏱Estimated time: ~15 minutes 1. Where to Set Setting page: Brand Management Screen & ...Segment V2
Purpose: This section explains how tripla Connect groups guest stay data, member information, and website browsing data into segments to automate personalized communications and support repeat customer engagement. ⏱ Estimated time: ~ 15mins 1. Where ...