1355988 - Provide search cohort churn data via csv

Status: RESOLVED FIXED

(Data Platform and Tools :: General, enhancement, P1)

Description

[Matt Pressman [:mpressman]]

We need the following:
channel,
geo,
is_funnelcake,
acquisition_period,
start_version,
sync_usage,
current_version,
current_week,
source,
medium,
campaign,
content,
distribution_id,
default_search_engine,
locale,
is_active,
n_profiles,
usage_hours,
sum_squared_usage_hours

If you can output that to:
s3://net-mozaws-prod-us-west2-pipeline-analysis/amiyaguchi/churn_csv

Thanks!

Comment 1

[Anthony Miyaguchi [:amiyaguchi]]

I think this should be seen as a stopgap measure while other solutions to import this dataset into vertica are worked out. There have been some good alternatives proposed for syncing and moving this data, including querying directly from Presto/Athena.

Comment 2

[Anthony Miyaguchi [:amiyaguchi]]

Attachment: Bug 1355988 - Provide search cohort churn data via csv #56

Comment 3

[Anthony Miyaguchi [:amiyaguchi]]

This data should be generated alongside the other csv files. The output csv files are gzip compressed in s3://net-mozaws-prod-us-west2-pipeline-analysis/amiyaguchi/churn_csv/week_start={week start date}.