What type of data can be returned from a VLOOKUP in Datorama?

When utilizing a VLOOKUP in Datorama, the function is specifically designed to return dimensions, which are categorical data points used for analysis and reporting. Dimensions are attributes that help describe the context of your measurements, such as date, location, or campaign type.

The reason dimensions are the focus here is that VLOOKUP is a method primarily geared towards fetching values based on keys or unique identifiers, which are typically associated with dimensional attributes. When you conduct a VLOOKUP, it connects specific values in one table with corresponding values in another, effectively enhancing your dataset with additional categorical context.

In contrast, calculated measurements and calculated dimensions represent derived values based on existing data rather than the lookup process that VLOOKUP facilitates. Similarly, while measurements are quantitative metrics derived from your data, they do not fit the nature of what VLOOKUP returns, which is fundamentally linked to the retrieval of categorical information that constitutes dimensions. Thus, the focus on dimensions solidifies the understanding of VLOOKUP's function within the Datorama environment.