Category – Operator – Value List

Category – Operator – Value List

When using date-based conditions, the data is searched based on information as of the previous day.
Example: If the condition is set on September 21, the search will cover the period from August 22 to September 20 (30 days).

Category
Operator
Value / Input
Membership Type=Member / Non-member
Membership PrograminSelect membership program
Membership Registered PropertyinSelect property
Membership Registration Date=, >=, <=, BetweenDate / Previous day / Last N days
Membership RankinSelect membership rank
Registration StatusinNot Registered / Registered / Email Pending
LanguageinJapanese / English / Traditional Chinese / Simplified Chinese / Korean / Other
Messenger ChannelinLINE/Facebook
Email Opt-in=Opted-in / Not opted-in
Latest Reservation Amount=, >=, <=, BetweenEnter amount
Latest Reserved PropertyinSelect property
First Reservation Date=, >=, <=, BetweenDate / Previous day / Last N days
Latest Reservation Date=, >=, <=, BetweenDate / Previous day / Last N days
Latest Check-in Date=, >=, <=, BetweenDate / Previous day / Last N days
First Check-in Date=, >=, <=, BetweenDate / Previous day / Last N days
Latest Check-in Date=, >=, <=, BetweenDate / Previous day / Last N days
First Check-out Date=, >=, <=, BetweenDate / Previous day / Last N days
Latest Check-out Date=, >=, <=, BetweenDate / Previous day / Last N days
Reservations (30 days)=, >=, <=, BetweenEnter count
Reservations (1 year)=, >=, <=, BetweenEnter count
Reservations (total)=, >=, <=, BetweenEnter count
Room Nights (30 days)=, >=, <=, BetweenEnter count
Room Nights (1 year)=, >=, <=, BetweenEnter count
Room Nights (total)=, >=, <=, BetweenEnter count
Avg. Number of Adult Guests=, >=, <=, BetweenEnter number
Avg. Number of Child Guests=, >=, <=, BetweenEnter number
Avg. Reservation Amount (30 days)=, >=, <=, BetweenEnter amount
Avg. Reservation Amount (1 year)=, >=, <=, BetweenEnter amount
Avg. Reservation Amount (total)=, >=, <=, BetweenEnter amount
Max Reservation Amount (30 days)=, >=, <=, BetweenEnter amount
Max Reservation Amount (1 year)=, >=, <=, BetweenEnter amount
Max Reservation Amount (total)=, >=, <=, BetweenEnter amount
Day-use Count (30 days)=, >=, <=, BetweenEnter count
Day-use Count (1 year)=, >=, <=, BetweenEnter count
Day-use Count (total)=, >=, <=, BetweenEnter count
Latest Payment MethodinPay at Hotel / Credit Card / Postpaid (Credit Required)
Latest Cancellation ReasoninOther / Trip Canceled / Found Cheaper / Change in Party Size / Booked Other Hotel / Fee Change
Latest Cancellation Date=, >=, <=, BetweenDate / Previous day / Last N days
Latest Cancellation or Check-out Date=, >=, <=, BetweenDate / Previous day / Last N days
Latest Canceled PropertyinSelect property
Total Reservation Amount (30 days)=, >=, <=, BetweenEnter amount
Total Reservation Amount (1 year)=, >=, <=, BetweenEnter amount
Total Reservation Amount (overall)=, >=, <=, BetweenEnter amount
Reserved Property (90 days)inSelect property
Reserved Property (180 days)inSelect property
Room Nights (90 days)=, >=, <=, BetweenEnter count
Room Nights (180 days)=, >=, <=, BetweenEnter count
Reservations (90 days)=, >=, <=, BetweenEnter count
Reservations (180 days)=, >=, <=, BetweenEnter count
Avg. Reservation Amount (90 days)=, >=, <=, BetweenEnter amount
Avg. Reservation Amount (180 days)=, >=, <=, BetweenEnter amount
Max Reservation Amount (90 days)=, >=, <=, BetweenEnter amount
Max Reservation Amount (180 days)=, >=, <=, BetweenEnter amount
Day-use Count (90 days)=, >=, <=, BetweenEnter count
Day-use Count (180 days)=, >=, <=, BetweenEnter count
Total Reservation Amount (90 days)=, >=, <=, BetweenEnter amount
Total Reservation Amount (180 days)=, >=, <=, BetweenEnter amount
Reservation Count (Jan–Dec)=, >=, <=, BetweenEnter count
First Visit Date=, >=, <=, BetweenEnter count
Latest Visit Date=, >=, <=, BetweenEnter count
Visit Count (7 / 30 / 90 / 180 days…)=, >=, <=, BetweenEnter count
Page Views (7 / 30 days, total)=, >=, <=, BetweenEnter count
Login Count (7 / 30 days)=, >=, <=, BetweenEnter count
Last Point Earned Date=, >=, <=, BetweenEnter count
Last Point Used Date=, >=, <=, BetweenEnter count
Expiration in 1 day / 7 days=, >=, <=, BetweenEnter count
Latest Earned Points=, >=, <=, BetweenEnter count
Total Earned Points=, >=, <=, BetweenEnter count
Latest Used Points=, >=, <=, BetweenEnter count
Total Used Points=, >=, <=, BetweenEnter points
Available Points=, >=, <=, BetweenEnter points
Point Expiration (30 / 90 / 180 days)=, >=, <=, BetweenYes / No
No Send Record=, >=, <=, BetweenYes / No
Email Open Count (7 / 30 days, 1 year)=, >=, <=, BetweenEnter count
Latest Email Delivery Date=, >=, <=, BetweenDate / Previous day / Last N days
Email Click Count (7 / 30 days, 1 year)=, >=, <=, BetweenEnter count
Latest Email Click Date=, >=, <=, BetweenDate / Previous day / Last N days
Birthday=Date / Previous day / Last N days
Gender=Male / Female / Other
Birth MonthinSelect month
PrefectureinSelect prefecture
Age=, >=, <=, BetweenEnter age

※Example Configuration

You can set conditions using OR or AND, and control how they are grouped by using parentheses '()'.


Info
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


    • Related Articles

    • Customer Segment V2 – Category List

      Data from past reservations excludes canceled bookings. If a reservation has been modified or changed, the most recent data will be used. You can also combine multiple segments. Example: By combining “Hotel Reserved in the Past” with “Check-in Date ...
    • Reservation List

      On the Reservation List page, you can view and manage customer reservations, make changes, cancel bookings, and resend confirmation emails. ⏱Estimated time: Approximately 5 minutes per item. Brand Admin Screen Property Admin Screen Click to open the ...
    • Chat List Page

      You can view inquiries received via chatbot in a list format and download them as a CSV file. Chat history is available for up to 4 weeks.If you need to check inquiries older than 4 weeks, please contact our AI team through the inquiry form. Where to ...
    • Connect to an operator

      Here is how to configure the chatbot to connect to a human operator: You can set up the chatbot to automatically connect to an operator when a specific tripla FAQ is triggered. After the connection to the operator is made, you can also configure it ...
    • Customer Segment V2

      In tripla Connect, guest stay history, membership data, and website browsing behavior are grouped to automate personalized communications and support repeat customer engagement. This grouping is referred to as a “segment.” While this manual provides ...