Is it possible to apply transformations to the dimensions in Analysis Workspace?

[Adnan-Sait]

I am using the "Custom Link" dimension in my Workspace. This dimension has the name of the clicked link along with some meta-data.

Large Product-Refrigerator (category-link)

I want to strip the category from the dimension and only show the link name in the visualization (Refrigerator).

Is this possible in the Analysis Workspace tool or any other product?

Thanks & Regards.

[MandyGeorge · Accepted solution]

Yes, this is possible using classifications. A classification can be built using the importer or the rule builder. In this case, you would want to use the rule builder. You can set it up using regex to parse the individual pieces of the link based on a delimiter.

This is some documentation about the classification rule builder.  https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-rulebui...

[yuhuisg]

@Adnan-Sait I second this approach.

[digitron93]

There are 2 Ways to achieve this . Option 1 is a smart approach and more scalable. 2nd way is a bit local solution but worth tyring.

Option 1: Processing Rule Approach

You can use a Processing Rule to create a new dimension that extracts the link name from the Custom Link dimension.

Here's an example of how you can create a Processing Rule to extract the link name:

1. Go to Adobe Analytics Admin and select the report suite that you want to create the Processing Rule for.
2. Click on "Processing Rules" under the "Data Governance" section.
3. Click on the "Create Rule" button.
4. Name the rule something like "Extract Link Name" and choose "Dimension" as the action.
5. Under "Dimension Settings," select the "Custom Link" dimension as the source dimension.
6. In the "Output Dimension" field, enter a name for the new dimension (e.g. "Link Name").
7. In the "Find" field, enter a regular expression to match the link name in the Custom Link dimension. For example, you could use the regular expression (?<=-)[^-]*(?=\s*\().
8. In the "Replace" field, enter the token $0 to keep the matched text.
9. Click "Save" to save the Processing Rule.

This Processing Rule uses a regular expression to match the link name after the dash ("-") and before the opening parenthesis in the Custom Link dimension. For example, if the Custom Link dimension value is "Large Product-Refrigerator (category-link)", the new "Link Name" dimension will have the value "Refrigerator".

Once the Processing Rule is saved and activated, you can use the new "Link Name" dimension in Adobe Analytics Workspace to visualize the link names without the category. You can also use the dimension in segments, dashboards, and other reports.

Option 2: Calculated Metric Approach ( Yes, Calculated Metric, you read that right)

it is possible to extract the link name from the Custom Link dimension and remove the category from it in Adobe Analytics Workspace. You can use a calculated metric to accomplish this.

Here's an example of how you can create a calculated metric to extract the link name:

1. Click on the "Add Metric" button in Workspace and select "Calculated Metric."
2. Name the metric something like "Link Name" and choose "Formula" as the type.
3. In the formula editor, enter the following code: substringAfter(Custom Link, "-")
4. Click "Save" to save the calculated metric.

This formula uses the substringAfter function to extract the link name after the dash ("-") in the Custom Link dimension. For example, if the Custom Link dimension value is "Large Product-Refrigerator (category-link)", the calculated metric will return "Refrigerator".

Once you have created this calculated metric, you can add it to your visualization and remove the original Custom Link dimension from the report.

To do this, select your visualization and click the "Add Metrics" button. Then, select your "Link Name" metric and add it to the report. You can remove the original Custom Link dimension by clicking the gear icon next to the dimension and selecting "Remove."

This will allow you to visualize the link names without the category in Adobe Analytics Workspace.