Predefined variables
The following table lists all the predefined variables you can use in your DC statements:
| Variable name | Type | Description |
|---|---|---|
| SubscriberId | int | Unique id of the subscriber in the ExpertSender System |
| SubscriberEmail | string | Subscriber email |
| SubscriberEmailMd5 | string | MD5 of subscriber email |
| SubscriberEmailSha256 | string | SHA256 of subscriber email |
| SubscriberName | string | Full name of the subscriber (first name and last name) |
| SubscriberDomainFamily | string | Returns subscriber domain family |
| SubscriberFirstname | string | First name of the subscriber |
| SubscriberLastname | string | Last name of the subscriber |
| SubscriberVendor | string | Vendor |
| SubscriberTrackingCode | string | Tracking code for the subscriber |
| SubscriberGeoCountry | string | GeoIP determined country |
| SubscriberGeoState | string | GeoIP determined state |
| SubscriberGeoCity | string | GeoIP determined city |
| SubscriberGeoZipCode | string | GeoIP determined zip code |
| SubscriberSignupIp | string | IP address from which subscriber signed up to the list. |
| SubscriberSignupDateTime | datetime? | Date and time of subscriber signing up to the list. System.DateTime object, suitable for date calculations, comparisons etc. |
| SubscriberCustomId | string | Unique id of the subscriber that can be assigned by the user |
| SubscriberPhone | string | Subscriber phone number (when SMS/MMS channel is enabled) |
| SubscriberLastActivity | datetime | Last known activity date in any channel |
| SubscriberLastMessageAll | datetime | The date when the last message was sent through any channel to a subscriber |
| SubscriberLastEmail | datetime | The date when the last email message was sent to a subscriber |
| SubscriberLastOpenEmail | datetime | The date of the last known open of an email message by a subscriber |
| SubscriberLastClickEmail | datetime | The date of the last known click of an email message by a subscriber |
| SubscriberLastSmsMms | datetime | The date when the last SMS/MMS message was sent to a subscriber |
| SubscriberLastClickSmsMms | datetime | The date of the last known click of a SMS/MMS message by a subscriber |
| SenderFromEmail | string | Sender email address |
| SenderFromName | string | Sender from name |
| SenderReplyToEmail | string | Sender reply to email address |
| SenderReplyToName | string | Sender reply to name |
| SenderId | int | Id of the business unit used to send the message |
| MessageId | int | Id of the message that is being sent out |
| MessageVersionId | int | Id of message version that is being sent out. Multiple versions are sent when using split testing. |
| MessageSubject | string | Message subject |
| MessageDay | int | Number of day in a month when the message was sent out. |
| MessageDayOfWeek | string | Name of the day of the week when the message was sent out (e.g. Monday). |
| MessageShortDate | string | Short version of the date when the message was sent out – e.g. 1/25/2011. The format depends on the regional settings. |
| MessageLongDate | string | Long version of the date when the message was sent out – e.g. Tuesday, January 25, 2011. The format depends on the regional settings. |
| MessageMonth | string | Name of the month when the message was sent out. Format depends on the regional settings. |
| MessageMonthNumber | int | Month (number) when the message was sent out. |
| MessageYear | int | Year when the message was sent out. |
| LinkStandard | string | The domain name portion of the click tracking URL of the business unit, e.g. http://www.yourdomain.com/ . |
| LinkPreferenceCenter | string | Preference Center URL. |
| LinkUnsubscribe | string | Unsubscribe URL. |
| ListName | string | Subscriber list name. |
| ListFriendlyName | string | Friendly subscriber list name – if different name is defined to be displayed to subscribers than the name of the list in the management panel. |
| ListId | int? | Id of the subscriber list. |
| SegmentName | string | Name of the subscriber segment (available if the message has been sent out to the subscriber segment). |
| SegmentId | int? (nullable int) | Id of the subscriber segment (available if the message has been sent out to the subscriber segment). |
| CustomerCompany | string | Sender company name. |
| CustomerStreet | string | Sender street address 1. |
| CustomerStreet2 | string | Sender street address 2. |
| CustomerZip | string | Sender zip. |
| CustomerCity | string | Sender city. |
| CustomerState | string | Sender state/province. |
| CustomerCountry | string | Sender country. |
| IsViewInBrowser | boolean | Flag informing if message is rendered in browser (using “view in browser” feature). This might be helpful for some conditional rendering. |