Want to use a segment as a dynamic dimension

Avatar

Avatar
Give Back
Level 1
richardthurman00
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Give Back
View profile

Avatar
Give Back
Level 1
richardthurman00
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Give Back
View profile
richardthurman00
Level 1

15-07-2020

I have 20 "markets" I want to report on as a dimension.  A "market" is a derived value when looking at several components of a hit.  For example, if the user's Geo Country=France, they go into the market value of France.  If they are visiting our site's French domain (site.fr), then they go into the market value of France.  Lastly, they could potentially have a subscription to one of our services with the preferred language set to French, and we also want to track them in the market value of France.

 

I know how to create an individual segment to capture all of this for France.  But we also have 19 other "market" combinations to track.  If I want to display a table in Analytics Workspace with the "market" as the 1st column, I would have to individually build all 20 segments, and then manually stack them into the panel.  (sample image attached)  Is there any way to build a dynamic segment using the logical operators in calculated metrics that could be a workaround for this? 

 

image (6).png

 

I thought about trying to calculate a Market ID as a number, but there's still no way to do a VLOOKUP or similar to get the named value of the Market into Workspace.

 

Is this a dead end?  I'm sure there's a more eloquent way to phrase this question, but I hope you get the idea of what I'm trying to accomplish. 

 

*NOTE* - this is a proof of concept only at this time.  We are very tight on our allotment of variables, so I cannot dedicate an eVar or prop to try and capture the market for reporting.  This needs to be a workspace solution that does not require implementation changes.  Because of this, classifications will not work as a solution.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

328 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

328 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

15-07-2020

Hi @richardthurman00 ,

Did you get a chance to check Classifications and see if that would help in achieving your objective? You can have Market ID and then classify those IDs into different values respectively to get it in the report. With that you can fetch the Classification report in Workspace to see all the line items.

Please see if that suits your requirement: https://docs.adobe.com/content/help/en/analytics/components/classifications/c-classifications.html.

Thanks!

Answers (4)

Answers (4)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

15-07-2020

Dear Richard,

There are only two ways.

1. Classification (Importer or Rule Builder): If you have any dimension which captures the Market ID, then you can use Classification Importer or Rule Builder to create a line Item with a proper name. But a single separate dimension is needed!

2. Segmentation: If you are about to create a line item using multiple dimensions like Geo, Domain, Language, etc., as you said below, the only way is to stack the segmentations.

Do not think there are any other options available right now.

Thank You, Arun.

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

15-07-2020

The way I see it, using segments as dimensions would be your best bet. You can then apply any number of metrics to your freeform table, and even save copies of the project if you need different reports on all those markets. Once you've created the 20 segments and dragged them onto the table, you should be good to go.

Avatar

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile
kainth
Level 4

15-07-2020

Hi @richardthurman00 ,

Based on my understanding, I don't think to populate the segments dynamically just like other dimensions. So, the only I think of if to manually stack the segments in the freeform table.

Best,

Abhinav

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

328 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

328 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

15-07-2020

Thanks for clarifying, @richardthurman00 .

In that case, we will need to use multiple segments as you have mentioned in the description. I'll keep on thinking about it and let you know in case I come across any other solution.