1201488 - Need daily stats on FxA signups per day broken down by entrypoint and service

Status: RESOLVED INVALID

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

Description

[Shane Tomlinson [:stomlinson]]

FxA's growth has gone through the roof since the new firstrun flow was released that adds FxA to the Firefox firstrun page. Both the Growth and FxA teams would like to run queries to see how many accounts are created per day, broken down by entrypoint and service/client_id.

Ideally, the data would be output as a CSV.

I am happy to write the Heka Lua filter, but will need mentoring through the process.

Comment 1

[Katie Parlante]

Hi Shane, I'm adding trink as a mentor.

I believe your request is a modest tweak to what we're doing for "account creates by service". Pointers to code involved:
https://github.com/mozilla-services/puppet-config/blob/master/shared/modules/fxa/files/hekad/lua_filters/fxa_creates.lua
https://github.com/mozilla-services/puppet-config/blob/5279e6d08190fe8279a38ddcb5868bb201b3ae66/shared/modules/fxa/templates/hekad/auth.toml.erb#L122
https://github.com/mozilla/accounts-dashboard/blob/master/js/main.js#L171
https://metrics.services.mozilla.com/accounts-dashboard/data/fxa_creates_by_service_1day.json

Perhaps the next step is to set up a time to talk to trink. One suggestion is doing a "pair programming" session with him to modify the filter.

Comment 2

[Thomas Huelbert]

I believe Cmore looking for some data by the end of the month. Assigning to Shane based on Katies comments. If that's incorrect (or the timeline is not achievable), please bounce back. Thanks!

Comment 3

[Katie Parlante]

Checking in on this bug... Shane, do you expect to take this on, or should we take it?

Comment 4

[Ryan Kelly [:rfkelly]]

I wonder if much of this is covered by https://github.com/mozilla-services/puppet-config/pull/1612 ?

Comment 5

[Shane Tomlinson [:stomlinson]]

:kparlante, thanks for asking. I'm going to be out for large portions of the rest of this quarter. If your team could pick up what is not yet covered, that'd be awesome.

Comment 6

[Shane Tomlinson [:stomlinson]]

I'm closing this as invalid. This data is available in re:dash now that pb has done all the grunt work to make it so.