**Behavioral Data Hub > Live Aggregates > Create aggregate**.
2. As the aggregate type, select **Profile**.
3. Enter the name of the aggregate, for example `Sum of transactions lifetime`.
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. Set the time range 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 `Last transaction time`.
4. Click **Analyze profiles by** and select **Last**.
5. From the **Choose event** dropdown list, select the `transaction.charge` event.
6. As the event parameter, select `TIMESTAMP`.
7. Click the **+ where** button. From the **Choose parameter** dropdown list, select `$revenue`. From the **Choose operator** dropdown, select **More than (Number)**. In the value field, enter `0`.
8. Set the time range to **Last 30 days**.
9. Save the aggregate.
**Behavioral Data Hub > Expressions > New expression**.
2. Enter the name of the expression, for example `Total customer spend`.
3. In the **Expressions for** dropdown, select **Attribute**.
4. In the **Formula definition** area, add the aggregate created in the [previous step](#aggregate-for-lifetime-transaction-sum) (`Sum of transactions lifetime`).
5. Set the expression **Type** to **Profile**.
6. Click **Publish**.
**Behavioral Data Hub > Expressions > New expression**.
2. Enter the name of the expression, for example `Last transaction time`.
3. In the **Expressions for** dropdown, select **Attribute**.
4. In the **Formula definition** area, add the aggregate created in the [previous step](#aggregate-for-last-transaction-timestamp) (`Last transaction time`).
5. Set the expression **Type** to **Profile**.
6. Click **Publish**.
{%- set spendArr = [] -%}
{%- set inactiveArr =[] -%}
{%- expressionvar EXPRESSION_ID_SPEND -%}
{%- do spendArr.append(expression_result) -%}
{%- endexpressionvar -%}
{%- expressionvar EXPRESSION_ID_INACTIVITY -%}
{%- do inactiveArr.append(expression_result) -%}
{%- endexpressionvar -%}
{%- set spend = spendArr[0] -%}
{%- set inactive = inactiveArr[0] -%}
{%- set now_dt = timestamp|timestamp_to_time -%}
{%- set event_dt = '' -%}
{%- if inactive == 'null' -%}
{%- set event_dt = timestamp|timestamp_to_time -%}
{% else %}
{%- set event_dt = inactive|iso8601_to_time -%}
{%- endif -%}
{%- set now_day = now_dt|datetimeformat('%Y')|int * 365 + now_dt|datetimeformat('%j')|int -%}
{%- set event_day = event_dt|datetimeformat('%Y','UTC')|int * 365 + event_dt|datetimeformat('%j','UTC')|int -%}
{%- set days = now_day - event_day -%}
{% set seg = '' %}
{%- if spend > 200 and days < 14 -%}{% set seg = 'vip'%}
{%- elif days > 14 -%}{% set seg = 'atrisk'%}
{%- else -%}{% set seg = 'standard'%}
{%- endif -%}
{%- set isMutated = [] -%}
{%- if customer.questOfferShown -%}
{% do isMutated.append(true)%}
{%- else -%}
{% do isMutated.append(false)%}
{%-endif-%}
{%- set mutated = isMutated[0] -%}
{#- Resolve voucher pool UUID per segment and mutation state -#}
{%- set code = [] -%}
{%- if mutated -%}
{%- if seg == "vip" -%}
{% do code.append('VIP_VOUCHER_POOL_UUID') %}
{%- elif seg == "atrisk" -%}
{% do code.append('ATRISK_VOUCHER_POOL_UUID') %}
{%- else -%}
{% do code.append('STANDARD_VOUCHER_POOL_UUID') %}
{%- endif -%}
{%- else -%}
{%- if seg == "vip" -%}
{% do code.append('VIP_VOUCHER_POOL_UUID') %}
{%- elif seg == "atrisk" -%}
{% do code.append('ATRISK_VOUCHER_POOL_UUID') %}
{%- else -%}
{% do code.append('STANDARD_VOUCHER_POOL_UUID') %}
{%- endif -%}
{%-endif-%}
{%- if seg == "vip" -%}
{%- if mutated -%}
{%- set title = "25% VIP flash deal" -%}
{%- set desc = "We've upgraded your offer! 25% off premium items." -%}
{%- set discount = 25 -%}
{%- set cta = "Claim 25% off" -%}
{%- else -%}
{%- set title = "20% Exclusive deal" -%}
{%- set desc = "As a VIP member, you've unlocked an exclusive discount on premium items." -%}
{%- set discount = 20 -%}
{%- set cta = "Claim 20% off" -%}
{%- endif -%}
{%- set timeout = 30 -%}
{%- elif seg == "atrisk" -%}
{%- if mutated -%}
{%- set title = "40% emergency deal" -%}
{%- set desc = "Final offer: 40% off anything. This won't come back." -%}
{%- set discount = 40 -%}
{%- set cta = "Claim 40% off NOW" -%}
{%- else -%}
{%- set title = "Flash 30% off" -%}
{%- set desc = "Welcome back! Here's a special comeback deal. Don't let it slip away." -%}
{%- set discount = 30 -%}
{%- set cta = "Grab 30% off now" -%}
{%- endif -%}
{%- set timeout = 5 -%}
{%- else -%}
{%- if mutated -%}
{%- set title = "15% off + 2x points" -%}
{%- set desc = "We've boosted your offer! 15% off and double loyalty points." -%}
{%- set discount = 15 -%}
{%- set cta = "Claim 15% off" -%}
{%- else -%}
{%- set title = "10% off + 2x points" -%}
{%- set desc = "Great job! Enjoy a 10% coupon and double loyalty points on your next order." -%}
{%- set discount = 10 -%}
{%- set cta = "Claim reward" -%}
{%- endif -%}
{%- set timeout = 15 -%}
{%- endif -%}
{
"segment": "{{ seg }}",
"offerTitle": "{{ title }}",
"offerDescription": "{{ desc }}",
"discountValue": {{ discount }},
"ctaLabel": "{{ cta }}",
"offerTimeout": {{ timeout }},
"offerStyle": "{{ seg }}",
"voucherCode": "{{ code[0] }}",
"isMutated": {{ mutated }}
}
**Experience Hub > In-app > Create new**.
2. Enter the name of the in-app campaign, for example `Quest reward offer loop`.
### Define the audience
---
1. In the **Audience** section, click **Define**.
2. Choose **Everyone** or specify the audience according to your business needs.
3. Click **Apply**.
### Define content
---
In this part of the process, you will create the in-app message template containing the quest UI and reward overlay.
1. In the **Content** section, click **Define**.
2. Click **Create message**.
3. Click **+ New template** in the upper right corner.
3. Choose **Code editor**.
#### HTML tab
The HTML defines the key structural elements required for the flow to work. The essential parts are:
- **Quest area** (`#mainArea`) — dynamically rendered quest card with progress bar and claim button.
- **Reward overlay** (`#overlay`) — bottom sheet that displays the personalized offer, countdown timer, and action buttons.
<div id="app">
<div class="topbar">
<h1>Quest hub</h1>
<div class="streak-badge">
<span id="streakCount">-</span>
</div>
</div>
<div class="main" id="mainArea"></div>
</div>
<div class="overlay" id="overlay">
<div class="reward-sheet">
<div class="reward-icon" id="rewardIcon"></div>
<div class="reward-title" id="rewardTitle"></div>
<div class="reward-sub" id="rewardSub"></div>
<div class="reward-timer" id="rewardTimer"></div>
<button class="reward-cta" id="rewardCta">Claim</button>
<button class="reward-dismiss" id="rewardDismiss">Maybe later</button>
</div>
</div>{% set offer = [] %}
{% brickworksgeneratevar schemaId=SCHEMA_ID recordId=SCHEMA_ID %}
{% do offer.append(brickworks_result.offer) %}
{% endbrickworksgeneratevar %}
const BW_OFFER = {{ offer[0] }};
**Automation Hub > Workflows > New workflow**.
2. Enter the name of the workflow, for example `Quest offer follow-up push`.
### Define the Profile Event trigger nodes
---
The workflow uses two trigger nodes connected via a Merge Paths node, so the push is sent regardless of whether the user completed the quest without claiming or dismissed the offer.
#### First trigger — quest completed without claim
1. As the first node of the workflow, add **Profile Event**. In the configuration of the node:
2. From the **Choose event** dropdown menu, choose the `form.submit` event.
3. Click the **+ where** button. From the **Choose parameter** dropdown menu, choose `fd:formType`. From the **Choose operator** dropdown, choose **Equal**. In the value field, enter `quest`.
2. Confirm by clicking **Apply**.
