Skip to content

Instantly share code, notes, and snippets.

@gregglind

gregglind/gist:9def0dc05fd51594a4a3 Secret

Created December 1, 2015 16:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gregglind/9def0dc05fd51594a4a3 to your computer and use it in GitHub Desktop.
Save gregglind/9def0dc05fd51594a4a3 to your computer and use it in GitHub Desktop.
Download ZIP
Heartbeat Votes disappear in 42+
Raw
gistfile1.txt
mysql> ## BY VERSION
mysql> SELECT
-> DATE_FORMAT(received_ts,'%Y-%m-%d') as ydm,
-> version,
-> channel,
-> 100*sum(flow_began_ts > 0) / count(received_ts) as pct_began,
-> 100*sum(flow_offered_ts >0) / count(received_ts) as pct_offered,
-> 100*sum(flow_voted_ts > 0)/ count(received_ts) as pct_voted,
-> 100*sum(flow_engaged_ts > 0) / count(received_ts) as pct_engaged,
-> count(received_ts) as N
-> FROM heartbeat_answer
-> WHERE
-> received_ts > timestamp("2015-11-24")
-> AND is_test=0
-> AND survey_id="heartbeat-by-user-first-impression"
-> AND (locale='en-us')
-> #AND version LIKE "4%"
-> GROUP BY version, channel, ydm
-> HAVING
-> N >= 20
->
-> ORDER BY
-> channel,
-> version,
-> ydm
-> ;
+------------+---------+---------+-----------+-------------+-----------+-------------+------+
| ydm | version | channel | pct_began | pct_offered | pct_voted | pct_engaged | N |
+------------+---------+---------+-----------+-------------+-----------+-------------+------+
| 2015-11-24 | 42.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 385 |
| 2015-11-25 | 42.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 381 |
| 2015-11-26 | 42.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 383 |
| 2015-11-27 | 42.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 360 |
| 2015-11-28 | 42.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 398 |
| 2015-11-29 | 42.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 380 |
| 2015-11-30 | 42.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 112 |
| 2015-11-25 | 43.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 21 |
| 2015-11-24 | 44.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 236 |
| 2015-11-25 | 44.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 264 |
| 2015-11-26 | 44.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 201 |
| 2015-11-27 | 44.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 213 |
| 2015-11-28 | 44.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 188 |
| 2015-11-29 | 44.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 198 |
| 2015-11-30 | 44.0a2 | aurora | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 88 |
| 2015-11-24 | 37.0 | beta | 100.0000 | 100.0000 | 13.6364 | 0.0000 | 44 |
| 2015-11-25 | 37.0 | beta | 100.0000 | 100.0000 | 8.8889 | 0.0000 | 45 |
| 2015-11-26 | 37.0 | beta | 100.0000 | 100.0000 | 5.4054 | 0.0000 | 37 |
| 2015-11-27 | 37.0 | beta | 100.0000 | 100.0000 | 10.5263 | 0.0000 | 38 |
| 2015-11-28 | 37.0 | beta | 100.0000 | 100.0000 | 6.8966 | 0.0000 | 29 |
| 2015-11-24 | 38.0 | beta | 100.0000 | 100.0000 | 2.8986 | 0.0000 | 69 |
| 2015-11-25 | 38.0 | beta | 100.0000 | 98.0769 | 9.6154 | 0.0000 | 52 |
| 2015-11-26 | 38.0 | beta | 100.0000 | 98.5075 | 7.4627 | 0.0000 | 67 |
| 2015-11-27 | 38.0 | beta | 100.0000 | 100.0000 | 7.3529 | 0.0000 | 68 |
| 2015-11-28 | 38.0 | beta | 100.0000 | 100.0000 | 5.5556 | 0.0000 | 54 |
| 2015-11-29 | 38.0 | beta | 100.0000 | 97.9167 | 6.2500 | 0.0000 | 48 |
| 2015-11-30 | 38.0 | beta | 100.0000 | 100.0000 | 0.0000 | 0.0000 | 24 |
| 2015-11-25 | 38.0.5 | beta | 100.0000 | 96.6667 | 0.0000 | 0.0000 | 30 |
| 2015-11-26 | 38.0.5 | beta | 100.0000 | 100.0000 | 0.0000 | 0.0000 | 21 |
| 2015-11-24 | 39.0 | beta | 100.0000 | 98.8764 | 6.7416 | 0.0000 | 89 |
| 2015-11-25 | 39.0 | beta | 100.0000 | 98.3871 | 4.8387 | 0.0000 | 62 |
| 2015-11-26 | 39.0 | beta | 100.0000 | 100.0000 | 6.4103 | 0.0000 | 78 |
| 2015-11-27 | 39.0 | beta | 100.0000 | 93.7500 | 4.6875 | 0.0000 | 64 |
| 2015-11-28 | 39.0 | beta | 100.0000 | 100.0000 | 4.9180 | 0.0000 | 61 |
| 2015-11-29 | 39.0 | beta | 100.0000 | 95.2381 | 6.3492 | 0.0000 | 63 |
| 2015-11-30 | 39.0 | beta | 100.0000 | 100.0000 | 6.5217 | 0.0000 | 46 |
| 2015-11-24 | 40.0 | beta | 100.0000 | 100.0000 | 9.2105 | 0.0000 | 76 |
| 2015-11-25 | 40.0 | beta | 100.0000 | 100.0000 | 4.8544 | 0.0000 | 103 |
| 2015-11-26 | 40.0 | beta | 100.0000 | 98.0392 | 8.8235 | 0.0000 | 102 |
| 2015-11-27 | 40.0 | beta | 100.0000 | 98.6486 | 5.4054 | 0.0000 | 74 |
| 2015-11-28 | 40.0 | beta | 100.0000 | 100.0000 | 8.1081 | 0.0000 | 74 |
| 2015-11-29 | 40.0 | beta | 100.0000 | 98.9011 | 2.1978 | 0.0000 | 91 |
| 2015-11-30 | 40.0 | beta | 100.0000 | 100.0000 | 2.4390 | 0.0000 | 41 |
| 2015-11-24 | 41.0 | beta | 100.0000 | 100.0000 | 4.6154 | 0.0000 | 130 |
| 2015-11-25 | 41.0 | beta | 100.0000 | 96.7213 | 4.9180 | 0.0000 | 122 |
| 2015-11-26 | 41.0 | beta | 100.0000 | 98.3607 | 4.0984 | 0.0000 | 122 |
| 2015-11-27 | 41.0 | beta | 100.0000 | 98.3607 | 8.1967 | 0.0000 | 122 |
| 2015-11-28 | 41.0 | beta | 100.0000 | 98.7952 | 3.6145 | 0.0000 | 83 |
| 2015-11-29 | 41.0 | beta | 100.0000 | 100.0000 | 9.1954 | 0.0000 | 87 |
| 2015-11-30 | 41.0 | beta | 100.0000 | 100.0000 | 7.4074 | 0.0000 | 54 |
| 2015-11-24 | 42.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 232 |
| 2015-11-25 | 42.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 213 |
| 2015-11-26 | 42.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 209 |
| 2015-11-27 | 42.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 190 |
| 2015-11-28 | 42.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 156 |
| 2015-11-29 | 42.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 186 |
| 2015-11-30 | 42.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 90 |
| 2015-11-24 | 43.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 2732 |
| 2015-11-25 | 43.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 2526 |
| 2015-11-26 | 43.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 2400 |
| 2015-11-27 | 43.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 2367 |
| 2015-11-28 | 43.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 2078 |
| 2015-11-29 | 43.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 2287 |
| 2015-11-30 | 43.0 | beta | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 1154 |
| 2015-11-24 | 45.0a1 | nightly | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 135 |
| 2015-11-25 | 45.0a1 | nightly | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 125 |
| 2015-11-26 | 45.0a1 | nightly | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 121 |
| 2015-11-27 | 45.0a1 | nightly | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 103 |
| 2015-11-28 | 45.0a1 | nightly | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 99 |
| 2015-11-29 | 45.0a1 | nightly | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 94 |
| 2015-11-30 | 45.0a1 | nightly | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 37 |
| 2015-11-24 | 39.0 | release | 100.0000 | 100.0000 | 10.0000 | 0.0000 | 20 |
| 2015-11-25 | 39.0 | release | 100.0000 | 100.0000 | 9.5238 | 0.0000 | 21 |
| 2015-11-24 | 40.0.3 | release | 100.0000 | 100.0000 | 5.0000 | 0.0000 | 20 |
| 2015-11-26 | 40.0.3 | release | 100.0000 | 96.5517 | 6.8966 | 0.0000 | 29 |
| 2015-11-27 | 40.0.3 | release | 100.0000 | 100.0000 | 3.7037 | 0.0000 | 27 |
| 2015-11-25 | 41.0.1 | release | 100.0000 | 100.0000 | 0.0000 | 0.0000 | 20 |
| 2015-11-24 | 41.0.2 | release | 100.0000 | 100.0000 | 7.5472 | 0.0000 | 53 |
| 2015-11-25 | 41.0.2 | release | 100.0000 | 97.6190 | 2.3810 | 0.0000 | 42 |
| 2015-11-26 | 41.0.2 | release | 100.0000 | 100.0000 | 2.2727 | 0.0000 | 44 |
| 2015-11-27 | 41.0.2 | release | 100.0000 | 100.0000 | 14.2857 | 0.0000 | 21 |
| 2015-11-28 | 41.0.2 | release | 100.0000 | 100.0000 | 3.4483 | 0.0000 | 29 |
| 2015-11-29 | 41.0.2 | release | 100.0000 | 92.8571 | 3.5714 | 0.0000 | 28 |
| 2015-11-24 | 42.0 | release | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 961 |
| 2015-11-25 | 42.0 | release | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 935 |
| 2015-11-26 | 42.0 | release | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 793 |
| 2015-11-27 | 42.0 | release | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 806 |
| 2015-11-28 | 42.0 | release | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 791 |
| 2015-11-29 | 42.0 | release | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 820 |
| 2015-11-30 | 42.0 | release | 100.0000 | 0.0000 | 0.0000 | 0.0000 | 399 |
+------------+---------+---------+-----------+-------------+-----------+-------------+------+
90 rows in set (0.24 sec)
@gregglind
Copy link
Author

There are ZERO recorded OFFERED or VOTES for anything 42+ in any channel.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment