# 🟡Dynamic Dimension

How many times have you asked the following questions:

* How many customers *churned* last month?
* How much revenue did our “*priority customers*” contribute last quarter?
* Or even: let’s set a goal to reduce churn rate by 20% next year.

**The tricky thing with those questions is that such properties vary over time for a given object**. A customer might be “priority” last year, but not this year - depending on their yearly spend level. To do this, your data team has to code and maintain a complex data query in their system, and they usually are fixed for use with a single metric, not to mention the need for tweaking the definitions around. Now you can do that on Presight with a simple point-and-click interface.

<figure><img src="https://lh5.googleusercontent.com/mmVzkKlmPu1K-TMU8qB8EmkvUAit43UXHgSTtBTnDDZ3jTaiAS7cCdbVyasgcyBqFhNAvlcB2rWiPKEXfSdikI14jpdbaFoadF-yl4gTwJDayuS45TrML7cFQfkhtXKFZNA0cXWep1SEvmBt81sQd94" alt=""><figcaption></figcaption></figure>

(Note that **this is different from a regular dimension** in that Dynamic Dimensions deal with data that tend to change occasionally or at irregular intervals, like Customer Spendings, Products Sold. In contrast, non-changing dimensions - or regular dimensions, such as Customer Country, Product Color, are usually fixed over time and can be defined using our existing [Dimension Editor](/presight-v1.0/model/segments-and-custom-segments/create-a-new-dimension.md).)

## What makes a Dynamic Dimension

A Dynamic Dimension is consisted of 3 elements:

1\. The **target dimension** to be segmented:&#x20;

* is it your customers (Active vs Churned), to run different campaigns
* or your sales personnels (Top Employees vs Normal Employees), to design different commission levels, for example.

2\. The **changing property** (i.e. a Metric) being used to segment the target dimension, for example:

* segment customers by their total spending in the month
* differentiate your salespersons by their total revenue contribution in prior year

3\. Lastly, the **time window** used in your segmentation definition

* A calendar period: a customer is “Churned” if they didn’t spend any money for a full calendar year, a product is “Hot” if it sold more than 1,000 units in a quarter.
* A running period: a customer is “Churned” if they haven't come back for 3 consecutive months.&#x20;

{% hint style="info" %}
Currently Presight doesn't support a running period time window in defining a Dynamic Dimension yet. For now, most usecases can be approximated using the calendar period method above without changing the effectiveness of applying the SCD to your operations.

Dynamic Dimension also cannot be created from formulated metrics.

These will be available in a future release!&#x20;
{% endhint %}

**Once defined, Dynamic Dimensions can be used by many other metrics**, just like any other dimension defined the traditional way. For example:

* Show percentage of churned users over time. What products were viewed by churned users but weren’t purchased?
* Show revenue contribution of “Best Selling” products over time. Show average margin of these best performing products versus the rest, should we invest more in our product R\&D?
* Are our sales teams performing well? Percentage of sales persons exceeding KPIs over time and see the projection.
* Make future growth plans for each of these questions.

Experimenting with different segmentation, and allocating your operations effectively to best serve each segment is crucial to success in many companies. With Presight, non-tech users can create a new Dynamic dimension in a few clicks. Compared to the traditional way of waiting for a few weeks for the tech team to code this into the data pipeline, Presight is setting a new standard in bringing data closer to business outcomes.

## How to use

* Choose a metric, find a dimension that you want to segment and click on the <mark style="color:blue;">**Segment icon**</mark> ![](/files/4zokxooNvE3XsoRUAXt7)

<figure><img src="/files/vZj0I97neKuLItM4tPKf" alt=""><figcaption><p>Segmenting Icon</p></figcaption></figure>

* Name the Segment and apply conditions

<figure><img src="/files/0GZSVuJ2J5fEwRQOkkjp" alt=""><figcaption><p>Classifying Customers by their spending values in a month</p></figcaption></figure>

{% hint style="info" %}
Describing the conditions at the Segment name can help you to remember the segment better.
{% endhint %}

* Then, Click **`Apply`**
* The dimension will appear in the drop-down list for you to breakdown the metric

<figure><img src="/files/jAgvfjwzuKCScHbPx41q" alt=""><figcaption></figcaption></figure>

The newly created segmenting dimension can also be used to breakdown at other related metrics.

<figure><img src="/files/I0TsRqkzDZNtzto5pzXI" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
The Segmenting Dimension helps to show that: Large Customer accounted for 808k sales in June (which is almost 48% of total sales), and there are 366 customers in that group (which is 7% of total customer number). \
Then, company can deeply dive in more details, such as: products sold to this group , their location, their age-bin...., and offer suitable marketing or pricing programs for them to increase sales and customer loyalty.

💡**Identifying customer segment can help companies improve targeted marketing, pricing strategies or product development, which can grow their business and increase customer loyalty.**
{% endhint %}

{% hint style="info" %}
The same Dynamic Dimension can be used by other metrics at different time granularity. For example, Customer Status defined with Quarterly Spending can be used in Monthly, Quarterly, Yearly breakdowns of related metrics.
{% endhint %}

<figure><img src="/files/IJKYEsA3McLLbOrtE4KN" alt=""><figcaption><p>Yearly Sales broken-down by Customer Monthly Spendings</p></figcaption></figure>

### Edit the created Dynamic Dimension

You can find the Edit Icon ![](/files/n5LyBtAtBrloky3Fe6Wl) next to the Dynamic Dimension name to edit the dimension: dimension name, segment name and conditions.

<figure><img src="/files/EphHNob3cMbEnKNBgcjs" alt=""><figcaption><p>Edit a Dynamic Dimension</p></figcaption></figure>

You can also edit the Dynamic Dimension from <mark style="color:blue;">**Data Hub**</mark>, tab <mark style="color:purple;">**Dimensions**</mark>, <mark style="color:orange;">**Dynamic Dimension**</mark>:

<figure><img src="/files/eS4zJXforWpfOixhRI75" alt=""><figcaption><p>Edit a Dynamic Dimension</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://presight.gitbook.io/presight-v1.0/dimension/creating-a-new-dimension/dynamic-dimension.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
