From the data dictionary here-- https://docs.google.com/a/mozilla.com/spreadsheets/d/1QvDvana0eZSgFgLty2KWbap9CTXxCVy8jm92X1voSWA/edit?pli=1#gid=0 -- we need the data pulled for rows 2 and 16. The output files should get put in the list of things to be slurped up into the content service S3 bucket. Row 2 ===== # of Users installing firefox for the first time, globally, per week weekly (after FHR de-orphaning) "count of payloads satisfying FHR_V2_FIREFOX_PAYLOAD criteria, and with $data$last$org.mozilla.profile.age$profileCreation within the seven day window from 21 to 28 days ago, starting from the date of the deorphaning extraction." Row 16 ====== "Users having the UP addon who have been active in the last month" "count of fhr records satisfying FHR_V2_FIREFOX_MAU definition who have UP installed and active-- i.e. $data$last$org.mozilla.addons.addons has an entry ""email@example.com"" this has been incorporated into Saptarshi's Vertica roll-up table in the column ""tHasUP"""
Done. Ali will be integrating the Content Services data into the dashboard. The data gets regularly generated from the V2 FF FHR Rollups, and put here: /home/hulmer/tmp/dashboards/content-services/up_fhr_weekly_data.csv /home/hulmer/tmp/dashboards/content-services/up_fhr_last_updated.json
Status: NEW → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
Hi Katie, To clarify, who is responsible for pushing these two data files to https://metrics.services.mozilla.com/content-services-dashboard/data
I've added the two UP charts and committed the change. I'll assume that the pushing of the two data files is being tracked in another bug.
The bug for moving files around is https://bugzilla.mozilla.org/show_bug.cgi?id=1134862, I'll update with the info above.
You need to log in before you can comment on or make changes to this bug.