How to do sequential analysis on Adobe raw data

Question

We need to analyse a sequence of events that a user engages in. Use case: number of users who see a banner as the immediate next hit after landing on a page. Page view should be hit x and banner impression should be hit x+1. How can I get this information out on Data warehouse? For us time stamp is not working as multple banners can be shown in the same time stamp, we want to know the exact hit number.

Thanks in advance for any advise. Also, why do we not maintain hit depth as a Dimension in Adobe. Any reasons?

Edit: After trying an iteration with Data feed, realized that the tsv file generated for even a day is huge (close to 3.5 GB), plus the data too is very complicated to process. Much easier with Data warehouse. Hoever, sequential analysis wont be possible on DWH. That will probably be limited to workspace. Personally I do not see any cross platform analysis where hit id will be required. Will use timestamp instead(even though in seconds)

Hemang35 · Accepted Answer

To analyze a sequence of events in Adobe Analytics, you can use sequential segments. However, sequential segments are not available in Data Warehouse. To get this information from Data Warehouse, you can leverage raw data export or Data Feeds

Jennifer_Dungan · Answer

Unfortunately, as @hemang35 pointed out, sequential segments aren't compatible with Data Warehouse...

Hit Depth is a dimension in Adobe, but again, it doesn't appear to be available in the Warehouse...

Have you considered trying to get the information out via the API?

(There is a also raw data feeds, but there is a significant overhead to learning how to process this information which may make this solution out of reach at this time... but it would provide the most flexibility to pull the data)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded