How to create a search that returns trial customers who do not have a purchased license

If you want to target emails to trial customers who do not have a purchased license, you can create a search that excludes customers with a permanent or subscription license.

  • Launch the QLM Management Console

  • Go to the Manage Keys tab

  • Click Search and then Edit Searches

  • Click Add to add a new search

  • Set a name to: Trials that expired in last 30 days

  • Set the SQL fied to: licenseModel='trial' and Email Not In (Select Email from qryLicenseInfo where licensemodel<>'trial' and Email is not NULL) and SubscriptionExpiryDate > [today_start-30] and SubscriptionExpiryDate < [today_start] and IncludeInMailList <> 0 and Disabled=0

  • Click Ok

Now you can create a scheduled task that uses this search.

Last updated