Mozilla VPN
Data related to the Mozilla VPN service
active_subscription_ids
Active Subscription Ids
mozilla_vpn.active_subscription_ids
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| active_date | Date | Yes | |
| subscription_id | String | Yes |
| 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
| 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 |
| 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
| Column | Description | Type | Nullable |
|---|---|---|---|
| fxa_uid | String | Yes | |
| timestamp | Timestamp | Yes |
| 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
| 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 |
| 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.
| 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 |
Source Directory | View Definition | Metadata File
baseline_clients_daily
Baseline Clients Daily
mozilla_vpn.baseline_clients_daily
Please provide a description for the query
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
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
Source Directory | View Definition | Metadata File
channel_group_proportions
Channel Group Proportions
mozilla_vpn.channel_group_proportions
Please provide a description for the query
| 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 |
| 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.
| 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 |
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.
| 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 |
Source Directory | View Definition | Metadata File
devices
Devices
mozilla_vpn.devices
Please provide a description for the query
| 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 |
| 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
| 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 |
| 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.
| 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 |
Source Directory | View Definition | Metadata File
events_daily
Events Daily
mozilla_vpn.events_daily
Please provide a description for the query
| 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 |
| 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.
| 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
| Column | Description | Type | Nullable |
|---|---|---|---|
| date | Date | Yes | |
| base_currency | String | Yes | |
| quote_currency | String | Yes | |
| price_type | String | Yes | |
| price | Numeric | Yes |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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.
| 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 |
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.
| 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 |
Source Directory | View Definition | Metadata File
metrics_clients_daily
Metrics Clients Daily
mozilla_vpn.metrics_clients_daily
Please provide a description for the query
| 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 |
| 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
| Column | Description | Type | Nullable |
|---|---|---|---|
| fxa_uid | String | Yes | |
| first_protected | Timestamp | Yes |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| 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 |
| 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
| Column | Description | Type | Nullable |
|---|---|---|---|
| id | Integer | Yes | |
| fxa_uid | String | Yes | |
| created_at | Timestamp | Yes |
| 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
| Column | Description | Type | Nullable |
|---|---|---|---|
| country_code | String | Yes | |
| country | String | Yes | |
| vat | Numeric | Yes | |
| effective_date | Date | Yes |
| 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.
| 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 |
Source Directory | View Definition | Metadata File
waitlist
Waitlist
mozilla_vpn.waitlist
Please provide a description for the query
| 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | mozilla_vpn_derived | waitlist_v1 |
Source Directory | View Definition | Metadata File