← Back to Dimensions
Patient Demographics
Also known as: Patient Profile, Demographic Data
Patient Demographics captures essential non-clinical attributes such as age, gender, and location, which are crucial for understanding patient populations and tailoring healthcare services.
Business Use Case
Healthcare executives use Patient Demographics to design targeted health programs and improve patient engagement strategies.
Business Criticality
High
Journey / Navigation Area
Generic
Owning Function
Data Architecture Team
Scope
User
Calculation Notes
Ensure data is anonymized to protect privacy; exclude incomplete records.
Technical Details
Data Typelist
Lookback WindowUser
Events
SQL Queries
Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT patient_id, first_name, last_name, date_of_birth, gender, email, phone_number, address, city, state, zip_code
FROM `your-project.crm.patient_data`
WHERE active_status = 'active';Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT patient_id, first_name, last_name, date_of_birth, gender, email, phone_number, address, city, state, zip_code
FROM crm.patient_data
WHERE active_status = 'active';Source Data
CRM
Dependencies
[ "Patient ID" ]
Report Attributes
Age Gender Location
Segment Eligibility
true
Governance
Data Sensitivityconfidential
Contains PIIYes - This Dimension contains Personally Identifiable Information
Governance
Created bydevyendarm
Created on8/25/2026
Last modified bydevyendarm
StatusPUBLISHED
GitHub
View File on GitHub
catalog/dimensions/patient-demographics.yml