Ever wondered where your records are coming from?
Here's a SQL Query that'll show you the number of records created, by their source for 2007. The dates can easily be changed so show whatever date range you'd like. This should work on any SQL based GoldMine system.
select source, count(*) as "#", max(accountno)
from contact1
where createon >= '1/1/2007' and createon <= '12/31/2007'
group by source
order by source
If you're using a dBASE GoldMine, this won't give a summary but will display the information:
select source, company
from contact1
where createon >= '1/1/2007' and createon <= '12/31/2007'
order by source
P.S. Want to learn how to write your own SQL Queries in GoldMine?
Check out http://www.thegmblog.com/sql4gm/
Comments (2)
Good tip, Chad. Since we run dBase, and I know little about writing SQL queries, I run a filter to do a similar task.
I "police" (for lack of a better term) the contact input on a daily basis by running a filter- where "Createby" is equal to 1/8/07-(yesterday's date). I go to each record that is created and make sure the required info is contained. If it is not, I create a next action for that user to input the full data.
Keep up the good work.
Posted by Jon VanNevel | January 9, 2007 9:21 AM
Posted on January 9, 2007 09:21
Chad, The SQL query will work in dBase with a little adjustment:
select source, count(*), max(accountno)
from contact1
where createon >= '1/1/2007' and createon group by source
order by source
That worked fine for me. I just took the alias out.
Posted by Bob Lozinak | January 9, 2007 6:02 PM
Posted on January 9, 2007 18:02