[Test Pilot] Please make the Min Vid experiment data available in re:dash

RESOLVED FIXED

Status

Cloud Services
Metrics: Product Metrics
RESOLVED FIXED
a year ago
a year ago

People

(Reporter: clouserw, Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

a year ago
Min Vid is a new experiment in the Test Pilot pipeline.  It is using the standard Test Pilot submitExternalPing() method.

An example JSON blob:
    
// Example: complete Test Pilot telemetry ping:
{
  "test": "@min-vid",
  "agent": "User Agent String",
  "payload": {
    "object": "player_view",
    "method": "pause", 
    "domain": "youtube.com",
    "played_count": 2, 
    "video_x": 1200,
    "video_y": 1150,
    "video_width": 300,
    "video_height": 110,
    "timestamp": 1470
  }
}
  
And a matching Redshift schema:
    
local schema = {--   column name                   field type   length  attributes   field name
    {"timestamp",                  "TIMESTAMP", nil,    "SORTKEY",   "Timestamp"},
    {"uuid",                       "VARCHAR",   36,      nil,         get_uuid},

    {"test",                       "VARCHAR",   255,     nil,         "Fields[test]"},

    -- Parsed automatically from the `agent` field
    {"user_agent_browser",         "VARCHAR",   255,     nil,         "Fields[user_agent_browser]"},
    {"user_agent_os",              "VARCHAR",   255,     nil,         "Fields[user_agent_os]"},
    {"user_agent_version",         "VARCHAR",   255,     nil,         "Fields[user_agent_version]"},

    {"object",                     "VARCHAR",   255,     nil,         "payload[object]"},
    {"method",                     "VARCHAR",   255,     nil,         "payload[method]"},
    {"domain",                     "VARCHAR",   255,     nil,         "payload[domain]"},
    {"played_count",               "INTEGER",   4,       nil,         "payload[played_count]"},

    {"video_x",                    "INTEGER",   4,       nil,         "payload[video_x]"},
    {"video_y",                    "INTEGER",   4,       nil,         "payload[video_y]"},
    {"video_width",                "INTEGER",   4,       nil,         "payload[video_width]"},
    {"video_height",               "INTEGER",   4,       nil,         "payload[video_height]"}
}

Full Min Vid metrics documentation: https://github.com/meandavejustice/min-vid/blob/master/docs/metrics.md
(Reporter)

Updated

a year ago
Blocks: 1297200

Comment 1

a year ago
Data populated at s3n://net-mozaws-prod-us-west-2-pipeline-analysis/isegall/minvid_daily/v1/activity_date=[date] and ready to import into presto
Flags: needinfo?(mark.bugzilla)

Comment 2

a year ago
Data populated at s3n://net-mozaws-prod-us-west-2-pipeline-analysis/isegall/minvid_daily/v1/activity_date=[date] and ready to import into presto

Comment 3

a year ago
Done!
Status: NEW → RESOLVED
Last Resolved: a year ago
Flags: needinfo?(mark.bugzilla)
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.