Page MenuHomePhabricator

Search Metrics Dashboard: Investigate recent spike in user engagement
Closed, ResolvedPublic


There was a spike in user engagement on Oct 25 - let's check it out and see if there is anything going on.

Screen Shot 2016-12-21 at 10.56.07 AM.png (856×2 px, 155 KB)

Event Timeline

debt triaged this task as Medium priority.Dec 21 2016, 7:48 PM

Yes, let's take a look before the data rolls off (gets removed).

The schema changed from TestSearchSatisfaction2_15700292 to TestSearchSatisfaction2_15922352 on Oct 25, so we ended up having 7896 sessions recorded in TestSearchSatisfaction2_15700292 and 1 session recorded in TestSearchSatisfaction2_15922352 which last longer than 10 seconds. Golden failed to pick up data points from both tables.

@mpopov replaced the user engagement data on Oct 25 with a 90-ish day median for now. After migrating to report updater, maybe we could solve this problem?

We'll need to backfill this data...assigned @mpopov

Thanks @chelsyx for looking into it!

OK, backfilling done (correct value was 0.400330116810564). The corrected data will be sync'd over to in the next 15 minutes or so, and will be visible on the dashboards either later today or tomorrow morning.