1311816 - Make desktop retention data available in re:dash

Status: RESOLVED FIXED

(Cloud Services Graveyard :: Metrics: Pipeline, defect, P1)

Description

[Chris More [:cmore]]

In bug 1226379, we ported python programs that created retention roll ups from FHR to telemetry. We want to have the same rolls ups available in re:dash for more ad hoc analysis.

This will be needed for regular retention reporting and also the desktop attribution project in bug 1259607 and specifically the reporting needs for attribution in bug 1309290.

These are the tableau reports that we use now and the fields that are available to tableau, should be the same fields that should be available in re:dash.

Comment 1

[Anthony Miyaguchi [:amiyaguchi]]

Are there any particular requirements on how far back this dataset should go? The churn dataset is currently available on redash under presto as the table `churn`, between the dates of September 4 - December 4 2016.

Comment 2

[Chris More [:cmore]]

(In reply to Anthony Miyaguchi [:amiyaguchi] from comment #1)
> Are there any particular requirements on how far back this dataset should
> go? The churn dataset is currently available on redash under presto as the
> table `churn`, between the dates of September 4 - December 4 2016.

given the 180 day moving window of telemetry, you probably won't go back any further than that. September 2016 should be fine as how far back to go.

Comment 3

[Anthony Miyaguchi [:amiyaguchi]]

The churn dataset should now be generated weekly and available to redash. I'll be watching this over the next week or two to make sure that everything is working okay.