Fact Email Opens
- Description
- Data Category
- Modified Time
- 2024-03-14 00:00:00
| Name | Type | Description | Properties |
|---|---|---|---|
| Email Campaign Key | 1 | ||
| Email Opens Open Count | 1 | ||
| Email Opens Open Date Key | 1 | ||
| Email Opens Open Time Key | 1 | ||
| Organization Key | 1 | ||
| RowNumber-2662979B-1795-4F74-8F37-6A1BA8059B61 | 3 | Primary Key Unique | |
| User Key | 1 |
| Name | Expression | Description |
|---|---|---|
| Sum Email Opens | SUM('Fact Email Opens'[Email Opens Open Count]) |
|
| Sum of Email Opens Unique Visitor Count | CALCULATE( DISTINCTCOUNT(User[User Id]),'Fact Email Opens') |
| From Table | To Table | Status |
|---|---|---|
| Fact Email Opens Current | Email Campaign | Active |
| Fact Email Opens Current | Email Opens Open Time | Active |
| Fact Email Opens Current | Email Opens Open Date | Active |
| Fact Email Opens Current | User | Active |
| Fact Email Opens Current | Organization | Active |