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. |