Fact Snapshot Email Metrics

Description
Data Category
Modified Time
2024-02-08 00:00:00

Name Type Description Properties
Email Campaign Key 1
Organization Key 1
RowNumber-2662979B-1795-4F74-8F37-6A1BA8059B61 3 Primary Key Unique
Snapshot Email Metrics Create Date Key 1
Snapshot Email Metrics Sent Date Key 1
Snapshot Email Metrics Total Bounces 1
Snapshot Email Metrics Total Clicks 1
Snapshot Email Metrics Total Delivered 1
Snapshot Email Metrics Total Opens 1
Snapshot Email Metrics Total Sent 1
Snapshot Email Metrics Total Unique Clicks 1
Snapshot Email Metrics Total Unique Opens 1
Snapshot Email Metrics Unsubscribe Count 1

Name Expression Description
Sum Email Metrics Bounces SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Total Bounces])
Sum Email Metrics Delivered SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Total Delivered])
Sum Email Metrics Delivery Rate DIVIDE('Fact Snapshot Email Metrics'[Sum Email Metrics Delivered],'Fact Snapshot Email Metrics'[Sum Email Metrics Sent],0)
Sum Email Metrics Open Rate DIVIDE('Fact Snapshot Email Metrics'[Sum Email Metrics Opens],'Fact Snapshot Email Metrics'[Sum Email Metrics Delivered],0)
Sum Email Metrics Opens SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Total Opens])
Sum Email Metrics Sent SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Total Sent])
Sum Email Metrics Total Clicks SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Total Clicks])
Sum Email Metrics Total Clicks Rate DIVIDE('Fact Snapshot Email Metrics'[Sum Email Metrics Total Clicks],'Fact Snapshot Email Metrics'[Sum Email Metrics Delivered],0)
Sum Email Metrics Total Unique Clicks SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Total Unique Clicks])
Sum Email Metrics Total Unique Clicks Rate DIVIDE('Fact Snapshot Email Metrics'[Sum Email Metrics Total Unique Clicks],'Fact Snapshot Email Metrics'[Sum Email Metrics Delivered],0)
Sum Email Metrics Total Unique Opens SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Total Unique Opens])
Sum Email Metrics Total Unique Opens Rate DIVIDE('Fact Snapshot Email Metrics'[Sum Email Metrics Total Unique Opens],'Fact Snapshot Email Metrics'[Sum Email Metrics Delivered],0)
Sum Email Metrics Unsubscribe SUM('Fact Snapshot Email Metrics'[Snapshot Email Metrics Unsubscribe Count])