Skip to content
This repository has been archived by the owner on Jul 23, 2024. It is now read-only.

Update Engagement query templates to divide by active_ticks #123

Closed
jaredlockhart opened this issue Nov 8, 2017 · 1 comment
Closed

Comments

@jaredlockhart
Copy link

To account for unmeasurable user unenrollment in studies, we need to move to computing all of our engagement metrics divided by active ticks until we have a better way to filter for unenrolled users.

@emtwo
Copy link
Contributor

emtwo commented Nov 8, 2017

Average Events Per Active Hour Template (Non-mapped): https://sql.telemetry.mozilla.org/queries/48795
Average Events Per Active Hour Template (Mapped): https://sql.telemetry.mozilla.org/queries/48830

Non-mapped TTest templates:
New Users: https://sql.telemetry.mozilla.org/queries/48422
Existing Users: https://sql.telemetry.mozilla.org/queries/48428

Mapped TTest templates:
New Users: https://sql.telemetry.mozilla.org/queries/48426
Existing Users: https://sql.telemetry.mozilla.org/queries/48433

@emtwo emtwo closed this as completed Nov 8, 2017
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants