Avatar

Employee

Hi Craig,

I may be missing some of the details of your challenge, but thought below may be of assistance.

I lead a team of engineer consultants at Adobe that custom process the clickstream data feeds for other Adobe customers.

Typically, we use visid_high & visid_low (post) and bring in visit_num (as a unique key) and add & sort by the hit_time_gmt. This timestamp is set at collection on every web beacon. Reviewing this specific timestamp along with the visit number that is processed during cache based on the virtual cookie table on the Adobe side, should provide what you're looking for. At least, it should give you another reference to view the data another way.

Also, I have a few basic data feed query examples here:

Using Adobe Analytics Data Feeds and SQL for Basic Reporting – The Data Feed Toolbox

And I'll be presenting at Summit in a technical lab if interested:

Become an Adobe Analytics Data Feed Ninja

This may not fully answer your question, but hope this is helpful.

Best,

Matt