Overview
Dimension Mapping, also referred to as 'Rich Dimensions' are a quick way to add additional dimensionality to your data in Beckon. This file depicts examples and relevant information that relates to the Dimension Mapping in Beckon.
Information
For example, suppose we have data for our advertising campaigns for apples and pears as follows:
Campaign | Clicks |
apples_red_campaign | 400 |
apples_green_campaign | 500 |
pears_brown_campaign | 600 |
pears_green_campaign | 700 |
It would be handy to be able to view this data broken down by fruit, like this:
Fruit | Clicks |
Apples | 900 |
Pears | 1300 |
But we do not currently have enough dimensionality to group together the apples and the pears. With Rich Dimensions, we can easily add another dimension without changing the way the data is imported into Beckon.
To add Rich Dimensions, create a .csv file with the Rich Dimensions' header, the dimensions to be mapped to and from, and the desired mappings. For example:
%Template:RichDimensionMappingTemplate | |
Campaign | Fruit |
apples_red_campaign | Apples |
apples_green_campaign | Apples |
pears_brown_campaign | Pears |
pears_green_campaign | Pears |
- Then, navigate to OPERATE >MONITOR > Files page.
- Click on Upload Date in the upper right corner, and upload the file. For more details, refer to How do I use Dimension Mapping?
Once the file has been uploaded, the account will need to re-index before the new dimensionality is visible, which may take a while. Once the indexing completes successfully, the new mappings will be visible on new charts created in Answers as well as current charts. It should now be possible to create a chart that looks like this:
Fruit | Clicks |
Apples | 900 |
Pears | 1300 |
Advanced Notes
You can map multiple dimensions in the same file. For example, this file will map Campaigns to both Fruit and Color:
%Template:RichDimensionMappingTemplate | ||
Campaign | Fruit | Fruit Color |
apples_red_campaign | Apples | Red |
apples_green_campaign | Apples | Green |
pears_brown_campaign | Pears | Brown |
pears_green_campaign | Pears | Green |
This would allow us also to make a chart like this:
Fruit Color |
Clicks |
Red | 400 |
Green | 1200 |
Brown | 600 |
You can even chain mappings together. For example, if these two mapping files were uploaded:
%Template:RichDimensionMappingTemplate | |
Campaign | Fruit |
apples_red_campaign | Apples |
apples_green_campaign | Apples |
pears_brown_campaign | Pears |
pears_green_campaign | Pears |
%Template:RichDimensionMappingTemplate | |
Fruit | Shape |
Apple | Round |
Pear | Pear-shaped |
It would then be possible to make a chart like this:
Fruit Shape | Clicks |
Round | 900 |
Pear-shaped | 1300 |