I'd like to calculate WAU for my community, but unfortunately I'm struggling to do that with the Khoros data not matching itself. I would love to know if others of you are calculating the follow Weekly Active Users - Total number of users who visited the community New Users - Number of users who visited the community for the first time. Returning Users - Users who visited the community this week, not for the first time and not having churned in the past week Churned Users - Users who have not visited this week Resurrected Users - Users who have visited after previously churning the week before. As a note, I have done some exploring, but haven't found a great way to calculate these. When I look at overall metrics it just tells me the number of unique visitors (so WAU), but not on an individual basis so there's no data that points to who visited each week and what retention looked like. I have also pulled the user reports where the number of users pulled for a week don't match what's in the community analytics. In addition to that, when I look at the user report I will have instances where a user's most recent sign in is on Dec 3, but when I pull data for the week of Dec 1- Dec 7 it says that user has 0 total sign ins. I'm not sure why this doesn't match up, but am hoping someone could help me here and explain why these don't equal.
... View more