Skip to content

Mozilla VPN

Data related to the Mozilla VPN service

Source Directory

active_subscription_ids

Active Subscription Ids

mozilla_vpn.active_subscription_ids

Please provide a description for the query

Schema
Column Description Type Nullable
active_date Date Yes
subscription_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived active_subscription_ids_live
moz-fx-data-shared-prod mozilla_vpn_derived active_subscription_ids_v1

Source Directory | View Definition | Metadata File


active_subscriptions

Active Subscriptions

mozilla_vpn.active_subscriptions

Please provide a description for the query

Schema
Column Description Type Nullable
active_date Date Yes
plan_id String Yes
status String Yes
country String Yes
country_name String Yes
entrypoint_experiment String Yes
entrypoint_variation String Yes
utm_campaign String Yes
utm_content String Yes
utm_medium String Yes
utm_source String Yes
utm_term String Yes
provider String Yes
plan_amount Integer Yes
billing_scheme String Yes
plan_currency String Yes
plan_interval String Yes
plan_interval_count Integer Yes
product_id String Yes
product_name String Yes
pricing_plan String Yes
normalized_acquisition_channel String Yes
normalized_campaign String Yes
normalized_content String Yes
normalized_medium String Yes
normalized_source String Yes
website_channel_group String Yes
promotion_codes String No
promotion_discounts_amount Integer Yes
count Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived active_subscriptions_live
moz-fx-data-shared-prod mozilla_vpn_derived active_subscriptions_v1

Source Directory | View Definition | Metadata File


add_device_events

Add Device Events

mozilla_vpn.add_device_events

Please provide a description for the query

Schema
Column Description Type Nullable
fxa_uid String Yes
timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived add_device_events_v1

Source Directory | View Definition | Metadata File


all_subscriptions

All Subscriptions

mozilla_vpn.all_subscriptions

Please provide a description for the query

Schema
Column Description Type Nullable
user_id Integer Yes
customer_id String Yes
subscription_id String Yes
original_subscription_id String Yes
plan_id String Yes
status String Yes
event_timestamp Timestamp Yes
subscription_start_date Timestamp Yes
original_subscription_start_date Timestamp Yes
subscription_start_reason String Yes
created Timestamp Yes
trial_start Timestamp Yes
trial_end Timestamp Yes
canceled_at Timestamp Yes
canceled_for_customer_at String Yes
cancel_at Timestamp Yes
cancel_at_period_end Boolean Yes
ended_at Timestamp Yes
ended_reason String Yes
fxa_uid String Yes
country String Yes
country_name String Yes
user_registration_date Timestamp Yes
entrypoint_experiment String Yes
entrypoint_variation String Yes
utm_campaign String Yes
utm_content String Yes
utm_medium String Yes
utm_source String Yes
utm_term String Yes
provider String Yes
plan_amount Integer Yes
billing_scheme String Yes
plan_currency String Yes
plan_interval String Yes
plan_interval_count Integer Yes
plan_interval_timezone String Yes
product_id String Yes
product_name String Yes
pricing_plan String Yes
billing_grace_period Interval Yes
promotion_codes String No
promotion_discounts_amount Integer Yes
customer_start_date Timestamp Yes
end_date Timestamp Yes
normalized_acquisition_channel String Yes
normalized_campaign String Yes
normalized_content String Yes
normalized_medium String Yes
normalized_source String Yes
website_channel_group String Yes
months_retained Integer Yes
original_subscription_months_retained Integer Yes
current_months_since_subscription_start Integer Yes
current_months_since_original_subscription_start Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived all_subscriptions_v1

Source Directory | View Definition | Metadata File


baseline

App-specific view for Glean ping "baseline"

mozilla_vpn.baseline

This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.baseline, org_mozilla_firefox_vpn.baseline, org_mozilla_ios_firefoxvpn.baseline, org_mozilla_ios_firefoxvpn_network_extension.baseline).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn baseline
moz-fx-data-shared-prod org_mozilla_firefox_vpn baseline
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn baseline
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension baseline

Source Directory | View Definition | Metadata File


baseline_clients_daily

Baseline Clients Daily

mozilla_vpn.baseline_clients_daily

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_firefox_vpn baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension baseline_clients_daily

Source Directory | View Definition | Metadata File


baseline_clients_first_seen

Baseline Clients First Seen

mozilla_vpn.baseline_clients_first_seen

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_firefox_vpn baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension baseline_clients_first_seen

Source Directory | View Definition | Metadata File


baseline_clients_last_seen

Baseline Clients Last Seen

mozilla_vpn.baseline_clients_last_seen

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_firefox_vpn baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension baseline_clients_last_seen

Source Directory | View Definition | Metadata File


channel_group_proportions

Channel Group Proportions

mozilla_vpn.channel_group_proportions

Please provide a description for the query

Schema
Column Description Type Nullable
subscription_start_date Date Yes
country String Yes
country_name String Yes
utm_medium String Yes
utm_source String Yes
utm_campaign String Yes
utm_content String Yes
utm_term String Yes
entrypoint_experiment String Yes
entrypoint_variation String Yes
product_name String Yes
pricing_plan String Yes
plan_interval String Yes
plan_interval_count Integer Yes
provider String Yes
granular_event_type String Yes
new_subscriptions Integer Yes
promotion_codes String No
channel_group String Yes
total_new_subscriptions_for_date Integer Yes
channel_group_percent_of_total_for_date Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived channel_group_proportions_live
moz-fx-data-shared-prod mozilla_vpn_derived channel_group_proportions_v1

Source Directory | View Definition | Metadata File


daemonsession

App-specific view for Glean ping "daemonsession"

mozilla_vpn.daemonsession

This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.daemonsession, org_mozilla_firefox_vpn.daemonsession, org_mozilla_ios_firefoxvpn.daemonsession, org_mozilla_ios_firefoxvpn_network_extension.daemonsession).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn daemonsession
moz-fx-data-shared-prod org_mozilla_firefox_vpn daemonsession
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn daemonsession
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension daemonsession

Source Directory | View Definition | Metadata File


deletion_request

App-specific view for Glean ping "deletion-request"

mozilla_vpn.deletion_request

This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.deletion_request, org_mozilla_firefox_vpn.deletion_request, org_mozilla_ios_firefoxvpn.deletion_request, org_mozilla_ios_firefoxvpn_network_extension.deletion_request).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn deletion_request
moz-fx-data-shared-prod org_mozilla_firefox_vpn deletion_request
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn deletion_request
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension deletion_request

Source Directory | View Definition | Metadata File


devices

Devices

mozilla_vpn.devices

Please provide a description for the query

Schema
Column Description Type Nullable
id Integer Yes
user_id Integer Yes
created_at Timestamp Yes
updated_at Timestamp Yes
platform String Yes
useragent String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived devices_v1

Source Directory | View Definition | Metadata File


event_types

Event Types

mozilla_vpn.event_types

Please provide a description for the query

Schema
Column Description Type Nullable
category String Yes
event String Yes
first_timestamp Timestamp Yes
numeric_index Integer Yes
index String Yes
event_properties Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived event_types_v1

Source Directory | View Definition | Metadata File


events

App-specific view for Glean ping "events"

mozilla_vpn.events

This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.events, org_mozilla_firefox_vpn.events, org_mozilla_ios_firefoxvpn.events, org_mozilla_ios_firefoxvpn_network_extension.events).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn events
moz-fx-data-shared-prod org_mozilla_firefox_vpn events
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn events
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension events

Source Directory | View Definition | Metadata File


events_daily

Events Daily

mozilla_vpn.events_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
sample_id Integer Yes
events String Yes
app_build String Yes
app_channel String Yes
app_display_version String Yes
architecture String Yes
first_run_date String Yes
telemetry_agent String Yes
telemetry_sdk_build String Yes
locale String Yes
city String Yes
country String Yes
subdivision1 String Yes
channel String Yes
os String Yes
os_version String Yes
experiments Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived events_daily_v1

Source Directory | View Definition | Metadata File


events_unnested

Events unnested view for Mozilla VPN

mozilla_vpn.events_unnested

This is a view that automatically unnests the events data sent by Mozilla VPN's "main" ping. Ordinarily this table is automatically generated by glean_usage, but that currently assumes that events are sent in an "events" ping.

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn main

Source Directory | View Definition | Metadata File


exchange_rates

Exchange Rates

mozilla_vpn.exchange_rates

Please provide a description for the query

Schema
Column Description Type Nullable
date Date Yes
base_currency String Yes
quote_currency String Yes
price_type String Yes
price Numeric Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived exchange_rates_v1

Source Directory | View Definition | Metadata File


funnel_fxa_login_to_protected

Funnel Fxa Login To Protected

mozilla_vpn.funnel_fxa_login_to_protected

Please provide a description for the query

Schema
Column Description Type Nullable
id String Yes
fxa_uid String Yes
start_date Date Yes
completed_login Boolean Yes
registered_user Boolean Yes
paid_for_subscription Boolean Yes
registered_device Boolean Yes
protected Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived funnel_fxa_login_to_protected_v1

Source Directory | View Definition | Metadata File


funnel_ga_to_subscriptions

Funnel Ga To Subscriptions

mozilla_vpn.funnel_ga_to_subscriptions

Please provide a description for the query

Schema
Column Description Type Nullable
date Date Yes
utm_join String Yes
site String Yes
normalized_acquisition_channel String Yes
normalized_medium String Yes
normalized_source String Yes
normalized_campaign String Yes
normalized_content String Yes
website_channel_group String Yes
sessions Integer Yes
sessions_in_available_geos Integer Yes
subscribe_intent Integer Yes
subscription_intent_in_available_geos Integer Yes
total_new_subscriptions Integer Yes
returning_subscriptions Integer Yes
first_time_subscriptions Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived funnel_ga_to_subscriptions_v1

Source Directory | View Definition | Metadata File


funnel_product_page_to_subscribed

Funnel Product Page To Subscribed

mozilla_vpn.funnel_product_page_to_subscribed

Please provide a description for the query

Schema
Column Description Type Nullable
partition_date Date Yes
country String Yes
utm_medium String Yes
utm_source String Yes
utm_campaign String Yes
utm_content String Yes
utm_term String Yes
entrypoint_experiment String Yes
entrypoint_variation String Yes
ua_browser String Yes
ua_version String Yes
os_name String Yes
os_version String Yes
entrypoint String Yes
product_id String Yes
product_name String Yes
plan_id String Yes
pricing_plan String Yes
plan_name String Yes
promotion_code String Yes
vpn_site_hits Integer Yes
channel_group String Yes
total_acquisition_process_start Integer Yes
total_payment_setup_engage Integer Yes
total_payment_setup_complete Integer Yes
overall_total_vpn_site_hits Integer Yes
overall_total_acquisition_process_start Integer Yes
overall_total_payment_setup_complete Integer Yes
new_fxa_user_input_emails Integer Yes
new_fxa_payment_setup_engage Integer Yes
new_fxa_payment_setup_complete Integer Yes
overall_new_fxa_user_input_emails Integer Yes
overall_new_fxa_payment_setup_complete Integer Yes
existing_fxa_payment_setup_view Integer Yes
existing_fxa_payment_setup_engage Integer Yes
existing_fxa_payment_setup_complete Integer Yes
existing_fxa_signedin_payment_setup_view Integer Yes
existing_fxa_signedin_payment_setup_engage Integer Yes
existing_fxa_signedin_payment_setup_complete Integer Yes
overall_existing_fxa_signedin_payment_setup_complete Integer Yes
overall_existing_fxa_signedin_payment_setup_view Integer Yes
existing_fxa_signedoff_signin_cta_click Integer Yes
overall_existing_fxa_signedoff_signin_cta_click Integer Yes
existing_signedoff_fxa_payment_setup_view Integer Yes
existing_fxa_signedoff_payment_setup_engage Integer Yes
existing_fxa_signedoff_payment_setup_complete Integer Yes
overall_existing_fxa_signedoff_payment_setup_complete Integer Yes
overall_existing_signedoff_fxa_payment_setup_view Integer Yes
subscribe_coupon_submit Integer Yes
subscribe_coupon_fail Integer Yes
subscribe_coupon_success Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived funnel_product_page_to_subscribed_v1

Source Directory | View Definition | Metadata File


login_flows

Login Flows

mozilla_vpn.login_flows

Please provide a description for the query

Schema
Column Description Type Nullable
flow_id String Yes
flow_started Timestamp Yes
flow_completed Timestamp Yes
fxa_uids String No
viewed_email_first_page Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived login_flows_v1

Source Directory | View Definition | Metadata File


main

App-specific view for Glean ping "main"

mozilla_vpn.main

This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.main, org_mozilla_firefox_vpn.main, org_mozilla_ios_firefoxvpn.main, org_mozilla_ios_firefoxvpn_network_extension.main).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn main
moz-fx-data-shared-prod org_mozilla_firefox_vpn main
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn main
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension main

Source Directory | View Definition | Metadata File


metrics

App-specific view for Glean ping "metrics"

mozilla_vpn.metrics

This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.metrics, org_mozilla_firefox_vpn.metrics, org_mozilla_ios_firefoxvpn.metrics, org_mozilla_ios_firefoxvpn_network_extension.metrics).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn metrics
moz-fx-data-shared-prod org_mozilla_firefox_vpn metrics
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn metrics
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension metrics

Source Directory | View Definition | Metadata File


metrics_clients_daily

Metrics Clients Daily

mozilla_vpn.metrics_clients_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
sample_id Integer Yes
normalized_channel String Yes
n_metrics_ping Integer Yes
days_sent_metrics_ping_bits Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived metrics_clients_daily_v1

Source Directory | View Definition | Metadata File


protected

Protected

mozilla_vpn.protected

Please provide a description for the query

Schema
Column Description Type Nullable
fxa_uid String Yes
first_protected Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived protected_v1

Source Directory | View Definition | Metadata File


site_metrics_summary

Site Metrics Summary

mozilla_vpn.site_metrics_summary

Please provide a description for the query

Schema
Column Description Type Nullable
date Date Yes
device_category String Yes
operating_system String Yes
browser String Yes
language String Yes
country String Yes
source String Yes
medium String Yes
campaign String Yes
content String Yes
site String Yes
sessions Integer Yes
non_fx_sessions Integer Yes
subscribe_intent_goal Integer Yes
non_fx_subscribe_intent_goal Integer Yes
join_waitlist_intent_goal Integer Yes
join_waitlist_success_goal Integer Yes
sign_in_intent_goal Integer Yes
download_intent_goal Integer Yes
download_installer_intent_goal Integer Yes
standardized_country_name String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived site_metrics_summary_v1

Source Directory | View Definition | Metadata File


subscription_events

Subscription Events

mozilla_vpn.subscription_events

Please provide a description for the query

Schema
Column Description Type Nullable
event_date Date Yes
event_type String Yes
granular_event_type String Yes
plan_id String Yes
status String Yes
country String Yes
country_name String Yes
entrypoint_experiment String Yes
entrypoint_variation String Yes
utm_campaign String Yes
utm_content String Yes
utm_medium String Yes
utm_source String Yes
utm_term String Yes
provider String Yes
plan_amount Integer Yes
billing_scheme String Yes
plan_currency String Yes
plan_interval String Yes
plan_interval_count Integer Yes
product_id String Yes
product_name String Yes
pricing_plan String Yes
normalized_acquisition_channel String Yes
normalized_campaign String Yes
normalized_content String Yes
normalized_medium String Yes
normalized_source String Yes
website_channel_group String Yes
promotion_codes String No
count Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived subscription_events_live
moz-fx-data-shared-prod mozilla_vpn_derived subscription_events_v1

Source Directory | View Definition | Metadata File


subscriptions

Subscriptions

mozilla_vpn.subscriptions

Please provide a description for the query

Schema
Column Description Type Nullable
id Integer Yes
user_id Integer Yes
is_active Boolean Yes
created_at Timestamp Yes
ended_at Timestamp Yes
updated_at Timestamp Yes
type String Yes
provider String Yes
apple_receipt Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived subscriptions_v1

Source Directory | View Definition | Metadata File


survey_cancellation_of_service

Survey Cancellation Of Service

mozilla_vpn.survey_cancellation_of_service

Please provide a description for the query

Schema
Column Description Type Nullable
survey_data Record No
response_time Integer Yes
session_id String Yes
submission_date Date Yes
id Integer Yes
status String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived survey_cancellation_of_service_v1

Source Directory | View Definition | Metadata File


survey_intercept_q3

Survey Intercept Q3

mozilla_vpn.survey_intercept_q3

Please provide a description for the query

Schema
Column Description Type Nullable
survey_data Record No
response_time Integer Yes
session_id String Yes
submission_date Date Yes
id Integer Yes
status String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived survey_intercept_q3_v1

Source Directory | View Definition | Metadata File


survey_lifecycle_28d_desktop

Survey Lifecycle 28d Desktop

mozilla_vpn.survey_lifecycle_28d_desktop

Please provide a description for the query

Schema
Column Description Type Nullable
survey_data Record No
response_time Integer Yes
session_id String Yes
submission_date Date Yes
id Integer Yes
status String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived survey_lifecycle_28d_desktop_v1

Source Directory | View Definition | Metadata File


survey_lifecycle_28d_mobile

Survey Lifecycle 28d Mobile

mozilla_vpn.survey_lifecycle_28d_mobile

Please provide a description for the query

Schema
Column Description Type Nullable
survey_data Record No
response_time Integer Yes
session_id String Yes
submission_date Date Yes
id Integer Yes
status String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived survey_lifecycle_28d_mobile_v1

Source Directory | View Definition | Metadata File


survey_market_fit

Survey Market Fit

mozilla_vpn.survey_market_fit

Please provide a description for the query

Schema
Column Description Type Nullable
survey_data Record No
response_time Integer Yes
session_id String Yes
submission_date Date Yes
id Integer Yes
status String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived survey_market_fit_v1

Source Directory | View Definition | Metadata File


survey_product_quality

Survey Product Quality

mozilla_vpn.survey_product_quality

Please provide a description for the query

Schema
Column Description Type Nullable
survey_data Record No
response_time Integer Yes
session_id String Yes
submission_date Date Yes
id Integer Yes
status String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived survey_product_quality_v1

Source Directory | View Definition | Metadata File


survey_recommend

Survey Recommend

mozilla_vpn.survey_recommend

Please provide a description for the query

Schema
Column Description Type Nullable
survey_data Record No
response_time Integer Yes
session_id String Yes
submission_date Date Yes
id Integer Yes
status String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived survey_recommend_v1

Source Directory | View Definition | Metadata File


users

Users

mozilla_vpn.users

Please provide a description for the query

Schema
Column Description Type Nullable
id Integer Yes
fxa_uid String Yes
created_at Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived users_v1

Source Directory | View Definition | Metadata File


vat_rates

Vat Rates

mozilla_vpn.vat_rates

Please provide a description for the query

Schema
Column Description Type Nullable
country_code String Yes
country String Yes
vat Numeric Yes
effective_date Date Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived vat_rates_v1

Source Directory | View Definition | Metadata File


vpnsession

App-specific view for Glean ping "vpnsession"

mozilla_vpn.vpnsession

This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.vpnsession, org_mozilla_firefox_vpn.vpnsession, org_mozilla_ios_firefoxvpn.vpnsession, org_mozilla_ios_firefoxvpn_network_extension.vpnsession).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozillavpn vpnsession
moz-fx-data-shared-prod org_mozilla_firefox_vpn vpnsession
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn vpnsession
moz-fx-data-shared-prod org_mozilla_ios_firefoxvpn_network_extension vpnsession

Source Directory | View Definition | Metadata File


waitlist

Waitlist

mozilla_vpn.waitlist

Please provide a description for the query

Schema
Column Description Type Nullable
platforms String No
country String Yes
region String Yes
region_subdivision String Yes
waitlist_date Date Yes
joined_date Date Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_vpn_derived waitlist_v1

Source Directory | View Definition | Metadata File