Closed Bug 1273573 Opened 4 years ago Closed 2 years ago

Import FxA uids with created dates into sync redshift


(Cloud Services :: Server: Sync, defect, P3)



(Not tracked)



(Reporter: dcoates, Unassigned)



(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.
I think this should live in the server component?
Component: Sync → Server: Firefox Accounts
Product: Firefox → Cloud Services
As with Bug 1273582 Comment 1, I'm not sure the right component, but "Server: Firefox Accounts" doesn't seem like it...
Yeah, sorry, I created these from "New bug... that blocks this bug" which defaulted the component to Firefox...
Component: Server: Firefox Accounts → Server: Sync
Whiteboard: [sync-metrics]
Assignee: dcoates → nobody
Priority: P1 → P2
Priority: P2 → P3
Do we still need/want this?
Flags: needinfo?(markh)
(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)
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)
> 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)
We've done a lot of metrics pipeline work, closing this out on the assumption that it was either done, or not needed.
Closed: 2 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.