July 21, 2014

Last contact SQL query for GoldMine users

Here is a SQL Query to be used to find out which Customers have not been contacted within the past # of days.
Copy paste this Query into the GoldMine SQL Query tab and change the 90 to whatever number you would like it to be.
ALSO, you will need to change the Contact1.Key2 field to be the same field in your database that contains the value "Customer".
__________________________________________________________________________
select contact1.company, contact1.contact, contact2.lastconton, contact2.lastcontat from contact1,contact2 where contact1.accountno = contact2.accountno and contact2.lastconton < (GETDATE()- 90) and contact1.key2 like '%Customer%' order by contact2.lastconton
__________________________________________________________________________

Leave a Reply

Your email address will not be published. Required fields are marked *

CSH Consulting is dedicated to glorifying God in all aspects of business through honesty and integrity.

Mailing Address
2253 W. Springfield Road
Glen Rock, PA 17327

Phone: (717) 235-4297

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram