MMM Reallocation Settings Table (BETA)

mmm_reallocation_settings_table

The MMM Reallocation Settings table stores budget scenario settings for a model run. One row per reallocation scenario. Scenario rows define the requested budget and default scenario.

📋
Table Guide
What You Can Answer With This Table

What budget scenarios were run on a model? — use reallocation_settings_name, reallocation_type, calculated_budget

How was a scenario's target budget requested? — use req_budget_type, req_budget_value, init_budget

Which scenario is the default for a model? — use is_default

Before You Query

This table is not time-series, so no date filter is needed.

Key Relationships

Table Join Key Use This Join To
MMM Reallocations reallocation_settings_id Get the per-group budget outputs produced by the scenario
MMM Models model_id Get the model run the scenario was based on

When to Use a Different Table

Use MMM Reallocations when you need budget scenario results by modeled group. MMM Reallocation Settings stores the scenario-level configuration and total target budget.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
MMM Reallocations	`reallocation_settings_id`	Get the per-group budget outputs produced by the scenario
MMM Models	`model_id`	Get the model run the scenario was based on

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Scenario Created Date	`created_at`	timestamp	The time at which the reallocation scenario was written to the database. Formatted according to the ISO 8601 international standard. Example value: `2024-01-22 06:15:00`
Is Default	`is_default`	boolean	True if this is the default reallocation scenario for the model run. Possible values: `true`, `false`
Model ID	`model_id`	string	The unique identifier of the model run the scenario was based on. Joins to MMM Models. Example value: `9f2c1a7e-3b44-4c9a-8e21-7d5f0b2a1c33`
Reallocation Settings ID	`reallocation_settings_id`	string	The unique identifier of the reallocation scenario. Joins to MMM Reallocations for the per-group budget outputs. Example value: `7d2e9a1b-5c44-4e8f-9a12-3b0c6d2e4f51`
Scenario Name	`reallocation_settings_name`	string	The display name of the reallocation scenario. Example values: `Current Budget`, `Scale Up`, `Scale Down`
Reallocation Type	`reallocation_type`	string	Whether the scenario optimizes an allocation for a budget, or simulates results for a user-specified allocation. Possible values: `optimization`, `simulation`
Requested Budget Type	`req_budget_type`	string	How `req_budget_value` should be interpreted when setting the scenario's budget. Possible values: `exact`, `absolute_change`, `percent_change`, `optimization`
Request Source	`request_source`	string	Where the reallocation request originated. Possible values: `chat`, `agent`, `api`
Settings ID	`settings_id`	string	The unique identifier of the model configuration. All runs of the same model share one `settings_id`. Example value: `3a7b2c9d-1e44-4f8a-9c12-6b0d8e2f4a51`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Calculated Budget	`calculated_budget`	numeric	The resulting total budget used by the scenario after applying the requested change. By default shown in the shop's currency.
Initial Budget	`init_budget`	numeric	The starting total budget before the scenario's changes. By default shown in the shop's currency.
Requested Budget Value	`req_budget_value`	numeric	The requested budget change or target value, interpreted according to `req_budget_type`.