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