https://www.softcrylic.com/blogs/adobe-analytics-for-target-a4t-a-look-under-the-hood/
I found this article and found few columns which are useful, however does the click stream have a column for name of expereince instead of the code ?
also I found that for some users tnt_action has two exp id in a hit, any way to clean this up
end objective is to create a dashboard with drop down to select relevant exp and see the results
I don't have Target, but if you are talking about the Analytics Raw Data feeds, I don't believe that Target data is included... however, the data should be available via API calls, as @abhinavpuri mentioned.
To access the Oberon debugger:
In your Workspace, first turn on debugging from the help menu:
This will add a new icon on your freeform tables:
When you click on this, it will have a few options: the data building the Freeform table, or the data building the Sparkline (you will likely want the table data)
Now, you will see one or more timestamps... every time the data refreshes, a timestamp will appear... but some complex tables may actually be built using multiple calls. You will have to click on each timestamp to access a new page that will provide the API calls that were used in multiple formats.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.