Email Marketing

Email Marketing is an integrated tool for targeting, improving and measuring the effect of your email marketing and newsletter efforts.

With Email Marketing, you can:

  • Send out user group-specific emails and newsletters
  • Track how users interact with your emails and newsletters
  • Test the effect of changes with split tests

In Dynamicweb, emails are actually pages. The Email Marketing tool allows you to send an html or item-based page to different kinds of users. This means that email marketing in Dynamicweb is very customizable.

Two things should be kept in mind when working with Emails Marketing:

  • In Dynamicweb, you can only send emails to registered users, who have given their consent to receiving emails from you. You can read more about registering users under the documentation for the Extranet app, and in this article
  • It is your own responsibility to familiarize yourself with spam legislation in the countries you operate in. Such legislation often applies to private recipients, while the rules regarding corporate recipients can be more lenient.

To access the Email Marketing tool:

  • Go to the Marketing area
  • Fold out the Email Marketing node (Figure 1.1)
Figure 1.1 Email Marketing tool tree

Note: In Dynamicweb, emails are actually pages. In order to be able to create and send an email to your users, you need to create a page with your email content first. Read more about creating pages.

To create a new email:

  • Rick click on an email top folder (Figure 2.2)
  • Click Create new email
Figure 2.2 Creating a new email

You will be asked to select an email type:

  • Click Blank email or select an email template – you can create email templates using the advanced email settings
  • Specify a subject (or leave blank)
  • Click OK

This takes you to the email settings, where you finalize the email before sending it.

It’s generally a really bad business idea to send an empty email to no one at all.

Rather than doing that you should:

  • Create a subject for your email
  • Choose someone to send it to
  • Choose something to send to them

The email settings (Figure 3.1) allow you to do just that!

Figure 3.1 Settings when creating an email

From the edit email view you can:

  • Specify a subject for your email - the green plus sign allows you to personalize the subject using tags.
  • Specify who to send the email to (your recipients)
  • Specify a custom from-name and from-email for your email
  • Specify a pre-header text (keep below 100 characters, which is what most email clients display)
  • Select a page to use as the body of an email – supports both standard html-based and item-based pages
  • Select a domain to use for dynamic links in the email

Once you are happy with your settings you can save the email, send it, or schedule it for future delivery.

Types of recipients

Dynamicweb allows you to send out emails to registered Dynamicweb users, users with an abandoned cart, and unresponsive users, who are users that have not opened a specific email.

  • Dynamicweb Users can be selected individually, by user group, or by a smart search – or any combination thereof. By default, Dynamicweb filters out any users which are added twice, or who haven’t given their consent to receiving emails from you.
  • Abandoned Cart users are users, who have added products to a cart, but have not finalized their purchase. You can customize when a cart is regarded as abandoned, how old a cart should be for the system to ignore it, and so forth.
  • Unresponsive users are users who have not opened a mail. The mail is specified by you.

You can change which recipients to send to by default in your top folder settings, or on the specific email by changing the recipient provider under your advanced email settings. Read more below.

To send an email, click Send or Scheduled send (Figure 4.1):

Figure 4.1 Sending an email

Once sent, your email is moved from the drafts folder to the sent folder under the top folder you are working in.

From the sent folder, you can right click and choose resend to unresponsive recipients (Figure 5.1):

Figure 5.1 Resend to unresponsive recipients

This allows you to quickly and effortlessly send out an email to people who did not open it in the first place.

Our marketing guys inform me that this is a really neat feature, so you might want to give it a spin :)

You may want to send out the same email weekly, e.g. if you have users who have added products to their cart but not finalized their purchase, or you may want to schedule an email to be sent out at a time where no one is in the office.

And Email Marketing lets you do exactly that.

Click Scheduled Send to send out emails periodically, or at a specified time (Figure 6.1). 

Figure 6.1 Scheduling an email

From the scheduling window, you can specify a start date and time and an end date and time, your time zone, and the frequency with which you want to send out this particular email.

When creating or editing an email, clicking the advanced tab on your toolbar gives you access to the advanced email settings (Figure 7.1).

Many of these settings are inherited from the top folder settings – so you don’t need to change them unless you want to override those. Read more about top folders in the implementing section.

Figure 7.1 Advanced email settings tab

The advanced settings are divided into several areas. Let’s go through them individually.

With the general advanced options:

  • You can attach one or more files to your email
  • You can select the encoding format for the text within the email
  • You can save the email as a template. Remember to provide a name and a description.
  • You can customize the text on your unsubscribe link, and select a custom page to redirect unsubscribers to.
    • For legal reasons, Dynamicweb will automatically add an (ugly) unsubscribe link to your emails, unless you add one to the template you use to render your emails. We strongly advise you to create something beautiful to replace it.
    • If you're really evil, you can disable the forced unsubscribe link
  • You can customize your content settings:
    • If you are sending out user-specific content, you can render the email-content for each recipient
    • You can send a plain text version of your email, along with the html version. The plain text can be generated automatically from content, or it can be provided by you.
  • You can customize the recipient settings to allow you to deliver the same email to the same recipient more than once
    • If you uncheck the ensure unique recipients checkbox, you must specify a quarantine period, during which the same user cannot receive the same email.

Unique recipients and quantine periods

With Dynamicweb Email Marketing, you can never send out the same email to a single address more than once per delivery.

And by default, Dynamicweb blocks sending out the same email to the a single address over several deliveries too due to spam legislation concerns.

If, however, you have a scheduled task sending out the same (uniquely rendered) email with information on an abandoned cart, you can disable the built in block on sending the same email-ID to the same email address.

You cannot, however, bypass the block on sending the same email to a single address more than once per single delivery.

With the measuring options, you can:

  • Customize the Engagement Index point values of users taking actions or opening links in the email.
    • The points values are defined in the top folder settings by default, but you can further customize them for this particular email here, or disable points entirely for some actions or links (Figure 9.1)
  • Select a tracking provider other than the one selected as default in the top folder, and fill out any associated parameters.
Figure 9.1 Customizing the engagement index for email marketing

With the distribution options, you can:

  • Change your default recipient provider settings. Read more about your options – Dynamicweb users, abandoned cart recipients and unresponsive recipients – here.
  • You can change your delivery provider settings. By default, Dynamicweb comes with the Dynamicweb Send Provider, but you can create your own delivery provider.

Click Validate emails to check the format of the current list of recipient emails.

  • The validation process is as follows:
    • Is the email address format correct (i.e. "does it follow the something@somthing.suffix format")?
    • Does the domain exist?
    • Does the domain have an MX (mail server) record?

You will be presented with a list of invalid emails, which you can then correct or clear manually.

You can also delete the user completely, which is useful for robot signups.

With email personalization, you can tailor your email marketing efforts to the needs, interests and behavioral patterns of your users.

You do so by selecting which paragraphs to send to which smart search based segments.

If, for example, you want to kick off an international campaign by organizing a flash mob in major European cities, you can easily do so. In the following section, I will be using this as an example of how email personalization works.

To create personalized content, simply create an email with variant city-specific information (Figure 13.1)

Figure 13.1 Personalized: City-specific paragraphs

In this case, I have three paragraphs targeting my users in three major cities – containing information on how to join the flash mob in their country – and a paragraph containing information on how to see videos of the flash mobs, targeting users who don’t have a chance to join the flash mob themselves.

Next, go to the Marketing tab (Figure 14.1) and click Email personalization.

Figure 14.1 Email personalization button

You will be presented with a view of your paragraphs, and a list of your segments (Figure 14.2)

Figure 14.2 Email personalization: content and segments

So far, there are no segments except ‘default’, which covers everyone who is not in one of the other segments.

You need to add segments matching your personalized content. To do so, click Add segment and select one of your existing smart searches (Figure 14.3).

 

Figure 14.3 Selecting smart searches (segments)

In this scenario, you are interested in users who live in the United Kingdom, users who live in Germany, and users who live in Denmark.

Select those smart searches (or create them in the standard manner), and add them to your email personalization window (Figure 15.1).

Figure 15.1 Email personalization - with segments added

For a full list of the many cool options you have when building smart searches, check out the smart search documentation.

Now, in order to ensure that your users get the right content, it is useful to go through each segment individually.

Start by looking at the default users, i.e. those who are not covered by the other segments – in this case, users in the US and in Japan.

  • Should the default users receive the intro? Yes
  • Should they receive the paragraphs targeting UK-, Germany- or Denmark-based users? No
  • Should they receive the default flash mob paragraph? Yes
  • Should they receive the outro? Yes

Click the green checkmarks/red crosses to change their state, and go through the other segments in the same manner. You should end up with the following configuration (Figure 16.1)

Figure 16.1 Email personalization: Content and segments configured

With this setup:

  • Users who live in the UK will receive the intro, the London flash mob, and the outro paragraphs.
  • Users who live in Germany will receive the intro, the Berlin flash mob, and the outro paragraphs.
  • Users who live in Denmark will receive the intro, the Copenhagen flash mob, and the outro paragraphs.
  • Users who do not live in the UK, Germany or Denmark will receive the intro, the default flash mob, and the outro paragraphs

If you are a little confused, don't worry.

You can preview your email as each segment, and catch any errors early!

From the marketing tab of a page (your email), click the email preview button (Figure 17.1) to get a preview of your email.

Figure 17.1 The email preview button

You will see a preview of your page, along with a dropdown menu listing your segments (Figure 17.2).

Figure 17.2 Email preview: dropdown with list of segments

You can preview the page as a user belonging to one or more of your segments.

A user cannot have both e.g. Denmark and Germany as their registered country, of course – but it’s very possible for a user to belong to more segments than one, and this lets you test these complex scenarios in an easy manner.

Split testing is a method for doing controlled experiments with for instance content or layout, to see which versions performs the best. With split testing, you can send out two versions of a newsletter or an email to a subset of recipients, and test which version produces the highest conversion rate – and then send out that version to the rest of your recipients.

To do a split test on an email, you must:

  • Create (or edit) an email with split test variation
  • Set up a split test

To create a split test variant of an email, you must:

  • Create or edit an email
  • Check the Create split test variation checkbox (Figure 19.1)
Figure 19.1 Split testing emails: Create split test variation

This enables you to select or create variant values for:

  • From: Name
  • From: Email
  • Subject
  • Pre-header
  • Page

By changing these values, you can test two version of a newsletter in an easy manner – with changes ranging from subtle to drastic.

It is generally advisable to only change one or very few parameters at a time, to make it easier to measure if a particular change has any effect. You can read more about split tests in general here.

When you have created a variant of an email, click Setup split test on your email toolbar (Figure 20.1).

Figure 20.1 Setting up a split test

This takes you to the split test setup window (Figure 20.2).

Figure 20.2 The split test setup window

From here, you must:

  • Specify how many per cent of email recipients should be involved in the split test – the remaining percentage will receive the best performing version after the split test has found a winner.
    • If you choose 10%, 5% of your total recipients will receive the original and 5% will receive the variant. The conversion rate will be measured on those 10%. The remaining 90% will receive the best performing version.
  • Choose a conversion goal
    • Best engagement compares the Engagement Index (EI) points awarded overall. The EI-point value settings are configured on your top folder, read more here
    • Most opened compares the number of opened emails
    • Most clicked compares the number of links clicked from within the email
  • Choose between starting the test now or scheduling it for later
  • Specifying how to pick the winner
    • After X hours picks a winner after a set number of hours
    • At a given time picks a winner at a specific date and time
    • When X has opened picks a winner after a specified percentage of split test users have opened their email
    • Manually allows you to pick a winner when you decide results are significant
  • Specify who to notify when a winner has been picked automatically

 

When you are happy with your settings, click Start split test to start (or schedule) your split test

Your email is then moved to the split test folder, located under the top folder you are working in.

Dynamicweb collects statistical information about the performance of your email marketing efforts, and how your users interact with your emails. This information is, of course, available to you.

To access the statistical information for an email:

  • Go to the sent folder and locate the email
  • Click the email

This opens the statistics window for that email.

In the top part of your statistics window, you have access to the general statistics (Figure 22.1).

Figure 22.1 General email statistics

The general statistics provide information on the opening rate, the click rate, and the links followed by your recipients.

The highlights area also conveniently show you statistics for desktop, tablet and mobile phone users, so you can see how well your marketing efforts are doing on each type of device.

Below the general statistics, you have the recipient statistics (Figure 23.1).

Figure 23.1 Email statistics: Recipient statistics

Here, you can see how each individual recipient has reacted to your email – how many times they have opened it, clicked links, added a product to their cart, what their total order value is, whether they have unsubscribed or not, and finally, the total engagement index score of their actions.

Clicking the arrow to the right of each tab to sort it in an ascending or descending order.

The engagement statistics provide you with details on the engagement index point values of this email, for various parameters (Figure 24.1).

Figure 24.1 Engagement statistics for email marketing

You also have access to statistics on the opening and click rate of different browsers (Figure 25.1)

Figure 25.1 Statistics on the opening and click rate of different browsers

Email clients (Figure 25.2)

Figure 25.2 Statistics on the opening and click rate of different email clients

And platforms (Figure 25.3)

Figure 25.3 Statistics on the opening and click rate of different platforms

You can export email statistics by clicking the export button above the statistics window (Figure 26.1)

Figure 26.1 The export statistics button

Click the export button in order to choose which statistics to export (Figure 26.2)

Click either one of these to download a .csv file with the statistical information.

Occasionally, your email marketing efforts will fail in the technical sense - this can happen for a number of reasons.

Click the Failures button (Figure 27.1) on the email statistics ribbon.

Figure 27.1 The Failures button shows you your failures. Not in life, but in delivering emails.

This opens a list of, well, your failures and the reasons behind them.

Figure 27.2 The failures window, unlike life, provides you with concrete reasons for you failures

From the failures window, you can:

  • See the name and email of the recipients you failed to deliver the email to
  • See the reason for the failed delivery
  • Save, clear the email , and/or clear the email permission setting from any of the recipients you failed to deliver an email to

In this manner, you can take immediate action to ensure you will not fail again!

All your emails are created and organized in folders.

When you have selected a folder - any folder - you have access to a number of actions from the email folder ribbon (Figure 1.1).

Figure 1.1 You email folder ribbon gives you access to a number of actions

From the action ribbon, you can:

  • Copy, move or delete the selected emails (from the All emails-folder, only delete)
  • Search you emails
  • Specify how many emails you want to see on screen
  • Filter on email send-state, i.e. draft, scheduled, split test, and sent

Your top folder is very important, because all emails created in a top folder inherit the default behavior configured on that folder.

To override this behavior for a single email, use the advanced settings.

A top folder contains the subfolders draftsscheduledsplit test and sent. They are used to automatically sort emails based on their current state.

To create a top folder:

  • Right click on Email Marketing
  • Click Create new top folder
Figure 2.1 Create a new top folder

You will then see the top folder settings window.

  • Fill out a name for the folder
  • Configure any settings you need to – you can see a rundown of the different settings in the next section. You can also edit the settings later on.
  • Click save

Regular folders can be used to organize your email marketing efforts even further.

To create a regular folder, right click on a top folder, click create folder, name it, and press enter. Voilà!

A top folder can be configured, allowing you to control the default behavior of emails created in that folder.

All emails created in a top folder inherit the top folder settings – although most of the settings can be changed on the instance by using the advanced email settings.

You access your top folder settings by right-clicking it and selecting edit top folder, or when creating a new top folder.

Here’s a rundown of the top folder settings.

The top folder general settings set the default values of the most basic settings when working with email (Figure 4.1).

Figure 4.1 Top folder general settings

With the top folder general settings, you can:

  • Specify the name of the folder (required)
  • Specify the name of the default sender of emails created within this folder
  • Specify the email of the default sender of emails created within this folder
  • Specify a default subject for new emails created within this folder
  • Select a default domain for new emails created within this folder.
    • Dynamic links in the emails created within this folder will point to this domain. This is useful if you have multiple domains on one solution, but want to point users to a specific one.

If you use this top folder for emails with personalized content, you should check the Render content for each recipient box, to make sure the personalized content is correctly rendered.

Figure 5.1 Top folder content settings

If you render content for each recipient, your email will be moved to the scheduled folder – don’t worry, it will be send as soon as the system has had a bit of time to think.

Rendering content for each recipient is equal to rendering and sending a unique page to every recipient, and may take a little while, depending on how many recipients you are working with.

For legal reasons, Dynamicweb will automatically add an (ugly) unsubscribe link to your emails, unless you add one to the template you use to render your emails. We strongly advise you to create something beautiful to replace it.

You can use the unsubscribe settings (Figure 6.1).

Figure 6.1 Top folder unsubscribe settings

With the unsubscribe settings, you can:

  • Customize the text of your unsubscribe link
  • Redirect users to a specific page after they unsubscribe

The engagement index (EI) is a sophisticated way of measuring how effective your marketing efforts are for a specific user – how interested they are in your services, so to speak.

For your email marketing efforts, the engagement index settings control how significant various interactions with your email are to the engagement index.

The engagement index is used when working with potential leads. Read more about leads and the engagement index.

Figure 7.1 Engagement index settings

From here you can specify the EI-value of conversion goals such as:

  • A user opening the email
  • A user clicking a link
  • A user adding a product to a cart
  • A user signing up to receive more emails
  • A user unsubscribing from the email

By specifying the Engagement Index value of these (and other) actions, you can get valuable information, which can heltp you determine which users are interested in your services and which are not.

A tracking provider enables you to track the sources of traffic on your solution.

Email Marketing supports Google Analytics by default, but you can create custom tracking providers.

Figure 8.1 Top folder tracking provider settings

With the tracking provider settings, you can:

  • Specify a default tracking provider for new emails created within this folder
  • Fill in default values for any parameters associated with the tracking provider

The tracking provider settings support using the tags {{SendDate}}, {{Domain}}, {{From}} and {{Subject}} as default values - which will be replaced with dynamic values when a new email is created. This makes it easier to ensure, that tracking does not fail because of human error.

The job of the tracking provider is to provide the tracking codes which should be added to all links in an email - for Google Analytics, the codes available are:

  • utm_source
  • utm_medium
  • utm_campaign
  • utm_term
  • utm_content

These codes map directly to the fields Google Analytics field above.

You can use dynamic values by using placeholder tags, making e.g. source based on the subject, and so forth. Read more about email placeholder tags.

A delivery provider manages the technical details of delivering emails, so you don’t have to worry about email servers, infrastructure, scaling, etc.

Figure 9.1 Top folder deliver provider settings

By default, Dynamicweb uses the Dynamicweb Send Provider, but you can create your own delivery providers (e.g. for SendGrid). 

By default, Dynamicweb enables you to send out emails to registered Dynamicweb users, users with an abandoned cart, and unresponsive users, who are users who have not opened a specific email.

Figure 10.1 Top folder recipient provider settings

These settings control the default recipients for emails created within this top folder, as well as the behavior associated with that particular recipient group.

Pay particular attention to On unsubscribe settings - these should be configured on the top folder always, unless you like to battle angry unsubscribers.

You can set permissions on your email top folders, in order to control which users and user groups can use which folders.

To do so:

  • Right click on your email top folder
  • Click permissions
  • Set permissions in the standard manner

 

Figure 11.1 You can set permissions on your top folders, to control who has access to what.

A placeholder tag is a piece of text formatted in a specific format, which is then processed and replaced by a dynamic value.

For Email Marketing, this means that you can personalize email content to a large degree.

The placeholder tag format is {{PlaceholderName||”fallback value”}}, and tags can be used in:

  • Email bodies (on pages) - including in links, for example <a href="/UserInfo.aspx?UserName={{Email:User.UserName}}">Click here to see your profile</a>
  • Subject fields (when creating emails)
  • Tracking provider fields

If you do not provide a fallback value for the placeholder tag, and the user does not have a value to replace the placeholder tag with, it will simply print the placeholder tag.

So, to avoid addressing your users as Dear {{Email:User.Name}}, always provide a fallback value.

You cannot currently use placeholders with abandoned cart emails.

The following email placeholder tags are available to you: 

Placeholder name

Description

EmailMessaging:Recipient.Id

The recipient id. This is not related to the user id.

EmailMessaging:Recipient.Key

The recipient key. When using the "Dynamicweb users" recipient provider, this is the user id.

EmailMessaging:Recipient.Name

The name of the recipient.

EmailMessaging:Recipient.Email

The email address of the recipient.

EmailMessaging:Message.Id

The message id. This identifier is not the email id. If split test is used, there will be one message id for both the original and the variation.

EmailMessaging:Message.SenderName

The sender name.

EmailMessaging:Message.SenderEmail

The sender email address, or the reply-to email address.

EmailMessaging:Message.Subject

The subject. If split test is used, this will contain the subject for the given version (original or variation).

EmailMessaging:Message.DomainUrl

The domain url. This url is the domain used for the links in the content.

EmailMessaging:Message.SendDate

The send date/time. This is the time when the message was sent. If the email is recurring, this value updated each time the email is sent.

EmailMessaging:Recipient.Secret

The recipient secret used for recipient-specific actions like unsubscribing.
This is automatically added to auto-generated unsubscribe links to prevent spoofing.
Note: This will cause unsubscribe links generated
prior to 8.4.1 to become invalid when upgrading to 8.4.1 or later.

EmailMarketing:Email.PreHeader

The pre-header span. This contains the pre-header text wrapped in a span-tag.
Must be placed right after the body tag of the page used as email. If the tag is not found, the preheader will be inserted automatically by the system.

EmailMarketing:Email.PreHeader.Clean

The pre-header text. This contains the pre-header text.

EmailMarketing:Email.ContentLink.Clean

The link to the content page. This contains the link (not in a tag) to the page that provided the content for the email.

EmailMarketing:Email.UnsubscribeLink

The unsubscribe link in a tag. This contains the unsubscribe link wrapped in an a-tag using the "Unsubscribe text" as the link text.

EmailMarketing:Email.UnsubscribeLink.Clean

The unsubscribe link. This contains the unsubscribe link (not in a tag).

EmailMarketing:Email.UnsubscribeAllLink.Clean

The link to completely unsubscribe the recipient using the EmailAllowed property of the User. This tag exists in addition to the regular customizable unsubscribe link to allow for more flexibility. The unsubscribe link is not wrapped in an html anchor (<a>) tag. This value is only available when using the
"Dynamicweb users" recipient provider (available from 8.4.1.0). The placeholder needs to be added manually.

EmailMarketing:Email.TrackingImage

The tracking image for the email. This can be place independently of the pre-header (available from 8.4.1.0).

Email:User.UserName

The username.

Email:User.Name

The name of the user.

Email:User.Address

The address of the user.

Email:User.Address2

The address2 of the user.

Email:User.ZipCode

The zip code of the user.

Email:User.City

The city of the user.

Email:User.Country

The country of the user.

Email:User.Phone

The phone of the user.

Email:User.PhonePrivate

The private phone of the user.

Email:User.PhoneMobile

The mobile phone of the user.

Email:User.Fax

The fax of the user.

Email:User.CustomerNumber

The customer number of the user.

Email:User.Currency

The default currency for the user.

Email:User.Image

The link to the image of the user. This link is not handled by the internal link management.

Email:User.Company

The company of the user.

Email:User.Department

The department of the user.

Email:User.JobTitle

The job title of the user.

Email:User.PhoneBusiness

The business phone of the user.

Email:User.LoginToken

The login token for logging the specified User in automatically. (Available from 8.4.1.0).

Example: {{EmailMessaging:Message.DomainUrl}}/ProtectedPage.aspx?Username={{Email:User.UserName}}&PwToken={{Email:User.LoginToken}}

Email:User.SYSTEMNAME_OF_CUSTOM_FIELD

It is possible to get custom fields on users out in the email (available from 8.6.1.0).
 

Use the system name of the custom field that should be used, not the name. 

Example:  {{Email:User.AccessUser_CustomTextField}} will get the CustomTextField content out in the mail.

You can add a dropdown menu with placeholder tags to the rich text editor used when editing and creating paragraph content.

You do so by changing the editor configuration file.

To do so:

  • Go to the Settings > Editing > Editor Configuration (Figure 14.1)
Figure 14.1 Editor configuration
  • Create a new configuration - or edit an existing one by clicking it
  • Select the email.js configuration file (Figure 14.2)
  • Save and close
Figure 14.2 Select the email.js configuration file

This adds a dropdown menu to your editor with the Email. User fields available to you, plus any custom fields you have defined under Settings > Control panel > Users

If your custom fields do not appear on the dropdown menu, try deleting your browser cache.

In order to be able to send emails to a user, you must obtain consent from them.

User creation and registration is handled by the Extranet app - and to ask them, on creation, if they would like to receive emails, simply add the <!--@UserManagement:User.EmailAllowed.Input--> tag to the template used for profile creation.

For example:

<tr> <th align="left"><!--@Translate(allowemail, "Do you want to receive emails about future deals and product updates?")-->: </th> <td><!--@UserManagement:User.EmailAllowed.Input--></td> </tr>

For further information, please refer to the Extranet app documentation.

Database

These are the database tables associated with the Email Marketing feature:

EmailDeliveryProvider

Contains setup data for email marketing delivery providers in the form of an XML document (DeliveryProviderConfiguration) as defined in Settings -> Marketing -> Email Marketing -> Delivery Providers.

Field name Data type Length
DeliveryProviderId int 4
DeliveryProviderName nvarchar 255
DeliveryProviderConfiguration nvarchar Max

EmailMarketingTopFolder

Contains setup data for a given email marketing top folder (TopFolderId) as defined in Marketing -> Email marketing. Default tracking- and recipient provider settings are stored as XML documents (TopFolderTrackingProviderConfiguration, TopFolderRecipientProviderConfiguration). Selected delivery provider is linked via TopFolderDeliveryProviderId.

Field name Data type Length
TopFolderId int 4
TopFolderName nvarchar 255
TopFolderSenderName nvarchar 255
TopFolderSenderEmail nvarchar 255
TopFolderSubject nvarchar 255
TopFolderDomainName nvarchar 255
TopFolderTrackingProviderConfiguration nvarchar Max
TopFolderUnsubscribePageId int 4
TopFolderDeliveryProviderId int 4
TopFolderUnsubscribeText nvarchar 255
TopFolderRecipientSpecificContent bit 1
TopFolderRecipientProviderConfiguration nvarchar Max
TopFolderQuarantinePeriod int 4

EmailMarketingFolder

Defines the folder structure (FolderId, FolderParentId) in email marketing for a given top folder (FolderTopFolderId).

Field name Data type Length
FolderId int 4
FolderParentId int 4
FolderName nvarchar 255
FolderTopFolderId int 4

EmailMarketingEmail

Contains email configuration data from email marketing. Email source page is stored in EmailPageId. Configurations for recipient- and tracking providers are stored as XML documents in EmailRecipientTrackingProviderConfiguration and EmailTrackingProviderConfiguration. Contents of an email are referenced via EmailMessageId and EmailPlainTextContent (the latter depending on state of EmailIncludePlainTextContent), If split testing is enabled for an email the various EmailVariation* columns are filled.

Field name Data type Length
EmailId int 4
EmailPageId int 4
EmailRecipientProviderConfiguration nvarchar Max
EmailTemplate nvarchar 255
EmailSenderName nvarchar 255
EmailSenderEmail nvarchar 255
EmailSubject nvarchar 255
EmailFileAttachmentPath nvarchar 255
EmailEncoding nvarchar 50
EmailTrackingProviderConfiguration nvarchar Max
EmailUnsubscribePageId int 4
EmailMessageId int 4
EmailDomainName nvarchar 255
EmailVariationName nvarchar 255
EmailVariationEmail nvarchar 255
EmailVariationSubject nvarchar 255
EmailVariationPageId int 4
EmailVariationMessageId int 4
EmailSplitTestIsSent bit 1
EmailFolderId int 4
EmailCreatedDate datetime 8
EmailTopFolderId int 4
EmailDeliveryProviderId int 4
OriginalMessageId int 4
EmailOriginalMessageId int 4
EmailIsTemplate bit 1
EmailTemplateName nvarchar 255
EmailTemplateDescription nvarchar Max
EmailUnsubscribeText nvarchar 255
EmailVariationUnsubscribeText nvarchar 255
EmailScheduledActive bit 1
EmailScheduledSendTime datetime 8
EmailOriginalPreHeader nvarchar Max
EmailVariantPreHeader nvarchar Max
EmailScheduledRepeatInterval int 4
EmailScheduledEndTime datetime 8
EmailRequireUniqueRecipients bit 1
EmailRecipientSpecificContent bit 1
EmailLastExportDate datetime 8
EmailQuarantinePeriod int 4
EmailIncludePlainTextContent bit 1
EmailPlainTextContent nvarchar Max
EmailName nvarchar 255
EmailDisableUnsubscribeTag bit 1

EmailMarketingEngagementIndex

Tracks engagement index scoring for a given email marketing email (EngagementIndexEmailId). Links within email are tracked via XML documents stored in EngagementIndexOriginalLinks and EngagementIndexVariantLinks.

Field name Data type Length
EngagementIndexId int 4
EngagementIndexEmailId int 4
EngagementIndexOpenMailIndex int 4
EngagementIndexOpenMailActive bit 1
EngagementIndexClickLinkIndex int 4
EngagementIndexClickLinkActive bit 1
EngagementIndexAddingProductsIndex int 4
EngagementIndexAddingProductsActive bit 1
EngagementIndexPlacingOrderIndex int 4
EngagementIndexPlacingOrderActive bit 1
EngagementIndexSigningEmailIndex int 4
EngagementIndexSigningEmailActive bit 1
EngagementIndexUnsubscribesEmailIndex int 4
EngagementIndexUnsubscribesEmailActive bit 1
EngagementIndexOriginalLinks nvarchar Max
EngagementIndexVariantLinks nvarchar Max
EngagementIndexTopFolderId int 4

EmailMarketingSplitTest

Contains setup data for email marketing split tests. Specific email is defined by SplitTestEmailId.

Field name Data type Length
SplitTestId int 4
SplitTestEmailId int 4
SplitTestName nvarchar 255
SplitTestIncludes int 4
SplitTestIncludesUnits int 4
SplitTestGoalType nvarchar 50
SplitTestActive bit 1
SplitTestStartDate datetime 8
SplitTestEndDate datetime 8
SplitTestEndType int 4
SplitTestOpenedEmails int 4
SplitTestOpenedEmailsUnits int 4
SplitTestHoursTillEnd int 4
SplitTestAfterEndSendBest bit 1
SplitTestAfterEndNotify bit 1
SplitTestAfterEndActionEmail nvarchar 255
SplitTestStartDateTimeZoneId nvarchar 256
SplitTestEndDateTimeZoneId nvarchar 256
SplitTestScheduledSendActive bit 1
SplitTestScheduledSendTime datetime 8
SplitTestScheduledPickWinnerActive bit 1
SplitTestScheduledPickWinnerTime datetime 8
SplitTestWinnerEndDate datetime 8

EmailMessage

Contains the contents of email marketing emails in the form of HTML blocks in MessageHtmlBody and MessagePreprocessedHtmlBody.

Field name Data type Length
MessageId int 4
MessageSubject nvarchar 255
MessageSenderName nvarchar 255
MessageSenderEmail nvarchar 255
MessageDomainUrl nvarchar 255
MessageRecipientsSource nvarchar 255
MessageHtmlBody nvarchar Max
MessagePreprocessedHtmlBody nvarchar Max
MessageFileAttachmentPaths nvarchar Max
MessageDeliveryProviderId int 4
MessageRequireUniqueRecipients bit 1
MessageRecipientSpecificContent bit 1
MessageRecipientContentProvider nvarchar Max
MessageQuarantinePeriod int 4
MessageIncludePlainTextBody bit 1
MessagePlainTextBody nvarchar Max

EmailMessageTag

Stores the values (MessageTagValue) of a given email marketing tag (MessageTagName) used in the content of an email marketing email (MessageTagMessageId).

Field name Data type Length
MessageTagId int 4
MessageTagMessageId int 4
MessageTagName nvarchar 255
MessageTagValue nvarchar Max
MessageTagDataType nvarchar 255

EmailAction

Tracks actions (ActionId, ActionType) performed by recipients (ActionRecipientId) on an email marketing email (ActionMessageId) at a specific time (ActionSessionId, ActionTimestamp).

Field name Data type Length
ActionId int 4
ActionSessionId nvarchar 50
ActionTimestamp datetime 8
ActionType nvarchar 255
ActionMessageId int 4
ActionMessageIdString nvarchar 50
ActionRecipientId int 4
ActionRecipientIdString nvarchar 50

EmailRecipient

Tracks when (RecipientSentTime) a specific email marketing email (RecipientMessageId) was sent to a specific recipient (RecipientKey, RecipientName, RecipientEmailAddress), the tag values for that email (RecipientTags), and a tracking key (RecipientSecret).

Field name Data type Length
RecipientId int 4
RecipientKey nvarchar 255
RecipientName nvarchar 255
RecipientEmailAddress nvarchar 255
RecipientMessageId int 4
RecipientSentTime datetime 8
RecipientErrorMessage nvarchar Max
RecipientErrorTime datetime 8
RecipientTags nvarchar Max
RecipientSecret nvarchar 50