I think that you'll have to be clearer as to exactly what you mean by "...are stamping their leads.
Are the Activities Scheduled, and then they must Complete them?
Do the just Complete an Activity willy nilly?
It is always better if the Schedule & Complete their Activities. You then have the ability to look at the Calendars to see if they are Completing their Activities.
You could look at completed activity using a SQL Query in GoldMine with a variant of this:
select AccountNo,
UserID,
[Bob] =
sum(case UserID
when 'BOB' then 1
when 'DJ' then 0
when 'JAMES' then 0
end),
[James] =
sum(case UserID
when 'BOB' then 0
when 'DJ' then 0
when 'JAMES' then 1
end),
[DJ] =
sum(case UserID
when 'BOB' then 0
when 'DJ' then 1
when 'JAMES' then 0
end)
from ContHist
where UserID in ('BOB','DJ','JAMES')
and OnDate >= '1/1/2011'
and OnDate <= '12/31/2011'
and (ActvCode = 'C1N'
or ActvCode = 'C1*')
group by UserID,
AccountNo
If you are not using the proper process of Scheduling and then Completing activities then I'm at a lose as to how you plan to double check that you staff is following procedures. They could be completing a Call and forgetting to do the Macro. They may not be completing the Call at all and telling you that they had.
If that is good enough for you then great, however, LastModified changes whenever a Contact1/Contact2 field is changed. You might be better off looking at Contact2.CallBackOn and Contact2.LastContOn.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.