We have added a Suggested Queries drop down list which will be updated from time to time offering assistance on building popular Fetch Campaigns used by many dealerships. Use this to auto populate the basic criteria needed to run this query, having the option of adding more specific criteria if needed.
Example 1: Emails Collected
Email LIKE @
Every dealership wonders how many email addresses are collected in their database (DMS + DealerMine combined). Â This suggested query will give you the starting point necessary in capturing this data.Â
Example 2: Lost Service Customers
"Last RO Date" < 01/01/2011
This is only a suggested date, and can be changed to any date you feel represents lost business.Â
Example 3: Purchased Here and not back for Service
"Purchase here and back for Service" = No and "Deal Date" >= 01/01/2011
This is suggesting the customer has not returned since taking delivery of their vehicle purchased at your dealership and the Deal Date is greater than January 1/2011. This date is only suggested and can be changed to any date you choose.
Version 5.8 - Released Dec 10, 2015
Source: Contact History   Suggested Query: Unsubscribes
"Contact Type" = UNSUBSCRIBE or reason like unsubscribed
This query will pull back a list for the corresponding store/branch of all customers that have unsubscribed to an email campaign. A user can also add more fields to the Query by clicking on Tools>Configure Fields and then select any Available Field name from the left side of the screen and then use the arrows to move the field to the right side of the screen, when clicking Save the Query will refresh to display the new Fields and corresponding information for that field.
NEW - Version 6.2 – Release June 23, 2016Â
We have added a new Suggested Query "Texting On" to Fetch. When using the Source Customer Vehicles, the Suggested Queries drop down will display "Texting On" when selected, it will display "Texting Contact" = ON and "Cell" IS NOT NULL for the Query and will return all customer that have a Cell phone and are on for Texting.
