New release · QAiry 3.1

A major step forward for audience building in SFMC

Smarter AI. More control. Greater automation.

QAiry 3.1 understands your Salesforce Marketing Cloud data model — Data Extensions, fields and the relationships between them — so you can build, refine and automate audiences with AI Chat, a visual builder or SQL.

Book a demo Try QAiry for free
QAiry
Feedback2CG CONSULTING Info

New thread

ChatManual EditSQL
Configuration
1Data context (optional)

Data Model: connected DEs. Data View: sends, opens and clicks. Use either or both. By default, connected DEs are used.

Data ModelData View
Type your prompt here…

Nothing to show yet.
Write your first prompt to generate a Data Extension preview.

My Requests

Type to search…
All Requests
My Requests
Reporting
Data_analytics
Campaign
Production
Archive
DeleteMove
Data ExtensionMy requestRecordsLast run
ClientsOrderedProductTh…Created on 09/05/2026 4:40 PM
By Info		Audience of clients who placed at least one product order in the current calendar year. Returns 1 row per client, keeping the most recent order date…7009/05/2026 4:41 PM⋮
Clients_Purchased_Aug_T…Created on 09/05/2026 12:49 PM
By Info		Audience of clients who made at least one purchase in August of the current year. Returns 1 row per client, keeping the most recent August order if…2009/05/2026 12:51 PM⋮
Audience_RandomTop1Clie…Created on 09/03/2026 11:35 AM
By Info		Creates an audience with 1 randomly selected client. The pick is random each time the query runs.109/03/2026 11:36 AM⋮
ContactsClickedEmailThi…Created on 08/29/2026 12:02 AM
By Info		Audience of subscribers who clicked any tracked email link during the current calendar month. Returns 1 row per subscriber and keeps their most rece…508/29/2026 12:04 AM⋮
OptInEmail_OrderedThisY…Created on 09/15/2026 10:02 AM
By Info		Audience of clients opted in to email who placed at least one order in the current year…3209/15/2026 10:03 AM⋮
Rows per page  10 1–10 of 137‹   ›

ClientsOrderedProductThisYear_952026144023

Production⋮
QAiry Saturday, September 5thRun

Give me the client who ordered a product this year

SQL Query: ▶  Run SQL
SELECT x.Clients_Subscriberkey AS Clients_Subscriberkey, x.Clients_Email AS Clients_Email, x.Orders_Date AS Orders_Date FROM ( SELECT c.Subscriberkey AS Clients_Subscriberkey, c.Email AS Clients_Email, o.[Date] AS Orders_Date, ROW_NUMBER() OVER ( PARTITION BY c.Subscriberkey ORDER BY o.[Date] DESC, o.Id DESC ) AS RowNum FROM Clients c INNER JOIN Orders o ON o.Client_id = c.Subscriberkey INNER JOIN Products p ON p.Product_sku = o.Product_id WHERE o.[Date] >= DATEADD(year, DATEDIFF(year, 0, GETDATE()), 0) ) x WHERE x.RowNum = 1
Configuration
Type your prompt here…

Combine and filter Data Extensions

Build your audience step by step. Changes from Chat and SQL appear here automatically.

✓
Combine dataClients + Orders + Products
✓
Filter your audience OPTIONAL2 rules
✓
Choose output fields3 output fields
✓
Advanced options OPTIONALDeduplicated
Audience nameClientsOrderedProductThisYear_952026144023
Save
SavedRUN
SELECT x.Clients_Subscriberkey AS Clients_Subscriberkey, x.Clients_Email AS Clients_Email, x.Orders_Date AS Orders_Date FROM ( SELECT c.Subscriberkey AS Clients_Subscriberkey, c.Email AS Clients_Email, o.[Date] AS Orders_Date, ROW_NUMBER() OVER ( PARTITION BY c.Subscriberkey ORDER BY o.[Date] DESC, o.Id DESC ) AS RowNum FROM Clients c INNER JOIN Orders o ON o.Client_id = c.Subscriberkey INNER JOIN Products p ON p.Product_sku = o.Product_id WHERE o.[Date] >= DATEADD(year, DATEDIFF(year, 0, GETDATE()), 0) AND o.[Date] < DATEADD(year, DATEDIFF(year, 0, GETDATE()) + 1, 0) ) x WHERE x.RowNum = 1
Unsaved changesRevert to savedVALIDATE  ›
Total Records70
RUN  ›
Clients_SubscriberkeyClients_EmailOrders_Date
0034828fakedata200@fakedata.com2/8/2026 7:47 PM
0119196fakedata3421@fakedata.com8/10/2026 6:54 AM
0149776fakedata9306@fakedata.com1/3/2026 10:59 PM
0193740fakedata557@fakedata.com1/28/2026 1:13 AM
0319194fakedata8448@fakedata.com1/30/2026 10:22 PM
0343121fakedata9277@fakedata.com2/2/2026 10:55 PM
0396578fakedata2954@fakedata.com2/5/2026 8:26 PM
0435313fakedata954@fakedata.com2/2/2026 2:05 AM
0497941fakedata95@fakedata.com1/10/2026 7:09 PM
0520910fakedata9156@fakedata.com8/10/2026 6:40 AM
Rows per page  100 1–70 of 70‹   ›

Last updated 11 days, 16 hours, 59 minutes ago

My Connections

Relationships
Synchronized
Shared Items
Data Extensions
Salesforce Data Extensions
Synchronized Data Extensions
↻  REFRESH
Search by name or descriptionDemo Data ModelAll CLEAR ALL8 data extension
NameDescriptionTags
ClientsClient records used for audience segmentationDemo Data Model⋮
Clients_exclusion_commercial_pressureContains all client records to exclude to avoid over-sol…Demo Data Model⋮
Events—Demo Data Model⋮
Invoices—Demo Data Model⋮
Optin—Demo Data Model⋮
Orders—Demo Data Model⋮
Payments—Demo Data Model⋮
Products—Demo Data Model⋮
Rows per page  25 1–8 of 8‹   ›

My Automations

Type to search…
4 automations · Manage schedules and ordered query stepsREFRESH+  CREATE AUTOMATION
AutomationStatusScheduleLast run
Waterfall_FinalAudienceCreated on 09/01/2026 6:00 AM4 query steps · runs in order1. Base_Audience  2. Enrichment  3. Exclusions  4. Final_AudienceScheduled
Waterfall · QAiry API		Start Date on : 09/02/2026 6:00 AM
Timezone : Brussels, Copenhagen, Madrid, Paris
Repeat : Daily
End : Never		09/17/2026 6:04 AM
MANAGE SCHEDULE		⋮
Clients_20-40yearsold_N…Created on 07/21/2026 12:58 PM1 query step · runs in order1. Clients20to40_Optin_Nike2026_7212026105218Scheduled
QAiry API		Start Date on : 07/22/2026 9:00 AM
Timezone : Indiana (East)
Repeat : Daily
End : Never		09/17/2026 9:00 AM
MANAGE SCHEDULE		⋮
Bounce_unsubscribe_cont…Created on 04/15/2026 5:06 PM1 query step · runs in order1. Bounce_Unsubscribe_Emails_415202615329Scheduled
Automation Studio		Start Date on : 04/16/2026 10:00 AM
Timezone : Central Time (No Daylight Savings)
Repeat : Daily
End : Never		09/17/2026 10:00 AM
MANAGE SCHEDULE		⋮
Test_event_parisCreated on 01/22/2026 3:17 PM1 query step · runs in order1. Clients_Evt_Souscrits_2026_1222026141153Scheduled
Automation Studio		Start Date on : 01/23/2026 3:17 PM
Timezone : Central Time (No Daylight Savings)
Repeat : Daily
End : Never		09/17/2026 3:17 PM
MANAGE SCHEDULE		⋮
Rows per page  10

Click the sidebar, open a request, and switch between Chat · Manual Edit · SQL.

SMARTER CHAT

More accurate AI. Understands your metadata and guides audience building.

MANUAL EDIT + SQL

Build visually or in SQL. Create, connect, filter and refine audiences your way.

AUTOMATION

API + Waterfall. Refresh and chain Data Extensions beyond Automation Studio.

Smarter Chat

Chat got a lot smarter.

More accurate answers. Better understanding of your metadata. Describe your audience in any of 80+ languages and QAiry maps the right fields and joins from your data model.

More accurate responsesQAiry understands your request in the context of your SFMC environment and returns more relevant, reliable answers.
Better metadata understandingData Extensions, fields and relationships are read correctly, so complex SFMC structures become easy to work with.
Smarter guidanceQAiry understands what you're trying to achieve and points you to the right next step as you build and refine.
Connect metadata directly from Chat New in 3.1If QAiry needs a Data Extension that isn't connected yet, search, select and connect it without leaving the conversation.
Your data model

Connect more of your data extensions.

Bring more of your Salesforce Marketing Cloud metadata into QAiry. Names, fields and data types are synchronised, so every audience QAiry creates follows your structure — including naming conventions and field typing.

Data Extensions

Build audiences using the Data Extensions connected to your Business Unit. Sync new DEs as your organisation evolves.

Shared Data Extensions

Bring shared data into your audience logic and work across Business Units with a unified view.

Synchronized Data Extensions New in 3.1

Use synchronized Salesforce CRM data directly in your audience-building workflow.

Salesforce Data Extensions New in 3.1

Connect Salesforce-generated Data Extensions and bring even more CRM data into your audiences.

Relationships
Table viewGraph view
1:1M:N1:N 1:N1:11:N Orders7 Payments1 Invoices3 Clients5 Optin4 Events1
Drag to pan · scroll to zoom · hover a table to isolate it
Relationships New in 3.1

Define how your tables connect. See it in Table View or Graph View.

Tell QAiry how your Data Extensions relate — Clients to Orders, Orders to Payments — and the AI, the builder and your SQL all join your data correctly.

1:1Clients → Optin 1:NClients → Orders 1:NClients → Events M:NOrders ↔ Invoices
More control

One workspace.
Three ways to build.

Chat, Manual Edit and SQL are different entry points into the same audience. Choose the way you prefer to work and keep refining from there.

CHAT

Ask in plain language

Describe the audience and let the AI write the logic. Build first, ask AI later, or combine both whenever you want.

Give me customers who: - purchased in the last 30 days - have a valid Email - are opted-in - exclude bounces and unsubscribes
MANUAL EDIT

Manual Edit is now a builder New in 3.1

Start directly in Manual Edit and design the logic step by step.

1
Select connected DEsChoose the Data Extensions you want to use for your audience.
2
Choose join logicConnect your Data Extensions and define how the data should be joined.
3
Add filtersDefine the conditions your contacts must meet to be included.
4
Apply exclusionsDefine who should be excluded from your audience.
5
Review outputChoose and organize the fields to include in your final audience.
Same QAiry experience. Much more control.Build first. Ask AI later, or combine both whenever you want.
SQL

Prefer SQL? Start there. New in 3.1

Open the SQL tab, write or paste your query, validate it, and keep refining the audience in Manual Edit or Chat.

SELECT c.SubscriberKey, c.Email FROM Clients c INNER JOIN Optin op ON op.Subscriberkey = c.Subscriberkey INNER JOIN Orders o ON o.Client_id = c.Subscriberkey WHERE op.Optin_email = 1 AND YEAR(o.[Date]) = YEAR(GETDATE())
SQL → Manual Edit → Chat  ·  Choose the entry point that matches how you work.
Insights

Cross-check audiences with tracking data.

QAiry leverages SFMC system Data Views — sends, opens, clicks, bounces, unsubscribes — to turn engagement into actionable audiences.

Engaged audience

Subscribers who opened or clicked in the last X days — ideal for re-activation or high-affinity targeting.

Show contacts who clicked at least once in the last 14 days.

Deliverability protection

Exclude recent hard bounces or repeated soft bounces to protect sender reputation.

Exclude subscribers with a bounce in the last 30 days.

Re-engagement

Build inactive segments based on no opens or clicks over a period to run win-back campaigns.

Find subscribers with no opens in the last 90 days.

Field types preserved for reliable activation

QAiry keeps the correct field types so sending, personalisation, SMS and validation work as expected. Email Address and Phone behave differently from generic Text fields.

Email AddressPhoneNumberTextDateBoolean
More control

One workspace.
Three ways to build.

Chat, Manual Edit and SQL are different entry points into the same audience. Choose the way you prefer to work and keep refining from there.

CHAT

Ask in plain language

Describe the audience and let the AI write the logic. Build first, ask AI later, or combine both whenever you want.

Give me customers who: - purchased in the last 30 days - have a valid Email - are opted-in - exclude bounces and unsubscribes
MANUAL EDIT

Manual Edit is now a builder New in 3.1

Start directly in Manual Edit and design the logic step by step.

  1. 1
    Select connected DEsChoose the Data Extensions for your audience.
  2. 2
    Choose join logicDefine how your data should be joined.
  3. 3
    Add filtersConditions contacts must meet to be included.
  4. 4
    Apply exclusionsDefine who should be left out.
  5. 5
    Review outputChoose and organize the final fields.
SQL

Prefer SQL? Start there. New in 3.1

Open the SQL tab, write or paste your query, validate it, and keep refining the audience in Manual Edit or Chat.

SELECT c.SubscriberKey, c.Email FROM Clients c INNER JOIN Optin op ON op.Subscriberkey = c.Subscriberkey INNER JOIN Orders o ON o.Client_id = c.Subscriberkey WHERE op.Optin_email = 1 AND YEAR(o.[Date]) = YEAR(GETDATE())
SQL → Manual Edit → Chat  ·  Choose the entry point that matches how you work.
Insights

Cross-check audiences with tracking data.

QAiry leverages SFMC system Data Views — sends, opens, clicks, bounces, unsubscribes — to turn engagement into actionable audiences.

Engaged audience

Subscribers who opened or clicked in the last X days — ideal for re-activation or high-affinity targeting.

Show contacts who clicked at least once in the last 14 days.

Deliverability protection

Exclude recent hard bounces or repeated soft bounces to protect sender reputation.

Exclude subscribers with a bounce in the last 30 days.

Re-engagement

Build inactive segments based on no opens or clicks over a period to run win-back campaigns.

Find subscribers with no opens in the last 90 days.

Field types preserved for reliable activation

QAiry keeps the correct field types so sending, personalisation, SMS and validation work as expected. Email Address and Phone behave differently from generic Text fields.

Email AddressPhoneNumberTextDateBoolean
Greater automation

Waterfall automation.
Refresh DEs in the right order.

QAiry 3.1 refreshes Data Extensions through the QAiry API, reducing your dependency on Automation Studio. Chain dependent refreshes sequentially — each step starts only when the previous one is complete.

  1. 01
    Base audienceBuild the starting population
    READY
  2. 02
    EnrichmentAdd profile & behavioral data
    AFTER 01
  3. 03
    ExclusionsApply suppression rules
    AFTER 02
  4. 04
    Final audiencePublish the refreshed audience
    AFTER 03
DEPENDENCIES

Refresh only when the previous DE is ready.

SFMC RESILIENCE

Reduce timeout pressure on long refresh chains.

Schedule in minutes API refresh

Time zone aware, hourly or daily recurrence, optional end date. Define the cadence once and QAiry keeps the Data Extension current.

AUTOMATIONAudience_RecentBuyers_Refresh
RECURRENCEDaily · 06:00 Europe/Paris
END DATENone (runs indefinitely)
STATUS● Active
QAiry 3.1 is available now

Build smarter. Connect more. Automate further.

One workspace. Three ways to build.

ChatManual EditSQL
Book a demo Try QAiry for free

Website

HomeProduct demosSecurity & PrivacyPricingBlogContact us

Legal

Privacy PolicyTerms of Service

Copyright @2026