Skip to content

activity_stream

events

A historical view of pings sent for the activity-stream/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

  • Friendly name: Historical Pings for activity-stream/events
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream_stable events_v1

Source Directory | Metadata File | View Definition


impression_stats

A historical view of pings sent for the activity-stream/impression-stats 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

  • Friendly name: Historical Pings for activity-stream/impression-stats
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream_stable impression_stats_v1

Source Directory | Metadata File | View Definition


impression_stats_by_experiment

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream tile_id_types
moz-fx-data-shared-prod activity_stream_bi impression_stats_by_experiment_v1

Source Directory | Metadata File | View Definition


impression_stats_flat

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream tile_id_types
moz-fx-data-shared-prod activity_stream_bi impression_stats_flat_v1

Source Directory | Metadata File | View Definition


on_save_recs

A historical view of pings sent for the activity-stream/on-save-recs 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

  • Friendly name: Historical Pings for activity-stream/on-save-recs
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream_stable on_save_recs_v1

Source Directory | Metadata File | View Definition


pocket_button

A historical view of pings sent for the activity-stream/pocket-button 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

  • Friendly name: Historical Pings for activity-stream/pocket-button
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream_stable pocket_button_v1

Source Directory | Metadata File | View Definition


sessions

A historical view of pings sent for the activity-stream/sessions 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

  • Friendly name: Historical Pings for activity-stream/sessions
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream_stable sessions_v1

Source Directory | Metadata File | View Definition


spoc_fills

A historical view of pings sent for the activity-stream/spoc-fills 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

  • Friendly name: Historical Pings for activity-stream/spoc-fills
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod activity_stream_stable spoc_fills_v1

Source Directory | Metadata File | View Definition


tile_id_types

Referenced Tables
Project Dataset Table
pocket-tiles pocket_tiles_data tile_id_types

Source Directory | Metadata File | View Definition