The Inserts tab in the Campaign menu is used to create dynamic content using SQL to pull information from your database that can be recipient specific by using specific tokens in your SQL statements. Axon also provides a few "template" Inserts you can choose from to use in your campaigns.
Personalized Dynamic Content Tokens
You can add personalized email content to your Campaign using the primary Content tab and the DynConent (Dynamic Content) tab. In the Dynamic Content tab, personalized Tokens are added to your SQL Statements making it easy to pull information from your database that specifically relates to the email recipient.
IMPORTANT: You must have the “Enable Personalization” option enabled in your Campaign for personalized content generation. Processing personalized content requires additional time to generate all of the emails. It will also require additional SQL Server space when running your campaign in batches or if you have checked the option “Save All Emails” in the Edit NukeAlert menu option. The amount of time and space depends on the number of recipients in your Campaign and the amount of content to be generated. Personalized tokens begin with the [ character and end with ] character. A list of valid tokens are displayed below.
Here is a sample of a SQL Statement using these tokens:
SELECT dbo.Roles.RoleName, dbo.UserRoles.ExpiryDate, dbo.UserRoles.UserID
FROM dbo.UserRoles INNER JOIN
dbo.Roles ON dbo.UserRoles.RoleID = dbo.Roles.RoleID
WHERE (dbo.UserRoles.UserID = [USR-USERID])
The token [USR-USERID] is used in the sample SQL Statement above. This statement returns the recipients current DotNetNuke Roles they belong to and displays the expiration date.
Valid Personalized Tokens are:
• [USR-LASTNAME] - This token will be replaced with the users last name.
• [USR-FIRSTNAME] - This token will be replaced with the users first name.
• [USR-FULLNAME] - This token will be replaced with the users full name.
• [USR-EMAIL] - This token will be replaced with the users email address.
• [USR-AFFILIATEID] - This token will be replaced with the users Affiliate ID.
• [USR-USERID] - This token will be replaced with the users User ID in DNN.
• [USR-USERNAME] - This token will be replaced with the users user name.
HTML Encode/Decode: When pulling information from a table that contains HTML (like the HtmlText DNN Table) you will need to HTML Decode or Encode this data. To use these functions you just need to use the tags as specified in the Available Functions section in your HTML Content of your Insert. Example: [DECODE:DesktopHtml]
After you have created your Insert, copy the Token name you specific to the Content of your email. In the example above, the token is [HtmlView].