If you are trying to manage customer or employee engagement, but have no quantitative understanding of impressions, engagements, and conversions, then you have zero grasp of your reach. If basics are covered, you should focus on the quality of the engagement. Streak Analysis could be very useful to understand patterns of engagement. Learn how to create the DAX calculations and use them in a report in this video.
Max Streaks reveal the longest continuous user engagement, indicating peak interest.
Avg Streaks, on the other hand, show the overall consistency of engagement across campaigns.
The Streaks are calculated in two steps, the first step is to calculate the Last Streak Duration for the specified User, Campaign and Date
LastStreak =
var _user = SELECTEDVALUE(User[User])
var _campagin = SELECTEDVALUE(Campaign[Campaign])
var _last_date = MAX('Date'[Date])
var _last_streak_start_date =
CALCULATE(MAX(Activity[Date]),
FILTER(ALL(Activity),
Activity[User] = _user &&
Activity[Campaign] = _campagin &&
Activity[hasEngaged] = FALSE() &&
Activity[Date]<_last_date)
)
var _streak = CALCULATE(COUNTROWS(Activity),
FILTER(ALL(Activity),
Activity[User] = _user &&
Activity[Campaign] = _campagin &&
Activity[Date]<= _last_date &&
Activity[Date]>= _last_streak_start_date &&
Activity[hasEngaged] = TRUE())
)
return _streak
Avg Streak =
CALCULATE(AVERAGEX(ADDCOLUMNS(Activity, "_streak", [LastStreak]), [_streak]))
Max Streak =
CALCULATE(MAXX(ADDCOLUMNS(Activity, "_streak", [LastStreak]), [_streak]))
business intelligist 