Fact Snapshot User Lifetime Metrics

Description
Data Category
Modified Time
2023-11-07 00:00:00

Name Type Description Properties
Cohort Date Key 1
Organization Key 1
Row_Id_Name 1
RowNumber-2662979B-1795-4F74-8F37-6A1BA8059B61 3 Primary Key Unique
Snapshot User Lifetime Metrics Acivity Type Key 1
Snapshot User Lifetime Metrics Activity Sum 1
Snapshot User Lifetime Metrics Row Id 1

Name Expression Description
Sum Snapshot User Lifetime Metrics Activity SUM('Fact Snapshot User Lifetime Metrics'[Snapshot User Lifetime Metrics Activity Sum])
Sum Snapshot User Lifetime Metrics Activity Total if(HASONEVALUE('Fact Snapshot User Lifetime Metrics Acivity Type'[Snapshot User Lifetime Metrics Acivity Type]), Switch(values('Fact Snapshot User Lifetime Metrics Acivity Type'[Snapshot User Lifetime Metrics Acivity Type]), "Visit",FORMAT('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits],"#,##0"), "Commissionable Click",FORMAT('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Commissionable Click],"#,##0"), "Unique Visitor",FORMAT('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor],"#,##0"), "Commissionable Clicks by Visits",'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Commissionable Clicks by Visits], "Commissionable Clicks by Unique Visitor",'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Commissionable Clicks by Unique Visitor], "Revenue by Visits",'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Revenue by Visits], "Revenue by Unique Visitor",'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Revenue by Unique Visitor], "" ))
Sum Snapshot User Lifetime Metrics Commissionable Click CALCULATE([Sum Snapshot User Lifetime Metrics Activity] ,Filter('Fact Snapshot User Lifetime Metrics','Fact Snapshot User Lifetime Metrics'[Snapshot User Lifetime Metrics Acivity Type Key] = 2) )
Sum Snapshot User Lifetime Metrics Commissionable Clicks by Unique Visitor IF('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Commissionable Click] = 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor] && 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor] > 0, FORMAT('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor],"#,##0"), FORMAT(DIVIDE('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Commissionable Click],'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor],0),"#,##0.00"))
Sum Snapshot User Lifetime Metrics Commissionable Clicks by Visits IF('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Commissionable Click] = 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits] && 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits] > 0, FORMAT('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits],"#,##0"), FORMAT(DIVIDE('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Commissionable Click],'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits],0),"#,##0.00"))
Sum Snapshot User Lifetime Metrics Revenue CALCULATE([Sum Snapshot User Lifetime Metrics Activity] ,Filter('Fact Snapshot User Lifetime Metrics','Fact Snapshot User Lifetime Metrics'[Snapshot User Lifetime Metrics Acivity Type Key] = 6) )
Sum Snapshot User Lifetime Metrics Revenue by Unique Visitor IF('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor Revenue] = 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor] && 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor] > 0, FORMAT('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor],"#,##0"), FORMAT(DIVIDE('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor Revenue],'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Unique Visitor],0),"$#,##0.00"))
Sum Snapshot User Lifetime Metrics Revenue by Visits IF('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Revenue] = 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits] && 'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits] > 0, FORMAT('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits],"#,##0"), FORMAT(DIVIDE('Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Revenue],'Fact Snapshot User Lifetime Metrics'[Sum Snapshot User Lifetime Metrics Visits],0),"$#,##0.00"))
Sum Snapshot User Lifetime Metrics Unique Visitor CALCULATE([Sum Snapshot User Lifetime Metrics Activity] ,Filter('Fact Snapshot User Lifetime Metrics','Fact Snapshot User Lifetime Metrics'[Snapshot User Lifetime Metrics Acivity Type Key] = 3) )
Sum Snapshot User Lifetime Metrics Unique Visitor Revenue CALCULATE([Sum Snapshot User Lifetime Metrics Activity] ,Filter('Fact Snapshot User Lifetime Metrics','Fact Snapshot User Lifetime Metrics'[Snapshot User Lifetime Metrics Acivity Type Key] = 7) )
Sum Snapshot User Lifetime Metrics Visits CALCULATE([Sum Snapshot User Lifetime Metrics Activity] ,Filter('Fact Snapshot User Lifetime Metrics','Fact Snapshot User Lifetime Metrics'[Snapshot User Lifetime Metrics Acivity Type Key] = 1) )