Garvan Keeley

Results 31 comments of Garvan Keeley

I modified the missing ping query for Beta-only: https://sql.telemetry.mozilla.org/queries/47290/source#128091 Here is how it looks ![screenshot 2017-10-11 13 56 03](https://user-images.githubusercontent.com/5495083/31457818-f8186a52-ae8b-11e7-9cf7-966ba5a12b22.png) We see a huge spike in successful pings, and the missing...

Activity Stream DAU/MAU graph for comparison (release and beta): https://sql.telemetry.mozilla.org/dashboard/activity-stream-ios-release-metrics-summary https://sql.telemetry.mozilla.org/dashboard/activity-stream-ios-metrics-summary-beta-

UT query for Beta DAU: https://sql.telemetry.mozilla.org/queries/47344/source#table

Today's results show trend indicates more healthy pings: Beta DAU accuracy got better also (see bottom 2 rows vs upper rows):

Tip: restrict data to build id with `telemetry_core_parquet`, example for 7227: `metadata.app_build_id='7227'`

Build 7227 went from 1% missing pings and increased to 9% over 3 days:

Downloading the data from build 7473 and manually analyzing it, I see 25 missing ping sequences only: ``` missing 2903B2D6-8BB7-4C42-BCC4-9223B5043F7B, jumped from 142 to 147 missing 2903B2D6-8BB7-4C42-BCC4-9223B5043F7B, jumped from 147...

Here is the reported errors and their counts in Sentry for build 7473 (. These are all *normal* URL connection errors and don't cause ping deletion: ``` -1009: 3 -1001:...

DAU for 10.0: https://sql.telemetry.mozilla.org/queries/47344/source#table

This is for future use with recordEvent, not part of initial event counting work.