capture aging of MQL | Community
Skip to main content
A
Anonymous
March 6, 2015
Question

capture aging of MQL

  • March 6, 2015
  • 1 reply
  • 1694 views
I would love ot know how people are capturing aging of when a lead goes from one stage to the next without an added BI tool.  Any help is appreciated.
 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Josh_Hill13
Josh_Hill13
Level 10
March 6, 2015
there was a previous thread on this today.

When a lead changes Stages, stamp them with a date: MQL Date Entry and MQL Date Exit. You'll need a formula field to calculate the days between those. These fields should be stamped ONCE and not updated again.
S
Scott_Kendrick
Level 2
June 3, 2015

Is this necessary once you have a revenue cycle model created?  Is there anyway to retro process this if you don't have it set up already?  Specifically I have 6 months of marketo data where I"m being asked to calculate average time from Lead to MQL to SQL.

Chris_Willis1
Adobe Champion
Chris_Willis1Adobe Champion
Adobe Champion
June 3, 2015

It shouldn't be necessary if you have RCE, but using the methods Josh is prescribing can allow you to dig deeper into the data than RCE allows.  You can create a Model Performance Report in RCE to get at this data.  If you're looking for your turnaround time from MQL to SQL, here are the parameters.

To stage includes SQL

Stage includes MQL

Measures:  Average Transition Time & Flow (for quantity)

Row/column:  Stage & To Stage.

Let me know if this helps.

Chris Willis - Fractional GTM Operations Consultant
Terms & ConditionsAccessibility statement

Loading footer...