Question
Reporting on sales person interaction with leads
Hi everyone, I want to be able to report on sales people's activity with a lead - Specifically wether they have updated the lead status (To something other than "Marketing Qualified") within 24 hours of the lead being created.
My current solution (Smart list):
1) Lead was synced with Salesforce in past 24 hours
2) Lead status is set to "Marketing Qualified"
3) Data value (Lead status) not changed in past 24 hours.
I'll then run the report every 24 hours to see the results.
It's not very elegant though. I want to reference the "Not data value changed" timescale to be "Within 24 hours of sync" however this isn't possible.
Does anyone have any ideas how I can accomplish the above report, if the current solution doesn't work?
My current solution (Smart list):
1) Lead was synced with Salesforce in past 24 hours
2) Lead status is set to "Marketing Qualified"
3) Data value (Lead status) not changed in past 24 hours.
I'll then run the report every 24 hours to see the results.
It's not very elegant though. I want to reference the "Not data value changed" timescale to be "Within 24 hours of sync" however this isn't possible.
Does anyone have any ideas how I can accomplish the above report, if the current solution doesn't work?