GROUP
and FILTER
by arbitrary SQL dimensions.in advance
and in arrears
matches how you invoice—for fees paid upfront for the following month (common for platform access or seats), pick the former. For fees like support, pick the latter.effective_time
of each transition; it’s common for upgrades to be immediate and downgrades to take effect at the end of the term.