Customer experience | Sales, Customer Insights,...

A field to show number of days a lead has been active

(0) Share

Report

Posted on by Logan W

Hi everyone,

I found there is a timer field on the Lead to Opportunity Sales Process to show how many days a lead has stayed active. Is there an out-of-box field?

Basically, I want to calculate and analyze two things

1) how many days a lead has stayed active

2) once a lead is set to Closed (either qualified or disqualified), the field just shows me the total number of days from the day the lead is created till the day it is closed.

Thanks.

All responses (3)

Answers (0)

Suggested answer

Abdul Wahab 12,085 Moderator on at

Like (0)

Report
RE: A field to show number of days a lead has been active

Hi Logan W,

You can fulfil your requirement with the help of two approaches

Approach # 1: As per my understanding, you need two calculated columns here

End Date & Time (When record status equal to Qualified or Disqualified then et value to Now())

Duration in Days (Something similar to End Date & Time - Created On)

Approach # 2: Use timer control

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../
Suggested answer

Amit Katariya007 10,407 Super User 2025 Season 1 on at

Like (0)

Report

RE: A field to show number of days a lead has been active

Hello Logan W,

Yes we can,

Please refer below article for it.

docs.microsoft.com/.../leadtoopportunitysalesprocess

Thank you,

Amit Katariya
Ray 1,485 on at

Like (0)

Report

RE: A field to show number of days a lead has been active

Hi,

I think the time is a out-of-box field "Duration" and this field is in "Lead To Opportunity Sales Process" entity. You may cosider to use it directly.