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