Report showing duration from newly created leads to MQLs | Community
Skip to main content
Kristof-2
Kristof-2
Level 4
March 22, 2024
Solved

Report showing duration from newly created leads to MQLs

  • March 22, 2024
  • 1 reply
  • 1814 views

Hello Community,

is there a way to create a report that will show duration times (or average duration) between the time that the person has entered Marketo database and the time when they reached a certain score threshold (i.e. 60 points) or their status changed to MQL/Marketing Review?

FYI, we are not using Revenue Cycle Modeler, and we are not time stamping the above fields/activities. 

Additionally, it would be great to have these periods/averages segmented - i.e. average duration per vertical / function / position.

Any ideas?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darshil_Shah1

RCE's Model performance report and Marketo Analytics' Success Path Analyzer reports would be a great fit for this; however, since you aren't using RCM in the first place, you'd probably have to slide to exporting Person Score change activities via bulk extract APIs and see the activities where the new score value was greater than the MQL threshold and determine the time duration from when they were created/engaged to MQL. Alternatively, you can also see when the record was stamped as MQL (assuming that you'd have some field where you update the person's current stage as a proxy for the revenue stage, so you know exactly where the person is in their buying journey).

1 reply

Darshil_Shah1
Community Advisor and Adobe Champion
Darshil_Shah1Community Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
March 22, 2024

RCE's Model performance report and Marketo Analytics' Success Path Analyzer reports would be a great fit for this; however, since you aren't using RCM in the first place, you'd probably have to slide to exporting Person Score change activities via bulk extract APIs and see the activities where the new score value was greater than the MQL threshold and determine the time duration from when they were created/engaged to MQL. Alternatively, you can also see when the record was stamped as MQL (assuming that you'd have some field where you update the person's current stage as a proxy for the revenue stage, so you know exactly where the person is in their buying journey).

    Kristof-2
    Kristof-2Author
    Level 4
    March 22, 2024

    Thank you @darshil_shah1 Activity log export was my 1st thought as well.

    I will still explore ways to do this and will share here if I come up with something else ✌️

    Terms & ConditionsAccessibility statement

    Loading footer...