Overview

Variable Properties provide users with a variety of options to customize their data according to specific needs. Below is a list of configurable options:

1. Edit Variable Name

This option allows users to modify the display name of a specific variable across all charts and data on the platform, enhancing presentation for business users.

2. Dimension and Time Aggregation

Single Dimension

• Time Aggregation: Choose between sum or average, with the default set to sum.
  • Example: Sum Facebook impressions over a month, but average temperature data.

Multi-Dimensional Data

• Data Dimension: Select the level at which data is available (e.g., city, state, country).
  • Example: If temperature data is available at the city level, set the dimension to city.
• Dimension Aggregation: Define the aggregation type for transitioning data from one dimension to another.
  • Example: Sum Facebook impressions from city to state, or average temperature data from city to state.

3. Modelling Properties

• Expected Relationship with Dependent Variable: Indicate the expected correlation between each variable and the target (dependent) variable:
  • Positive: Variable tends to increase with the target.
  • Negative: Variable tends to decrease with the target.
  • Unknown: Relationship is unclear or complex.
  Example for a sales model:
  • Advertising spends: Likely positive.
  • Price: Likely negative.
  • Weather: Might be unknown.

This information aids in guiding the modeling process, enhancing accuracy and interpretability.

4. Formatting

• Purpose: Define variable types for meaningful segmentation in output viewing.

• Unit Metrics:

  • Standard Units: Select from a predefined list (e.g., impressions, degrees Celsius, dollars).
  • Custom Units: Choose "Other" from the dropdown to enter a custom unit in a text box.

5. Saving and Editing

• After updating variable properties, always save your changes by clicking the 'Save' button at the bottom right of the page.
• Important: Always save before leaving the page to prevent losing updates.

Group Editing

• Use checkboxes to select multiple variables for simultaneous changes.
  • Example: Set the unit to 'GRP' for all selected variables at once.

Export/Import

• Download: Export variable properties to an Excel file for offline editing.
• Update: Make changes to multiple variables in the spreadsheet.
• Import: Upload the modified Excel file to apply all changes at once.

These features streamline the management of multiple variables, saving time and minimizing errors.

6. Review Variables

• Use the 'Review Variables' feature for a comprehensive view of all variable properties. This summary allows for quick scanning and last-minute adjustments.

Key Takeaway

Accurate property setup is essential for precise modeling and reporting, leading to more reliable business insights.