So I ran NCOA for the first time in NXT and here are the challenges I ran into... It seems like only some of the time does the address update/ failure reason go onto the address record, so I cannot query on it. Also, the last updated by is NXT Data Health Service but that isn't a real user so again cannot query on that. Lastly the export that I can pull from the Data Health Services only have System Record ID and not import ID or Constituent ID, I cannot build an import query into classic based on System Record ID.

I saw all of this because the NCOA automatic update is close to being good but still has some work to do. I may have to go back to the manual process until these things are fixed.