Setting workspace dimensions

What is a dimension?

Dimensions are one of the two building blocks of your workspace. A dimension is an attribute of your data, which contains values that describe the data. Common dimensions include Country, Device OS, Advertiser, or Publisher. Dimensions appear in the right-hand panel of your workspace.

Choosing workspace dimensions

A dimension is anything that can be used to describe your metrics. For example, Device OS is a dimension, which has dimension values such as "iOS", "Android". Dimensions come from the columns inside of your dataset. Within a Facet workspace they will be used to split and filter your data, to provide insights about your metrics.

Choose all of the dimensions that you believe will be valuable for investigating trends. If you only have a handful of dimensions, let's say 20, there's no harm in making all of them visible and available in your workspace — you can always go back and edit visible dimensions later.

If adding all of your dimensions would clutter your workspace, only choose those that make sense for the end workspace user. For example, for most users "Device Model" (e.g. iPhone) will be more useful than "User Agent" (e.g. Mozilla/5.0 (iPhone; CPU iPhone OS 12_1_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16D57)

Click the "Visible" checkbox to make a dimension available in the workspace. This will add the dimension as a drop-down option in the dimension panel. Click the "Default" checkbox to pin the dimension as a default for all new users.

👍

Pick default dimensions

Make sure to select at least one default dimension for your workspace, or your dimension panel will appear "empty" to new users on login.

Users are able to overwrite defaults with personal "pins" after signing in.

Lookups

For dimensions in your dataset that have ID keys, you can use lookups to replace the IDs with their respective values. You must ensure that the credentials set up for your workspace have access to the lookup tables you would like to use.

For each dimension you would like to look up, you will need the following:

  • Dimension name
  • Lookup table name
  • Column name for ID key in lookup table
  • Column name for ID value in lookup table

The end format will look like this: ${dimension_name}.lookup('{lookup_table_name}', '{lookup_table_key}', '{lookup_table_value}')

e.g. $ADVERTISER_ID.lookup('PUBLIC.ADVERTISERS', 'ID', 'NAME')

Set your lookup formula as your dimension calculation in workspace settings, and your ID values will populate automatically.


Did this page help you?