Revenue Campaign merge fields are incorrect in email message based on a constituent export definition

When sending email messages out of BBIS using constituent export definitions as the data source in the templates the incorrect campaign linked to the gift being included in the email.
Download and install the latest Service Pack which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Steps to Duplicate

1.  Create a new constituent record and add your email address to the constituent
2.  Create two new pledges for the constituent created in step 1.  Ensure each pledge has a different campaign associated with it
3.  Create a constituent query with the criteria being the constituent created in step 1
4.  Create a new constituent export definition with the criteria in the attached screenshot (export definition criteria)
5.  Create a new export and select the constituent query in step 3 and the export definition in step 4
6.  Run the export and open the file in Excel.  Notice both pledges are exported and each campaign appears
7.  Open BBIS and create a new list
8.  Select constituent as the data source
9.  Enter a list name and select the query created in step 3 for the constituent query
10. Save the List
11. Create a new Template
12. Enter a template name, subject, from address, from name, constituent as the data source, and the export definition created in step 4
13. In the template design include the following merge fields from the export definition:
Constituent>Revenue>Revenue Splits>Revenue Campaigns>Campaign>Campaign.Lookup ID
Constituent>Revenue (2)>Revenue (2).Amount
Constituent>Revenue (2)>Revenue Splits>Revenue Campaigns>Campaign>Campaign.Lookup ID
14. Include a link to a preference page and privacy page
15. Save the template
16. Select Messages and create a new message
17. Select the template created in step 13 and select ok
18. Enter the list created in step 10 as the recipient lists
19. Enter an email name, subject, and appeal
20. Save the email and then select send final. When the email is received notice that both pledge amounts from step 2 appear but the campaign for pledge 1 appears for both.  This is incorrect as it should be including the campaign on the second pledge



 Blackbaud CRM

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.