If a query returns 0 results while the associated campaign appears to contain data — for example, 2,000 contacts — the issue is usually a mismatch between the query criteria and the underlying data structure in your relational table.

What causes this

When a query is created against a relational table with specific criteria (such as filtering by an SID Campaign), it will only return contacts that meet all defined conditions. The most common cause is that the relational table being queried does not contain any contacts that match the entry criteria, even though the campaign itself appears to have data.

This can happen when:

• Contacts have not been properly synced from the CRM system (such as Salesforce) into the relational table
• The campaign ID reference used in the query does not match the values stored in the relational table

How to fix it

1. Open the relational table directly using the data browser and verify that it contains data.
2. Confirm that contacts exist in the relational table with the specific field values used in your query criteria — for example, the campaign ID you are filtering by.
3. Check with your team to determine whether there have been any recent changes to the CRM-to-Acoustic data integration that may have affected the sync.
4. If the relational table appears empty or does not contain matching records, contact Acoustic Support to investigate potential data sync or integration issues.