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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Want to use a segment as a dynamic dimension

richardthurman00
Level 1
Level 1

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.

1 Accepted Solution
ishans52004352
Correct answer by
Employee
Employee

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!

View solution in original post

7 Replies
ishans52004352
Correct answer by
Employee
Employee

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!

View solution in original post

richardthurman00
Level 1
Level 1
Thank you for your answer. Your reply made me realize a vital piece of information I left out of my original post (which I have now edited). We cannot assign a variable (prop or eVar) at this time to capture the market, so classifications will not be a viable solution. This is something we must derive within Workspace without requiring implementation changes.
ishans52004352
Employee
Employee

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.

 

kainth
Level 5
Level 5

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

PratheepArunRaj
Moderator
Moderator

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.

Gigazelle
Employee
Employee

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.

jantzen_belliston-Adobe
Community Manager
Community Manager
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?