Feed Import is successful and shows number of nodes imported but nodes not listed under content
I found the solution. This is what I did for the nodes to be picked and listed under content:
For the importer, Mapping for Node Processor, added a source xpathparser mapped to target GUID and checked Unique target.

Then for XPath XML parser mapped the GUID field to the Node id field in my xml file (for my case the label was Nid)