The different types of Derived (Client Side) Dimensions and how to setup those in Data Workbench.
Metric Dimension allows you to group metric counts by a specific Level. It also allows you to group metric counts by a specific level. Once, a Metric Dimension is created, you can segment data based on the metric value.
Example 1: You are a Travel Company and you want to understand difference of behavioral activities on the website between your frequent flyers and customers who have booked flight less than 5 times-how would you do that?
All you have is count of Bookings as a metric, how will you segment customers based on a metric -here, booking -to understand their behavior on the website?
Example 2: You are a Financial Bank and you want to group your customers based on number of CDs they have invested in. You want to segment your customers in 3 Tiers. Tier 1 -Customers with 10+ CDs, Tier 2 -Customers with >5 and <10 CDs and Tier 3 -Customers with >0 and <5 CDs
The information you have is metric which gives you counts of CD investments -how will you create Tired Customer Segments for your analysis?
Creating Metric Dimension - via Workstation
Mark one of the OOB metric dimensions as local and Rename that dimension with a custom name / Make local copy of the RenameDim.example and rename it to the proper dimension name with .dim extension
Open the newly created dimension in the workstation to make changes. Change following parameters of the metric dimension based on the requirements:
Metric - Metric to be grouped
Level - Level at which metrics will be grouped
Bucket Start - Starting element of the Metric Dimension. Enter the same value in offset.
Bucket Size - Grouping size of metric. Enter the same value in scale
Bucket Count - Maximum number of elements to be displayed in the dimension
Save the newly created dimension on the server if you want to share it with others.
The main purpose of the Prefix dimension is to group elements of the original dimension and to provide user friendly names to the grouped elements.
For example, you own a retail site and your site has various site sections such as Women’s Apparel, Men’s Apparel, Toys and Games, Home Decor, etc and each of these site sections has several pages associated with it. You want to do path analysis and get insights about the traffic that goes from one site section to other and so on. If you use URI dimension, you will be required to pull each page of each of the site section in the Path Browser or Process Map and carry on the analysis.
The same analysis can be done easily if there is a Prefix dimension which has pages of a site section grouped together as a single element.
Creating Prefix Dimension:
Open a 2D process map from the Visualization menu.
Change following parameters of the prefix dimension based on the requirements.
Change Map Dimension - The Dimension that you want to use for 2D process map (Ex: SMS Typology)
Change Map Level Dimension - Level of the above mentioned dimension
Change Map Clip Dimension - The countable level at which you want to look at the data.
Change Map Metric - The metric that you want to look at.
Once the 2D Process map is set, open the dimension that you mentioned in Change Map Dimension parameter.
Select the elements you want to group. Use CTRL+ALT and drag & drop the elements on to process map.
Right click on the dot that appears and rename the group name. If you have selected 3 elements to group, the default name will be 3 Selected.
Right click on the outline of the visualization and save dimension from the menu that appears.
Rename Dimensions are created off of a pre-existing dimension. The main purpose of the rename dimension is to provide user friendly names to the elements of the dimension. The out of the box Rename dimension is the Page dimension which is created off of the URI dimension. The URI dimension can be confusing for a person who does not know technical names of the pages and that is why the Page dimension allows you to rename elements of the URI dimension.
CREATING CUSTOM RENAME DIMENSIONS:
Elements of the Renamed dimension hold a One-to-One mapping with the original base dimension’s elements. You can verify this by opening the .dim file of the Rename Dimension in the Workstation/Note pad. You will notice that each element of the original dimension has only one value (Rename String) against it in the file.
If you have fewer elements for the rename purpose; you can create a .dim file in the workstation and rename each individual elements by the steps explained below.
Steps to create a .dim file for a Rename Dimension- Using the Workstation
Use this option if the numbers of elements to be renamed are less.
Prefix and Rename dim creator Tool
Adobe has an Excel tool to generate Prefix and Rename Dimensions.
Below are the steps to generate the Prefix/Rename dimensions using the tool:
Save the Excel tool Adobe_DWB_Dimension_Generator.xlsm in a folder. Contact Adobe Customer Care to download the tool.
Open the tool and enable macros:
Fill the data sheet with the vales to be used.
For example, we are creating Product Brand Prefix dimension based on Product Dimension. In the data Sheet, the following information is captured:
Each product is assigned to a brand in the data sheet.
In the Configuration tab, fill the information related to the dimension to be created. For the sample data above below information is entered:
Name: Name for the Prefix/Rename dimension
Source Dim: Original Dimension
Match Column: Column to be matched
Result column: Value to be used for new dimension.
Click the button titled Click Here.
The dim file will be generated in the same folder where the tool was saved.
Using the Profile Manager, save the dim file in the Dimension folder.
Shift dimensions allows you to look at the Nth element of any dimension at the within any particular Countable Dimension.
They also give you the ability to look back at -Nth element of any dimension within any particular Countable Dimension
Why it is important to know Nth element of the countable dimension?
The Next URI is one of the OOB Shift dimensions which can be used as template. The example above is giving you 2nd(Offset = 1) element of the Campaign (Dim = Campaign) in the Engagement Event (Clip = Engagement Event)
Here offset 1 means look on the right -forward in the Event
Some other OOB Shift Dimensions
The next page viewed in a session after currently selected Page in the Page Dimension
Here offset is 1, Level is Page View, Dim is Page and Clip is Session
The previous page viewed in a session before currently selected Page in the Page Dimension
Here offset is -1, Level is Page View, Dim is Page and Clip is Session
What will be the previous Campaign viewed before currently selected Campaign by a visitor?
Here offset is -1, Level is Campaign Response, Dim is Campaign Response Attribute Value and Clip is Visitor
Creating Shift Dimension -Via Workstation
Mark one of the OOB shift dimension as local
Rename that dimension with a custom name
Open newly created dimension in the workstation to make changes
Change following parameters of the metric dimension based on the requirements.
Save the newly created dimension on the server if you want to share it with others.
Last N Dimension
Last N Dimensions operates only on the Time Dimension and on the As of Time of the system. OOB time dimensions are Day, Week, Hour and Month. You can create, Last N dimension for each of these base time dimensions such as Last 10 Days, Last 72 hours, Last 8 Weeks, Last 6 Months, etc. Last N Dimension calculates Last N based on the current “Report Time Metric” or As of Time of the system.
Count - Total number of elements to be displayed in the dimension
Range offset - Offset value to denote the starting point (Day/Week) to calculate the last N Day/Week.
None.dim is a Alias dimension. It is used to create alias from extended dimensions.
In the None.dim the entity is defined as “wdata/model/dim/Parent/+name” (it can be changed) which means create the dimension as per the name of the dimension file. So if we create a copy of None.dim file under Dimension folder (for this example, copying and renaming the None.dim file under Visitor Profile folder) and rename it to “Log Source ID.dim”, a new derived dimension with Log Source ID will appear in the Menu under Visitor Profile as shown below:
After None.dim changes:
The entity can be changed to the extended dimension name, in this case another dimension with other name pointing to the same dimension as shown below:
In this example the “Source Name.dim” has the following content:
So another Dimension Source Name pointing to Log Source ID will appear.
Hiding Derived Dimensions
To hide the Derived Dimension, set the Show property to “false”.