Closed
Bug 1273573
Opened 8 years ago
Closed 6 years ago
Import FxA uids with created dates into sync redshift
Categories
(Cloud Services Graveyard :: Server: Sync, defect, P3)
Cloud Services Graveyard
Server: Sync
Tracking
(Not tracked)
RESOLVED
INCOMPLETE
People
(Reporter: dcoates, Unassigned)
References
Details
(Whiteboard: [sync-metrics])
I'm currently looking for a uid's earliest activity date to determine when a user was created. It works ok for now, but will get increasingly slower as we get more data. The better way to do it is to get it from FxA. This will make cohort analysis like retention much easier. We need an archive of the existing uids and a mechanism to get new uids.
Comment 1•8 years ago
|
||
I think this should live in the server component?
Component: Sync → Server: Firefox Accounts
Product: Firefox → Cloud Services
Comment 2•8 years ago
|
||
As with Bug 1273582 Comment 1, I'm not sure the right component, but "Server: Firefox Accounts" doesn't seem like it...
Reporter | ||
Comment 3•8 years ago
|
||
Yeah, sorry, I created these from "New bug... that blocks this bug" which defaulted the component to Firefox...
Component: Server: Firefox Accounts → Server: Sync
Reporter | ||
Updated•8 years ago
|
Whiteboard: [sync-metrics]
Reporter | ||
Updated•8 years ago
|
Assignee: dcoates → nobody
Updated•8 years ago
|
Priority: P1 → P2
Updated•8 years ago
|
Priority: P2 → P3
Comment 5•7 years ago
|
||
(In reply to Ryan Kelly [:rfkelly] from comment #4) > Do we still need/want this? I don't know :) IIRC, this was so we could track things like "how long after account creation was a second device added" etc. I've no plans for any metrics that would require this, but Alex might - if he doesn't care either I think we can close this. Alex, do you want this for any metrics you've identified?
Flags: needinfo?(markh) → needinfo?(adavis)
Comment 6•7 years ago
|
||
IIUC, we can do all of what is described above through FxA data. - Creation dates - Number of synced devices - Retention rates The only thing missing from FxA is the full history of account creation dates (discussed with Ryan this week) but I don't think it's a stopper since I'm sure we can add it to Redshift if we think it's necessary to answer questions. Only question I have... Is the FxA uid in Sync data on Presto the same as that of FxA data in Redshift? If so, this could allow us to join data in the future and simplifies everything. There is apparently a way to query across data sources in Re:Dash.
Flags: needinfo?(adavis) → needinfo?(rfkelly)
Comment 7•7 years ago
|
||
> Is the FxA uid in Sync data on Presto the same as that of FxA data in Redshift
I believe so, yes. If it's not then we should fix that to make sure it is.
Flags: needinfo?(rfkelly)
Comment 8•6 years ago
|
||
We've done a lot of metrics pipeline work, closing this out on the assumption that it was either done, or not needed.
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → INCOMPLETE
Updated•1 year ago
|
Product: Cloud Services → Cloud Services Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•