WARNING: The information in this article is specific to target group IQAs in the MailingLists folder only.

Do not make changes in other areas without consulting your iMIS partner or Higher Logic; doing so can cause problems with your integration.

Enhancement overview

ASI has made an enhancement to the integration between Higher Logic Thrive Marketing Professional (Thrive Marketing Professional) and iMIS EMS. The enhancement results in Mailing Lists IQAs running more quickly and enabling larger lists to be synced on send.

NOTE: This enhancement is available only to customers on iMIS EMS and those hosted on-premise on version 20.3.190 and above.

Mailing Lists IQA criteria

In order to take advantage of the enhancement, the Mailing Lists IQA must meet the following criteria:

• The IQA must return four columns (i.e., Properties) or fewer
• The Id and Email Address Properties must be two of the four
• The Length value must not exceed 1000 characters for any of the selected Properties
• The IQA must not request any large object type or TEXT columns

Performance improvement

With these criteria met, the Mailing Lists IQA can return 5000 rows per page instead of 500.

Customer action

In order to take advantage of the enhancement:

• review all the IQAs in your MailingLists folder and
• delete any IQAs that do not meet the criteria, or edit them to meet the criteria.

NOTE: Older IQAs with more columns in the MailingLists folder can be removed or edited without any issues.

To review your MailingLists IQAs:

1. Log in to the admin panel of your iMIS instance.
2. Navigate to RISE > Intelligent Query Architect.
3. Locate and open the HigherLogic folder.
4. Open the MailingLists folder and edit an IQA.
5. In the Property column of the Display tab, choose (or verify that there is) a maximum of four Properties to display as columns. Two required Properties are:

• • Id
  • Email Address

NOTE: If there are more than four columns, our on-demand syncing will not be optimized for the sync-on-send functionality.

NOTE: If your target group IQA is particularly large, we suggest breaking it up into multiple, smaller lists of four columns or fewer.

If you are still experiencing issues, contact our Support team, informzsupport@higherlogic.com, so that we can help you review and optimize your target groups.