SOLVED

Lead Scoring Report

Go to solution
michellechopin
Level 7 - Community Advisor

Lead Scoring Report

Hi Community,

 

Reaching out for your help as always! I am looking to create a Lead Scoring report and found this awesome thread that shared how to do so without having Advance Reporting. I've followed all the steps but the report isn't showing the information how I'd expect.

 

Here's my process:

  • Created three Smart Lists to collect leads with scores of 1-19, 20-39, and 40+ for the last month (MQL is 40). Here are the filters for the 40+ grouping as an example

MichelleK_5-1611797520823.png

  • Set up a Person Performance Report (assuming this is what the OP meant by Lead Report) with my Smart Lists

MichelleK_0-1611796625617.png

  • Adjusted the Report setup as follows.
    Note: I've gone with The Person Created At = All Time as I want to know, overall, which leads fell into each score group last month (if I change it to = Last Month, it will ignore leads created before that):

MichelleK_2-1611796793519.png

 

The report looks like this (I adjusted the Grouping to be by the hundreds so it fit the screenshot - results are the same):

MichelleK_4-1611797084578.png

There are 2800+ leads in the first smart list, 770 in the second, and 1500+ in the third so I'm unsure why all those columns say zero (also impressed that someone has managed to amass an enormous score - likely a tester!).

 

What am I missing here? Is this the wrong report? Am I pulling in the wrong data? Is this whole process wrong?

 

Any insight is much appreciated, and if there's any other information I can provide, please let me know.

TIA!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Michael_Florin
Level 10

Re: Lead Scoring Report

I don't see an obvious error in your setup. It's the correct report type, and everything looks more or less okay to me.

Couple of thoughts:

 

You don't need to - or probably should not - use your three Custom Columns Smart Lists in the Smart List section for your report. It might slow it down due to Smart List nesting. Just use the filter "Score was changed between 1 and 100 in past 30 days" here. That will also remove your outlier with the thousands of points.

 

Secondly, name your Custom Column Smart List in a way so they can specifically function as a column heads. Like "1-19", "20-39" and so on. As short as possible - will make your report more readable.


And I don't think grouping by the same category that is already expressed in your Custom Columns is a good idea. The Custom Columns represent your grouping. (I wish we could remove grouping altogether.)

 

Here's the same report you built from our instance:

Michael_Florin_0-1611827947422.png

 

Grouping by "Created Date" is also not ideal, but again: I don't see any reason why your report wouldn't work. Have you refreshed it? 😉

 

 

View solution in original post

4 REPLIES 4
Michael_Florin
Level 10

Re: Lead Scoring Report

I don't see an obvious error in your setup. It's the correct report type, and everything looks more or less okay to me.

Couple of thoughts:

 

You don't need to - or probably should not - use your three Custom Columns Smart Lists in the Smart List section for your report. It might slow it down due to Smart List nesting. Just use the filter "Score was changed between 1 and 100 in past 30 days" here. That will also remove your outlier with the thousands of points.

 

Secondly, name your Custom Column Smart List in a way so they can specifically function as a column heads. Like "1-19", "20-39" and so on. As short as possible - will make your report more readable.


And I don't think grouping by the same category that is already expressed in your Custom Columns is a good idea. The Custom Columns represent your grouping. (I wish we could remove grouping altogether.)

 

Here's the same report you built from our instance:

Michael_Florin_0-1611827947422.png

 

Grouping by "Created Date" is also not ideal, but again: I don't see any reason why your report wouldn't work. Have you refreshed it? 😉

 

 

michellechopin
Level 7 - Community Advisor

Re: Lead Scoring Report

Hey @Michael_Florin,

 

Thank you so much for your help! I wonder if it was the use of the individual Smart Lists as the Smart List for this report that was causing confusion because as soon as I removed that (and before I did anything else), the report looked far more like your example.

 

I've made a few adjustments:

  • Person Created = Last 12 Months
  • Group People = Months 
  • Adjusted my Smart Lists to be titled with just the scoring brackets (named these to stand out from other lists in our instance but these are simple enough to find!)

And my report looks as follows:

MichelleK_0-1611884104992.png

I'll run that by the team and potentially adjust for various elements if needed. Thank you again so much - this was hugely helpful and I'm so glad it wasn't a massive fix either.

 

Much appreciated 😀

Michael_Florin
Level 10

Re: Lead Scoring Report

Great! Glad I could help.

 

One more tip: Create a folder in "Database" for your Custom Column Smart Lists. Now that you see what these reports can do, you'll build dozens more. 🙂 Name that folder "Custom Columns", and tell everybody not to touch these Smart Lists. (If you click their "Used By" tab, Marketo won't show any usage for them, and that might tempt other users to delete them.)

michellechopin
Level 7 - Community Advisor

Re: Lead Scoring Report

Great tip indeed! I am going to set that up now and protect these lists for the future.

 

Thank you so so much 😀