Overview
Campaign Triggers are optional configurations of Campaigns that allow for a SQL statement to be run before or after a Campaign launches. Campaign Triggers are available in Pre-Campaign Triggers and Post-Campaign Triggers.
The most common use of Campaign Triggers is to write Campaign Metadata into a table for reporting purposes. With this data, complex reporting can be developed and extracted from the metadata table.
In order to use Campaign Triggers, Message must be enabled within Accelerator.
Table of Contents
Adding a Trigger to a Campaign
Creating a Campaign Metadata Table
Process
Creating a Campaign Trigger
Whether creating a Pre-Campaign Trigger or a Post-Campaign Trigger, both are created the same way.
Navigate to Admin → Campaign Triggers. This opens a screen to manage any existing Campaign Triggers.
Click an existing Campaign Trigger to open the Campaign Trigger settings. Click the Create Trigger button in the top right to create a new Trigger. If creating a new Trigger, the screen will prompt the user to enter a name for the new Trigger.
After naming a new Trigger, the Trigger Overview screen will display.
Currently, this Trigger exists within Accelerator, but it doesn’t do anything. View the details of the Trigger to see information about the Trigger. Underneath the details of the Trigger is the Add a Campaign Trigger Action button.
Click this button to create a query for the Campaign Trigger.
Adding a Campaign Trigger Action is the functionality that executes when using this Campaign Trigger in a Marketing Campaign. Configure the Action Name to be descriptive and choose the appropriate database connection to allow this Campaign Trigger to interact with appropriate data sources.
The right side of the screen is the data source explorer. Use this interface to view tables and columns within the data source.
There are unique variables available within the Campaign Trigger Action. A list variables are found below the Query Editor. Click on the variables to copy the variables in the correct format. Paste the text within the Query Editor to use the variable.
| A full list of available variables can be found within this document. View variables in this section. |
Once the Query is configured, click Save at the bottom of the screen. Once saved, the screen will display the Campaign Trigger Overview.
A Campaign Trigger can contain multiple Actions and Queries. If needed, continue to add additional Trigger Actions to the Campaign Trigger.
When using multiple Actions within a Campaign Trigger, the Actions are processed sequentially. This means that the order that the Actions are displayed is important. Arrange the actions in the proper order using the arrow buttons that display when using multiple Actions.
Adding a Trigger to a Campaign
Navigate to Message → Delivery → Marketing to view existing Marketing Campaigns. Create a new Campaign or open an existing Campaign.
| For more information on creating Marketing Campaigns, refer to End-to-End Newsletter Creation. |
Once in the Campaign Overview screen, select the Settings option on the right side of the screen.
Scroll to the bottom of the Campaign Settings and expand the View Advanced Options dropdown. Within the Advanced Options is a field to select a Pre-Campaign Trigger or a Post-Campaign Trigger.
Use the dropdown to select an existing Campaign Trigger.
A Campaign Trigger created within Accelerator can be selected for either a Pre-Campaign Trigger or a Post-Campaign Trigger.
Save the configuration of the Campaign.
Campaign Trigger Variables
Below is a list of variables available within the Campaign Trigger:
Job Metadata
|
Element Name |
Description (*Notes) |
Data Type |
Nullable |
|
jobId |
The internal Accelerator job ID. Note: Suggested Primary Key |
Int |
No |
|
startTime |
The Accelerator job execution timestamp. |
Datetime |
No |
Template Metadata
|
Element Name |
Description (*Notes) |
Data Type |
Nullable |
|
templateId |
The internal Accelerator template ID. |
Int |
No |
|
templateName |
The specified template name. |
String |
No |
|
templateDescription |
The specified template description. |
String |
Yes |
|
fromAddress |
The unrendered From Address specified in the template. |
String |
No |
|
fromName |
The unrendered From Name specified in the template. |
String |
Yes |
|
subjectLine |
The unrendered subject line specified in the template. |
String |
No |
|
replyToAddress |
The unrendered reply-too address specified in the template. |
String |
Yes |
|
approxTemplateSize |
The approximate template size based on the rendered template preview. |
Int |
No |
|
spamAssassinScore |
The approximate Spam Assassin Score based on the rendered template preview. |
Double |
No |
Audience/ContextData Metadata
|
Element Name |
Description (*Notes) |
Data Type |
Nullable |
|
recipientDataSourceName |
The specified Audience name. |
String |
No |
|
recipientDataSource |
- Pre-campaign trigger: The unrendered SQL or API URL. - Post-campaign trigger: The rendered SQL or API URL. |
String |
No |
|
contextDataSourceName |
The specified Audience name. |
String |
No |
|
contextDataSource |
- Pre-campaign trigger: The unrendered SQL or API URL. - Post-campaign trigger: The rendered SQL or API URL. |
String |
No |
Campaign Metadata
|
Element Name |
Description (*Notes) |
Data Type |
Nullable |
|
campaignId |
The internal Accelerator campaign ID. |
Int |
No |
|
campaignName |
The specified Accelerator campaign name. |
String |
No |
|
campaignDescription |
The specified Accelerator campaign description. |
String |
Yes |
|
category |
The specified Accelerator campaign (job) category. |
String |
Yes |
|
urlAppend |
The specified Accelerator campaign URL Append. |
String |
Yes |
|
notificationEmailAddress |
The specified Accelerator campaign notification email address. |
String |
Yes |
Account Metadata
|
Element Name |
Description (*Notes) |
Data Type |
Nullable |
|
accountId |
The account ID used to send the job. |
Int |
No |
|
accountName |
The account name used to send the job. |
Int |
No |
Other Post-Campaign Metadata
|
Element Name |
Description (*Notes) |
Data Type |
Nullable |
|
messageGearsRequestId |
The global unique MessageGears job identifier. *Note - this will be null for a 0 recipient job. |
String |
Yes |
|
recipientCount |
The total recipient count from the audience for the job. |
Int |
No |
|
firstRecipientXml |
The first recipient transformed into the XML format sent to Cloud. *Note - this will be null for a 0 recipient job. |
String |
Yes |
|
dateExtractionStartTime |
The timestamp when Accelerator began extraction from the external datasource/database. |
Timestamp |
No |
|
dataTransferStartTime |
The timestamp when Accelerator began transferring the recipient data to Cloud. |
Timestamp |
No |
|
jobSubmissionStartTime |
The timestamp when Accelerator received a successful job submission response from Cloud. |
String |
No |
|
variantName |
The MVT variant name of the job if an MVT was used. |
String |
Yes |
|
error |
"true" if the job resulted in an error. "false" otherwise. |
Boolean |
No |
|
errorMessage |
The corresponding error message if there was a job error. |
String |
Yes |
|
Bolded fields can only be used in post-campaign triggers. |
Creating a Campaign Metadata Table
It is recommended that a table exists within the data source to hold metadata. An example of the SQL code used to create this table is shown below:
CREATE or REPLACE TABLE 'campaign_metadata' (
'job_id' int(11) NOT NULL,
'request_id' varchar(50) NOT NULL,
'start_time' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
'job_category' varchar(255) DEFAULT NULL,
'recipient_count' int(11) DEFAULT NULL,
'campaign_name' varchar(255) DEFAULT NULL,
PRIMARY KEY ('job_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Make note of the data types for each field.
Example of a Campaign Trigger
Below is an example of a Campaign Trigger Query with variables:
INSERT INTO myschema.campaign_metadata
(
job_id,
request_id,
start_time,
job_category,
recipient_count,
campaign_name
)
VALUES
(
${trigger.jobId},
'${trigger.messageGearsRequestId}',
'${trigger.startTime[0..19]}',
'${trigger.category}',
${trigger.recipientCount},
'${trigger.campaignName}'
);
When the variables are populated, the SQL query will be rendered as:
INSERT INTO myschema.campaign_metadata
(
job_id,
request_id,
start_time,
job_category,
recipient_count,
campaign_name
)
VALUES
(
1
'p4-2020345-145df83a93819417ab9372daf',
'2020-02-30T18:53:11',
'NEWSLETTER',
13013981,
'US - Weekly Newsletter'
);
Comments
0 comments
Please sign in to leave a comment.