Higher Logic Thrive Marketing Professional (Thrive Marketing Professional) requests mailing recipients from a saved query found in netFORUM Enterprise. Each time individuals are requested, netFORUM Enterprise re-runs the query, ensuring that Thrive Marketing Professional has the most current list.

The following must be true for each netFORUM Enterprise query to be usable by Thrive Marketing Professional.

• Each query must contain “Informz” as its prefix
• Each query must contain the Individual Primary Email Address column (cst_eml_address_dn)
• Each query must contain the Do Not Contact By Email column (cst_no_email_flag)
• Queries cannot contain run-time parameters

Create a Query

Below are the required steps to create a query that Thrive Marketing Professional can use as a target group.

1. Navigate to Modules > CRM.
2. Navigate to Individuals > Query from the left column.
3. Click the Query Columns tab.
4. Add the following two columns to the Display Columns section:

1. Customer::Primary E-Mail
2. Customer::Do Not Contact by Email

5. Add any additional columns needed as filter criteria.
6. Click the Column to Query menu and select the desired column.
7. Enter any necessary query criteria.
8. Click Add to Query.
9. Enter a Query Name. Always begin this name with the prefix Informz. Any descriptive text can be added after Informz, as long as you don't include any special characters (only queries that begin with Informz are identified as a source for a target group).
10. Click Save Query.
11. Click Run Query to view any subscribers that match your criteria.

Create an Audience Query

Below are the required steps to create an audience query that Thrive Marketing Professional can use as a target group.

1. Navigate to Modules > CRM.
2. Navigate to Individuals > Audience.
3. Enter a name for the Audience Query. Always begin this name with the prefix Informz. Any descriptive text can be added after Informz as long as you don't include any special characters (only queries that begin with Informz are identified as a source for a target group in Thrive Marketing Professional).
4. Click Add in the Query Blocks section to enable the Object and Query menus.
5. Click the Object menu and select the Individual type to include. Audience queries must be built with queries built on the Individual Object.
6. Click the Query menu and select an available Individual query. Only select a query with the Informz prefix.
7. Enter any additional information required for the query.
8. Click Update Count to see how many records the current criteria returns. This action updates the Block Count, Running Count, and Final Audience Count fields. Use this any time an Audience is created or changed to ensure the results are what you expect.
9. Click Save Audience when complete.
10. Click Run Query to view the newly created query and verify the results.

NOTE: netFORUM Enterprise integrations only support the primary email address (cst_eml_address_dn) for individuals (this is true for individual and audience queries). Secondary or tertiary email addresses from a customer record are not supported for mailing through the integration.