Hello,
I have a question.
I would like to find out the most common combination for a search form that consists of several values.
Evar20
Evar21
Evar22
Evar23
Evar24
I want a combination of:
Evar20
Evar21
Evar22
Find out.
Color : Evar20 { red,blue, orange, yellow}
Size: Evar21 {10,15,20,25,30,35}
Shape:Evar22 {waffle, cup}
Is there a way to find out with existing data?
Solved! Go to Solution.
Views
Replies
Total Likes
that looks as either a job for excel/raw data or change in the tracking setup...
excel with warehouse export:
export data using data wharehouse where you break down by desired dimensions. this way you would get line items like "red|15|waffle|1" where the last number is your selected metric. use excel to sort by the metric...
change setup:
I would recommend that you weite the values all in one evar (either choose a new one or skip the existing 3 ones), especially if they really belong together (such as filter options).
to get the single dimensions you can still use clasifications (with regex rule builder) to split them apart for reporting. but having the values all in one evar would allow to show the top values directly in reports or workspace.
Views
Replies
Total Likes
that looks as either a job for excel/raw data or change in the tracking setup...
excel with warehouse export:
export data using data wharehouse where you break down by desired dimensions. this way you would get line items like "red|15|waffle|1" where the last number is your selected metric. use excel to sort by the metric...
change setup:
I would recommend that you weite the values all in one evar (either choose a new one or skip the existing 3 ones), especially if they really belong together (such as filter options).
to get the single dimensions you can still use clasifications (with regex rule builder) to split them apart for reporting. but having the values all in one evar would allow to show the top values directly in reports or workspace.
Views
Replies
Total Likes
Hello, Urs,
thank you.
I thought there might be an internal variable that contains all that.
I'll have to create a new variable.
Beste Grüße
Vitali
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies