--- title: "Creating Audience Queries" slug: "acoustic-creating-audience-queries" updated: 2025-07-10T17:28:22Z published: 2025-07-10T17:28:22Z canonical: "support.jacquard.com/acoustic-creating-audience-queries" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.jacquard.com/llms.txt > Use this file to discover all available pages before exploring further. # Creating Audience Queries The first part of setting up a Jacquard's Acoustic integration is to define 11 database segments. Ten segments are for the split test, nine of which will receive a Jacquard variant and one which will receive your human control variant. The eleventh and final query is to select the remaining bulk of the members of the database who will receive the winning variant with the best performing language from the test. You need to provide Jacquard with the IDs of these queries prior to your first send so they can be recorded in your profile settings. You only need to do this once, as long as you **do not delete or recreate the queries** for any reason. The following instructions detail how to create the queries and update your database using the built in Acoustic segmentation tool and field type to populate the queries. You will need to run the Acoustic segmentation tool prior to the deploying a Jacquard experiment to ensure the audiences selected for the queries are newly randomised for each send. We suggest scheduling this soon after the conclusion of your previous experiment to provide enough time for Acoustic to complete the operation before your next experiment. ### Setting up the database segmentation Log in to Acoustic and open your main database. [![](https://downloads.intercomcdn.com/i/o/42747442/e4ce056fe7bb6277cd780d67/WCA_01.png?expires=1749734100&signature=2cb1a52c08de77367171dbf2fd7ed960dfa9b4c232d66a5fbaa624b0b3fc0911&req=cCIgEs56mYMTWLcX3D%2B5hpyWMAsTGRLmviMO3pl3STpdL3%2FU3PfN1QRZedgb%0ApaHZ4qSJc07EGG3a%0A)](https://downloads.intercomcdn.com/i/o/42747442/e4ce056fe7bb6277cd780d67/WCA_01.png?expires=1749734100&signature=2cb1a52c08de77367171dbf2fd7ed960dfa9b4c232d66a5fbaa624b0b3fc0911&req=cCIgEs56mYMTWLcX3D%2B5hpyWMAsTGRLmviMO3pl3STpdL3%2FU3PfN1QRZedgb%0ApaHZ4qSJc07EGG3a%0A) Select your **Master Database**. [![](https://downloads.intercomcdn.com/i/o/42748849/8444be22c0e410006130f565/WCA_02.png?expires=1749734100&signature=23de20e093618dea4bd9724c8d35f070a0213fe193daada011a648cf0810c673&req=cCIgEsF2mYgTWLcX3D%2B5hjiyaFhG%2F9DEJEFAbAOWu%2BDfh0iQH15ingByk%2BNe%0Ab4bnNs4hO2JxafQt%0A)](https://downloads.intercomcdn.com/i/o/42748849/8444be22c0e410006130f565/WCA_02.png?expires=1749734100&signature=23de20e093618dea4bd9724c8d35f070a0213fe193daada011a648cf0810c673&req=cCIgEsF2mYgTWLcX3D%2B5hjiyaFhG%2F9DEJEFAbAOWu%2BDfh0iQH15ingByk%2BNe%0Ab4bnNs4hO2JxafQt%0A) Click **Add Field**. [![](https://downloads.intercomcdn.com/i/o/42749258/ed06c7d8ec6eb896bf0b3aaa/WCA_03.png?expires=1749734100&signature=2bec701ed0b212fc739b9355f563e1c13d39d2110d4203b7f4f7534041ed9b27&req=cCIgEsB8mIkTWLcX3D%2B5hkDF9E4X2tFJsg8xoyMdSpMA341gy1xpcjW55ybJ%0AKtgV6JQxxmkfU4Bq%0A)](https://downloads.intercomcdn.com/i/o/42749258/ed06c7d8ec6eb896bf0b3aaa/WCA_03.png?expires=1749734100&signature=2bec701ed0b212fc739b9355f563e1c13d39d2110d4203b7f4f7534041ed9b27&req=cCIgEsB8mIkTWLcX3D%2B5hkDF9E4X2tFJsg8xoyMdSpMA341gy1xpcjW55ybJ%0AKtgV6JQxxmkfU4Bq%0A) Give the field a valid meaningful name and select the **Segmenting** Field Type. [![](https://downloads.intercomcdn.com/i/o/42752019/b4b69ad6eee18d1aad2e7241/WCA_04.png?expires=1749734100&signature=6d1e10b61930b789f4314f630cad0370a1c0d80e5d499936833e2417f0598d45&req=cCIgE8t%2BnIgTWLcX3D%2B5hq0ORqL955%2BurHSTWT6q%2F03nOzqSw9OCXmcLDrmi%0ARndXGyv7WgCze9fx%0A)](https://downloads.intercomcdn.com/i/o/42752019/b4b69ad6eee18d1aad2e7241/WCA_04.png?expires=1749734100&signature=6d1e10b61930b789f4314f630cad0370a1c0d80e5d499936833e2417f0598d45&req=cCIgE8t%2BnIgTWLcX3D%2B5hq0ORqL955%2BurHSTWT6q%2F03nOzqSw9OCXmcLDrmi%0ARndXGyv7WgCze9fx%0A) Run the segmentation tool to randomly select your split test audiences. [![](https://downloads.intercomcdn.com/i/o/42752244/fd0053246796a2786d2c88b4/WCA_05.png?expires=1749734100&signature=771858d1c9058207ddc24b2417a3dce9f5b81f73eaf2837385d667db657e3aaa&req=cCIgE8t8mYUTWLcX3D%2B5hm%2Fbe4avFaR4dSclmaYw7Ag1Z2LH8pmqlJ5lWJ%2Fw%0AnfK%2FO4b1BeqOiYxK%0A)](https://downloads.intercomcdn.com/i/o/42752244/fd0053246796a2786d2c88b4/WCA_05.png?expires=1749734100&signature=771858d1c9058207ddc24b2417a3dce9f5b81f73eaf2837385d667db657e3aaa&req=cCIgE8t8mYUTWLcX3D%2B5hm%2Fbe4avFaR4dSclmaYw7Ag1Z2LH8pmqlJ5lWJ%2Fw%0AnfK%2FO4b1BeqOiYxK%0A) Complete **Step 1** of the **Segment contact source** by filling in the fields as indicated: - Set the **Base Segmenting Value** to 1 - Select the field your created above for the segmentation field - Give the data job a meaningful name [![](https://downloads.intercomcdn.com/i/o/42752651/39ec8865b6e048a00a997282/WCA_06.png?expires=1749734100&signature=7b9f642849d421d4fd4a1ab803a7ea79d1da0f1a8a8065cbcc114581e1cc04ad&req=cCIgE8t4mIATWLcX3D%2B5hpDByy7ZhSGrVPwBX8FIFt%2B2vbNwKiVgUJNEvPQQ%0AY8xejystHx7GiGbG%0A)](https://downloads.intercomcdn.com/i/o/42752651/39ec8865b6e048a00a997282/WCA_06.png?expires=1749734100&signature=7b9f642849d421d4fd4a1ab803a7ea79d1da0f1a8a8065cbcc114581e1cc04ad&req=cCIgE8t4mIATWLcX3D%2B5hpDByy7ZhSGrVPwBX8FIFt%2B2vbNwKiVgUJNEvPQQ%0AY8xejystHx7GiGbG%0A) Complete Step 2 by: - Selecting **conduct sampling by selecting the following option and providing values** - Selecting **Number of segments** and entering 10 (or the number of splits advised by your Customer Success Manager) - Selecting **Percent of contacts per segment** and entering the number confirmed by your Jacquard Customer Success Manager (usually in the neighborhood of 3) - Unchecking **Automatically generate each segment as a** - Clicking **Next** to move to Step 3 [![](https://downloads.intercomcdn.com/i/o/42752860/81140196769ea87c050a0035/WCA_07.png?expires=1749734100&signature=fd40828ea93f8adb8c411345081c495237418e2229d4df4520f3813df159c64f&req=cCIgE8t2m4ETWLcX3D%2B5hg838J140UXj0Lf7AMhNKpKXp5QAMsmbbodpKlm1%0ATKew79T%2FAbdTRO%2F4%0A)](https://downloads.intercomcdn.com/i/o/42752860/81140196769ea87c050a0035/WCA_07.png?expires=1749734100&signature=fd40828ea93f8adb8c411345081c495237418e2229d4df4520f3813df159c64f&req=cCIgE8t2m4ETWLcX3D%2B5hg838J140UXj0Lf7AMhNKpKXp5QAMsmbbodpKlm1%0ATKew79T%2FAbdTRO%2F4%0A) Click **Submit** to run the data segmentation job. [![](https://downloads.intercomcdn.com/i/o/42753036/8d7cf5b98390d3d0d5fa3c5a/WCA_08.png?expires=1749734100&signature=13ac9fe318bf503a6a9a096f921a5b685c9b7458e64f16fd152624fd4035496a&req=cCIgE8p%2BnocTWLcX3D%2B5hi7qqCC0b4uBOPbYvKcZWGkitFW3ymHOplKkxeVX%0AifZChv9zz02RL1pZ%0A)](https://downloads.intercomcdn.com/i/o/42753036/8d7cf5b98390d3d0d5fa3c5a/WCA_08.png?expires=1749734100&signature=13ac9fe318bf503a6a9a096f921a5b685c9b7458e64f16fd152624fd4035496a&req=cCIgE8p%2BnocTWLcX3D%2B5hi7qqCC0b4uBOPbYvKcZWGkitFW3ymHOplKkxeVX%0AifZChv9zz02RL1pZ%0A) Acoustic should then confirm the job has been submitted. [![](https://downloads.intercomcdn.com/i/o/42753640/508b59ae4fed26df9c288d78/WCA_09.png?expires=1749734100&signature=f9c3062dc46fe18a8043899c82cf9e14823b7ec0ad194cfd4a0bffbde4f35d4b&req=cCIgE8p4mYETWLcX3D%2B5huzU1VA1ZXgDOa2vuzTgtAWN50kpOypEso%2ByBRbD%0A4ha80Lg2hEYwBx7V%0A)](https://downloads.intercomcdn.com/i/o/42753640/508b59ae4fed26df9c288d78/WCA_09.png?expires=1749734100&signature=f9c3062dc46fe18a8043899c82cf9e14823b7ec0ad194cfd4a0bffbde4f35d4b&req=cCIgE8p4mYETWLcX3D%2B5huzU1VA1ZXgDOa2vuzTgtAWN50kpOypEso%2ByBRbD%0A4ha80Lg2hEYwBx7V%0A) ### Creating queries To use the segmentation you created in your Jacquard experiments, you now need to create queries to select audience members based on your segmentation field. Go to **Queries** in Acoustic. [![](https://downloads.intercomcdn.com/i/o/42754329/3c015ae619d5273317595163/WCA_10.png?expires=1749734100&signature=22534b88e355aa518217ab8ee1ead810500ee42411f982dd65ed0bdca35ac713&req=cCIgE819n4gTWLcX3D%2B5hlo%2Bwd2bqHbLhQC3j%2BjUCGS4NFWFpCPgNxNijby4%0AxAwxrbm2aEjwsQUO%0A)](https://downloads.intercomcdn.com/i/o/42754329/3c015ae619d5273317595163/WCA_10.png?expires=1749734100&signature=22534b88e355aa518217ab8ee1ead810500ee42411f982dd65ed0bdca35ac713&req=cCIgE819n4gTWLcX3D%2B5hlo%2Bwd2bqHbLhQC3j%2BjUCGS4NFWFpCPgNxNijby4%0AxAwxrbm2aEjwsQUO%0A) Select **Create Query**. [![](https://downloads.intercomcdn.com/i/o/42754498/3ff20afa32e920ad1512f535/WCA_11.png?expires=1749734100&signature=ef7f6947f6035e619065f352f2301ba82b2bd43e3f4039d363377f07898c3f91&req=cCIgE816lIkTWLcX3D%2B5hojor6WSGWOWvyaxVH%2FmCsjCVaDwzPVsgD%2BB3%2BaJ%0Arf65lP3KG0FpID5P%0A)](https://downloads.intercomcdn.com/i/o/42754498/3ff20afa32e920ad1512f535/WCA_11.png?expires=1749734100&signature=ef7f6947f6035e619065f352f2301ba82b2bd43e3f4039d363377f07898c3f91&req=cCIgE816lIkTWLcX3D%2B5hojor6WSGWOWvyaxVH%2FmCsjCVaDwzPVsgD%2BB3%2BaJ%0Arf65lP3KG0FpID5P%0A) Complete the **Save Query As** form by: - Selecting the **Master Database** where you created the split number field - Giving the Query a meaningful name and including the appropriate split number at the end to help you keep track - Selecting the location as **Shared** and the type as **Query** [![](https://downloads.intercomcdn.com/i/o/42754883/0fd9a2e114f2df4c401576d8/WCA_12.png?expires=1749734100&signature=0a8bb9eb6bf24b56e80fa26792123d528569152a028a1c3c191ffb0e987baafe&req=cCIgE812lYITWLcX3D%2B5htYUvpM4ild%2BN2n0Dphn9vuJPJxxoPGGb4lEL9TD%0AO3GdPrimTnns9tYA%0A)](https://downloads.intercomcdn.com/i/o/42754883/0fd9a2e114f2df4c401576d8/WCA_12.png?expires=1749734100&signature=0a8bb9eb6bf24b56e80fa26792123d528569152a028a1c3c191ffb0e987baafe&req=cCIgE812lYITWLcX3D%2B5htYUvpM4ild%2BN2n0Dphn9vuJPJxxoPGGb4lEL9TD%0AO3GdPrimTnns9tYA%0A) In the query creation form select **Profile > Data field** under **Add Criteria**. [![](https://downloads.intercomcdn.com/i/o/42754995/bb92b0a0c87b023b8c5dfff6/WCA_13.png?expires=1749734100&signature=e68fb450b5127b26f90576af1496984d33165c8fa1769a7d64cbc0a419a9f339&req=cCIgE813lIQTWLcX3D%2B5huASexrs0mD7of0jBD8fSWJmw745dNvjRrW3ckz2%0Ab78UwOrAYPC4x%2BEn%0A)](https://downloads.intercomcdn.com/i/o/42754995/bb92b0a0c87b023b8c5dfff6/WCA_13.png?expires=1749734100&signature=e68fb450b5127b26f90576af1496984d33165c8fa1769a7d64cbc0a419a9f339&req=cCIgE813lIQTWLcX3D%2B5huASexrs0mD7of0jBD8fSWJmw745dNvjRrW3ckz2%0Ab78UwOrAYPC4x%2BEn%0A) In the **Data Field** selection, find the **Split Number** field you created earlier. [![](https://downloads.intercomcdn.com/i/o/42755527/ede26347cfacf93a8676e8be/WCA_14.png?expires=1749734100&signature=2571338064df9626aefc991609189f76345d0b4e3234b208b223db5cdf937e55&req=cCIgE8x7n4YTWLcX3D%2B5hmAzgUPhota3D4EVKbmwJdhP3nJC0GeEaTo8tT4f%0AsGjccdNajlXZMi8%2B%0A)](https://downloads.intercomcdn.com/i/o/42755527/ede26347cfacf93a8676e8be/WCA_14.png?expires=1749734100&signature=2571338064df9626aefc991609189f76345d0b4e3234b208b223db5cdf937e55&req=cCIgE8x7n4YTWLcX3D%2B5hmAzgUPhota3D4EVKbmwJdhP3nJC0GeEaTo8tT4f%0AsGjccdNajlXZMi8%2B%0A) Fill in the Operator Field as **is equal to** and then enter the value that corresponds to the Query being created (e.g. 1, 2, 3, 4...10). Then select click **Done**. [![](https://downloads.intercomcdn.com/i/o/42755645/f89578e92062d45db42dec77/WCA_15.png?expires=1749734100&signature=75e0d6386fb0fddca14dc3db4a08b58e0bba6acb30c683cab1b7383a185480a4&req=cCIgE8x4mYQTWLcX3D%2B5hlESit0ud%2FoseV7VI%2FOLF2rG%2BsXT3vv4KqmSB9L8%0AREwOcFpBFRJlmLdu%0A)](https://downloads.intercomcdn.com/i/o/42755645/f89578e92062d45db42dec77/WCA_15.png?expires=1749734100&signature=75e0d6386fb0fddca14dc3db4a08b58e0bba6acb30c683cab1b7383a185480a4&req=cCIgE8x4mYQTWLcX3D%2B5hlESit0ud%2FoseV7VI%2FOLF2rG%2BsXT3vv4KqmSB9L8%0AREwOcFpBFRJlmLdu%0A) You should have the following setting for the query which you can then **Save & Close**. [![](https://downloads.intercomcdn.com/i/o/42755785/a9f737fb5ccd3093f5c71f5c/WCA_16.png?expires=1749734100&signature=40e789b49177e294cd8f931c926cf9c6aa0db678c356cf9287e3507efb9b37ce&req=cCIgE8x5lYQTWLcX3D%2B5hhKMRS%2FDHyFcf1ovVEwzIasIJRTan4kkk0epxwom%0AUzyfSVSJmGKRrVa%2B%0A)](https://downloads.intercomcdn.com/i/o/42755785/a9f737fb5ccd3093f5c71f5c/WCA_16.png?expires=1749734100&signature=40e789b49177e294cd8f931c926cf9c6aa0db678c356cf9287e3507efb9b37ce&req=cCIgE8x5lYQTWLcX3D%2B5hhKMRS%2FDHyFcf1ovVEwzIasIJRTan4kkk0epxwom%0AUzyfSVSJmGKRrVa%2B%0A)[![](https://downloads.intercomcdn.com/i/o/42755892/f55a58a91be389bced1486a2/WCA_17.png?expires=1749734100&signature=ca35994df04f40a4076266f28106b294ff4b63e39b616d1daee02bac345d7c9d&req=cCIgE8x2lIMTWLcX3D%2B5hliHSnhc1FDF6GfQjOHSaDrkZ0lC%2FIuyp4vS4Tpd%0Ajr1vgFYDXDaRvnz1%0A)](https://downloads.intercomcdn.com/i/o/42755892/f55a58a91be389bced1486a2/WCA_17.png?expires=1749734100&signature=ca35994df04f40a4076266f28106b294ff4b63e39b616d1daee02bac345d7c9d&req=cCIgE8x2lIMTWLcX3D%2B5hliHSnhc1FDF6GfQjOHSaDrkZ0lC%2FIuyp4vS4Tpd%0Ajr1vgFYDXDaRvnz1%0A) Complete the query creation for all of your remaining splits by repeating the steps above. When you're finished, you should have a query for each split number one through 10 (or for whichever number of splits your Jacquard Customer Success Manager suggested). Finally, create the final send query. [![](https://downloads.intercomcdn.com/i/o/42756052/746be71f194de0cb163f7b7b/WCA_18.png?expires=1749734100&signature=0f4d6cdfc6a7e2970faad6d0b69d7667397bed79e13b4c9714fed76e5c729f13&req=cCIgE89%2BmIMTWLcX3D%2B5hrbby3v%2B8FEN%2B2Jl2HJ90Om5GLBC8O8WpzTki6Qu%0AbSZT4rWiGhh4se0B%0A)](https://downloads.intercomcdn.com/i/o/42756052/746be71f194de0cb163f7b7b/WCA_18.png?expires=1749734100&signature=0f4d6cdfc6a7e2970faad6d0b69d7667397bed79e13b4c9714fed76e5c729f13&req=cCIgE89%2BmIMTWLcX3D%2B5hrbby3v%2B8FEN%2B2Jl2HJ90Om5GLBC8O8WpzTki6Qu%0AbSZT4rWiGhh4se0B%0A) For this final query, give it a different name like **Jacquard_Final** and use the Operator **is blank**. [![](https://downloads.intercomcdn.com/i/o/42756182/8b7b58de3dbb15726e419476/WCA_19.png?expires=1749734100&signature=ebf2b4a3fde321f23a1ae01abd9a9eca63c0aee088535bc8b59fb4f788c59127&req=cCIgE89%2FlYMTWLcX3D%2B5htyzKKksEYnJMzcQ68myM8uyo%2FngpFS2ugWmD%2BVq%0AB40QLXd7%2Fd%2FPfnzu%0A)](https://downloads.intercomcdn.com/i/o/42756182/8b7b58de3dbb15726e419476/WCA_19.png?expires=1749734100&signature=ebf2b4a3fde321f23a1ae01abd9a9eca63c0aee088535bc8b59fb4f788c59127&req=cCIgE89%2FlYMTWLcX3D%2B5htyzKKksEYnJMzcQ68myM8uyo%2FngpFS2ugWmD%2BVq%0AB40QLXd7%2Fd%2FPfnzu%0A) The final send query settings should look like the below before clicking **Save & Close**. [![](https://downloads.intercomcdn.com/i/o/42756344/1dfe159745f9a7a2498ec065/WCA_20.png?expires=1749734100&signature=1516b0cd1b3b51c138c88a8b51a20c46dcd9699bf1e3943b8d6619dce6e52858&req=cCIgE899mYUTWLcX3D%2B5hiWrQlGZgqT6eKG3L%2BO2kXi9Vs9Q4yIYiIIznNkk%0A3jwxEdVlIETAe6aG%0A)](https://downloads.intercomcdn.com/i/o/42756344/1dfe159745f9a7a2498ec065/WCA_20.png?expires=1749734100&signature=1516b0cd1b3b51c138c88a8b51a20c46dcd9699bf1e3943b8d6619dce6e52858&req=cCIgE899mYUTWLcX3D%2B5hiWrQlGZgqT6eKG3L%2BO2kXi9Vs9Q4yIYiIIznNkk%0A3jwxEdVlIETAe6aG%0A) ### Getting the Query IDs Once all the queries have been created, you need to record the query IDs to send to Jacquard to include in your integration setup. You can do this by hovering over the query name and recording the query ID that pops up in the tooltip. If you click on the query, you can also find the ID in the address bar of your browser. Record the query ID for each split test (e.g. Jacquard_Split_1 = 555621) and be sure to include the final send query, too. [![](https://downloads.intercomcdn.com/i/o/42756520/74d82401bbf695f3c6818cb0/WCA_21.png?expires=1749734100&signature=547f6e7fcc339c6272cddbd3fb8341137abe2a890d0086ac588bb866b20fa51e&req=cCIgE897n4ETWLcX3D%2B5hgzzSATMmhgZYr427j6bmmEBjAQIO5bnbcH6ssIR%0AaEse%2FDn5%2F3VBjuhA%0A)](https://downloads.intercomcdn.com/i/o/42756520/74d82401bbf695f3c6818cb0/WCA_21.png?expires=1749734100&signature=547f6e7fcc339c6272cddbd3fb8341137abe2a890d0086ac588bb866b20fa51e&req=cCIgE897n4ETWLcX3D%2B5hgzzSATMmhgZYr427j6bmmEBjAQIO5bnbcH6ssIR%0AaEse%2FDn5%2F3VBjuhA%0A)[![](https://downloads.intercomcdn.com/i/o/42756628/fddb4ad15593689b9abbc1da/WCA_22.png?expires=1749734100&signature=bd6bbaaf47dec30b30735792e737086448e85f345b9d07b489ac0be6752798bb&req=cCIgE894n4kTWLcX3D%2B5huphlfJ6Mgawg5rFg%2FMoMSKYMtOF%2Fux%2BBPOE2vXR%0AD09jGGckamb%2FBrWf%0A)](https://downloads.intercomcdn.com/i/o/42756628/fddb4ad15593689b9abbc1da/WCA_22.png?expires=1749734100&signature=bd6bbaaf47dec30b30735792e737086448e85f345b9d07b489ac0be6752798bb&req=cCIgE894n4kTWLcX3D%2B5huphlfJ6Mgawg5rFg%2FMoMSKYMtOF%2Fux%2BBPOE2vXR%0AD09jGGckamb%2FBrWf%0A) Before each send, you will need to follow the procedure for Segmenting your database up until the data job has been submitted to properly randomise your audiences.