{"id":3948,"date":"2023-09-22T07:26:59","date_gmt":"2023-09-22T06:26:59","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&#038;p=3948"},"modified":"2024-07-10T08:22:38","modified_gmt":"2024-07-10T07:22:38","slug":"predefined-variables","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/dynamic-content\/predefined-variables\/","title":{"rendered":"Predefined variables"},"content":{"rendered":"\n<p>The following table lists all the predefined variables you can use in your DC statements:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Variable name<\/th><th>Type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>SubscriberId<\/td><td>int<\/td><td>Unique id of the subscriber in the ExpertSender System<\/td><\/tr><tr><td>SubscriberEmail<\/td><td>string<\/td><td>Subscriber email<\/td><\/tr><tr><td>SubscriberEmailMd5<\/td><td>string<\/td><td>MD5 of subscriber email<\/td><\/tr><tr><td>SubscriberEmailSha256<\/td><td>string<\/td><td>SHA256 of subscriber email<\/td><\/tr><tr><td>SubscriberName<\/td><td>string<\/td><td>Full name of the subscriber (first name and last name)<\/td><\/tr><tr><td>SubscriberDomainFamily<\/td><td>string<\/td><td>Returns subscriber domain family<\/td><\/tr><tr><td>SubscriberFirstname<\/td><td>string<\/td><td>First name of the subscriber<\/td><\/tr><tr><td>SubscriberLastname<\/td><td>string<\/td><td>Last name of the subscriber<\/td><\/tr><tr><td>SubscriberVendor<\/td><td>string<\/td><td>Vendor<\/td><\/tr><tr><td>SubscriberTrackingCode<\/td><td>string<\/td><td>Tracking code for the subscriber<\/td><\/tr><tr><td>SubscriberGeoCountry<\/td><td>string<\/td><td>GeoIP determined country<\/td><\/tr><tr><td>SubscriberGeoState<\/td><td>string<\/td><td>GeoIP determined state<\/td><\/tr><tr><td>SubscriberGeoCity<\/td><td>string<\/td><td>GeoIP determined city<\/td><\/tr><tr><td>SubscriberGeoZipCode<\/td><td>string<\/td><td>GeoIP determined zip code<\/td><\/tr><tr><td>SubscriberSignupIp<\/td><td>string<\/td><td>IP address from which subscriber signed up to the list.<\/td><\/tr><tr><td>SubscriberSignupDateTime<\/td><td>datetime?<\/td><td>Date and time of subscriber signing up to the list. System.DateTime object, suitable for date calculations, comparisons etc.<\/td><\/tr><tr><td>SubscriberCustomId<\/td><td>string<\/td><td>Unique id of the subscriber that can be assigned by the user<\/td><\/tr><tr><td>SubscriberPhone<\/td><td>string<\/td><td>Subscriber phone number (when SMS\/MMS channel is enabled)<\/td><\/tr><tr><td>SubscriberLastActivity<\/td><td>datetime<\/td><td>Last known activity date in any channel<\/td><\/tr><tr><td>SubscriberLastMessageAll<\/td><td>datetime<\/td><td>The date when the last message was sent through any channel to a subscriber<\/td><\/tr><tr><td>SubscriberLastEmail<\/td><td>datetime<\/td><td>The date when the last email message was sent to a subscriber<\/td><\/tr><tr><td>SubscriberLastOpenEmail<\/td><td>datetime<\/td><td>The date of the last known open of an email message by a subscriber<\/td><\/tr><tr><td>SubscriberLastClickEmail<\/td><td>datetime<\/td><td>The date of the last known click of an email message by a subscriber<\/td><\/tr><tr><td>SubscriberLastSmsMms<\/td><td>datetime<\/td><td>The date when the last SMS\/MMS message was sent to a subscriber<\/td><\/tr><tr><td>SubscriberLastClickSmsMms<\/td><td>datetime<\/td><td>The date of the last known click of a SMS\/MMS message by a subscriber<\/td><\/tr><tr><td>SenderFromEmail<\/td><td>string<\/td><td>Sender email address<\/td><\/tr><tr><td>SenderFromName<\/td><td>string<\/td><td>Sender from name<\/td><\/tr><tr><td>SenderReplyToEmail<\/td><td>string<\/td><td>Sender reply to email address<\/td><\/tr><tr><td>SenderReplyToName<\/td><td>string<\/td><td>Sender reply to name<\/td><\/tr><tr><td>SenderId<\/td><td>int<\/td><td>Id of the business unit used to send the message<\/td><\/tr><tr><td>MessageId<\/td><td>int<\/td><td>Id of the message that is being sent out<\/td><\/tr><tr><td>MessageVersionId<\/td><td>int<\/td><td>Id of message version that is being sent out. Multiple versions are sent when using split testing.<\/td><\/tr><tr><td>MessageSubject<\/td><td>string<\/td><td>Message subject<\/td><\/tr><tr><td>MessageDay<\/td><td>int<\/td><td>Number of day in a month when the message was sent out.<\/td><\/tr><tr><td>MessageDayOfWeek<\/td><td>string<\/td><td>Name of the day of the week when the message was sent out (e.g. Monday).<\/td><\/tr><tr><td>MessageShortDate<\/td><td>string<\/td><td>Short version of the date when the message was sent out \u2013 e.g. 1\/25\/2011. The format depends on the regional settings.<\/td><\/tr><tr><td>MessageLongDate<\/td><td>string<\/td><td>Long version of the date when the message was sent out \u2013 e.g. Tuesday, \u200eJanuary \u200e25, \u200e2011. The format depends on the regional settings.<\/td><\/tr><tr><td>MessageMonth<\/td><td>string<\/td><td>Name of the month when the message was sent out. Format depends on the regional settings.<\/td><\/tr><tr><td>MessageMonthNumber<\/td><td>int<\/td><td>Month (number) when the message was sent out.<\/td><\/tr><tr><td>MessageYear<\/td><td>int<\/td><td>Year when the message was sent out.<\/td><\/tr><tr><td>LinkStandard<\/td><td>string<\/td><td>The domain name portion of the click tracking URL of the business unit, e.g. http:\/\/www.yourdomain.com\/ .<\/td><\/tr><tr><td>LinkPreferenceCenter<\/td><td>string<\/td><td>Preference Center URL.<\/td><\/tr><tr><td>LinkUnsubscribe<\/td><td>string<\/td><td>Unsubscribe URL.<\/td><\/tr><tr><td>ListName<\/td><td>string<\/td><td>Subscriber list name.<\/td><\/tr><tr><td>ListFriendlyName<\/td><td>string<\/td><td>Friendly subscriber list name \u2013 if different name is defined to be displayed to subscribers than the name of the list in the management panel.<\/td><\/tr><tr><td>ListId<\/td><td>int?<\/td><td>Id of the subscriber list.<\/td><\/tr><tr><td>SegmentName<\/td><td>string<\/td><td>Name of the subscriber segment (available if the message has been sent out to the subscriber segment).<\/td><\/tr><tr><td>SegmentId<\/td><td>int? (nullable int)<\/td><td>Id of the subscriber segment (available if the message has been sent out to the subscriber segment).<\/td><\/tr><tr><td>CustomerCompany<\/td><td>string<\/td><td>Sender company name.<\/td><\/tr><tr><td>CustomerStreet<\/td><td>string<\/td><td>Sender street address 1.<\/td><\/tr><tr><td>CustomerStreet2<\/td><td>string<\/td><td>Sender street address 2.<\/td><\/tr><tr><td>CustomerZip<\/td><td>string<\/td><td>Sender zip.<\/td><\/tr><tr><td>CustomerCity<\/td><td>string<\/td><td>Sender city.<\/td><\/tr><tr><td>CustomerState<\/td><td>string<\/td><td>Sender state\/province.<\/td><\/tr><tr><td>CustomerCountry<\/td><td>string<\/td><td>Sender country.<\/td><\/tr><tr><td>IsViewInBrowser<\/td><td>boolean<\/td><td>Flag informing if message is rendered in browser (using &#8220;view in browser&#8221; feature). This might be helpful for some conditional rendering.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"author":5,"featured_media":0,"parent":3856,"menu_order":193,"template":"","format":"standard","emp-category":[],"class_list":["post-3948","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es"}],"about":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/types\/es"}],"author":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":2,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3948\/revisions"}],"predecessor-version":[{"id":11147,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3948\/revisions\/11147"}],"up":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3856"}],"wp:attachment":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/media?parent=3948"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}