OpenKPIs
Leaderboard
Sign in
← Back to Metrics

Average Loan Approval Time

Also known as: Loan Processing Time, Approval Duration

EfficiencymetricFinTech & Banking

Measures the average duration from loan application submission to approval decision. It helps assess the efficiency of the loan processing workflow.

Business Use Case

Executives use this metric to identify bottlenecks in the loan approval process and implement process improvements.

Business Criticality

High

Journey / Navigation Area

Onboarding

Owning Function

Data Architecture Team

Scope

Global

Formula

SUM(approval_time) / COUNT(approved_loans)

Calculation Notes

1️⃣ Exclude withdrawn applications. 2️⃣ Exclude incomplete applications. 3️⃣ Consider only business hours for timing. 4️⃣ Calculate timing based on business days. 5️⃣ Ensure all relevant applications are valid.

Technical Details

Measure Typeaverage
Aggregation WindowTime based - Daily

Events

SQL Queries

Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT AVG(TIMESTAMP_DIFF(approval_time, application_time, MINUTE)) AS average_loan_approval_time
FROM `your-project.crm.loan_applications`
WHERE approval_time IS NOT NULL AND application_time IS NOT NULL;
Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT AVG(DATEDIFF(approval_time, application_time) * 24 * 60 + TIMESTAMPDIFF(MINUTE, application_time, approval_time)) AS average_loan_approval_time
FROM crm.loan_applications
WHERE approval_time IS NOT NULL AND application_time IS NOT NULL;

Source Data

CRM

Dependencies

[ "Loan Application Event", "Approval Event" ]

Report Attributes

Loan Type Region Approval Channel

Recommended Reporting Views

Views
Loan Operations DashboardEfficiency Metrics Dashboard

Segment Eligibility

true

Governance

Data Sensitivityinternal

Governance

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

GitHub

View File on GitHubcatalog/metrics/average-loan-approval-time.yml

Community Discussion