I work at a reasonably large e-commerce retailer that's working on doing a lot more with Google Analytics. One of the things we're doing is tagging each individual user that hits our site with a unique ID, and passing it in as a custom dimension to GA. This allows us to get a profile of an individual user, including every traffic source they ever come to our property from, etc. We've hit one snag though.
Imagine a custom report... Dimensions are: Unique ID, Source / Medium, and Date. Metric is hits.
This will show every traffic source that a user's traffic is attributable to, by day. If the user comes in from organic one day, then a referral the next, we'll know about it.
However, the one thing we won't know about is if a user comes from the same source twice in a row. If a user comes from organic twice in a day, we'll just see organic tracked. Ideally, we'd like to know that's two different organic arrivals.
Any ideas on how to tease this out? The end goal is pulling this down into a data warehouse for analysis outside of GA.
(Obviously, I know that this can be done using Multi-Channel Funnels for users that have already made a purchase. But what about those that haven't?)