- After creating the Constituent Query to be split, save its final version in the static format. Be sure to note the number of records that the query generates.
- Create a new Static Constituent Query.
- In the query, Select Tools>Query Options.
- Select the Record Processing tab.
- Mark the Select from query checkbox.
- Click the binoculars icon in the Select from query field.
- Search to include the Query saved in Step 1.
- Mark the Apply output limits checkbox.
- Select Random Sampling.
- In the No. of records to include field, enter half of the number of records noted in Step 1.
- Click OK.
- Save and close the query.
- Return to Query.
- Click Merge Queries:
- In the Primary Query field, select the Query saved in Step 1.
- In the Secondary Query field, select the Query saved in Step 4.
- In the Operator dropdown, select SUB.
- Click OK.
- Save and close the resulting merged Query.
The resulting queries to be used for the split testing are:
- The Query saved in Step 4.
- The Query saved in Step 7.
Note: These steps produce two queries that have counts of about half the records noted in Step 1. Each query will have unique records that were randomly selected. In order to see the resulting records, an Export must be performed. Opening the query in The Raiser’s Edge, re-running the Query Merge, or refreshing the static query will alter the results in each one.
If there are multiple segment queries, for example from segmenting with the Mail module, then the steps above must be performed for each output query of that process.