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
|Are they a system user? (yes = 1, no = 0)||ISUSER|
|Subscriber record date in the system||REGDATE|
|Function in the system (owner = landlord ou guest = client)||ROLE|
|Number of bookings registered by the user in question||RCOUNT|
|Check-in date of most recent booking||LAST RESERVE CHECKIN|
|Check-out date of most recent booking||LAST 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 residence||CITY|
|Contact's country of residence||COUNTRY|
|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.