Creating a campaign has three steps:
- Create the campaign.
- Create the steps in the campaign to populate it with accounts/contacts.
- Execute the campaign steps to retrieve the accounts/contacts for the campaign.
Create the Campaign
A campaign contains the criteria for the campaign and the accounts/contacts within the campaign. To add a new campaign:
- Click the Campaigns link for the applicable area of Momentus Enterprise for the campaign (Event CRM, Registration, etc.). The Campaigns screen opens.
- Click the Add button. The Add Campaign screen opens.
- Enter the following information:
- Description - Name of the campaign.
- Owner - Internal user responsible for the campaign. Defaults to the user adding the campaign.
- Coordinator - Internal user coordinating the campaign.
- Active - If checked, the campaign is available for selection in drop-downs.
- Locked - If checked, only the user assigned as the owner can make changes to the campaign and retrieve the campaign results.
- Summary - Brief note about the campaign for informational purposes.
- ID - Unique alphanumeric code used by the system. *AUTO auto-generates a code. You can overwrite the *AUTO with your own code if desired.
- Group - Campaign group assigned to the campaign.
- Event - Event associated with the campaign, if applicable.
- Click the Save (disk) button.
Create the Campaign Steps
Campaign steps to determine which accounts/contacts are included or excluded in the campaign. You can have as many steps as you need to add and/or remove the desired accounts/contacts. You can create campaign steps based on:
- SQL Statements - Uses a SQL statement to add/remove accounts/contacts from a campaign.
- Macros - Pre-written SQL statements you can use to include/exclude accounts/contacts in a campaign.
- Queries - Uses the information in Enterprise tables and fields to add/remove accounts/contacts from a campaign.
- Any combination of the above
You can also manually add accounts and/or contacts to a new or existing campaign or create a step to convert organizations to individuals.
- Select the Campaign Steps tab.
- Click the Add button.
- Select how you want to add accounts/contacts to the project:
- Click OK once you have added all steps to the campaign.
SQL Statement Steps
A SQL Statement step is a SQL statement that is used to include/exclude accounts/contacts in a campaign.
- Click the Campaigns link for the applicable area of Momentus Enterprise for the campaign (Event CRM, Registration, etc.). The Campaigns screen opens.
- Select the campaign for the account/contact criteria.
- Right-click and select Edit. The Edit Campaign screen opens.
- Select the Campaign Steps tab.
- Click the Add button.
- Select Add SQL Step. The Add SQL Step screen opens.
- Enter the necessary information:
- Description - Name of the campaign step.
- Operation - Select what to do with the accounts/contacts that are selected as part of the step:
- Add - Selected accounts/contacts are added to the campaign.
- Keep Only - Used as an additional filter for adding accounts/contacts to the campaign. For example, keep only accounts with Arts & Science or Education market segments.
- Remove - Selected accounts/contacts are removed from the campaign.
- Campaign Step SQL Statement - SQL statement for the step.
- Click OK.
Macro Steps
A Macro Step is a pre-written SQL statement you can use to include/exclude accounts/contacts in a campaign. You use campaign macros for common SQL statements. See Campaign Macros for information about adding and maintaining campaign macros.
- Click the Campaigns link for the applicable area of Enterprise for the campaign (Event CRM, Registration, etc.). The Campaigns screen opens.
- Select the campaign for the account/contact criteria.
- Right-click and select Edit. The Edit Campaign screen opens.
- Select the Campaign Steps tab.
- Click the Add button.
- Select Add Macro Step. The Add Macro Step screen opens.
- Select the macro for the campaign.
- Click the Select button.
Query Steps
You use Query steps to determine which accounts/contacts you want to add or remove to a campaign. Query steps allow you to use the information (tables and fields) within Enterprise to find the accounts/contacts you want to include in a campaign or the accounts/contacts you want to remove from a campaign. You define the table you want to use for the query step and then within the query step, you can define the field criteria you want to use to include/exclude the accounts/contacts within the campaign.
- Click the Campaigns link for the applicable area of Enterprise for the campaign (Event CRM, Registration, etc.). The Campaigns screen opens.
- Select the campaign for the account/contact criteria.
- Right-click and select Edit. The Edit Campaign screen opens.
- Select the Campaign Steps tab.
- Click the Add button.
- Select Add Query Step. The Add Query Step screen opens.
- Enter the necessary information:
- Description - Name of the campaign step.
- Operation - Select what to do with the accounts/contacts that are selected as part of the step:
- Add - Selected accounts/contacts are added to the campaign.
- Keep Only - Used as an additional filter for adding accounts/contacts to the campaign. For example, keep only accounts with Arts & Science or Education market segments.
- Remove - Selected accounts/contacts are removed from the campaign.
- Project Step Table ID - Table to use for the campaign step criteria.
- Select the Query Step Fields tab. This is where you determine which fields and the values in the fields to use to include/exclude accounts/contacts for the step.
- Click the Insert Row hyperlink. A new row displays in the tab.
- Enter the following information:
- Column Name - Field to use to select the accounts/contacts for the step.
- Operator - How the value entered into the Value field needs to match the information on the account/contact to include it in the step.
- Set Value - Click the Set Value hyperlink to determine the value to use for the step criteria. The Set Value screen opens. The information available in the Set Value screen is dependent on the field selected from the Column Name drop-down.
- ( or ) - Add parentheses for and between conditions if needed.
- Logical Operator - If adding additional fields to the step, select if accounts/contacts need to meet the criteria of the current and next field (AND) or if an account/contact only needs to meet the criteria of the current or next field (OR).
- Click the green plus sign (+) to the left of the row to add additional field criteria.
- Click OK once all field criteria is entered and complete.
Convert Organizations To Individuals Step
The Convert Organizations To Individuals Step creates a step that converts the organization accounts into contacts for the organizations. You must check the Business-To-Business check box on the Add/Edit Project screen to use this step.
- Click the Campaigns link for the applicable area of Enterprise for the campaign (Event CRM, Registration, etc.). The Campaigns screen opens.
- Select the campaign for the account/contact criteria.
- Right-click and select Edit. The Edit Campaign screen opens.
- Select the Campaign Steps tab.
- Click the Add button.
- Select Convert Organizations To Individuals Step. The Convert Organizations to Individuals screen opens.
- Enter the necessary information:
- Method - Retrieval process preference.
- Stop Retrieving At First Step With Results - If selected, the campaign retrieval process stops once results are returned regardless of any additional configured steps.
- Process All Conversion Steps - If selected, the campaign retrieval process uses all campaign steps.
- Keep Organizations if Contacts Not Found - If checked, keeps the organization account if no individual/contact is found.
- Individuals Inherit Organization's Status - If checked, the organization's contacts included in the campaign use the organization's account status.
- [Add Campaign Steps to this Step as required otherwise the Covert Organizations To Individuals Step won't work]
- Method - Retrieval process preference.
- Click OK.
Execute the Campaign Steps
After you create all the campaign steps to determine which accounts/contacts to add/remove from the campaign, you can then run those steps. When you run the campaign steps, Enterprise uses the parameters in the steps to find the accounts/contacts that meet the criteria and builds the campaign with those accounts/contacts. To run the campaign steps:
- Click the Campaigns link for the applicable area of Enterprise for the campaign (Event CRM, Registration, etc.). The Campaigns screen opens.
- Select the campaign for the account/contact criteria.
- Right-click and select Tools -> Retrieve. The campaign retrieval process begins. When the process is complete, the Count field updates with the number of accounts/contacts available in the campaign.
Comments
21 comments
Hi,
When you retrieve a project you always get prompted the following: "Do you wish to keep the detail status values, where applicable?"
When you accidentally click no here, all of the project detail statusses are reset...
Is there a way to avoid this?
Regards,
Tom
0 upvotes
Furthermore, you state "As accounts are added to the database with a city of St.Louis, the Project will automatically update to include them."
This is not the case, the project is not automatically updated, you have to retrieve the project again, or I am missing something here...
0 upvotes
Is the email marketing option available in V19? I get an error because it tries to open a V20 window when I click E-mail marketing settings. Also in V19 there are also Projects in ER&H; is it possible to do mass e-mailing from those as well?
0 upvotes
Kirsti - email marketing is v20 only (although you can see elements of it in later versions of 19.x). However you can mass e-mail from a v19 project under Tasks. One trick - it will look like it is sending one e-mail with everyone in CC, but it isn't. Click Preview to confirm each one, especially if using a template with wildcards.
0 upvotes
Thanks Alex, I already found the e-mail option under Tasks; but your remark about previewing is very useful!
If you cancel a previewed mail, will it continue with the next mail or does it terminate all of the mailing?
0 upvotes
Not sure without trying - perhaps you could make a project with a few internal (or personnel) accounts, and test that way?
0 upvotes
Thanks, I'll try it with some test accounts.
0 upvotes
Apparently this is only available in 20.7 and higher? I don't see a PROJECTS option from the main menu in 20.6. All I see in 20.6 is Projects(v19).
0 upvotes
I know that at some point they are being re-branded as Campaigns, but as we run on 19.5 I cannot confirm the details.
0 upvotes
Lori, you are correct. v20 Projects is available in version 20.7 and above. Beginning in v20.8, Projects were re-named Campaigns but the functionality remains the same.
0 upvotes
is it correct that 'add query step', 'add SQL step' and 'add Macro step' is still not available in v20.8L ?
0 upvotes
Tom,
It is not exclusively available in v20. The functionality is there, but it requires bridging to v19.
-Carrie
0 upvotes
Carrie,
Any chance this will be integrated in v20 without bridging? The less we have to bridge, the better :-)
0 upvotes
It absolutely will be at some point, but unfortunately it's not on the plan in the near future. Sorry!
--Carrie
0 upvotes
Hi
It's been over a year now. Is there a way add query steps without bridging to v19.
0 upvotes
Martha,
I requested an update from Product Management, and it is actively being worked on, but we do not have a set release date yet.
Thank you!
--Carrie
0 upvotes
Hi
Is there a way add query steps without bridging to v19?
0 upvotes
Hi Michaela - Bridging to v19 is the only way you can add query steps at this time. We will be sure to update this thread when Development has plans to implement this feature in v20.
Thanks,
Ryan
0 upvotes
Hi Ryan,
Are you aware of the bugs with the bridging to v19 to add Query Steps?
I have found on pretty much all versions that the first query you add is numbered 2 and the second query you add is numbered 4 and the 'Add, Keep Only, Remove' radio buttons are all greyed out and stuck on Add (this is always the default option for step 1 but not subsequent steps).
We are forced to create all steps as 'Add' and then Edit the campaign in v19 to amend the steps accordingly - very frustrating.
0 upvotes
Hi Sean,
I was not aware of this so thanks for bringing to my attention. I just tested all versions and found the same inconsistencies with the first query step showing 2 instead of 1 (will enter a case for this). However, the second query is showing step 3 and not 4. The second issue with the 'Add, Keep Only, Remove' radio buttons being greyed out and stuck on Add has been fixed as part of a previous customer case a few weeks back. This change went into 20.94 F and 20.93 J service packs.
Thanks,
Ryan
0 upvotes
Thanks Ryan,
good to hear.
0 upvotes
Please sign in to leave a comment.