Segmenting contacts is one of the main steps for marketing campaigns.
In the spreadsheets generated by Stays, you will have the following variables, according to the chosen spreadsheet:

Type of Information
Column Name in Spreadsheet
Email addressEMAIL
First nameFNAME
Last nameLNAME
Preferred languageLANG
Are they a system user? (yes = 1, no = 0)ISUSER
Subscriber record date in the systemREGDATE
BirthdayBIRTHDATE
Function in the system (owner = landlord ou guest = client)ROLE
Number of bookings registered by the user in questionRCOUNT
Check-in date of most recent bookingLAST RESERVE CHECKIN
Check-out date of most recent bookingLAST RESERVE CHECKOUT
Check-in date of the last booking request (booking request manager)LAST REQUEST CHECKIN
Check-out date of the last booking request (booking request manager)LAST REQUEST CHECKOUT
Contact's city of residenceCITY
Contact's country of residenceCOUNTRY
Contact's birthday (added to spreadsheets that you did not have in past versions)DTBIRTH

In addition, the RCOUNT variable counts only the reservations already confirmed by the guest, in order to give you a more accurate segmentation.

<< BACK TO FAQ