Naming Conventions
Dimension Columns
Overview
A dimension will always consist of an entity
(e.g. order, customer) and a dimension
, which is a
qualifier that specifies a certain attribute of the entity
. Like with metrics, the entity
and dimension
combination is the majority of what you’re looking for when locating a dimension or typing a dimension in a query.
As such, entity
and dimension
will always appear next to each other, with any modifiers
appearing first.
Dimension column name formula
{{ modifier }}_{{ entity }}_{{ dimension }}
Examples
order_index
, whereorder
is theentity
andindex
is thedimension
that specifies the attribute of the orderproduct_variant_title
, whereproduct_variant
is theentity
andtitle
is thedimension
that specifies the attribute of the product variant
In some cases, dimension columns will have modifiers. As with metrics, modifiers will fall before the entity
.
Examples with modifiers
primary_order_payment_gateway
, whereorder
is theentity
,payment_gateway
is thedimension
, andprimary
modifies thisentity_dimension
combinationmost_recent_refund_date
, whererefund
is theentity
,date
is thedimension
, andmost_recent
modifies thisentity_dimension
combination
Was this page helpful?