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 address | |
| First name | FNAME |
| Last name | LNAME |
| Preferred language | LANG |
| Are they a system user? (yes = 1, no = 0) | ISUSER |
| Subscriber record date in the system | REGDATE |
| Birthday | BIRTHDATE |
| Function in the system (owner = landlord ou guest = client) | ROLE |
| Number of reservations registered by the user in question | RCOUNT |
| Check-in date of most recent reservation | LAST RESERVE CHECKIN |
| Check-out date of most recent reservation | LAST RESERVE CHECKOUT |
| Check-in date of the last reservation request (reservation request manager) | LAST REQUEST CHECKIN |
| Check-out date of the last reservation request (reservation 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.