Track the change of a dimension in Adobe Analytics

Avatar

Avatar

danielf16493531

Avatar

danielf16493531

danielf16493531

07-08-2019

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

486

Correct Answer

252

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

486

Correct Answer

252
ursboller
MVP

19-08-2019

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).

Answers (7)

Answers (7)

Avatar

Avatar

Asheesh_P

MVP

Avatar

Asheesh_P

MVP

Asheesh_P
MVP

11-08-2019

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

Avatar

danielf16493531

Avatar

danielf16493531

danielf16493531

20-08-2019

Hi ursboller,

now this looks very good:

1818239_pastedImage_0.png

Thanks for all the help, everyone!

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

486

Correct Answer

252

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

486

Correct Answer

252
ursboller
MVP

20-08-2019

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

Avatar

danielf16493531

Avatar

danielf16493531

danielf16493531

19-08-2019

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

Avatar

danielf16493531

Avatar

danielf16493531

danielf16493531

18-08-2019

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

Avatar

Asheesh_P

MVP

Avatar

Asheesh_P

MVP

Asheesh_P
MVP

11-08-2019

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

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

486

Correct Answer

252

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

486

Correct Answer

252
ursboller
MVP

11-08-2019

Hi asheep. great solution!

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