How to exclude or rename a Dimension using Query Builder

    Dimensions can be excluded or renamed using Query Builder. Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only.  Request a trial of Query Builder by following these steps.

HOW TO

How to exclude a Dimension

If you choose to skip a Dimension, it will no longer show up as a Dimension for the Custom Metric on a Databoard. 

1
 Navigate to Metrics > Query Builder
2
 Find the Custom Metric you're interested in excluding Dimensions from and click Edit
3
 Click Run query to generate a Data Preview of the Custom Metric
4
 At the top of the Dimension column in the Data Preview, click the ... icon
5
 Select Skip  Dimension
6

 Click on the Skip Item drop-down list to view all Dimensions returned from the Custom Metric. Select the Dimension you want to exclude

7

 To exclude another Dimension, click the green + sign

8

 Repeat steps 6-7 until you have excluded all necessary Dimensions

9

 Click the green Save button

How to rename a Dimension

If you choose to rename a Dimension, the Dimension name will be updated for any instances where the Dimension is returned. 

1
 Navigate to Metrics > Query Builder
2
 Find the Custom Metric you're interested in renaming Dimensions for and click  Edit
3
 Click  Run query to generate a  Data Preview of the Custom Metric
4
 At the top of the Dimension column in the Data Preview, click the  ... icon
5
 Select  Rename  Dimension
6

 Click on the  Select item drop-down list to view all Dimensions returned from the Custom Metric. Select the Dimension you want to rename

7

 In the Value textbox, enter the new name for the Dimension

8

 To rename another Dimension, click the green  + sign

9

 Repeat steps 6-8 until you have renamed all necessary Dimensions

10

 Click the green  Save button

Additional Info

  • If a Dimension is renamed to a Dimension name that already exists, the Dimension will not be recognized by Databox. To aggregate multiple Dimension values, it is recommended that you use Data Calculations to add together the unique Dimensions and produce a new Calculated Metric.  
  • For Agencies: Excluded and renamed Dimensions will be retained when Custom Metric is used on a Databoard and copied to a Client Account. 
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us