---
title: "Querying Variants by Subscriber"
slug: "braze-dynamic-optimisation-querying-variants-by-subscriber"
updated: 2025-07-16T20:20:02Z
published: 2025-07-16T20:20:02Z
canonical: "support.jacquard.com/braze-dynamic-optimisation-querying-variants-by-subscriber"
---
> ## 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.
# Querying Variants by Subscriber
There are two principal steps to ensuring you can access subscriber-level variant assignment information:
1. Ensure Braze records your Jacquard variant against each send record with a small Jacquard code snippet modification
2. Properly querying the send records using Braze's Query Builder
## Code snippet modification
Thanks to the easy-to-modify Connected Content code snippet Jacquard employs to call variants in from our real-time endpoint, we can make a simple change to the code snippet used to call the variants.
This change will instruct Braze to record the variant ID and variant called for each subscriber against the send record. We can then use other Braze fields in a query to call that record and join it with others.
The code snippet you start with for this exercise may vary slightly based on your use case and the type of testing you're conducting with Jacquard, but the structure will look very similar to the following example:
`{% assign phraseeExperimentId = '<campaign_id>' %}`
`{{content_blocks.${CONTENT_BLOCK_NAME}}}{% comment %}{% endcomment %}{% if {{variants.variant_text}} == blank or {{variants.variant_text}} == null %}`
`PASTE YOUR HUMAN CONTROL HERE`
`{% else %}`
`{{variants.variant_text}}`
`{% endif %} `
To instruct Braze to record the variant_id and variant_text against the send record we simply need to add the following two lines of code to the end of code snippet:
{% message_extras :key sl_id :value {{variants.variant_id}} %}
{% message_extras :key sl_text :value {{variants.variant_text}} %}
When that's done, your code snippet will look something like the following:
`{% assign phraseeExperimentId = '<campaign_id>' %}`
`{{content_blocks.${CONTENT_BLOCK_NAME}}}{% comment %}{% endcomment %}{% if {{variants.variant_text}} == blank or {{variants.variant_text}} == null %}`
`PASTE YOUR HUMAN CONTROL HERE`
`{% else %}`
`{{variants.variant_text}}`
`{% endif %} `
`{% message_extras :key sl_id :value {{variants.variant_id}} %}`
`{% message_extras :key sl_text :value {{variants.variant_text}} %}`
With those lines of code added, you can deploy your Braze messages using the same Jacquard sending methods you normally do.
## Querying your data
After your send has deployed from Braze and some engagement data has rolled in, you can query your send in Braze's Query Builder.
You'll want to start with the following query:
```sql
SELECT sends.USER_ID, sends.DISPATCH_ID, sends.MESSAGE_EXTRAS, count(opens.ID) as "OPENS",count(clicks.ID) as "CLICKS",count(unsub.ID) as "UNSUBSCRIBE"
FROM USERS_MESSAGES_EMAIL_SEND_SHARED sends
LEFT JOIN USERS_MESSAGES_EMAIL_OPEN_SHARED opens
ON opens.USER_ID = sends.USER_ID
AND opens.DISPATCH_ID = sends.DISPATCH_ID
LEFT JOIN USERS_MESSAGES_EMAIL_CLICK_SHARED clicks
ON clicks.USER_ID = sends.USER_ID
AND clicks.DISPATCH_ID = sends.DISPATCH_ID
LEFT JOIN USERS_MESSAGES_EMAIL_UNSUBSCRIBE_SHARED unsub
ON unsub.USER_ID = sends.USER_ID
AND unsub.DISPATCH_ID = sends.DISPATCH_ID
WHERE sends.CAMPAIGN_API_ID = '' GROUP BY sends.USER_ID, sends.DISPATCH_ID, sends.MESSAGE_EXTRAS
```
Then, the only thing you'll need to do is locate your campaign's Campaign API Identifier.
You can find this by clicking on the **name of your deployed campaign** in the **Messages** area of Braze.
[](https://downloads.intercomcdn.com/i/o/1117927467/95fae103073002f5fd101630/image.png?expires=1749717900&signature=43313684f0f57771b682ba78032a3d17b83815c4c21283bfa0ae3b5759249a2c&req=dSEmEcB8moVZXvMW1HO4zXqIibN%2BvYWo9m9fU5JvMmsngSsIhEw3vHy63Npe%0A%2BeTqEsTGTfp0F0VH91o%3D%0A)
This will take you to your campaign's details page.
[](https://downloads.intercomcdn.com/i/o/1117929254/4a898cab1171205dc5caef5d/image.png?expires=1749717900&signature=27d8664eff9c2412cc7b37d1bd3ca4116bb0174e20e6af76bc4793c8e236eb36&req=dSEmEcB8lINaXfMW1HO4zX53jJtdQeAg4OLxbsafGzfr%2Ftd9Brsw9vFyWqCy%0AjA0SETIP2pb1JR8ZIqg%3D%0A)
Scroll down until you see the **API Identifier** heading.
Just below that, you'll see a field labelled **Campaign API Identifier**. The string that immediately follows in what you should paste over **** in the query above.
[](https://downloads.intercomcdn.com/i/o/1117933250/23f6579ef50d1e8b684f914a/image.png?expires=1749717900&signature=9a4b79c171a885c180ea21bc785c64d795f321732233052864eddef79386e94f&req=dSEmEcB9noNaWfMW1HO4zaz33L9X85ivVC0Xxi0y7My3LEbv2j6gdMZXBH1e%0AEqgbKkN3z9102MulnJ0%3D%0A)
Once all of that is complete, you can run your query in Query Builder to retrieve the data you seek and export it from there for your external use.
You can find Query Builder under **Analytics > Query Builde**r.
[](https://downloads.intercomcdn.com/i/o/1117934804/f59cc73e0ec80e634bacdaea/image.png?expires=1749717900&signature=c35e06c644f9ab6840be3eb0f9da30d0a2cbb66670f176be8b711e3aaa66204d&req=dSEmEcB9mYlfXfMW1HO4zRn9Im60pWvncjF%2FOGsXtUQ2aSXqC5zpW860xHUV%0AGwMvsLYxM2gpMgyf7sU%3D%0A)
In the Query Builder area, click **Create SQL Query > SQL Editor**.
[](https://downloads.intercomcdn.com/i/o/1117938551/0577b6b37b365319f8507e39/image.png?expires=1749717900&signature=ce5ebf51716be54289946a35e77e14965d1e85e5e8e091d2d0ea7568dd9f3adb&req=dSEmEcB9lYRaWPMW1HO4zcm4AgVh%2FBUcf63IoxUPJWwwZvmZ2QhRFHTFyX8C%0A63NvTGOzYJh43IS1FZ0%3D%0A)
Paste your query with your Campaign API Identifier in place into the text box. Then, click **Run Query**.
[](https://downloads.intercomcdn.com/i/o/1118946905/c3a92994c3af5e4d237530c1/image.png?expires=1749717900&signature=3f5661c6cf50c3e103989854f54f8fa2bb32f6a4ddf5475ffdf4fa6a3fabd1a4&req=dSEmHsB6m4hfXPMW1HO4zWPasMrQoDcilEvT8qQWXQ%2FLHL9yu9PQ9%2B3rbrL1%0A4cS17Ljlaa0nDheaOKE%3D%0A)
From here, you can export your results via CSV using the teal **Export** button.
[](https://downloads.intercomcdn.com/i/o/1118948191/f334de26f23dec63ffc8bb6a/image.png?expires=1749717900&signature=1395d066222590da5ede386ab0c932574476c86569d1ab70eb192967ab7e53ad&req=dSEmHsB6lYBWWPMW1HO4zdXYitpgNun9e1mRb2vMRt2RaDXSIDPtZPoLJHK9%0A%2Flnkv0Fk2zOur8nVdvY%3D%0A)
Once you've confirmed your query works properly, you can name it something unique so you can find it again and reuse it in the future for subsequent sends.
The basic query provided above will pull USER_ID, DISPATCH_ID, VARIANT_ID, VARIANT_TEXT, OPENS, CLICKS, and UNSUBSCRIBES. If you'd like to include any additional fields in the query (e.g. conversions), amend and expand the basic query using the Query Builder tools on the right.
[](https://downloads.intercomcdn.com/i/o/1118961206/098235877115052a3549218c/image.png?expires=1749717900&signature=782b9a00985c9ff59246ca0fe81b949eba8635ec13e412abe13bdc36887dfcb8&req=dSEmHsB4nINfX%2FMW1HO4zdOzN1Jq2GhnsSbAXdVske1mI1YAmlCKI59mG%2FKd%0AHukA5MboQ4cf%2BwsG6I4%3D%0A)
For more information on using Query Builder and the credits required, please see [Braze's documentation](https://www.braze.com/docs/user_guide/data_and_analytics/query_builder).