Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Track the change of a dimension in Adobe Analytics

Avatar

Level 1

I have following case:


In a input form we're having a city field, which represents the city the user searches something in, Dimension is named city_combo

For Example:

1) User has by default the located city in there, like Madrid

2) User doesn't want to search in Madrid, but in Barcelona, dimension gets set the new value

How can i find out, how many users change the default of the dimension, not based on cities?

I want to have a metric, which represents the # of users who change the default localization, regardless of which city he changes to.

Thanks in advance!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi danielf16493531

I believe the provided solution works perfectly for the desired use case, maybe needs some testing/adjustments regarding the number.

assume you have a single visit where user searches 3 times for "madrid", twice for "barcelona", that would be "2 different values" for the "city_combo". that means if you are looking for users who made 1 change, that would be 2 "distinct count" for the desired value.

I would take the segment provided by asheep​ above and do the following modifications:

1) change to "visit" container

2) change to "equals 2" or "equals 3". there might be cases where the user didn't have a value for "city combo", that means the item has a first value of "undefined". so looking for "distinct count = 3" moght be the right condition for those users in question (unspecified/madrid/barcelone).

View solution in original post

8 Replies

Avatar

Community Advisor

HI Daniel,

All you need to do it, create a distinct count segment with "city_combo" dimension as shown below.

city_combo_segment.jpg

Now use this segment "City Combo Distinct Count >= 2" to create a calculate metrics as shown below..save it.

1811320_pastedImage_3.png

This calculated metrics is ready to use with date on month dimension etc. to see how many users changed default city.

Thanks,

Asheesh

Avatar

Community Advisor

Hi asheep. great solution!

just a small thing: I would change the segment to "visit" container.

Avatar

Community Advisor

Thanks @ursboller, I agree as we are looking for city_combo dimension change in a visit, segment should be change to "visit container".

Avatar

Level 1

Hi Guys,

this can't work - because the city_combo gets fired every time the user searches

He could do 5 searches in Madrid and 3 in Barcelona, but i want the amount the user changed the city - in this case 1.

Avatar

Correct answer by
Community Advisor

Hi danielf16493531

I believe the provided solution works perfectly for the desired use case, maybe needs some testing/adjustments regarding the number.

assume you have a single visit where user searches 3 times for "madrid", twice for "barcelona", that would be "2 different values" for the "city_combo". that means if you are looking for users who made 1 change, that would be 2 "distinct count" for the desired value.

I would take the segment provided by asheep​ above and do the following modifications:

1) change to "visit" container

2) change to "equals 2" or "equals 3". there might be cases where the user didn't have a value for "city combo", that means the item has a first value of "undefined". so looking for "distinct count = 3" moght be the right condition for those users in question (unspecified/madrid/barcelone).

Avatar

Level 1

Hi ursboller,

I worked it out and the numers are telling this:

1817490_pastedImage_1.png

I'd interpret this like "99,9% of the Users are switching their city they want to search in, i don't think this is a valid calculation, by now.

Avatar

Community Advisor

I would turn the condition to "greater than or equal 3" since it looks as "unspecified" is messing up your segment ("unspecified" is counted as a value!)

Avatar

Level 1

Hi ursboller,

now this looks very good:

1818239_pastedImage_0.png

Thanks for all the help, everyone!