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.
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 
.png)