Magic hidden are database fields that you can use dynamically within the email.
You can use the list below to add to your database (via Setup -> Database Fields):
bold = reserved. These names you cannot create but are created automatically
| Fieldname | Function |
|---|---|
| id | RecipientID, each contact record has their unique user ID |
| create_date | The date the user is created in the database |
| the email address of the user | |
| mobile_nr | in campaigns with SMS-sender this field gets added automatically. |
| format | If you use the option of the plaintext of HTML. |
| DMDcreate_date | create_date in some exports |
| DMDmember_since | the date that the user gets connected to the group you export. |
| sender_name | when you use this field this will replace the sender name |
| sender_email | when you use this field this will replace the sender email |
| reply_name | when you use this field this will replace the sender-reply-name |
| reply_email | when you use this field this will replace the sender-reply-email |
| last_mail_date | the date that the last mailing is sent |
| last_open_date | last date the email is opened |
| last_click_date | last date the email is clicked |
| dmd_last_remote_addr | the IP-address of the contact where the open/click/conversion has been |
| dmd_last_browser | the browser of the last open/click/conversion has been |
| dmd_last_browser_version | Version number of the browser |
| dmd_last_os | operation system |
| dmd_last_click_date | See last_click_date |
| dmd_last_click_name | title of the last link that is been clicked on |
| dmd_last_open_date | see last_open_date |
| dmd_last_geo_country | If you use the GEOMODULE: the country where the IP-address is |
| dmd_last_geo_region | If you use the GEOMODULE: the region where the IP-address is |
| dmd_last_geo_city | If you use the GEOMODULE: the city where the IP-address is |
| dmd_last_geo_lat | If you use the GEOMODULE: the geo-lat where the IP-address is |
| dmd_last_geo_long | If you use the GEOMODULE: the geo-long where the IP-address is |
| dmd* | Only SU-accounts can add these database fields |
