Analysis Workspace Feature Request - Details Table

craigk88031179

10-04-2018

  • In Analysis Workspace, provide a new table type called “Details Table”.  I would think this would be on the level of Freeform Table. 
    • From there dimensions and metrics can only be applied across the top
    • It would treat everything at the Hit level.  Dimensions that are Visitor/People level would align automatically to the left, Visit level would be to the right of Visitor/People and Hit level dimensions and metrics would always be right most.
    • Hits would be sorted and grouped by Visitor, Visit and Hit in chronological order.  There should be some type of shading to show the groupings.
    • Any Visitor or Visit level values would repeat itself for each Hit in their respective Visitor or Visit grouping (note that Data Workbench does not repeat the value for each Hit but I think it should to make it easier to create Pivot Tables after exporting to Excel).
    • Allow up to ten dimensions/metric combinations.  Any dimension or metric could be applied.  It would be great if the Marketing Cloud ID were available since that would be an easy way to show a unique Visitor and might be used to drill down to one Visitor (such as a potential fraud use case).
    • It may make sense to default a timestamp dimension.  Ideally it would show down to the minute but Data Workbench typically only goes to the hour.
    • The table would only show a sampling of the data but users could narrow their applied segment to potentially show non-sampled data.
    • The table could be exported to show more data.
  • Use Cases
    • To troubleshoot suspected tagging issues
    • To explain unusual data.  It is typically always explained when looking at the lowest (Hit) level.
    • To research suspected cybersecurity or fraud Visits and Visitors.  The Cybersecurity team may provide a customer ID, IP address or other identifiable attribute to drill down to a single Visitor.  They want to understand the online traffic pattern of that user to confirm or clear suspected fraud.

DWBDetailsTable.jpg

3 Comments (3 New)
3 Comments

admoseremic

Employee

10-04-2018

Thanks Craig! I've already forwarded the email you sent me previously to the team. The problem you've outlined resonates with me.

craigk88031179

10-04-2018

Great; that sounds good Trevor.  I know Adobe likes feature requests submitted here so I thought it would be an opportunity for me to take a more active role in the forums.

jeff_bloomer

14-11-2019

I like this idea a LOT.  Our fraud and info security departments would probably like a feature like this as well if they knew this were possible.