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

Status: RESOLVED FIXED

(Cloud Services :: Metrics: Dashboard, defect)

Description

[brendan c]

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 ""[e-mail]""
 
this has been incorporated into Saptarshi's Vertica roll-up table in the column ""tHasUP"""

Comment 1

[Hamilton]

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

Comment 2

[Ali Almossawi]

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

[Ali Almossawi]

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

[Katie Parlante]

The bug for moving files around is https://bugzilla.mozilla.org/show_bug.cgi?id=1134862, I'll update with the info above.