Skip to main content

Dimensions Tables

Overview​

Dimensions are a common concept in data analytics. By dimensions, we often mean a set of properties the users, product, or session may have. Examples of user properties:

  • Country of origin
  • Email addresses
  • Primary email address
  • Phone number
  • Is paying
  • First event time
  • Last event time
  • Sign-up time
  • etc.

In addition to the user profiles, you can configure a dimension table for any entities you've added on the Entities page.

Most companies store these properties in a data warehouse in separate tables, where each row holds information about a single entity. Later, during analysis, they join these tables to the event tables for further filtering and segmentation.

Mitzu supports joining one or more dimension tables to event tables.

Setting up the user profile tables​

  1. Click the Add dimension table button, select the schema and the tables in the modal, and click the Add Tables button.
image

  1. You need to set the entity of each selected table. You can add more entities on the Entities page if necessary.

  2. For the Primary key field, you need to set the field that can be used as a joining key when joining the event tables. For example, if you've selected the User entity, you should set the column containing the user ID field.

  3. Optionally, you can set the Ignored fields listing the table fields that you don't want to be indexed.

  4. Click the Save button to start updating your user properties catalog with the newest dimension properties.

warning

The newly added and the reconfigured event tables are not indexed automatically. You need to select them and click on the Re-index selected button to index them.

image

Removing user profile tables​

If you decide to remove any dimension table, select it with the checkbox in the table and click the Remove tables button. It will remove the table from the list of tables and the user property catalog. All saved Insights using one of the removed tables will break.