Not Available in RCE

[Anonymous]

What constitutes “Not Available” in Revenue Cycle Explorer Report? Please see my screenshot below as well as a more thorough explanation as to why I am looking for the answer.

This number has gone up exponentially since the last monthly report that I pulled. From September 15 through October 15, it went up nearly 5,000. In the days, since I pulled it on Monday (10/16/2017) it has gone up nearly 2,000 more. In previous/normal monthly reports the leads in this cell increased by on average by less than 1,000.

This is very odd because the smart list numbers to pull similar data in regards to this are on par with our normal monthly average. Why the huge spike in the RCE report though? Any ideas? I assume that “not available” in the RCE report does not mean the same thing as “is empty” in the smart list. 

[Gerard_Donnell4]

I honestly don't know, I tried to have a look in my RCE but I'm waiting 4 minutes so far and it still hasn't finished loading the welcome screen.  Have you looked at all the different ways that the field gets populated? i.e. Marketo Form, Salesforce, List Upload. Also, if its Marketo forms or SF, are the field types drop downs etc where someone might not select a choice.

If there has been a huge jump in the numbers it could also point to a list upload into Marketo or your CRM.

Thats my 2 cents worth

[Josh_Hill13]

"Not Available"=NULL

If your Account Type field isn't being populated properly, then it's likely an issue with SFDC. BUT, if this report looks at Leads mostly, then the Account Type would be NULL right?

Marketo RCE updates overnight and sees whatever you allow it to see. Are you sure this is the correct Account Type field?

[Anonymous]

I do not use SFDC, so it cannot be anything with that. The problem is that this (REC Report) normally reflects numbers very similar to pulling a smart list looking at these leads. The smart list when I run it looks right on par with normal monthly reports.  I think that perhaps the numbers RCE is not pulling the numbers correctly. We don’t have any forms to speak of that would really affect this either.