User Tables

Add and manage user profile tables in Mitzu

User profiles are a common concept in product analytics. By user profiles, we often mean a set of properties that the users of a product 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.

These properties in a data warehouse are often stored in a table, where each row holds information about a single user. This table is joined to the event tables during analysis for further filtering and segmentation.

Mitzu supports joining one or more user profile tables to event tables.

Setting up the user profile tables

  • First, add the table under the User tables tab on the ⚙️Workspace settings page.

  • Then, you need to choose the User ID column from the table. The user IDs in the selected column must be joinable to the events listed in the Event tables tab. Otherwise, the SQL queries generated by Mitzu won't yield good results.

  • Once this is done, click Save & update catalog. This will update your user properties catalog with the newest user properties.

Removing user profile tables

If you decide to remove any user profile table, just select it with the checkbox in the table and click Remove tables. This will remove the table from the list of tables and the user property catalog.

Last updated