Need a couple columns pulled from Saptarshi's Vertica rollups for Content Services dashboard

RESOLVED FIXED

Status

Cloud Services
Metrics: Dashboard
RESOLVED FIXED
3 years ago
3 years ago

People

(Reporter: brendan c, Assigned: Hamilton)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

3 years ago
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 ""firefox.interest.dashboard@up.mozilla""
 
this has been incorporated into Saptarshi's Vertica roll-up table in the column ""tHasUP"""
(Reporter)

Updated

3 years ago
Assignee: nobody → hulmer

Updated

3 years ago
Blocks: 1135839
(Assignee)

Comment 1

3 years ago
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
(Assignee)

Updated

3 years ago
Status: NEW → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED

Comment 2

3 years ago
Hi Katie,

To clarify, who is responsible for pushing these two data files to https://metrics.services.mozilla.com/content-services-dashboard/data

Comment 3

3 years ago
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.

Comment 4

3 years ago
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.