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.