**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] loyalty points sum`.
4. Click **Analyze profiles by** and select **Sum**.
5. From the **Choose event** dropdown list, select the `points.loyalty` event.
6. As the event parameter, select `points`.
7. Define the period to **Lifetime**.
8. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] expired loyalty points`.
4. Click **Analyze profiles by** and select **Sum**.
5. From the **Choose event** dropdown list, select the `points.loyalty` event.
6. As the event parameter, select `points`.
7. Click the **+ where** button and add the condition: `$source` **Equal** `expiration`.
8. Define the period to **Lifetime**.
9. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Sum of transactions`.
4. Click **Analyze profiles by** and select **Sum**.
5. From the **Choose event** dropdown list, select the `transaction.charge` event.
6. As the event parameter, select `$totalAmount`.
7. Define the period to **Lifetime**.
8. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Number of transactions`.
4. Click **Analyze profiles by** and select **Count**.
5. From the **Choose event** dropdown list, select the `transaction.charge` event.
6. Define the period to **Lifetime**.
7. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Top 5 visited categories`.
4. Click **Analyze profiles by** and select **Top Multi**.
5. From the **Choose event** dropdown list, select the `page.visit` event.
6. As the event parameter, select `product:category`.
7. Click the **+ where** button and add the condition that `product:category` **is not null**.
8. In the **Size** field, enter `5`.
9. Define the period to the **Last 30 days**.
10. Save the aggregate.
**Behavioral Data Hub > Expressions > New expression**.
2. Enter the name of the expression, for example `[UC] Loyalty points`.
3. Set **Expressions for** to **Attribute**.
4. Enable **Show in profile card** if you want the result visible on customer profiles.
5. In the **Formula definition**, define the formula as:
- `earned loyalty points sum` **minus** `expired loyalty points`
where the first operand references the `[UC] loyalty points sum` aggregate and the second references the `[UC] expired loyalty points` aggregate, both created in the [previous step](#create-aggregates-for-loyalty-points).
6. Click **Publish**.
**Decision Hub > Segmentations > New segmentation**.
2. Enter the name of the segmentation, for example `[UC] Loyalty level - Gold`.
3. Name the segment `Gold`.
4. Click **Add condition**.
5. From the dropdown list, select **Has property**.
6. Choose the `[UC] loyalty points sum` expression.
7. From the **Choose operator** dropdown, select **Less than** and enter the value `10 000`.
8. Click **Add condition**.
9. Again select **Has property** and choose the `[UC] loyalty points sum` expression.
10. From the **Choose operator** dropdown, select **More than** and enter the value `4 000`.
11. Connect these conditions with the **And** operator.
12. Save the segmentation.
**Behavioral Data Hub > Expressions > New expression**.
2. Enter the name of the expression, for example `[UC] Loyalty level`.
3. Set **Expressions for** to **Attribute**.
4. Enable **Show in profile card** if desired.
5. In the **Formula definition**, build a conditional formula using the following logic:
- If `[UC] Loyalty level - Base` → return `Base member`
- If `[UC] Loyalty level - Silver` → return `Silver member`
- If `[UC] Loyalty level - Gold` → return `Gold member`
- If `[UC] Loyalty level - Premium` → return `Premium member`
- Otherwise → return `null`
Each condition references the corresponding segmentation created in the [next step](#create-segmentations-for-loyalty-tiers).
6. Click **Publish**.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Transaction IDs`.
4. Click **Analyze profiles by** and select **Last Multi**.
5. From the **Choose event** dropdown list, select the `transaction.charge` event.
6. As the event parameter, select `$orderId`.
7. In the **Size** field, enter `25`.
8. Define the period to **Lifetime**.
9. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Transaction loyalty points`.
4. Click **Analyze profiles by** and select **Last Multi**.
5. From the **Choose event** dropdown list, select the `points.loyalty` event.
6. As the event parameter, select `points`.
7. Click the **+ where** button and add the condition: `$revenue` **Is not null**.
8. In the **Size** field, enter `25`.
9. Define the period to **Lifetime**.
10. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Transaction amounts`.
4. Click **Analyze profiles by** and select **Last Multi**.
5. From the **Choose event** dropdown list, select the `transaction.charge` event.
6. As the event parameter, select `$totalAmount`.
7. In the **Size** field, enter `25`.
8. Define the period to **Lifetime**.
9. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Transaction dates`.
4. Click **Analyze profiles by** and select **Last Multi**.
5. From the **Choose event** dropdown list, select the `transaction.charge` event.
6. As the event parameter, select `TIMESTAMP`.
7. In the **Size** field, enter `25`.
8. Define the period to **Lifetime**.
9. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Transaction product names`.
4. Click **Analyze profiles by** and select **Last Multi**.
5. From the **Choose event** dropdown list, select the `product.buy` event.
6. As the event parameter, select `$name`.
7. In the **Size** field, enter `1 000`.
8. Define the period to **Lifetime**.
9. Save the aggregate.
**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `[UC] Product buy order IDs`.
4. Click **Analyze profiles by** and select **Last Multi**.
5. From the **Choose event** dropdown list, select the `product.buy` event.
6. As the event parameter, select `$orderId`.
7. In the **Size** field, enter `1 000`.
8. Define the period to **Lifetime**.
9. Save the aggregate.
{% set txn_ids = [] %}{% set txn_points = [] %}{% set txn_amounts = [] %}{% set txn_dates = [] %}{% set buy_names = [] %}{% set buy_order_ids = [] %}{% aggregate TRANSACTION_IDS_AGGREGATE_HASH %}{%- for res in aggregate_result -%}{% do txn_ids.append(res) %}{%- endfor -%}{% endaggregate %}{% aggregate TRANSACTION_POINTS_AGGREGATE_HASH %}{%- for res in aggregate_result -%}{% do txn_points.append(res) %}{%- endfor -%}{% endaggregate %}{% aggregate TRANSACTION_AMOUNTS_AGGREGATE_HASH %}{%- for res in aggregate_result -%}{% do txn_amounts.append(res) %}{%- endfor -%}{% endaggregate %}{% aggregate TRANSACTION_DATES_AGGREGATE_HASH %}{%- for res in aggregate_result -%}{% set splitDate = res|split(':') %}{% set splitDateLength = splitDate|length %}{% set finalDate = splitDate[0:splitDateLength-1]|join(':') ~ splitDate[splitDateLength-1] %}{% set finalDateFormatted = datetimeformat(finalDate|strtotime("yyyy-MM-dd'T'HH:mm:ss.SSSZ"), '%b %d, %Y') %}{% do txn_dates.append(finalDateFormatted) %}{%- endfor -%}{% endaggregate %}{% aggregate PRODUCT_NAMES_AGGREGATE_HASH %}{%- for res in aggregate_result -%}{% do buy_names.append(res) %}{%- endfor -%}{% endaggregate %}{% aggregate PRODUCT_ORDER_IDS_AGGREGATE_HASH %}{%- for res in aggregate_result -%}{% do buy_order_ids.append(res) %}{%- endfor -%}{% endaggregate %}{% set orders = [] %}{% for i in range(txn_ids | length) %}{% set order_id = txn_ids[i] %}{% set products = [] %}{% for j in range(buy_order_ids | length) %}{% if buy_order_ids[j] == order_id %}{% set _ = products.append(buy_names[j]) %}{% endif %}{% endfor %}{% set _ = orders.append({'orderId': order_id,'date': txn_dates[i],'amount': txn_amounts[i],'loyaltyPoints': txn_points[i],'products': products}) %}{% endfor %}{{ orders | reverse | tojson }}
**Experience Hub > In-app messages > Create in-app**.
2. Enter the name of the in-app message.
### Define the audience
---
1. In the **Audience** section, click **Define**.
2. Click **Everyone** (or define a specific segment according to your needs).
3. Click **Apply**.
### Define content
---
1. In the **Content** section, click **Define**.
2. Click **Create message**.
3. In the code editor, paste the in-app template code provided below.
The template uses the `{% brickworksgeneratevar %}` tag to fetch all schema fields for the current customer and renders the profile panel with sections for stats, top interests, dynamically loaded promotions, and past transactions.
{% brickworksgeneratevar schemaId=SCHEMA_ID recordId=RECORD_ID %}
<div class="profile-container">
<button id="close-btn" onclick="SRInApp.close()">×</button>
<div class="profile-header">
<div class="avatar">{{ brickworks_result.firstName|default('P')|truncate(1, true, '') }}</div>
<div class="header-info">
<h1 class="user-name">{{ brickworks_result.firstName|default('Profile') }}</h1>
<span class="member-badge {{ brickworks_result.loyaltyLevel | lower | replace(' ', '-') }}">{{ brickworks_result.loyaltyLevel }}</span>
</div>
</div>
<div class="stats-row">
<div class="stat-card">
<div class="stat-icon">💰</div>
<div class="stat-value">${{ brickworks_result.transactionTotal|default('0') }}</div>
<div class="stat-label">Total Spent</div>
</div>
<div class="stat-card highlight">
<div class="stat-icon">🏆</div>
<div class="stat-value">{{ brickworks_result.loyaltyPointsTotal|default('0') }}</div>
<div class="stat-label">Loyalty Points</div>
</div>
<div class="stat-card">
<div class="stat-icon">🛍</div>
<div class="stat-value">{{ brickworks_result.numberOfTransactions|default('0') }}</div>
<div class="stat-label">Transactions</div>
</div>
</div>
{% set topVisitedCategories = brickworks_result.topVisitedCategories %}
<div class="section-card">
<div class="section-title">🔥 Top Interest</div>
<div class="interest-bar">
{%- if topVisitedCategories|length > 0 -%}
{%- for category in topVisitedCategories -%}
{% set splitCategory = category[0]|split('Default Category > ') %}
<div class="interest-item">
<span class="interest-label">{{ splitCategory[1] }}</span>
</div>
{%- endfor -%}
{%- else -%}
<p class="empty-message">Browse our products to see your interests</p>
{%- endif -%}
</div>
</div>
<div class="section-card">
<div class="section-title">🎁 Active Promotions</div>
<div class="promo-list">
{%- if brickworks_result.promotions.data|length > 0 -%}
{%- for promo in brickworks_result.promotions.data -%}
<div class="promo-item">
<div class="promo-badge">{%- if promo.discountType != "NONE" -%}{{ promo.discountValue }}{%- endif -%}{%- if promo.discountType == "PERCENT" -%}% OFF{%- elif promo.discountType == "AMOUNT" -%}$ OFF{%- else -%}PROMO{%- endif -%}</div>
<div class="promo-info">
<div class="promo-name">{{ promo.name }}</div>
<div class="promo-exp">{{ promo.description|truncate(35) }}</div>
</div>
</div>
{%- endfor -%}
{%- else -%}
<p class="empty-message">There are no promotions available for you</p>
{%- endif -%}
</div>
</div>
<div class="section-card">
<div class="section-title">📋 Past Transactions</div>
<div class="transactions-list">
{%- if brickworks_result.transactionData|length > 0 -%}
{%- for transaction in brickworks_result.transactionData -%}
<div class="tx-item">
<div class="tx-info">
<div class="tx-name">{{ transaction.products | join(', ') }}</div>
<div class="tx-date">{{ transaction.date }}</div>
</div>
<div class="tx-right">
<div class="tx-amount">{{ transaction.amount }}</div>
<div class="tx-points">+{{ transaction.loyaltyPoints }} pts</div>
</div>
</div>
{%- endfor -%}
{%- else -%}
<p class="empty-message">You haven't made any transactions yet</p>
{%- endif -%}
</div>
</div>
</div>
{% endbrickworksgeneratevar %}