Empty Field showing leads in Reports??? | Community
Skip to main content
Tara_Rowe
Tara_Rowe
Level 5
March 17, 2016
Question

Empty Field showing leads in Reports???

  • March 17, 2016
  • 2 replies
  • 2563 views

Looking for some help - I am new to Marketo and trying to figure out some things within our lead database and clean up data errors.

When pulling a lead report I always seem to have a Empty field with leads. As you can see below it shows we have 18 empty leads. Since I am unable to Drill-Down how can we find out who these 18 Leads are and why they are Empty?

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

2 replies

R
rachel2-2
Level 8
March 17, 2016

Can you create a smart list that has only one filter that says Active is empty?

Tara_Rowe
Tara_RoweAuthor
Level 5
March 18, 2016

I tried this smart list and it did not pull out anything...

Robb_Barrett
Robb_Barrett
Level 10
March 17, 2016

There's probably not a default setting, or the field is newer than some of the leads.

For example, let's say you have a binary field. Unless it's set up with to default to YES or NO, it'll stay NULL.

Robb Barrett
Tara_Rowe
Tara_RoweAuthor
Level 5
March 17, 2016

I will look into that, the challenge is the more I dig the more empty leads I find. Yikes!

Josh_Hill13
Josh_Hill13
Level 10
March 17, 2016

This just means that X leads have an Active value of NULL or IS EMPTY.

That's a data quality issue. What is this field used for?

Terms & ConditionsAccessibility statement

Loading footer...