Hi Leo, Thank you so much for your time and reply. I found out we need to add filters on exclude_hit, and hit_source also to make accurate counts.  I am wondering have you tried creating the number of "Single Page Visits" using DataFeed? 

,Hi Vani, Thanks for your reply.  based on the query, hit sources (5,7,8,9) are removed from the data, and the exclude_hit is set to 0.  Then visits with just 1 post_pagename are selected. The "Single Page Visits" are not matched with the Workspace. I am wondering if I miss more filters   Query: df_...

I tried a few different methods to calculate Single Page Visit using DataFeed and none of them matched the number in Adobe Workspace, counted visits with exactly one pagename, one page_url, one post_pagename, one post_page_url, one hit, one visit_page_num, similar first and last hit time.   I am won...