Neither search satisfaction schema is producing data despite the fixes
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ironholds
	Nov 5 2015, 7:45 PM

Description

We have almost no data coming into the search satisfaction schema. This both removes our ability to compute our existing user satisfaction metrics, and acts as a hard blocker on the qualitative/quantitative comparison for a 'complete' user satisfaction model.

mysql:research@analytics-store.eqiad.wmnet [log]> SELECT LEFT(timestamp,8), COUNT(*) FROM TestSearchSatisfaction2_14098806 GROUP BY LEFT(timestamp,8);
+-------------------+----------+
| LEFT(timestamp,8) | COUNT(*) |
+-------------------+----------+
| 20151013          |      393 |
| 20151014          |    18442 |
| 20151015          |    37068 |
| 20151016          |    31343 |
| 20151017          |    25805 |
| 20151018          |    29082 |
| 20151019          |    37371 |
| 20151020          |    33310 |
| 20151021          |    19311 |
| 20151022          |     1520 |
| 20151023          |      770 |
| 20151024          |      547 |
| 20151025          |      665 |
| 20151026          |      511 |
| 20151027          |        2 |
| 20151028          |        4 |
| 20151029          |       41 |
| 20151030          |       27 |
| 20151101          |        1 |
| 20151102          |        3 |
| 20151103          |        1 |
| 20151104          |        4 |
+-------------------+----------+

mysql:research@analytics-store.eqiad.wmnet [log]> SELECT LEFT(timestamp,8), COUNT(*) FROM TestSearchSatisfaction2_13223897 GROUP BY LEFT(timestamp,8);
+-------------------+----------+
| LEFT(timestamp,8) | COUNT(*) |
+-------------------+----------+
| 20150902          |      403 |
| 20150903          |     8529 |
| 20150904          |    37253 |
| 20150905          |    28580 |
| 20150906          |    33704 |
| 20150907          |    39694 |
| 20150908          |    40264 |
| 20150909          |    39626 |
| 20150910          |    39467 |
| 20150911          |    35108 |
| 20150912          |    27881 |
| 20150913          |    33484 |
| 20150914          |    42683 |
| 20150915          |    40480 |
| 20150916          |    37290 |
| 20150917          |    37840 |
| 20150918          |    34397 |
| 20150919          |    28022 |
| 20150920          |    32722 |
| 20150921          |    41661 |
| 20150922          |    40722 |
| 20150923          |    39890 |
| 20150924          |    40336 |
| 20150925          |    33759 |
| 20150926          |    25956 |
| 20150927          |    31002 |
| 20150928          |    41050 |
| 20150929          |    39901 |
| 20150930          |    38618 |
| 20151001          |    37244 |
| 20151002          |    33563 |
| 20151003          |    27702 |
| 20151004          |    32543 |
| 20151005          |    40666 |
| 20151006          |    43115 |
| 20151007          |    41675 |
| 20151008          |    40308 |
| 20151009          |    34178 |
| 20151010          |    31097 |
| 20151011          |    32847 |
| 20151012          |    39495 |
| 20151013          |    41434 |
| 20151014          |       11 |
| 20151015          |       25 |
| 20151016          |        6 |
| 20151017          |        3 |
| 20151018          |        4 |
| 20151019          |        2 |
| 20151021          |     7211 |
| 20151022          |    20585 |
| 20151023          |    15515 |
| 20151024          |    14281 |
| 20151025          |    18003 |
| 20151026          |    13299 |
| 20151027          |        5 |
| 20151028          |        5 |
| 20151029          |        3 |
| 20151030          |        2 |
| 20151031          |        2 |
| 20151101          |        1 |
| 20151103          |        2 |
| 20151105          |        3 |

Event Timeline

Ironholds created this task.Nov 5 2015, 7:45 PM

Ironholds raised the priority of this task from to Unbreak Now!.

Ironholds updated the task description. (Show Details)

Ironholds added a project: Discovery-Search (Current work).

Ironholds subscribed.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 5 2015, 7:45 PM

Resolved; looks like the revert changed the schema number in the db. Wat.

Smalyshev moved this task from Incoming to Needs Reporting on the Discovery-Search (Current work) board.Nov 5 2015, 11:12 PM

• Deskana moved this task from Needs Reporting to Resolved on the Discovery-Search (Current work) board.Nov 20 2015, 5:21 AM

Neither search satisfaction schema is producing data despite the fixesClosed, ResolvedPublicActions

Description

Event Timeline

Neither search satisfaction schema is producing data despite the fixes
Closed, ResolvedPublic
Actions