Report Fields
Your spreadsheet can include one or more Report Fields that ExcelSend will populate with information about messages sent and received. The field names are fixed and are optional.
| Field Name | Description | Format |
| EXS_WasMessageSent | Determines whether the message relating to that row was sent or not | text field: Yes or No |
| EXS_DateSent | If the message was sent the date and time it was sent | date field |
| EXS_Message | The text of the message that was sent | text field |
| EXS_SendError | The reason a message was not sent | text field |
| EXS_WasReplyReceived | Determines whether a reply was received to the original message sent | text field: Yes or No |
| EXS_DateReceived | If a reply was received the date and time it was received | date field |
| EXS_Reply | The text of the reply that was received | text field |
To use Report Fields they must be included in your spreadsheet before uploading to ExcelSend to use in sending your message.
Before Uploading To ExcelSend
This example spreadsheet shows 4 columns of data and 3 columns for the report fields.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | name | date | mobile | balance | EXS_WasReplyReceived | EXS_DateReceived | EXS_Reply |
| 2 | Joe | 02/26/2021 15:11:29 | 078 00000000 | 12.50 |
After Downloading From ExcelSend
Once the messages have been sent and replies received you can download the spreadsheet from the Message Job and ExcelSend will populate the report fields.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | name | date | mobile | balance | EXS_WasReplyReceived | EXS_DateReceived | EXS_Reply |
| 2 | Joe | 02/26/2021 15:11:29 | 078 00000000 | 12.50 | Yes | 05/31/2020 10:32 | Ok, thanks. I'll see you there |