|
Snapshot Organization Metrics Engagement Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Unique Visitor Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Active Registered User Count],"") |
|
|
Snapshot Organization Metrics Filtered Remove Industry Type Engagement Rate
|
IFERROR([Sum of Snapshot Organization Metrics Filtered Remove Industry Type Unique Visitor Count]/[Sum of Snapshot Organization Metrics Filtered Remove Industry Type Active Registered User Count],"") |
|
|
Snapshot Organization Metrics Filtered Remove Industry Type Participation Rate
|
IFERROR([Sum of Snapshot Organization Metrics Filtered Remove Industry Type Active Registered User Count]/[Sum of Snapshot Organization Metrics Filtered Remove Industry Type Eligible Users],"") |
|
|
Snapshot Organization Metrics Industry Type Engagement Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Industry Type Unique Visitor Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Industry Type Active Registered User Count],"") |
|
|
Snapshot Organization Metrics Industry Type Participation Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Industry Type Active Registered User Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Industry Type Eligible Users],"") |
|
|
Snapshot Organization Metrics IS Core All Clients Engagement Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics IS Core All Clients Unique Visitor Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics IS Core All Clients Active Registered User Count],"") |
|
|
Snapshot Organization Metrics IS Core All Clients Participation Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics IS Core All Clients Active Registered User Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics IS Core All Clients Eligible Users],"") |
|
|
Snapshot Organization Metrics Participation Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Active Registered User Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Eligible Users],"") |
|
|
Snapshot Organization Metrics Selected Engagement Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Selected Unique Visitor Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Selected Active Registered User Count],"") |
|
|
Snapshot Organization Metrics Selected Participation Rate
|
IFERROR('Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Selected Active Registered User Count]/'Fact Snapshot Organization Metrics'[Sum of Snapshot Organization Metrics Selected Eligible Users],"") |
|
|
Sum of Snapshot Organization Metrics Active Registered User Count
|
SUM([Snapshot Organization Metrics Active Registered User Count]) |
|
|
Sum of Snapshot Organization Metrics Commissionable Click Count
|
SUM([Snapshot Organization Metrics Commissionable Click Count]) |
|
|
Sum of Snapshot Organization Metrics Eligible Users
|
SUM([Snapshot Organization Metrics Eligible Users]) |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Offer Click Ct Per Uniq Visitor
|
[Sum of Snapshot Organization Metrics Filtered Remove Industry Type Offer Click Count]/[Sum of Snapshot Organization Metrics Filtered Remove Industry Type Unique Visitor Count] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Active Registered User Count
|
[Sum of Snapshot Organization Metrics Industry Type Active Registered User Count] - [Sum of Snapshot Organization Metrics Selected Active Registered User Count] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Commissionable Click Count
|
[Sum of Snapshot Organization Metrics Industry Type Commissionable Click Count] - [Sum of Snapshot Organization Metrics Selected Commissionable Click Count] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Eligible Users
|
[Sum of Snapshot Organization Metrics Industry Type Eligible Users] - [Sum of Snapshot Organization Metrics Selected Eligible Users] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Offer Click Count
|
[Sum of Snapshot Organization Metrics Industry Type Offer Click Count] - [Sum of Snapshot Organization Metrics Selected Offer Click Count] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Unique Visitor Count
|
[Sum of Snapshot Organization Metrics Industry Type Unique Visitor Count] - [Sum of Snapshot Organization Metrics Selected Unique Visitor Count] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type User Registration Count
|
[Sum of Snapshot Organization Metrics Industry Type User Registration Count] - [Sum of Snapshot Organization Metrics Selected User Registration Count] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Visit Count
|
[Sum of Snapshot Organization Metrics Industry Type Visit Count] - [Sum of Snapshot Organization Metrics Selected Visit Count] |
|
|
Sum of Snapshot Organization Metrics Filtered Remove Industry Type Visit Per Unique Visitor
|
[Sum of Snapshot Organization Metrics Filtered Remove Industry Type Visit Count]/[Sum of Snapshot Organization Metrics Filtered Remove Industry Type Unique Visitor Count] |
|
|
Sum of Snapshot Organization Metrics Industry Type Active Registered User Count
|
CALCULATE([Sum of Snapshot Organization Metrics Active Registered User Count]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type Commissionable Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics Commissionable Click Count]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type Eligible Users
|
CALCULATE([Sum of Snapshot Organization Metrics Eligible Users]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type Offer Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics Total Offer Click Count]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type Offer Click Count Per Unique Visitor
|
[Sum of Snapshot Organization Metrics Industry Type Offer Click Count]/[Sum of Snapshot Organization Metrics Industry Type Unique Visitor Count] |
|
|
Sum of Snapshot Organization Metrics Industry Type Total Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics Total Click Count]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type Unique Visitor Count
|
CALCULATE([Sum of Snapshot Organization Metrics Unique Visitor Count]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type User Registration Count
|
CALCULATE([Sum of Snapshot Organization Metrics User Registration Count]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type Visit Count
|
CALCULATE([Sum of Snapshot Organization Metrics Visit Count]
,REMOVEFILTERS(Organization)
,VALUES(Organization[Organization Industry Type]),Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Industry Type Visit Per Unique Visitor
|
[Sum of Snapshot Organization Metrics Industry Type Visit Count]/[Sum of Snapshot Organization Metrics Industry Type Unique Visitor Count] |
|
|
Sum of Snapshot Organization Metrics IS Core Active Registered User Count
|
CALCULATE([Sum of Snapshot Organization Metrics Active Registered User Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Active Registered User Count
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Active Registered User Count]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Commissionable Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Commissionable Click Count]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Eligible Users
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Eligible Users]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Offer Click Count Per Unique Visitor
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Offer Click Count Per Unique Visitor]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Total Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Total Click Count]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Unique Visitor Count
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Unique Visitor Count]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients User Registration Count
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core User Registration Count]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Visit Count
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Visit Count]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core All Clients Visit Per Unique Visitor
|
CALCULATE([Sum of Snapshot Organization Metrics IS Core Visit Per Unique Visitor]
,REMOVEFILTERS(Organization)
) |
|
|
Sum of Snapshot Organization Metrics IS Core Carousel Offer Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics Total Carousel Offer Click Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Commissionable Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics Commissionable Click Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Eligible Users
|
CALCULATE([Sum of Snapshot Organization Metrics Eligible Users],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Engagement Rate
|
CALCULATE(
[Snapshot Organization Metrics Engagement Rate],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Offer Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics Total Offer Click Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Offer Click Count Per Unique Visitor
|
CALCULATE([Sum of Snapshot Organization Metrics Offer Click Count Per Unique Visitor],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Participation Rate
|
CALCULATE(
[Snapshot Organization Metrics Participation Rate],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Total Click Count
|
CALCULATE([Sum of Snapshot Organization Metrics Total Click Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Total User Search Count
|
CALCULATE([Sum of Snapshot Organization Metrics Total User Search Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Total View Count
|
CALCULATE([Sum of Snapshot Organization Metrics Total View Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Unique Visitor Count
|
CALCULATE([Sum of Snapshot Organization Metrics Unique Visitor Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core User Registration Count
|
CALCULATE([Sum of Snapshot Organization Metrics User Registration Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Visit Count
|
CALCULATE([Sum of Snapshot Organization Metrics Visit Count],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics IS Core Visit Per Unique Visitor
|
CALCULATE([Sum of Snapshot Organization Metrics Visit Per Unique Visitor],
Filter(Organization,Organization[Organization Is Core] = "CORE")
) |
|
|
Sum of Snapshot Organization Metrics Offer Click Count Per Unique Visitor
|
[Sum of Snapshot Organization Metrics Total Offer Click Count]/[Sum of Snapshot Organization Metrics Unique Visitor Count] |
|
|
Sum of Snapshot Organization Metrics Selected Active Registered User Count
|
var OrganName = Organization[Organization Selected]
RETURN
CALCULATE([Sum of Snapshot Organization Metrics Active Registered User Count]
,Filter(Organization,Organization[Organization Name] = OrganName)
,Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Selected Commissionable Click Count
|
var OrganName = Organization[Organization Selected]
RETURN
CALCULATE([Sum of Snapshot Organization Metrics Commissionable Click Count]
,Filter(Organization,Organization[Organization Name] = OrganName)
,Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Selected Eligible Users
|
var OrganName = Organization[Organization Selected]
RETURN
CALCULATE([Sum of Snapshot Organization Metrics Eligible Users]
,Filter(Organization,Organization[Organization Name] = OrganName)
,Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Selected Offer Click Count
|
var OrganName = Organization[Organization Selected]
RETURN
CALCULATE([Sum of Snapshot Organization Metrics Total Click Count]
,Filter(Organization,Organization[Organization Name] = OrganName)
,Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Selected Unique Visitor Count
|
var OrganName = Organization[Organization Selected]
RETURN
CALCULATE([Sum of Snapshot Organization Metrics Unique Visitor Count]
,Filter(Organization,Organization[Organization Name] = OrganName)
,Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Selected User Registration Count
|
var OrganName = Organization[Organization Selected]
RETURN
CALCULATE([Sum of Snapshot Organization Metrics User Registration Count]
,Filter(Organization,Organization[Organization Name] = OrganName)
,Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Selected Visit Count
|
var OrganName = Organization[Organization Selected]
RETURN
CALCULATE([Sum of Snapshot Organization Metrics Visit Count]
,Filter(Organization,Organization[Organization Name] = OrganName)
,Filter('Snapshot Organization Metrics Date','Snapshot Organization Metrics Date'[Snapshot Organization Metrics Date Key] >= [Organization Selected Launch Date])
) |
|
|
Sum of Snapshot Organization Metrics Total Carousel Offer Click Count
|
SUM([Snapshot Organization Metrics Carousel Offer Click Count]) |
|
|
Sum of Snapshot Organization Metrics Total Click Count
|
SUM([Snapshot Organization Metrics Total Click Count]) |
|
|
Sum of Snapshot Organization Metrics Total Offer Click Count
|
SUM([Snapshot Organization Metrics Offer Click Count]) |
|
|
Sum of Snapshot Organization Metrics Total User Search Count
|
SUM([Snapshot Organization Metrics User Search Count]) |
|
|
Sum of Snapshot Organization Metrics Total View Count
|
SUM([Snapshot Organization Metrics Total View Count]) |
|
|
Sum of Snapshot Organization Metrics Unique Visitor Count
|
SUM([Snapshot Organization Metrics Unique Visitor Count]) |
|
|
Sum of Snapshot Organization Metrics User Registration Count
|
SUM([Snapshot Organization Metrics User Registration Count]) |
|
|
Sum of Snapshot Organization Metrics Visit Count
|
SUM([Snapshot Organization Metrics Visit Count]) |
|
|
Sum of Snapshot Organization Metrics Visit Per Unique Visitor
|
[Sum of Snapshot Organization Metrics Visit Count]/[Sum of Snapshot Organization Metrics Unique Visitor Count] |
|