Revenue trends db is mostly complete now
diff --git a/revenue_trends.dashboard.lookml b/revenue_trends.dashboard.lookml
index 42d0d63..de5d8f6 100644
--- a/revenue_trends.dashboard.lookml
+++ b/revenue_trends.dashboard.lookml
@@ -268,1112 +268,1112 @@
col: 3
width: 7
height: 3
- # - title: MTD
- # name: MTD
- # model: cloud_sales_bi
- # explore: revenue
- # type: single_value
- # fields: [revenue.month_to_date, revenue.revenue_toggle]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.month_to_date: "-NULL"
- # revenue.usage_month: 3 months
- # revenue.metric_selector: blended
- # sorts: [revenue.month_to_date desc]
- # limit: 500
- # dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
- # label: MoM %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
- # table_calculation: mom, _type_hint: number}]
- # query_timezone: America/Los_Angeles
- # custom_color_enabled: true
- # show_single_value_title: true
- # show_comparison: true
- # comparison_type: change
- # comparison_reverse_colors: false
- # show_comparison_label: true
- # enable_conditional_formatting: false
- # conditional_formatting_include_totals: false
- # conditional_formatting_include_nulls: false
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_view_names: false
- # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
- # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
- # showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
- # tickDensityCustom: 5, type: linear}]
- # show_y_axis_labels: true
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: true
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: normal
- # limit_displayed_rows: false
- # legend_position: center
- # series_types: {}
- # point_style: none
- # show_value_labels: true
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # show_null_points: true
- # interpolation: linear
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # hidden_fields: []
- # note_state: collapsed
- # note_display: hover
- # note_text: Based on Sales Revenue
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 7
- # col: 17
- # width: 7
- # height: 3
- # - title: QTD
- # name: QTD
- # model: cloud_sales_bi
- # explore: revenue
- # type: single_value
- # fields: [revenue.quarter_to_date, revenue.revenue_toggle]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.usage_month: 3 quarters
- # revenue.quarter_to_date: "-NULL"
- # revenue.metric_selector: blended
- # sorts: [revenue.quarter_to_date desc]
- # limit: 500
- # dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
- # label: QoQ %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
- # table_calculation: qoq, _type_hint: number}]
- # query_timezone: America/Los_Angeles
- # custom_color_enabled: true
- # show_single_value_title: true
- # show_comparison: true
- # comparison_type: change
- # comparison_reverse_colors: false
- # show_comparison_label: true
- # enable_conditional_formatting: false
- # conditional_formatting_include_totals: false
- # conditional_formatting_include_nulls: false
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_view_names: false
- # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
- # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
- # showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
- # tickDensityCustom: 5, type: linear}]
- # show_y_axis_labels: true
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: true
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: normal
- # limit_displayed_rows: false
- # legend_position: center
- # series_types: {}
- # point_style: none
- # show_value_labels: true
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # show_null_points: true
- # interpolation: linear
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # hidden_fields: []
- # note_state: collapsed
- # note_display: hover
- # note_text: Based on Sales Revenue
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 7
- # col: 10
- # width: 7
- # height: 3
- # - title: Navigation
- # name: Navigation
- # model: cloud_sales_bi
- # explore: pommelhorse_links
- # type: looker_grid
- # fields: [pommelhorse_links.link_name]
- # filters:
- # pommelhorse_links.category: Revenue Detail
- # pommelhorse_links.link_size: 1em
- # sorts: [pommelhorse_links.link_name]
- # limit: 500
- # column_limit: 50
- # query_timezone: America/Los_Angeles
- # show_view_names: false
- # show_row_numbers: false
- # transpose: false
- # truncate_text: false
- # hide_totals: false
- # hide_row_totals: false
- # size_to_fit: true
- # table_theme: white
- # limit_displayed_rows: false
- # enable_conditional_formatting: false
- # header_text_alignment: left
- # header_font_size: '18'
- # rows_font_size: '18'
- # conditional_formatting_include_totals: false
- # conditional_formatting_include_nulls: false
- # show_sql_query_menu_options: false
- # show_totals: true
- # show_row_totals: true
- # series_labels:
- # pommelhorse_links.link_name: Navigation
- # custom_color_enabled: true
- # show_single_value_title: true
- # show_comparison: false
- # comparison_type: value
- # comparison_reverse_colors: false
- # show_comparison_label: true
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_y_axis_labels: true
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: true
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # legend_position: center
- # point_style: none
- # show_value_labels: false
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # series_types: {}
- # hidden_fields: []
- # y_axes: []
- # title_hidden: true
- # listen:
- # SFDC Account ID: pommelhorse_links.account_id
- # Sub-Account Name: pommelhorse_links.account_name
- # Region: pommelhorse_links.region
- # EMEA Geocluster: pommelhorse_links.geocluster
- # NORTHAM Sector: pommelhorse_links.sector
- # Sub Region: pommelhorse_links.sub_region
- # Micro Region: pommelhorse_links.micro_region
- # NAL Cluster: pommelhorse_links.nal_cluster
- # NAL Subcluster: pommelhorse_links.nal_sub_cluster
- # NAL Name: pommelhorse_links.nal_name
- # Reporting Account Name: pommelhorse_links.reporting_account_name
- # row: 0
- # col: 0
- # width: 3
- # height: 12
- # - title: 'Revenue Walk: List --> Gross'
- # name: 'Revenue Walk: List --> Gross'
- # model: cloud_sales_bi
- # explore: revenue
- # type: looker_waterfall
- # fields: [revenue.revenue_list, revenue.revenue_gross]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.usage_year: 1 years
- # revenue.service_family: CLOUD
- # limit: 500
- # dynamic_fields: [{category: table_calculation, expression: "-1 * (${revenue.revenue_list}-${revenue.revenue_gross})",
- # label: 'Negotiated Discounts, Fraud & BMODs', value_format: "[>1000000000]$0.00,,,\\\
- # B;[>1000000]$0.00,,\\M;$0.00,\\K", value_format_name: !!null '', _kind_hint: measure,
- # table_calculation: negotiated_discounts_fraud_bmods, _type_hint: number},
- # {category: measure, expression: !!null '', label: Revenue (Gross), value_format: !!null '',
- # value_format_name: !!null '', based_on: revenue.revenue_gross, _kind_hint: measure,
- # measure: revenue_gross, type: sum, _type_hint: number}, {category: table_calculation,
- # expression: "${revenue.revenue_gross}", label: Revenue (Gross), value_format: "[>1000000000]$0.00,,,\\\
- # B;[>1000000]$0.00,,\\M;$0.00,\\K", value_format_name: !!null '', _kind_hint: measure,
- # table_calculation: revenue_gross_1, _type_hint: number, is_disabled: true}]
- # filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
- # up_color: "#4285F4"
- # down_color: "#EA4335"
- # total_color: "#FBBC04"
- # show_value_labels: true
- # show_x_axis_ticks: true
- # show_x_axis_label: true
- # x_axis_scale: auto
- # show_y_axis_labels: false
- # show_y_axis_ticks: true
- # y_axis_gridlines: true
- # label_color: ["#000"]
- # x_axis_gridlines: false
- # show_view_names: false
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # limit_displayed_rows: false
- # legend_position: center
- # point_style: none
- # label_density: 25
- # y_axis_combined: true
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # series_types: {}
- # hidden_fields: [revenue.revenue_gross]
- # y_axes: []
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 33
- # col: 0
- # width: 6
- # height: 16
- # - name: ''
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: |-
- # <div id="discounts" style="text-align:center;font-size:1.5em">Revenue Walk</div>
- # <div style="text-align:center;font-size:1em">For more information, visit <a href="http://go/revenue-walk">go/revenue-walk</a></div>
- # row: 31
- # col: 0
- # width: 24
- # height: 2
- # - title: Top Gainers
- # name: Top Gainers
- # model: cloud_sales_bi
- # explore: revenue
- # type: looker_grid
- # fields: [revenue.rolling_window_prior_window, revenue.rolling_window_current_window,
- # revenue.rolling_window_window_variance, revenue.reporting_account_name]
- # filters:
- # revenue.usage_date: 70 days
- # revenue.rolling_window: "-NULL"
- # revenue.window_size: '28'
- # revenue.rolling_window_current_window: ">=0"
- # revenue.rolling_window_prior_window: ">=0"
- # revenue.rolling_window_window_variance: ">0"
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.service_family: CLOUD
- # sorts: [revenue.rolling_window_window_variance desc]
- # limit: 50
- # column_limit: 50
- # dynamic_fields: [{category: table_calculation, expression: "${revenue.rolling_window_window_variance}/${revenue.rolling_window_prior_window}",
- # label: MoM List, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
- # table_calculation: mom_list, _type_hint: number}]
- # query_timezone: America/Los_Angeles
- # show_view_names: false
- # show_row_numbers: false
- # transpose: false
- # truncate_text: false
- # hide_totals: false
- # hide_row_totals: false
- # size_to_fit: true
- # table_theme: white
- # limit_displayed_rows: false
- # enable_conditional_formatting: true
- # header_text_alignment: left
- # header_font_size: '12'
- # rows_font_size: '12'
- # conditional_formatting_include_totals: false
- # conditional_formatting_include_nulls: false
- # show_sql_query_menu_options: false
- # column_order: [revenue.reporting_account_name, revenue.rolling_window_current_window,
- # revenue.rolling_window_prior_window, revenue.rolling_window_window_variance,
- # mom]
- # show_totals: true
- # show_row_totals: true
- # series_labels:
- # revenue.rolling_window_prior_window: 28 Days Before That
- # revenue.rolling_window_current_window: 28 Days Ago
- # revenue.rolling_window_window_variance: Sales Revenue Growth $
- # mom: Sales Revenue Growth %
- # mom_list: Sales Revenue Growth %
- # series_column_widths:
- # revenue.rolling_window: 282
- # account_meta.customer_name: 298
- # series_cell_visualizations:
- # revenue.revenue_net_cn:
- # is_active: true
- # palette:
- # palette_id: 3de02744-c6d0-ba29-2378-81b0f7919624
- # collection_id: google
- # custom_colors:
- # - "#4285F4"
- # - "#185ABC"
- # limit_displayed_rows_values:
- # show_hide: show
- # first_last: first
- # num_rows: '2'
- # header_font_color: "#5F6368"
- # conditional_formatting: [{type: greater than, value: 0, background_color: '',
- # font_color: "#137333", color_application: {collection_id: google, palette_id: google-sequential-0},
- # bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance]},
- # {type: less than, value: 0, background_color: '', font_color: "#B31412", color_application: {
- # collection_id: google, palette_id: google-sequential-0}, bold: false, italic: false,
- # strikethrough: false, fields: [revenue.rolling_window_window_variance]}]
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_y_axis_labels: true
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: true
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # legend_position: center
- # point_style: none
- # show_value_labels: false
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # show_null_points: true
- # interpolation: linear
- # defaults_version: 1
- # series_types: {}
- # hidden_fields: [current_month_to_date]
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # hidden_points_if_no: []
- # y_axes: []
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 63
- # col: 0
- # width: 12
- # height: 6
- # - title: Top Decliners
- # name: Top Decliners
- # model: cloud_sales_bi
- # explore: revenue
- # type: looker_grid
- # fields: [revenue.rolling_window_prior_window, revenue.rolling_window_current_window,
- # revenue.rolling_window_window_variance, revenue.reporting_account_name]
- # filters:
- # revenue.usage_date: 70 days
- # revenue.rolling_window: "-NULL"
- # revenue.window_size: '28'
- # revenue.rolling_window_current_window: ">=0"
- # revenue.rolling_window_prior_window: ">=0"
- # revenue.rolling_window_window_variance: "<=0"
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.service_family: CLOUD
- # sorts: [revenue.rolling_window_window_variance]
- # limit: 50
- # column_limit: 50
- # dynamic_fields: [{table_calculation: mom, label: MoM, expression: "${revenue.rolling_window_window_variance}/${revenue.rolling_window_prior_window}",
- # value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
- # _type_hint: number}]
- # query_timezone: America/Los_Angeles
- # show_view_names: false
- # show_row_numbers: false
- # transpose: false
- # truncate_text: false
- # hide_totals: false
- # hide_row_totals: false
- # size_to_fit: true
- # table_theme: white
- # limit_displayed_rows: false
- # enable_conditional_formatting: true
- # header_text_alignment: left
- # header_font_size: '12'
- # rows_font_size: '12'
- # conditional_formatting_include_totals: false
- # conditional_formatting_include_nulls: false
- # show_sql_query_menu_options: false
- # column_order: [revenue.reporting_account_name, revenue.rolling_window_current_window,
- # revenue.rolling_window_prior_window, revenue.rolling_window_window_variance,
- # mom]
- # show_totals: true
- # show_row_totals: true
- # series_labels:
- # revenue.rolling_window_prior_window: 28 Days Before That
- # revenue.rolling_window_current_window: 28 Days Ago
- # revenue.rolling_window_window_variance: Sales Revenue Growth $
- # mom: Sales Revenue Growth %
- # series_column_widths:
- # revenue.rolling_window: 282
- # account_meta.customer_name: 298
- # series_cell_visualizations:
- # revenue.revenue_net_cn:
- # is_active: true
- # palette:
- # palette_id: 3de02744-c6d0-ba29-2378-81b0f7919624
- # collection_id: google
- # custom_colors:
- # - "#4285F4"
- # - "#185ABC"
- # limit_displayed_rows_values:
- # show_hide: show
- # first_last: first
- # num_rows: '2'
- # header_font_color: "#5F6368"
- # conditional_formatting: [{type: greater than, value: 0, background_color: '',
- # font_color: "#137333", color_application: {collection_id: google, palette_id: google-sequential-0},
- # bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance,
- # mom]}, {type: less than, value: 0, background_color: '', font_color: "#B31412",
- # color_application: {collection_id: google, palette_id: google-sequential-0},
- # bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance,
- # mom]}]
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_y_axis_labels: true
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: true
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # legend_position: center
- # point_style: none
- # show_value_labels: false
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # show_null_points: true
- # interpolation: linear
- # defaults_version: 1
- # series_types: {}
- # hidden_fields: [current_month_to_date]
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # hidden_points_if_no: []
- # y_axes: []
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 63
- # col: 12
- # width: 12
- # height: 6
- # - name: " (2)"
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: <div style="text-align:center;font-size:1.5em"><a href="#growth"><img
- # src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/sort/default/24px.svg">Growth</a></div>
- # row: 10
- # col: 13
- # width: 5
- # height: 2
- # - name: " (3)"
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: <div id="growth" style="text-align:center;font-size:1.5em">Growth (28
- # days vs. Prior 28 Days)</div>
- # row: 61
- # col: 0
- # width: 24
- # height: 2
- # - name: " (4)"
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: <div style="text-align:center;font-size:1.5em"><a href="#discounts"><img
- # src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/local_offer/default/24px.svg">Revenue
- # Walk</a></div>
- # row: 10
- # col: 8
- # width: 5
- # height: 2
- # - title: Weekly Sales Revenue Trends
- # name: Weekly Sales Revenue Trends
- # model: cloud_sales_bi
- # explore: revenue
- # type: looker_line
- # fields: [revenue.usage_week, revenue.revenue_toggle]
- # fill_fields: [revenue.usage_week]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.usage_week: 52 weeks ago for 52 weeks
- # revenue.service_family: CLOUD
- # sorts: [revenue.usage_week desc]
- # limit: 500
- # query_timezone: America/Los_Angeles
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_view_names: false
- # show_y_axis_labels: true
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: false
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # limit_displayed_rows: false
- # legend_position: center
- # point_style: none
- # show_value_labels: true
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # show_null_points: true
- # interpolation: linear
- # y_axes: [{label: Weekly Revenue, orientation: left, series: [{axisId: revenue.revenue_toggle,
- # id: revenue.revenue_toggle, name: Revenue (Toggle-able)}], showLabels: true,
- # showValues: true, valueFormat: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\\
- # M;$0,\\K", unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
- # type: linear}]
- # label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\M;$0.00,\\K"
- # series_types: {}
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # hidden_fields: []
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 18
- # col: 0
- # width: 24
- # height: 6
- # - name: " (5)"
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: |-
- # <div style="height:2em;font-size:1.5em;text-align:center"><a href="http://go/bhi-bug" target="_blank"><img src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/bug_report/default/24px.svg
- # ">File a Bug</a></div>
- # row: 10
- # col: 3
- # width: 5
- # height: 2
- # - name: " (6)"
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: |-
- # <div style="text-align:center;font-size:1.2em">
- # Missing the old <a href="https://data.corp.google.com/sites/q1yjy0md0d87/insights__trends/">Account360</a>?
- # </div>
- # row: 10
- # col: 18
- # width: 6
- # height: 2
- # - title: 'Revenue Walk: Gross --> Invoice'
- # name: 'Revenue Walk: Gross --> Invoice'
- # model: cloud_sales_bi
- # explore: revenue
- # type: looker_waterfall
- # fields: [revenue.revenue_invoice, revenue.invoice_revenue_components_gross, revenue.invoice_revenue_components_ft,
- # revenue.invoice_revenue_components_sud, revenue.invoice_revenue_components_cud,
- # revenue.invoice_revenue_components_promo, revenue.invoice_revenue_components_reseller_credit,
- # revenue.invoice_revenue_components_cross_pa_credits_addback]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.usage_year: 1 years
- # revenue.service_family: CLOUD
- # limit: 500
- # dynamic_fields: [{category: table_calculation, expression: "-1 * (${revenue.revenue_gross}+(\n\
- # \ ${revenue.revenue_promo}+${revenue.revenue_ft}+${revenue.revenue_ft}+${revenue.revenue_reseller}+${revenue.revenue_cud}+${revenue.revenue_sud}+${revenue.revenue_cross_pa_credits}\n\
- # ) - ${revenue.revenue_invoice})", label: Discounts (Other), value_format: "$0.00,,\\\
- # M", value_format_name: !!null '', _kind_hint: measure, table_calculation: discounts_other,
- # _type_hint: number, is_disabled: true}]
- # filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
- # up_color: "#4285F4"
- # down_color: "#EA4335"
- # total_color: "#FBBC04"
- # show_value_labels: true
- # show_x_axis_ticks: true
- # show_x_axis_label: true
- # x_axis_scale: auto
- # show_y_axis_labels: false
- # show_y_axis_ticks: true
- # y_axis_gridlines: true
- # label_color: ["#000"]
- # x_axis_gridlines: false
- # show_view_names: false
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # limit_displayed_rows: false
- # legend_position: center
- # point_style: none
- # label_density: 25
- # y_axis_combined: true
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # series_types: {}
- # hidden_fields: [revenue.revenue_invoice]
- # y_axes: []
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 33
- # col: 6
- # width: 18
- # height: 8
- # - title: 'Revenue Walk: Gross --> Sales'
- # name: 'Revenue Walk: Gross --> Sales'
- # model: cloud_sales_bi
- # explore: revenue
- # type: looker_waterfall
- # fields: [revenue.revenue_net_cn, revenue.sales_revenue_components_gross, revenue.sales_revenue_components_ft,
- # revenue.sales_revenue_components_sud, revenue.sales_revenue_components_cud,
- # revenue.sales_revenue_components_promo, revenue.sales_revenue_components_reseller_credit,
- # revenue.sales_revenue_components_cross_pa_credits_addback, revenue.sales_revenue_components_isv_deduction,
- # revenue.sales_revenue_components_partner_margin_addback]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.usage_year: 1 years
- # revenue.service_family: CLOUD
- # limit: 500
- # dynamic_fields: [{category: measure, expression: !!null '', label: Revenue (Gross),
- # value_format: !!null '', value_format_name: !!null '', based_on: revenue.revenue_gross,
- # _kind_hint: measure, measure: revenue_gross, type: sum, _type_hint: number},
- # {category: measure, expression: '${revenue.segment}="Corporate" OR ${revenue.region}="PUBLIC
- # SECTOR"', label: Corp & GPS Partner Margin, value_format: !!null '', value_format_name: !!null '',
- # based_on: revenue.revenue_reseller, filter_expression: '${revenue.segment}="Corporate"
- # OR ${revenue.region}="PUBLIC SECTOR"', _kind_hint: measure, measure: corp_gps_partner_margin,
- # type: sum, _type_hint: number, filters: {}}]
- # filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
- # up_color: "#4285F4"
- # down_color: "#EA4335"
- # total_color: "#FBBC04"
- # show_value_labels: true
- # show_x_axis_ticks: true
- # show_x_axis_label: true
- # x_axis_scale: auto
- # show_y_axis_labels: false
- # show_y_axis_ticks: true
- # y_axis_gridlines: true
- # label_color: ["#000"]
- # x_axis_gridlines: false
- # show_view_names: false
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # limit_displayed_rows: false
- # legend_position: center
- # point_style: none
- # label_density: 25
- # y_axis_combined: true
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # series_types: {}
- # hidden_fields: [revenue.revenue_net_cn]
- # y_axes: []
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 41
- # col: 6
- # width: 18
- # height: 8
- # - title: List, Gross & Sales Revenue Comparison (Weekly)
- # name: List, Gross & Sales Revenue Comparison (Weekly)
- # model: cloud_sales_bi
- # explore: revenue
- # type: looker_line
- # fields: [revenue.revenue_net_cn, revenue.revenue_list, revenue.usage_week, revenue.revenue_gross,
- # revenue.revenue_cud, revenue.revenue_promo, revenue.revenue_bmod]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.service_family: CLOUD
- # revenue.usage_month: 12 months
- # sorts: [revenue.usage_week desc]
- # limit: 500
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_view_names: false
- # show_y_axis_labels: false
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: false
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: ''
- # limit_displayed_rows: false
- # legend_position: center
- # point_style: none
- # show_value_labels: true
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # show_null_points: true
- # interpolation: linear
- # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
- # id: revenue.revenue_net_cn, name: Revenue (Sales)}, {axisId: revenue.revenue_list,
- # id: revenue.revenue_list, name: "[go/listrev] Revenue (List)"}, {axisId: revenue.revenue_gross,
- # id: revenue.revenue_gross, name: Revenue (Gross)}, {axisId: revenue.revenue_cud,
- # id: revenue.revenue_cud, name: Revenue (Committed Usage Discount)}, {
- # axisId: revenue.revenue_promo, id: revenue.revenue_promo, name: Revenue
- # (Promo)}, {axisId: revenue.revenue_bmod, id: revenue.revenue_bmod, name: Revenue
- # (Billing Modifications)}], showLabels: false, showValues: true, minValue: !!null '',
- # valueFormat: "[>=1000000000]$0.0,,,\\B;[>1000000]$0.0,,\\M;$0.0,\\K", unpinAxis: true,
- # tickDensity: default, tickDensityCustom: 5, type: linear}]
- # hidden_series: []
- # label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.0,,\\M;$0.0,\\K"
- # series_types: {}
- # label_color: []
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: true
- # show_silhouette: false
- # totals_color: "#808080"
- # up_color: "#4285F4"
- # down_color: "#EA4335"
- # total_color: "#FBBC04"
- # defaults_version: 1
- # hidden_fields: []
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 49
- # col: 0
- # width: 24
- # height: 12
- # - title: Most Recent Revenue Data
- # name: Most Recent Revenue Data
- # model: cloud_sales_bi
- # explore: revenue
- # type: single_value
- # fields: [revenue.usage_date, revenue.revenue_net_cn]
- # fill_fields: [revenue.usage_date]
- # filters:
- # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
- # revenue.service_family: CLOUD
- # revenue.usage_date: 30 days
- # sorts: [revenue.usage_date desc]
- # limit: 500
- # dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
- # label: YoY %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
- # table_calculation: yoy, _type_hint: number, is_disabled: true}, {category: table_calculation,
- # expression: "${revenue.revenue_net_cn} > 0.5 * median(${revenue.revenue_net_cn})",
- # label: 'Is valid row?', value_format: "$0.00,\\K", value_format_name: !!null '',
- # _kind_hint: measure, table_calculation: is_valid_row, _type_hint: yesno}]
- # query_timezone: America/Los_Angeles
- # custom_color_enabled: true
- # show_single_value_title: true
- # show_comparison: false
- # comparison_type: change
- # comparison_reverse_colors: false
- # show_comparison_label: true
- # enable_conditional_formatting: false
- # conditional_formatting_include_totals: false
- # conditional_formatting_include_nulls: false
- # x_axis_gridlines: false
- # y_axis_gridlines: true
- # show_view_names: false
- # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
- # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
- # showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
- # tickDensityCustom: 5, type: linear}]
- # show_y_axis_labels: true
- # show_y_axis_ticks: true
- # y_axis_tick_density: default
- # y_axis_tick_density_custom: 5
- # show_x_axis_label: true
- # show_x_axis_ticks: true
- # y_axis_scale_mode: linear
- # x_axis_reversed: false
- # y_axis_reversed: false
- # plot_size_by_field: false
- # trellis: ''
- # stacking: normal
- # limit_displayed_rows: false
- # legend_position: center
- # series_types: {}
- # point_style: none
- # show_value_labels: true
- # label_density: 25
- # x_axis_scale: auto
- # y_axis_combined: true
- # show_null_points: true
- # interpolation: linear
- # ordering: none
- # show_null_labels: false
- # show_totals_labels: false
- # show_silhouette: false
- # totals_color: "#808080"
- # defaults_version: 1
- # hidden_fields: [revenue.revenue_net_cn]
- # hidden_points_if_no: [is_valid_row]
- # note_state: collapsed
- # note_display: hover
- # note_text: Most recent date with complete revenue numbers
- # listen:
- # SFDC Account ID: revenue.sfdc_account_id
- # Product Group: revenue.product_group
- # GCP Revenue Source: revenue.gcp_revenue_source
- # Billing Account ID: revenue.billing_account_id
- # Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
- # Is Data Analytics? (Yes / No): revenue.is_data_analytics
- # Revenue Granularity: revenue.revenue_granularity
- # Region: revenue.region
- # EMEA Geocluster: revenue.geocluster
- # NORTHAM Sector: revenue.sector
- # Sub Region: revenue.sub_region
- # Micro Region: revenue.micro_region
- # NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
- # NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
- # Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
- # row: 4
- # col: 3
- # width: 7
- # height: 3
+ - title: MTD
+ name: MTD
+ model: hdeist-test-model
+ explore: revenue
+ type: single_value
+ fields: [revenue.month_to_date, revenue.revenue_toggle]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.month_to_date: "-NULL"
+ revenue.usage_month: 3 months
+ revenue.metric_selector: blended
+ sorts: [revenue.month_to_date desc]
+ limit: 500
+ dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
+ label: MoM %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ table_calculation: mom, _type_hint: number}]
+ query_timezone: America/Los_Angeles
+ custom_color_enabled: true
+ show_single_value_title: true
+ show_comparison: true
+ comparison_type: change
+ comparison_reverse_colors: false
+ show_comparison_label: true
+ enable_conditional_formatting: false
+ conditional_formatting_include_totals: false
+ conditional_formatting_include_nulls: false
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_view_names: false
+ y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
+ tickDensityCustom: 5, type: linear}]
+ show_y_axis_labels: true
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: true
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: normal
+ limit_displayed_rows: false
+ legend_position: center
+ series_types: {}
+ point_style: none
+ show_value_labels: true
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ hidden_fields: []
+ note_state: collapsed
+ note_display: hover
+ note_text: Based on Sales Revenue
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 7
+ col: 17
+ width: 7
+ height: 3
+ - title: QTD
+ name: QTD
+ model: hdeist-test-model
+ explore: revenue
+ type: single_value
+ fields: [revenue.quarter_to_date, revenue.revenue_toggle]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.usage_month: 3 quarters
+ revenue.quarter_to_date: "-NULL"
+ revenue.metric_selector: blended
+ sorts: [revenue.quarter_to_date desc]
+ limit: 500
+ dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
+ label: QoQ %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ table_calculation: qoq, _type_hint: number}]
+ query_timezone: America/Los_Angeles
+ custom_color_enabled: true
+ show_single_value_title: true
+ show_comparison: true
+ comparison_type: change
+ comparison_reverse_colors: false
+ show_comparison_label: true
+ enable_conditional_formatting: false
+ conditional_formatting_include_totals: false
+ conditional_formatting_include_nulls: false
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_view_names: false
+ y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
+ tickDensityCustom: 5, type: linear}]
+ show_y_axis_labels: true
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: true
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: normal
+ limit_displayed_rows: false
+ legend_position: center
+ series_types: {}
+ point_style: none
+ show_value_labels: true
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ hidden_fields: []
+ note_state: collapsed
+ note_display: hover
+ note_text: Based on Sales Revenue
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 7
+ col: 10
+ width: 7
+ height: 3
+ - title: Navigation
+ name: Navigation
+ model: hdeist-test-model
+ explore: pommelhorse_links
+ type: looker_grid
+ fields: [pommelhorse_links.link_name]
+ filters:
+ pommelhorse_links.category: Revenue Detail
+ pommelhorse_links.link_size: 1em
+ sorts: [pommelhorse_links.link_name]
+ limit: 500
+ column_limit: 50
+ query_timezone: America/Los_Angeles
+ show_view_names: false
+ show_row_numbers: false
+ transpose: false
+ truncate_text: false
+ hide_totals: false
+ hide_row_totals: false
+ size_to_fit: true
+ table_theme: white
+ limit_displayed_rows: false
+ enable_conditional_formatting: false
+ header_text_alignment: left
+ header_font_size: '18'
+ rows_font_size: '18'
+ conditional_formatting_include_totals: false
+ conditional_formatting_include_nulls: false
+ show_sql_query_menu_options: false
+ show_totals: true
+ show_row_totals: true
+ series_labels:
+ pommelhorse_links.link_name: Navigation
+ custom_color_enabled: true
+ show_single_value_title: true
+ show_comparison: false
+ comparison_type: value
+ comparison_reverse_colors: false
+ show_comparison_label: true
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_y_axis_labels: true
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: true
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ legend_position: center
+ point_style: none
+ show_value_labels: false
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ series_types: {}
+ hidden_fields: []
+ y_axes: []
+ title_hidden: true
+ listen:
+ SFDC Account ID: pommelhorse_links.account_id
+ Sub-Account Name: pommelhorse_links.account_name
+ Region: pommelhorse_links.region
+ EMEA Geocluster: pommelhorse_links.geocluster
+ NORTHAM Sector: pommelhorse_links.sector
+ Sub Region: pommelhorse_links.sub_region
+ Micro Region: pommelhorse_links.micro_region
+ NAL Cluster: pommelhorse_links.nal_cluster
+ NAL Subcluster: pommelhorse_links.nal_sub_cluster
+ NAL Name: pommelhorse_links.nal_name
+ Reporting Account Name: pommelhorse_links.reporting_account_name
+ row: 0
+ col: 0
+ width: 3
+ height: 12
+ - title: 'Revenue Walk: List --> Gross'
+ name: 'Revenue Walk: List --> Gross'
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_waterfall
+ fields: [revenue.revenue_list, revenue.revenue_gross]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.usage_year: 1 years
+ revenue.service_family: CLOUD
+ limit: 500
+ dynamic_fields: [{category: table_calculation, expression: "-1 * (${revenue.revenue_list}-${revenue.revenue_gross})",
+ label: 'Negotiated Discounts, Fraud & BMODs', value_format: "[>1000000000]$0.00,,,\\\
+ B;[>1000000]$0.00,,\\M;$0.00,\\K", value_format_name: !!null '', _kind_hint: measure,
+ table_calculation: negotiated_discounts_fraud_bmods, _type_hint: number},
+ {category: measure, expression: !!null '', label: Revenue (Gross), value_format: !!null '',
+ value_format_name: !!null '', based_on: revenue.revenue_gross, _kind_hint: measure,
+ measure: revenue_gross, type: sum, _type_hint: number}, {category: table_calculation,
+ expression: "${revenue.revenue_gross}", label: Revenue (Gross), value_format: "[>1000000000]$0.00,,,\\\
+ B;[>1000000]$0.00,,\\M;$0.00,\\K", value_format_name: !!null '', _kind_hint: measure,
+ table_calculation: revenue_gross_1, _type_hint: number, is_disabled: true}]
+ filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
+ up_color: "#4285F4"
+ down_color: "#EA4335"
+ total_color: "#FBBC04"
+ show_value_labels: true
+ show_x_axis_ticks: true
+ show_x_axis_label: true
+ x_axis_scale: auto
+ show_y_axis_labels: false
+ show_y_axis_ticks: true
+ y_axis_gridlines: true
+ label_color: ["#000"]
+ x_axis_gridlines: false
+ show_view_names: false
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ limit_displayed_rows: false
+ legend_position: center
+ point_style: none
+ label_density: 25
+ y_axis_combined: true
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ series_types: {}
+ hidden_fields: [revenue.revenue_gross]
+ y_axes: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 33
+ col: 0
+ width: 6
+ height: 16
+ - name: ''
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: |-
+ <div id="discounts" style="text-align:center;font-size:1.5em">Revenue Walk</div>
+ <div style="text-align:center;font-size:1em">For more information, visit <a href="http://go/revenue-walk">go/revenue-walk</a></div>
+ row: 31
+ col: 0
+ width: 24
+ height: 2
+ - title: Top Gainers
+ name: Top Gainers
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_grid
+ fields: [revenue.rolling_window_prior_window, revenue.rolling_window_current_window,
+ revenue.rolling_window_window_variance, revenue.reporting_account_name]
+ filters:
+ revenue.usage_date: 70 days
+ revenue.rolling_window: "-NULL"
+ revenue.window_size: '28'
+ revenue.rolling_window_current_window: ">=0"
+ revenue.rolling_window_prior_window: ">=0"
+ revenue.rolling_window_window_variance: ">0"
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.service_family: CLOUD
+ sorts: [revenue.rolling_window_window_variance desc]
+ limit: 50
+ column_limit: 50
+ dynamic_fields: [{category: table_calculation, expression: "${revenue.rolling_window_window_variance}/${revenue.rolling_window_prior_window}",
+ label: MoM List, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ table_calculation: mom_list, _type_hint: number}]
+ query_timezone: America/Los_Angeles
+ show_view_names: false
+ show_row_numbers: false
+ transpose: false
+ truncate_text: false
+ hide_totals: false
+ hide_row_totals: false
+ size_to_fit: true
+ table_theme: white
+ limit_displayed_rows: false
+ enable_conditional_formatting: true
+ header_text_alignment: left
+ header_font_size: '12'
+ rows_font_size: '12'
+ conditional_formatting_include_totals: false
+ conditional_formatting_include_nulls: false
+ show_sql_query_menu_options: false
+ column_order: [revenue.reporting_account_name, revenue.rolling_window_current_window,
+ revenue.rolling_window_prior_window, revenue.rolling_window_window_variance,
+ mom]
+ show_totals: true
+ show_row_totals: true
+ series_labels:
+ revenue.rolling_window_prior_window: 28 Days Before That
+ revenue.rolling_window_current_window: 28 Days Ago
+ revenue.rolling_window_window_variance: Sales Revenue Growth $
+ mom: Sales Revenue Growth %
+ mom_list: Sales Revenue Growth %
+ series_column_widths:
+ revenue.rolling_window: 282
+ account_meta.customer_name: 298
+ series_cell_visualizations:
+ revenue.revenue_net_cn:
+ is_active: true
+ palette:
+ palette_id: 3de02744-c6d0-ba29-2378-81b0f7919624
+ collection_id: google
+ custom_colors:
+ - "#4285F4"
+ - "#185ABC"
+ limit_displayed_rows_values:
+ show_hide: show
+ first_last: first
+ num_rows: '2'
+ header_font_color: "#5F6368"
+ conditional_formatting: [{type: greater than, value: 0, background_color: '',
+ font_color: "#137333", color_application: {collection_id: google, palette_id: google-sequential-0},
+ bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance]},
+ {type: less than, value: 0, background_color: '', font_color: "#B31412", color_application: {
+ collection_id: google, palette_id: google-sequential-0}, bold: false, italic: false,
+ strikethrough: false, fields: [revenue.rolling_window_window_variance]}]
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_y_axis_labels: true
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: true
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ legend_position: center
+ point_style: none
+ show_value_labels: false
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ defaults_version: 1
+ series_types: {}
+ hidden_fields: [current_month_to_date]
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ hidden_points_if_no: []
+ y_axes: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 63
+ col: 0
+ width: 12
+ height: 6
+ - title: Top Decliners
+ name: Top Decliners
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_grid
+ fields: [revenue.rolling_window_prior_window, revenue.rolling_window_current_window,
+ revenue.rolling_window_window_variance, revenue.reporting_account_name]
+ filters:
+ revenue.usage_date: 70 days
+ revenue.rolling_window: "-NULL"
+ revenue.window_size: '28'
+ revenue.rolling_window_current_window: ">=0"
+ revenue.rolling_window_prior_window: ">=0"
+ revenue.rolling_window_window_variance: "<=0"
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.service_family: CLOUD
+ sorts: [revenue.rolling_window_window_variance]
+ limit: 50
+ column_limit: 50
+ dynamic_fields: [{table_calculation: mom, label: MoM, expression: "${revenue.rolling_window_window_variance}/${revenue.rolling_window_prior_window}",
+ value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ _type_hint: number}]
+ query_timezone: America/Los_Angeles
+ show_view_names: false
+ show_row_numbers: false
+ transpose: false
+ truncate_text: false
+ hide_totals: false
+ hide_row_totals: false
+ size_to_fit: true
+ table_theme: white
+ limit_displayed_rows: false
+ enable_conditional_formatting: true
+ header_text_alignment: left
+ header_font_size: '12'
+ rows_font_size: '12'
+ conditional_formatting_include_totals: false
+ conditional_formatting_include_nulls: false
+ show_sql_query_menu_options: false
+ column_order: [revenue.reporting_account_name, revenue.rolling_window_current_window,
+ revenue.rolling_window_prior_window, revenue.rolling_window_window_variance,
+ mom]
+ show_totals: true
+ show_row_totals: true
+ series_labels:
+ revenue.rolling_window_prior_window: 28 Days Before That
+ revenue.rolling_window_current_window: 28 Days Ago
+ revenue.rolling_window_window_variance: Sales Revenue Growth $
+ mom: Sales Revenue Growth %
+ series_column_widths:
+ revenue.rolling_window: 282
+ account_meta.customer_name: 298
+ series_cell_visualizations:
+ revenue.revenue_net_cn:
+ is_active: true
+ palette:
+ palette_id: 3de02744-c6d0-ba29-2378-81b0f7919624
+ collection_id: google
+ custom_colors:
+ - "#4285F4"
+ - "#185ABC"
+ limit_displayed_rows_values:
+ show_hide: show
+ first_last: first
+ num_rows: '2'
+ header_font_color: "#5F6368"
+ conditional_formatting: [{type: greater than, value: 0, background_color: '',
+ font_color: "#137333", color_application: {collection_id: google, palette_id: google-sequential-0},
+ bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance,
+ mom]}, {type: less than, value: 0, background_color: '', font_color: "#B31412",
+ color_application: {collection_id: google, palette_id: google-sequential-0},
+ bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance,
+ mom]}]
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_y_axis_labels: true
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: true
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ legend_position: center
+ point_style: none
+ show_value_labels: false
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ defaults_version: 1
+ series_types: {}
+ hidden_fields: [current_month_to_date]
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ hidden_points_if_no: []
+ y_axes: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 63
+ col: 12
+ width: 12
+ height: 6
+ - name: " (2)"
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: <div style="text-align:center;font-size:1.5em"><a href="#growth"><img
+ src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/sort/default/24px.svg">Growth</a></div>
+ row: 10
+ col: 13
+ width: 5
+ height: 2
+ - name: " (3)"
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: <div id="growth" style="text-align:center;font-size:1.5em">Growth (28
+ days vs Prior 28 Days)</div>
+ row: 61
+ col: 0
+ width: 24
+ height: 2
+ - name: " (4)"
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: <div style="text-align:center;font-size:1.5em"><a href="#discounts"><img
+ src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/local_offer/default/24px.svg">Revenue
+ Walk</a></div>
+ row: 10
+ col: 8
+ width: 5
+ height: 2
+ - title: Weekly Sales Revenue Trends
+ name: Weekly Sales Revenue Trends
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_line
+ fields: [revenue.usage_week, revenue.revenue_toggle]
+ fill_fields: [revenue.usage_week]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.usage_week: 52 weeks ago for 52 weeks
+ revenue.service_family: CLOUD
+ sorts: [revenue.usage_week desc]
+ limit: 500
+ query_timezone: America/Los_Angeles
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_view_names: false
+ show_y_axis_labels: true
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: false
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ limit_displayed_rows: false
+ legend_position: center
+ point_style: none
+ show_value_labels: true
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ y_axes: [{label: Weekly Revenue, orientation: left, series: [{axisId: revenue.revenue_toggle,
+ id: revenue.revenue_toggle, name: Revenue (Toggle-able)}], showLabels: true,
+ showValues: true, valueFormat: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\\
+ M;$0,\\K", unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
+ type: linear}]
+ label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\M;$0.00,\\K"
+ series_types: {}
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ hidden_fields: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 18
+ col: 0
+ width: 24
+ height: 6
+ - name: " (5)"
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: |-
+ <div style="height:2em;font-size:1.5em;text-align:center"><a href="http://go/bhi-bug" target="_blank"><img src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/bug_report/default/24px.svg
+ ">File a Bug</a></div>
+ row: 10
+ col: 3
+ width: 5
+ height: 2
+ - name: " (6)"
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: |-
+ <div style="text-align:center;font-size:1.2em">
+ Missing the old <a href="https://data.corp.google.com/sites/q1yjy0md0d87/insights__trends/">Account360</a>?
+ </div>
+ row: 10
+ col: 18
+ width: 6
+ height: 2
+ - title: 'Revenue Walk: Gross --> Invoice'
+ name: 'Revenue Walk: Gross --> Invoice'
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_waterfall
+ fields: [revenue.revenue_invoice, revenue.invoice_revenue_components_gross, revenue.invoice_revenue_components_ft,
+ revenue.invoice_revenue_components_sud, revenue.invoice_revenue_components_cud,
+ revenue.invoice_revenue_components_promo, revenue.invoice_revenue_components_reseller_credit,
+ revenue.invoice_revenue_components_cross_pa_credits_addback]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.usage_year: 1 years
+ revenue.service_family: CLOUD
+ limit: 500
+ dynamic_fields: [{category: table_calculation, expression: "-1 * (${revenue.revenue_gross}+(\n\
+ \ ${revenue.revenue_promo}+${revenue.revenue_ft}+${revenue.revenue_ft}+${revenue.revenue_reseller}+${revenue.revenue_cud}+${revenue.revenue_sud}+${revenue.revenue_cross_pa_credits}\n\
+ ) - ${revenue.revenue_invoice})", label: Discounts (Other), value_format: "$0.00,,\\\
+ M", value_format_name: !!null '', _kind_hint: measure, table_calculation: discounts_other,
+ _type_hint: number, is_disabled: true}]
+ filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
+ up_color: "#4285F4"
+ down_color: "#EA4335"
+ total_color: "#FBBC04"
+ show_value_labels: true
+ show_x_axis_ticks: true
+ show_x_axis_label: true
+ x_axis_scale: auto
+ show_y_axis_labels: false
+ show_y_axis_ticks: true
+ y_axis_gridlines: true
+ label_color: ["#000"]
+ x_axis_gridlines: false
+ show_view_names: false
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ limit_displayed_rows: false
+ legend_position: center
+ point_style: none
+ label_density: 25
+ y_axis_combined: true
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ series_types: {}
+ hidden_fields: [revenue.revenue_invoice]
+ y_axes: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 33
+ col: 6
+ width: 18
+ height: 8
+ - title: 'Revenue Walk: Gross --> Sales'
+ name: 'Revenue Walk: Gross --> Sales'
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_waterfall
+ fields: [revenue.revenue_net_cn, revenue.sales_revenue_components_gross, revenue.sales_revenue_components_ft,
+ revenue.sales_revenue_components_sud, revenue.sales_revenue_components_cud,
+ revenue.sales_revenue_components_promo, revenue.sales_revenue_components_reseller_credit,
+ revenue.sales_revenue_components_cross_pa_credits_addback, revenue.sales_revenue_components_isv_deduction,
+ revenue.sales_revenue_components_partner_margin_addback]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.usage_year: 1 years
+ revenue.service_family: CLOUD
+ limit: 500
+ dynamic_fields: [{category: measure, expression: !!null '', label: Revenue (Gross),
+ value_format: !!null '', value_format_name: !!null '', based_on: revenue.revenue_gross,
+ _kind_hint: measure, measure: revenue_gross, type: sum, _type_hint: number},
+ {category: measure, expression: '${revenue.segment}="Corporate" OR ${revenue.region}="PUBLIC
+ SECTOR"', label: Corp & GPS Partner Margin, value_format: !!null '', value_format_name: !!null '',
+ based_on: revenue.revenue_reseller, filter_expression: '${revenue.segment}="Corporate"
+ OR ${revenue.region}="PUBLIC SECTOR"', _kind_hint: measure, measure: corp_gps_partner_margin,
+ type: sum, _type_hint: number, filters: {}}]
+ filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
+ up_color: "#4285F4"
+ down_color: "#EA4335"
+ total_color: "#FBBC04"
+ show_value_labels: true
+ show_x_axis_ticks: true
+ show_x_axis_label: true
+ x_axis_scale: auto
+ show_y_axis_labels: false
+ show_y_axis_ticks: true
+ y_axis_gridlines: true
+ label_color: ["#000"]
+ x_axis_gridlines: false
+ show_view_names: false
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ limit_displayed_rows: false
+ legend_position: center
+ point_style: none
+ label_density: 25
+ y_axis_combined: true
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ series_types: {}
+ hidden_fields: [revenue.revenue_net_cn]
+ y_axes: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 41
+ col: 6
+ width: 18
+ height: 8
+ - title: List, Gross & Sales Revenue Comparison (Weekly)
+ name: List, Gross & Sales Revenue Comparison (Weekly)
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_line
+ fields: [revenue.revenue_net_cn, revenue.revenue_list, revenue.usage_week, revenue.revenue_gross,
+ revenue.revenue_cud, revenue.revenue_promo, revenue.revenue_bmod]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.service_family: CLOUD
+ revenue.usage_month: 12 months
+ sorts: [revenue.usage_week desc]
+ limit: 500
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_view_names: false
+ show_y_axis_labels: false
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: false
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: ''
+ limit_displayed_rows: false
+ legend_position: center
+ point_style: none
+ show_value_labels: true
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ id: revenue.revenue_net_cn, name: Revenue (Sales)}, {axisId: revenue.revenue_list,
+ id: revenue.revenue_list, name: "[go/listrev] Revenue (List)"}, {axisId: revenue.revenue_gross,
+ id: revenue.revenue_gross, name: Revenue (Gross)}, {axisId: revenue.revenue_cud,
+ id: revenue.revenue_cud, name: Revenue (Committed Usage Discount)}, {
+ axisId: revenue.revenue_promo, id: revenue.revenue_promo, name: Revenue
+ (Promo)}, {axisId: revenue.revenue_bmod, id: revenue.revenue_bmod, name: Revenue
+ (Billing Modifications)}], showLabels: false, showValues: true, minValue: !!null '',
+ valueFormat: "[>=1000000000]$0.0,,,\\B;[>1000000]$0.0,,\\M;$0.0,\\K", unpinAxis: true,
+ tickDensity: default, tickDensityCustom: 5, type: linear}]
+ hidden_series: []
+ label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.0,,\\M;$0.0,\\K"
+ series_types: {}
+ label_color: []
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: true
+ show_silhouette: false
+ totals_color: "#808080"
+ up_color: "#4285F4"
+ down_color: "#EA4335"
+ total_color: "#FBBC04"
+ defaults_version: 1
+ hidden_fields: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 49
+ col: 0
+ width: 24
+ height: 12
+ - title: Most Recent Revenue Data
+ name: Most Recent Revenue Data
+ model: hdeist-test-model
+ explore: revenue
+ type: single_value
+ fields: [revenue.usage_date, revenue.revenue_net_cn]
+ fill_fields: [revenue.usage_date]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.service_family: CLOUD
+ revenue.usage_date: 30 days
+ sorts: [revenue.usage_date desc]
+ limit: 500
+ dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
+ label: YoY %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ table_calculation: yoy, _type_hint: number, is_disabled: true}, {category: table_calculation,
+ expression: "${revenue.revenue_net_cn} > 0.5 * median(${revenue.revenue_net_cn})",
+ label: 'Is valid row?', value_format: "$0.00,\\K", value_format_name: !!null '',
+ _kind_hint: measure, table_calculation: is_valid_row, _type_hint: yesno}]
+ query_timezone: America/Los_Angeles
+ custom_color_enabled: true
+ show_single_value_title: true
+ show_comparison: false
+ comparison_type: change
+ comparison_reverse_colors: false
+ show_comparison_label: true
+ enable_conditional_formatting: false
+ conditional_formatting_include_totals: false
+ conditional_formatting_include_nulls: false
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_view_names: false
+ y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
+ tickDensityCustom: 5, type: linear}]
+ show_y_axis_labels: true
+ show_y_axis_ticks: true
+ y_axis_tick_density: default
+ y_axis_tick_density_custom: 5
+ show_x_axis_label: true
+ show_x_axis_ticks: true
+ y_axis_scale_mode: linear
+ x_axis_reversed: false
+ y_axis_reversed: false
+ plot_size_by_field: false
+ trellis: ''
+ stacking: normal
+ limit_displayed_rows: false
+ legend_position: center
+ series_types: {}
+ point_style: none
+ show_value_labels: true
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ hidden_fields: [revenue.revenue_net_cn]
+ hidden_points_if_no: [is_valid_row]
+ note_state: collapsed
+ note_display: hover
+ note_text: Most recent date with complete revenue numbers
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
+ row: 4
+ col: 3
+ width: 7
+ height: 3
# - title: QTD (GCP Core + Looker + Apigee)
# name: QTD (GCP Core + Looker + Apigee)
- # model: cloud_sales_bi
+ # model: hdeist-test-model
# explore: gcp_forecast_quotas_transformed
# type: single_value
# fields: [gcp_forecast_quotas_transformed.revenue_net_cn]
@@ -1411,7 +1411,7 @@
# show_row_totals: true
# series_labels:
# gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue: Called Forecast
- # vs. Quota
+ # vs Quota
# revenue.revenue_net_cn: Sales Revenue Actuals
# gcp_forecast_quotas_transformed.quota_revenue: Quota
# gcp_forecast_quotas_transformed.total_called_revenue_forecast: Called Forecast
@@ -1505,36 +1505,36 @@
# NAL Name: gcp_forecast_quotas_transformed.nal_name
# Reporting Account Name: gcp_forecast_quotas_transformed.reporting_account_name
# Segment: vector_customers.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Digital Native vs Traditional: vector_customers.is_digital_native
# Is ISV? (Yes / No): vector_customers.is_isv
# row: 0
# col: 10
# width: 7
# height: 4
- # - name: " (7)"
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: <div style="font-size:2em;text-align:center">All other tiles represent
- # <b>GCP Core only</b> and do not include Looker or Apigee Revenue.</div>
- # row: 4
- # col: 10
- # width: 14
- # height: 3
- # - name: " (8)"
- # type: text
- # title_text: ''
- # subtitle_text: ''
- # body_text: |-
- # <div style="font-size:1.5em"><img style="float:left" height=100 src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/west/default/24px.svg">
- # These tiles represent <b>GCP Core + Looker + Apigee</b> and match values on <a href="http://go/bhi">go/bhi</a>.</div>
- # row: 0
- # col: 17
- # width: 7
- # height: 4
+ - name: " (7)"
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: <div style="font-size:2em;text-align:center">All other tiles represent
+ <b>GCP Core only</b> and do not include Looker or Apigee Revenue.</div>
+ row: 4
+ col: 10
+ width: 14
+ height: 3
+ - name: " (8)"
+ type: text
+ title_text: ''
+ subtitle_text: ''
+ body_text: |-
+ <div style="font-size:1.5em"><img style="float:left" height=100 src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/west/default/24px.svg">
+ These tiles represent <b>GCP Core + Looker + Apigee</b> and match values on <a href="http://go/bhi">go/bhi</a>.</div>
+ row: 0
+ col: 17
+ width: 7
+ height: 4
# - title: YTD (GCP Core + Looker + Apigee)
# name: YTD (GCP Core + Looker + Apigee)
- # model: cloud_sales_bi
+ # model: hdeist-test-model
# explore: gcp_forecast_quotas_transformed
# type: single_value
# fields: [gcp_forecast_quotas_transformed.revenue_net_cn]
@@ -1572,7 +1572,7 @@
# show_row_totals: true
# series_labels:
# gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue: Called Forecast
- # vs. Quota
+ # vs Quota
# revenue.revenue_net_cn: Sales Revenue Actuals
# gcp_forecast_quotas_transformed.quota_revenue: Quota
# gcp_forecast_quotas_transformed.total_called_revenue_forecast: Called Forecast
@@ -1666,7 +1666,7 @@
# NAL Name: gcp_forecast_quotas_transformed.nal_name
# Reporting Account Name: gcp_forecast_quotas_transformed.reporting_account_name
# Segment: vector_customers.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Digital Native vs Traditional: vector_customers.is_digital_native
# Is ISV? (Yes / No): vector_customers.is_isv
# row: 0
# col: 3
@@ -1675,12 +1675,6 @@
-
-
-
-
-
-
filters:
- name: Region
title: Region
diff --git a/views/revenue/revenue_from_revenue.view.lkml b/views/revenue/revenue_from_revenue.view.lkml
index 59ec8f2..a32ab62 100644
--- a/views/revenue/revenue_from_revenue.view.lkml
+++ b/views/revenue/revenue_from_revenue.view.lkml
@@ -1,4 +1,13 @@
-# emulates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue_from_revenue.view.lkml
+########################################################
+#
+# Author: hillz@
+# Updated Date: Oct 6, 2021 Def.
+# Fields related to "Revenue" from the revenue table
+# Meant to be extended into the revenue view
+# Primary key will be in the primary (revenue) view
+#
+########################################################
+
view: revenue_from_revenue {
extension: required
@@ -139,6 +148,7 @@
sql: ${TABLE}.product_group ;;
drill_fields: [product_line]
}
+
dimension: product_line {
group_label: "Legacy Product Hierarchy"
view_label: "Product"
@@ -157,94 +167,92 @@
hidden: yes
group_label: "Legacy Product Hierarchy"
view_label: "Product"
- sql: ${TABLE}.product_line;;
- #drill_fields: [sku_description]
+ sql: {% if project_number._in_query %} ${TABLE}.product_name
+ {% elsif project_name._in_query %} ${TABLE}.product_name
+ {% elsif project_id._in_query %} ${TABLE}.product_name
+ {% elsif sku_id._in_query %} ${TABLE}.product_name
+ {% elsif sku_description._in_query %} ${TABLE}.product_name
+ {% elsif machine_type._in_query %} ${TABLE}.product_name
+ {% elsif resource_group._in_query %} ${TABLE}.product_name
+ {% elsif storage_locality._in_query %} ${TABLE}.product_name
+ {% elsif storage_class._in_query %} ${TABLE}.product_name
+ {% elsif usage_location._in_query %} ${TABLE}.product_name
+ {% elsif usage_unit._in_query %} ${TABLE}.product_name
+ {% elsif usage_in_usage_units._in_query %} ${TABLE}.product_name
+ {% else %} ${TABLE}.product_line {% endif %} ;;
+ drill_fields: [sku_description]
}
- # dimension: product_line_raw {
- # hidden: yes
- # group_label: "Legacy Product Hierarchy"
- # view_label: "Product"
- # sql: {% if project_number._in_query %} ${TABLE}.product_name
- # {% elsif project_name._in_query %} ${TABLE}.product_name
- # {% elsif project_id._in_query %} ${TABLE}.product_name
- # {% elsif sku_id._in_query %} ${TABLE}.product_name
- # {% elsif sku_description._in_query %} ${TABLE}.product_name
- # {% elsif machine_type._in_query %} ${TABLE}.product_name
- # {% elsif resource_group._in_query %} ${TABLE}.product_name
- # {% elsif storage_locality._in_query %} ${TABLE}.product_name
- # {% elsif storage_class._in_query %} ${TABLE}.product_name
- # {% elsif usage_location._in_query %} ${TABLE}.product_name
- # {% elsif usage_unit._in_query %} ${TABLE}.product_name
- # {% elsif usage_in_usage_units._in_query %} ${TABLE}.product_name
- # {% else %} ${TABLE}.product_line {% endif %} ;;
- # drill_fields: [sku_description]
- # }
- # dimension: product_specialization {
- # view_label: "Product"
- # sql: {% if project_number._in_query %} ${TABLE}.specialization
- # {% elsif project_name._in_query %} ${TABLE}.specialization
- # {% elsif project_id._in_query %} ${TABLE}.specialization
- # {% elsif sku_id._in_query %} ${TABLE}.specialization
- # {% elsif sku_description._in_query %} ${TABLE}.specialization
- # {% elsif machine_type._in_query %} ${TABLE}.specialization
- # {% elsif resource_group._in_query %} ${TABLE}.specialization
- # {% elsif storage_locality._in_query %} ${TABLE}.specialization
- # {% elsif storage_class._in_query %} ${TABLE}.specialization
- # {% elsif usage_location._in_query %} ${TABLE}.specialization
- # {% elsif usage_unit._in_query %} ${TABLE}.specialization
- # {% elsif usage_in_usage_units._in_query %} ${TABLE}.specialization
- # {% else %} ${TABLE}.product_specialization {% endif %} ;;
- # drill_fields: [sku_description]
- # }
+ dimension: product_specialization {
+ view_label: "Product"
+ sql: {% if project_number._in_query %} ${TABLE}.specialization
+ {% elsif project_name._in_query %} ${TABLE}.specialization
+ {% elsif project_id._in_query %} ${TABLE}.specialization
+ {% elsif sku_id._in_query %} ${TABLE}.specialization
+ {% elsif sku_description._in_query %} ${TABLE}.specialization
+ {% elsif machine_type._in_query %} ${TABLE}.specialization
+ {% elsif resource_group._in_query %} ${TABLE}.specialization
+ {% elsif storage_locality._in_query %} ${TABLE}.specialization
+ {% elsif storage_class._in_query %} ${TABLE}.specialization
+ {% elsif usage_location._in_query %} ${TABLE}.specialization
+ {% elsif usage_unit._in_query %} ${TABLE}.specialization
+ {% elsif usage_in_usage_units._in_query %} ${TABLE}.specialization
+ {% else %} ${TABLE}.product_specialization {% endif %} ;;
+ drill_fields: [sku_description]
+ }
+
dimension: service_family {
view_label: "Product"
description: "Service family, i.e. CLOUD or GEO"
type: string
sql: ${TABLE}.service_family ;;
}
- # dimension: storage_class {
- # view_label: "Product"
- # group_label: "Cloud Storage"
- # description: "Groups Cloud Storage into Archive, Coldline, Nearline, and Standard based on sku description."
- # case: {
- # when: {
- # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Archive%' ;;
- # label: "Archive"
- # }
- # when: {
- # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Coldline%' ;;
- # label: "Coldline"
- # }
- # when: {
- # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Nearline%' ;;
- # label: "Nearline"
- # }
- # when: {
- # sql: ${product_line_raw} = "Cloud Storage" ;;
- # label: "Standard"
- # }
- # }
- # }
- # dimension: storage_locality {
- # view_label: "Product"
- # group_label: "Cloud Storage"
- # description: "Groups Cloud Storage into Multi-Region, Dual-Region, or Regional based on sku description."
- # case: {
- # when: {
- # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Multi%' ;;
- # label: "Multi-Region"
- # }
- # when: {
- # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Dual%' ;;
- # label: "Dual-Region"
- # }
- # when: {
- # sql: ${product_line_raw} = "Cloud Storage" ;;
- # label: "Regional"
- # }
- # }
- # }
+
+ dimension: storage_class {
+ view_label: "Product"
+ group_label: "Cloud Storage"
+ description: "Groups Cloud Storage into Archive, Coldline, Nearline, and Standard based on sku description."
+ case: {
+ when: {
+ sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Archive%' ;;
+ label: "Archive"
+ }
+ when: {
+ sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Coldline%' ;;
+ label: "Coldline"
+ }
+ when: {
+ sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Nearline%' ;;
+ label: "Nearline"
+ }
+ when: {
+ sql: ${product_line_raw} = "Cloud Storage" ;;
+ label: "Standard"
+ }
+ }
+ }
+
+ dimension: storage_locality {
+ view_label: "Product"
+ group_label: "Cloud Storage"
+ description: "Groups Cloud Storage into Multi-Region, Dual-Region, or Regional based on sku description."
+ case: {
+ when: {
+ sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Multi%' ;;
+ label: "Multi-Region"
+ }
+ when: {
+ sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Dual%' ;;
+ label: "Dual-Region"
+ }
+ when: {
+ sql: ${product_line_raw} = "Cloud Storage" ;;
+ label: "Regional"
+ }
+ }
+ }
+
+
dimension_group: usage {
type: time
timeframes: [raw, day_of_month, day_of_year, day_of_week, date, week, month, month_name, quarter, quarter_of_year, year]
@@ -254,6 +262,7 @@
datatype: date
convert_tz: no
}
+
dimension: usd_revenue_blended {
hidden: yes
view_label: "Revenue"
@@ -264,56 +273,78 @@
{% endif %}
;;
}
+
dimension: usd_revenue_bmod {
hidden: yes
view_label: "Revenue"
sql: ${TABLE}.usd_revenue_bmod ;;
}
+
+ dimension: usd_revenue_sales {
+ hidden: yes
+ view_label: "Revenue"
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.sales_revenue ;;
+ }
+
+ dimension: usd_revenue_invoice {
+ hidden: yes
+ view_label: "Revenue"
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.invoice_revenue ;;
+ }
+
dimension: usd_revenue_cross_pa_credits {
hidden: yes
description: "Added to usd_revenue_net_cn to create GCP Actuals"
sql: ${TABLE}.usd_revenue_cross_pa_credits ;;
}
+
dimension: usd_revenue_cud {
hidden: yes
view_label: "Revenue"
description: "Committed Usage Discount credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
sql: ${TABLE}.usd_revenue_cud ;;
}
+
dimension: usd_revenue_ft {
hidden: yes
view_label: "Revenue"
description: "Free Trial credit applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
sql: ${TABLE}.usd_revenue_ft ;;
}
+
dimension: usd_revenue_gross {
hidden: yes
view_label: "Revenue"
description: "Monetised value for resource consumption, before application of any credits, reported in USD($) using a monthly Ceilometer exchange rate. (Generally a positive number)"
sql: ${TABLE}.usd_revenue_gross ;;
}
+
dimension: usd_revenue_gross_cn {
hidden: yes
view_label: "Revenue"
sql: ${TABLE}.usd_revenue_gross_cn ;;
}
+
dimension: usd_revenue_list {
hidden: yes
view_label: "Revenue"
sql: ${TABLE}.usd_revenue_list ;;
}
+
dimension: usd_revenue_net {
hidden: yes
view_label: "Revenue"
description: "Final billed amounts after application of all other credits, reported in USD($) using an annual exchange rate. (Net amounts are normally positive or round to zero, but it some cases credits can exceed gross and net will be negative)"
sql: ${TABLE}.usd_revenue_net ;;
}
+
dimension: usd_revenue_ntg {
hidden: yes
view_label: "Revenue"
description: "Net to Google Revenue"
sql: ${TABLE}.usd_revenue_ntg ;;
}
+
dimension: usd_revenue_net_cn {
hidden: yes
view_label: "Revenue"
@@ -324,66 +355,213 @@
{% endif %}
;;
}
+
dimension: usd_revenue_promo {
hidden: yes
view_label: "Revenue"
description: "Other promotional credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
sql: ${TABLE}.usd_revenue_promo ;;
}
+
dimension: usd_revenue_protected_credit {
hidden: yes
view_label: "Revenue"
sql: ${TABLE}.usd_revenue_protected_credit ;;
}
+
dimension: usd_revenue_reseller {
hidden: yes
view_label: "Revenue"
sql: ${TABLE}.usd_revenue_reseller ;;
}
- dimension: usd_revenue_rvp {
- hidden: yes
- view_label: "Revenue"
- description: "Revenue for RVPs: see go/revenue-walk for details"
- sql: ${TABLE}.usd_revenue_rvp ;;
- }
+
dimension: usd_revenue_sud {
hidden: yes
view_label: "Revenue"
description: " Usage Discount credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
sql: ${TABLE}.usd_revenue_sud ;;
}
+
dimension: is_nonmetered {
type: yesno
label: "Is Nonmetered?"
view_label: "Product"
sql: ${TABLE}.is_nonmetered ;;
}
+
+ ## Metric Components
+
+ # Invoice Revenue
+
+ dimension: usd_invoice_revenue_components_gross {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ description: "Gross Revenue component of Invoice Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_gross ;;
+ }
+
+ dimension: usd_invoice_revenue_components_sud {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ description: "SUD component of Invoice Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_sud ;;
+ }
+
+ dimension: usd_invoice_revenue_components_cud {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ description: "CUD component of Invoice Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_cud ;;
+ }
+
+ dimension: usd_invoice_revenue_components_ft {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ description: "FT component of Invoice Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_ft ;;
+ }
+
+ dimension: usd_invoice_revenue_components_promo {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ description: "Promo component of Invoice Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_promo ;;
+ }
+
+ dimension: usd_invoice_revenue_components_reseller_credit {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ description: "Reseller Credit component of Invoice Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_reseller_credit ;;
+ }
+
+ dimension: usd_invoice_revenue_components_cross_pa_credits_addback {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ description: "xPA component of Invoice Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.cross_pa_credits_addback ;;
+ }
+
+## Metric Components
+
+# Sales Revenue
+
+ dimension: usd_sales_revenue_components_gross {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "Gross Revenue component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_gross ;;
+ }
+
+ dimension: usd_sales_revenue_components_sud {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "SUD component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_sud ;;
+ }
+
+ dimension: usd_sales_revenue_components_cud {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "CUD component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_cud ;;
+ }
+
+ dimension: usd_sales_revenue_components_ft {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "FT component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_ft ;;
+ }
+
+ dimension: usd_sales_revenue_components_promo {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "Promo component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_promo ;;
+ }
+
+ dimension: usd_sales_revenue_components_reseller_credit {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "Reseller Credit component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_reseller_credit ;;
+ }
+
+ dimension: usd_sales_revenue_components_cross_pa_credits_addback {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "xPA component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.cross_pa_credits_addback ;;
+ }
+
+ dimension: usd_sales_revenue_components_partner_margin_addback {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "Partner Margin addback component of Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.partner_margin_addback ;;
+ }
+
+
+ dimension: usd_sales_revenue_components_isv_tier {
+ hidden: no
+ label: "ISV Tier"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "ISV tier used to calculate marketplace tier adjustment in Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.isv_tier ;;
+ }
+
+ dimension: usd_sales_revenue_components_isv_deduction {
+ hidden: yes
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ description: "Marketplace ISV deduction in Sales Revenue calculation."
+ sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.isv_deduction ;;
+ }
+
+
#### MEASURES ####
measure: revenue_invoice {
alias: [revenue_actuals]
label: "Revenue (Invoice)"
view_label: "Revenue"
- description: "Sum of Revenue (Sales) minus hug credits. Post alignment we have agreed to keep only one source of truth for revenue and it will be gcc.revenue. Gcp_consumpiton will be deprecated but another table(with adjustments) will be established to enable the bridge from gcc.revenue to finance."
+ description: "Invoice Revenue, aligned with go/revenue-walk."
type: sum
- sql: ${usd_revenue_net} - ${usd_revenue_cross_pa_credits};;
+ sql: ${usd_revenue_invoice};;
value_format_name: usd_0
- drill_fields: [billing_account_id, revenue_actuals, revenue_net_cn]
+ drill_fields: [reporting_account_name, billing_account_id, revenue_invoice, revenue_net_cn]
link: {
- url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10"
+ url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.product_line\" }}&limit=10"
label: "Top 10 Product Lines"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc
+ {% assign column_name = \"\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Top 10 Accounts"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
{{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Drill by Segment"
@@ -391,15 +569,15 @@
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=vector_customers.is_digital_native\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Drill by Account Category"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
{{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Drill by Region"
@@ -407,20 +585,21 @@
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
{{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc
"
label: "Drill by NAL"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
- url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}"
+ url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.product_group\" }}"
label: "Drill by Product Group"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_bmod {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (Billing Modifications)"
@@ -433,6 +612,7 @@
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_cross_pa_credits {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (xPA Credits)"
@@ -445,6 +625,7 @@
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_cud {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (Committed Usage Discount)"
@@ -457,6 +638,7 @@
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_discounts_other {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (Other Discounts)"
@@ -465,14 +647,16 @@
type: sum
sql: -1 * (${usd_revenue_gross} - ${usd_revenue_blended} + ${usd_revenue_cud} + ${usd_revenue_ft} + ${usd_revenue_promo} + ${usd_revenue_sud} +${usd_revenue_reseller}) ;;
value_format_name: usd_0
- drill_fields: [billing_account_id
+ drill_fields: [reporting_account_name
+ , billing_account_id
, revenue_discounts_other
, revenue_gross
, revenue_net_cn
]
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
- # html: @{custom_dollar_formatting} ;;
+ #html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_ft {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (Free Trial)"
@@ -485,6 +669,7 @@
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_gross {
label: "Revenue (Gross)"
view_label: "Revenue"
@@ -546,6 +731,7 @@
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
}
+
measure: revenue_list {
label: "[go/listrev] Revenue (List)"
view_label: "Revenue"
@@ -611,6 +797,9 @@
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
}
+
+ # TODO: delete this measure during a scheduled maintenance window, and replace with a measure pointing to `usd_revenue_net_cn` directly
+
measure: revenue_net_cn {
label: "Revenue (Sales)"
view_label: "Revenue"
@@ -680,6 +869,81 @@
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
+
+
+ # TODO: unhide this measure once we have re-pointed usd_revenue_net_cn
+
+ measure: revenue_sales {
+ label: "Revenue (Sales)"
+ hidden: no
+ view_label: "Revenue"
+ description: "Sales Revenue, aligned with go/revenue-walk."
+ type: sum
+ sql: ${usd_revenue_sales};;
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, revenue_sales]
+ link: {
+ url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.product_line\" }}&limit=10"
+ label: "Top 10 Product Lines"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ link: {
+ url: "
+ {% assign column_name = \"\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=\" }}&limit=10&sorts={{ _field._name }}+desc
+ "
+ label: "Top 10 Accounts"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ link: {
+ url: "
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=revenue.product_group,revenue.sku_id,revenue.sku_description\" }}&limit=10&sorts={{ _field._name }}+desc
+ "
+ label: "Top 10 SKUs"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ link: {
+ url: "
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc
+ "
+ label: "Drill by Segment"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ link: {
+ url: "
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=vector_customers.is_digital_native\" }}&limit=10&sorts={{ _field._name }}+desc
+ "
+ label: "Drill by Account Category"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ link: {
+ url: "
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc
+ "
+ label: "Drill by Region"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ link: {
+ url: "
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc
+ "
+ label: "Drill by NAL"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ link: {
+ url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.product_group\" }}"
+ label: "Drill by Product Group"
+ icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
+ }
+ # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
+ #html: @{custom_dollar_formatting} ;;
+ }
+
measure: revenue_promo {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (Promo)"
@@ -692,6 +956,7 @@
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_reseller {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (Reseller)"
@@ -704,75 +969,7 @@
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
# html: @{custom_dollar_formatting} ;;
}
- measure: revenue_rvp {
- label: "Revenue (RVP)"
- view_label: "Revenue"
- description: "Revenue definition used by Region VPs. See go/revenue-walk"
- type: sum
- sql: ${usd_revenue_rvp};;
- value_format_name: usd_0
- drill_fields: [billing_account_id, revenue_net_cn]
- link: {
- url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10"
- label: "Top 10 Product Lines"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- link: {
- url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc
- "
- label: "Top 10 Accounts"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- link: {
- url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.product_group,revenue.sku_id,revenue.sku_description\" }}&limit=10&sorts={{ _field._name }}+desc
- "
- label: "Top 10 SKUs"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- link: {
- url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc
- "
- label: "Drill by Segment"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- link: {
- url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc
- "
- label: "Drill by Account Category"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- link: {
- url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc
- "
- label: "Drill by Region"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- link: {
- url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc
- "
- label: "Drill by NAL"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- link: {
- url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}"
- label: "Drill by Product Group"
- icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
- }
- # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
- # html: @{custom_dollar_formatting} ;;
- }
+
measure: revenue_sud {
group_label: "Discounts, Credits & BMODS"
label: "Revenue (Sustained Usage Discount)"
@@ -781,10 +978,11 @@
type: sum
sql: ${usd_revenue_sud};;
value_format_name: usd_0
- drill_fields: [billing_account_id, revenue_sud, revenue_gross, revenue_net_cn]
+ drill_fields: [reporting_account_name, billing_account_id, revenue_sud, revenue_gross, revenue_net_cn]
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
- # html: @{custom_dollar_formatting} ;;
+ # html: @{custom_dollar_formatting} ;;
}
+
measure: revenue_toggle {
group_label: "Other Revenue"
label: "Revenue (Toggle-able)"
@@ -800,26 +998,25 @@
{% elsif metric_selector._parameter_value == 'net_channel_neutral' %} ${usd_revenue_net_cn}
{% elsif metric_selector._parameter_value == 'gross' %} ${usd_revenue_gross}
{% elsif metric_selector._parameter_value == 'blended' %} ${usd_revenue_blended}
- {% elsif metric_selector._parameter_value == 'rvp' %} ${usd_revenue_rvp}
{% endif %} ;;
- drill_fields: [billing_account_id, revenue_toggle]
+ drill_fields: [reporting_account_name, billing_account_id, revenue_toggle]
value_format_name: usd_0
link: {
- url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10"
+ url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.product_line\" }}&limit=10"
label: "Top 10 Product Lines"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc
+ {% assign column_name = \"\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Top 10 Accounts"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
{{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Drill by Segment"
@@ -827,15 +1024,15 @@
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
- {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
+ {{ link | replace: column_name, \"=vector_customers.is_digital_native\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Drill by Account Category"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
{{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc
"
label: "Drill by Region"
@@ -843,21 +1040,221 @@
}
link: {
url: "
- {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
+ {% assign column_name = \"=\" | append: _view._name | append: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
{{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc
"
label: "Drill by NAL"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
link: {
- url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}"
+ url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.product_group\" }}"
label: "Drill by Product Group"
icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
}
# Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
- # html: @{custom_dollar_formatting} ;;
+ #html: @{custom_dollar_formatting} ;;
}
+
+ ## Metric Components
+
+ # Invoice Revenue
+
+ measure: invoice_revenue_components_gross {
+ label: "Gross Revenue (Invoice Component)"
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_gross, revenue_invoice]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Gross Revenue component of Invoice Revenue calculation."
+ sql: ${usd_invoice_revenue_components_gross} ;;
+ }
+
+ measure: invoice_revenue_components_sud {
+ label: "SUDs (Invoice Component)"
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_sud, revenue_invoice]
+ #html: @{custom_dollar_formatting} ;;
+ description: "SUD component of Invoice Revenue calculation."
+ sql: ${usd_invoice_revenue_components_sud} ;;
+ }
+
+ measure: invoice_revenue_components_cud {
+ label: "CUDs (Invoice Component)"
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_cud, revenue_invoice]
+ #html: @{custom_dollar_formatting} ;;
+ description: "CUD component of Invoice Revenue calculation."
+ sql: ${usd_invoice_revenue_components_cud} ;;
+ }
+
+ measure: invoice_revenue_components_ft {
+ label: "Free Trial Credits (Invoice Component)"
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_ft, revenue_invoice]
+ #html: @{custom_dollar_formatting} ;;
+ description: "FT component of Invoice Revenue calculation."
+ sql: ${usd_invoice_revenue_components_ft} ;;
+ }
+
+ measure: invoice_revenue_components_promo {
+ label: "Promo Credits (Invoice Component)"
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_promo, revenue_invoice]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Promo component of Invoice Revenue calculation."
+ sql: ${usd_invoice_revenue_components_promo} ;;
+ }
+
+ measure: invoice_revenue_components_reseller_credit {
+ label: "Reseller Margin (Invoice Component)"
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_reseller_credit, revenue_invoice]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Reseller Credit component of Invoice Revenue calculation."
+ sql: ${usd_invoice_revenue_components_reseller_credit} ;;
+ }
+
+ measure: invoice_revenue_components_cross_pa_credits_addback {
+ label: "xPA Credit Addback (Invoice Component)"
+ view_label: "Revenue"
+ group_label: "Invoice Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_cross_pa_credits_addback, revenue_invoice]
+ #html: @{custom_dollar_formatting} ;;
+ description: "xPA component of Invoice Revenue calculation."
+ sql: ${usd_invoice_revenue_components_cross_pa_credits_addback} ;;
+ }
+
+# Sales Revenue
+
+ measure: sales_revenue_components_gross {
+ label: "Gross Revenue (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_gross, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Gross Revenue component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_gross} ;;
+ }
+
+ measure: sales_revenue_components_sud {
+ label: "SUDs (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_sud, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "SUD component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_sud} ;;
+ }
+
+ measure: sales_revenue_components_cud {
+ label: "CUDs (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_cud, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "CUD component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_cud} ;;
+ }
+
+ measure: sales_revenue_components_ft {
+ label: "Free Trial Credits (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_ft, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "FT component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_ft} ;;
+ }
+
+ measure: sales_revenue_components_promo {
+ label: "Promo Credits (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_promo, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Promo component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_promo} ;;
+ }
+
+ measure: sales_revenue_components_reseller_credit {
+ label: "Reseller Margin (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_reseller_credit, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Reseller Credit component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_reseller_credit} ;;
+ }
+
+ measure: sales_revenue_components_cross_pa_credits_addback {
+ label: "xPA Credit Addback (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_cross_pa_credits_addback, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "xPA component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_cross_pa_credits_addback} ;;
+ }
+
+ measure: sales_revenue_components_partner_margin_addback {
+ label: "Partner Margin Addback (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_partner_margin_addback, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Partner Margin addback component of Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_partner_margin_addback} ;;
+ }
+
+ measure: sales_revenue_components_isv_deduction {
+ label: "ISV Deduction (Sales Component)"
+ view_label: "Revenue"
+ group_label: "Sales Revenue Components"
+ type: sum
+ value_format_name: usd_0
+ drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_isv_deduction, revenue_sales]
+ #html: @{custom_dollar_formatting} ;;
+ description: "Marketplace ISV deduction in Sales Revenue calculation."
+ sql: ${usd_sales_revenue_components_isv_deduction} ;;
+ }
+
#### PARAMETERS ####
+
parameter: metric_selector {
view_label: "Revenue"
description: "This parameter is for dashboard building only. This allows users to select a metric type
@@ -871,10 +1268,6 @@
value: "blended"
}
allowed_value: {
- label: "Revenue (RVP)"
- value: "rvp"
- }
- allowed_value: {
label: "Revenue (2021 Def.)"
value: "net_channel_neutral"
}
@@ -891,6 +1284,7 @@
value: "ntg"
}
}
+
parameter: filter_nonmetered {
view_label: "Revenue"
label: "Remove Prepaid Purchases?"
@@ -906,6 +1300,7 @@
value: "false"
}
}
+
parameter: usage_timeframe_selector {
view_label: "Revenue"
description: "Updates the `Dynamic Usage Timeframe` field based on selection of granularity."
@@ -921,4 +1316,5 @@
value: "Month"
}
}
+
}
