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 |