User-facing views related to document namespace pocket; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/pocket
events
Events
pocket.events
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_timestamp | Timestamp | Yes | |
| normalized_app_id | String | Yes | |
| metadata | Record | Yes | |
| client_info | Record | Yes | |
| event | String | Yes | |
| event_timestamp | Timestamp | Yes | |
| event_extra | Json | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | pocket_derived | events_v1 |
Source Directory | View Definition | Metadata File
fire_tv_events
Historical Pings for pocket/fire-tv-events
pocket.fire_tv_events
A historical view of pings sent for the
pocket/fire-tv-events
document type.
This view is guaranteed to contain only complete days
(per submission_timestamp)
and to contain only one row per distinct document_id within a given date.
Clustering fields: normalized_channel, sample_id
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| created | Integer | Yes | |
| device | String | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| locale | String | Yes | |
| metadata | Record | Yes | |
| normalized_app_name | Set to "Other" if this message contained an unrecognized app name | String | Yes |
| normalized_channel | Set to "Other" if this message contained an unrecognized channel name | String | Yes |
| normalized_country_code | An ISO 3166-1 alpha-2 country code | String | Yes |
| normalized_os | Set to "Other" if this message contained an unrecognized OS name | String | Yes |
| normalized_os_version | String | Yes | |
| os | String | Yes | |
| osversion | String | Yes | |
| pocket_id | String | Yes | |
| process_start_timestamp | Integer | Yes | |
| sample_id | Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 | Integer | Yes |
| seq | Integer | Yes | |
| submission_timestamp | Time when the ingestion edge server accepted this message | Timestamp | Yes |
| v | Integer | Yes | |
| events | Record | No |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | pocket_stable | fire_tv_events_v1 |
Source Directory | View Definition | Metadata File
pocket_reach_mau
Pocket Reach Mau
pocket.pocket_reach_mau
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| date | Date | Yes | |
| mau | Numeric | Yes |
| Project | Dataset | Table |
|---|---|---|
| pocket-airflow-prod | data_from_pocket | pocket_reach_mau |
Source Directory | View Definition | Metadata File
rolling_monthly_active_user_counts
Rolling Monthly Active User Counts
pocket.rolling_monthly_active_user_counts
Rolling count of monthly active users (MAU) for Pocket.
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| measured_at | Activity date represented by this row | Date | Yes |
| user_count | Number of Pocket monthly active users on this measured_at date | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | pocket_derived | rolling_monthly_active_user_counts_v1 |
Source Directory | View Definition | Metadata File
spoc_tile_ids
Sponsored Content (Spoc) Tile IDs
pocket.spoc_tile_ids
Lookup table of the currently registered tile IDs for Pocket sponsored content
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| tile_id | Numeric ID for the tile | Integer | Yes |
| type | Type of content (should always be 'spoc') | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | pocket_derived | spoc_tile_ids_v1 |
Source Directory | View Definition | Metadata File
twice_weekly_active_user_counts
Twice Weekly Active User Counts
pocket.twice_weekly_active_user_counts
Count of twice weekly active users (T-WAU) for Pocket, measured each calendar week.
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| active_at | Calendar week represented by this row | Date | Yes |
| user_count | Number of Pocket twice weekly active users on this date | Integer | Yes |
| yearly_cumulative_user_count | Cumulative TWAU for the year up to this active_at date | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | pocket_derived | twice_weekly_active_user_counts_v1 |
Source Directory | View Definition | Metadata File