Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Multiple Dimensions columns in Adobe Workspace

Avatar

Level 5

29-03-2018

It would be great to be able to have multiple dimension columns rather than having the information stacked. Currently whenever you breakdown dimensions it stacks this on a line by line basis which makes it harder to analyse and also looks messy for the end user.

Example below

1453641_pastedImage_0.png

51 Comments

Avatar

Level 2

05-08-2022

Yep, same here. The only way you can get around it is if you put browser type in one evar and then have browser type and browser in another separate evar.  Or for the customer wanting products.... product names in one evar and then have product name and product number concatenated in another evar. 

evar1 =  browser type

evar2 = browsertype-_-browser

 

Or

 

evar1 = product name

evar2 = product name-_-product number. 

 

This would be the equivalent of what I had to do for campaigns with multiple parameters. You have to make each one it's own parameter and then stuff multiple parameters into individual evars so that you can see it however you need to see it on a multiple dimension level (rows) without breakdowns.

 

An old coremetrics example:  cm_mmc=vendor-_-category-_-placement-_-item

evar1=vendor

evar2=vendor-_-category

evar3=vendor-_-category-_-placement

evar4=vendor-_-category-_-placement-_-item

 

Reports dimensional rows come out like the above, example:

evar2 report would be  GooglePLAs-_-Dresses

evar3 would look like GooglePLAs-_-Dresses-_-ShortDresses

 

Using filters you might have one report with multiple vendors and when you download any of the reports you can use excel "text to column" to break it apart using "-" as the delimiter. Then sort however you need. 

 

But this is all a pain we should not have to endure. Adobe should have the ability to display a minimum of three dimensions on one row in flat file without having to download a breakdown of hierarchy data.