Classic queries and new queries have different limitations.
Criteria limitations
- Queries have a variable maximum of query criteria. However, there is a technical hard limit of 32,000 SQL characters. On average, each criteria can generate 500-1,000 characters of SQL. In general, the range of query criteria could be 30-150 query criteria.
- Classic queries are limited to a maximum number of 100 criteria.
Can you do a search for a specific contact within all databases?
Acoustic Campaign is designed to provide database-specific information only. The user interface provides data on a specific contact for a particular database. A general search that includes all databases is not supported.
Merging values within data fields
Currently, it is not possible to merge values within data fields in Acoustic Campaign. However, you can export the CSV file and correct the fields in Excel.
Then, by using formulas such as "CONCATENATE", you can merge data and represent the newly created column with the merged data.
Finally, you can perform an import/update for that database in order to input the new values.
Web form queries
Currently, you can only query behaviors on standard and progressive web forms. Submission of Forward to a Friend and Opt out web forms is not currently supported.
Can you move snoozed contacts from one database to another and keep them in snoozed mode?
While you can export your snoozed contacts from one database and import them into a new database, the 'newly imported' snoozed contacts are not in snoozed status in the new Database.
However, there is work around after the import you can use the API call UpdateRecipient
to snooze contacts.
<Envelope>
<Body>
<UpdateRecipient>
<LIST_ID>4334819</LIST_ID>
<CREATED_FROM>2</CREATED_FROM>
<OLD_EMAIL>test@yahoo.co.uk</OLD_EMAIL>
<COLUMN>
<NAME>EMAIL</NAME>
<VALUE>test@yahoo.co.uk</VALUE>
</COLUMN>
<SNOOZE_SETTINGS>
<SNOOZED>true</SNOOZED>
<RESUME_SEND_DATE>12/15/2015</RESUME_SEND_DATE>
</SNOOZE_SETTINGS>
</UpdateRecipient>
</Body>
</Envelope>
Or alternatively, you can create a web form to snooze contacts.
Programs
If you are unable to select a query as a contact source for a program, it is due to one the following:
- The query is a classic query.
- The query contains Universal behavior criteria.
- The query contains 'is in query' criteria.
Currently, none of these types of queries are available for program entrance criteria. If your query does not contain universal behaviors, does not contain 'is in query' statements, and is not a classic query, contact Support for assistance.