Dimension mapping, also referred to as 'Rich dimensions' are a quick way to add additional dimensionality to your data.
For example, suppose we have data for our advertising campaigns for apples and pears:
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 don't 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, on the OPERATE ->MONITOR ->Files page, click on"Upload Date" in the upper right corner, and upload the file. For more details on how to add and update rich dimensions, see this article about setting up rich dimensions.
Once the file has been uploaded, the account will need to re-index before the new dimensionality will be visible. This can take awhile. Once the indexing completes successfully, the new mappings will be visible on new charts created in Answers as well as existing charts. It should now be possible to create a chart that looks like this:
Fruit | Clicks |
Apples | 900 |
Pears | 1300 |
Advanced Notes
It is possible to 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 to also 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 |