OpenKPIs
Leaderboard
Sign in
← Back to Dimensions

Customer Segmentation by Risk Profile

Also known as: Risk Segmentation, Risk Profile Classification

ConversiondimensionFinTech & Banking

This dimension categorizes customers based on their financial risk levels, enabling targeted strategies for risk management and marketing. It measures the risk tolerance and behavior patterns of customers in financial transactions.

Business Use Case

Executives use this segmentation to tailor financial products and marketing campaigns to different risk profiles, optimizing conversion rates.

Business Criticality

High

Journey / Navigation Area

Generic

Owning Function

Data Architecture Team

Scope

User

Calculation Notes

Exclude customers with insufficient transaction history; update profiles monthly.

Technical Details

Data Typestring
Lookback WindowUser

Events

SQL Queries

Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT customer_id, 
       CASE 
           WHEN risk_score <= 20 THEN 'Low Risk'
           WHEN risk_score BETWEEN 21 AND 50 THEN 'Medium Risk'
           ELSE 'High Risk'
       END AS risk_profile
FROM `your-project.crm.customer_data`
WHERE risk_score IS NOT NULL;
Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT customer_id, 
       CASE 
           WHEN risk_score <= 20 THEN 'Low Risk'
           WHEN risk_score BETWEEN 21 AND 50 THEN 'Medium Risk'
           ELSE 'High Risk'
       END AS risk_profile
FROM crm.customer_data
WHERE risk_score IS NOT NULL;

Source Data

CRM

Dependencies

[ "Transaction History", "Credit Score" ]

Report Attributes

Age Group Geographic Region

Segment Eligibility

true

Governance

Data Sensitivityinternal

Governance

Created bydevyendarm
Created on8/25/2026
Last modified bydevyendarm
StatusPUBLISHED

GitHub

View File on GitHubcatalog/dimensions/customer-segmentation-by-risk-profile.yml

Community Discussion