What is dimension mapping?

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
  1. Then, navigate to OPERATE >MONITOR > Files page
  2. 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

Comments

0 comments

Article is closed for comments.