Add stuff to revenue explore
Change-Id: I8c357b22780632817c25f643d0f0600f39bc8147
diff --git a/explores/revenue.view.lkml b/explores/revenue.view.lkml
index e188b19..d77b2e8 100644
--- a/explores/revenue.view.lkml
+++ b/explores/revenue.view.lkml
@@ -1,4 +1,14 @@
# Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/explores/revenue.view.lkml
-include: "/views/revenue/revenue.view.lkml"
+include: "/views/revenue/*.view.lkml"
-explore: revenue {}
+explore: revenue {
+ label: "Usage Revenue"
+ description: "Daily Revenue for GCC Cloud BI Sales, defaults to Split Revenue"
+ always_filter: {
+ filters: [
+ revenue.segment: "-Scaled"
+ , revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ , revenue.sub_region: "-NULL"
+ , revenue.service_family: "CLOUD"
+ ]
+ }}
diff --git a/views/revenue/account_from_account_revenue.view.lkml b/views/revenue/account_from_account_revenue.view.lkml
new file mode 100644
index 0000000..c627496
--- /dev/null
+++ b/views/revenue/account_from_account_revenue.view.lkml
@@ -0,0 +1,197 @@
+# https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/account_from_account_revenue.view.lkml
+
+view: account_from_revenue {
+ extension: required
+ ########## DIMENSIONS ############
+ dimension: billing_account_id {
+ view_label: "Account"
+ group_label: "Identifiers"
+ description: "Billing account ID"
+ sql: ${TABLE}.billing_account_id ;;
+ }
+ dimension: country {
+ alias: [account_meta.country]
+ view_label: "Account"
+ group_label: "Geography"
+ description: "Country code for Account location"
+ sql: ${TABLE}.country ;;
+ }
+ dimension: geocluster {
+ alias: [account_meta.geocluster]
+ }
+ dimension: industry {
+ view_label: "Account"
+ group_label: "Industry"
+ description: "Examples: Software & Internet, Business & Professional Services, Public Sector & EDU"
+ alias: [account_meta.industry]
+ sql: ${TABLE}.industry ;;
+ drill_fields: [sub_industry]
+ }
+ dimension: micro_region {
+ alias: [account_meta.micro_region]
+ }
+ dimension: micro_industry {
+ view_label: "Account"
+ group_label: "Industry"
+ description: "Examples: Higher Education, Storage & Data Mgt, Specialty- Apparel & Footware"
+ alias: [account_meta.micro_industry]
+ sql: ${TABLE}.micro_industry ;;
+ }
+ dimension: nal_cluster {
+ alias: [account_meta.nal_cluster]
+ }
+ dimension: nal_id {
+ alias: [account_meta.nal_id]
+ }
+ dimension: nal_name {
+ alias: [account_meta.nal_name]
+ }
+ dimension: region {
+ alias: [account_meta.region]
+ }
+ dimension: region_toggle {
+ alias: [account_meta.region_toggle]
+ sql: {% if region_granularity._parameter_value == "region" %}
+ ${region}
+ {% elsif region_granularity._parameter_value == "geocluster" %}
+ ${geocluster}
+ {% elsif region_granularity._parameter_value == "sector" %}
+ ${sector}
+ {% elsif region_granularity._parameter_value == "sub_region" %}
+ ${sub_region}
+ {% elsif region_granularity._parameter_value == "micro_region" %}
+ ${micro_region}
+ {% elsif region_granularity._parameter_value == "nal_cluster" %}
+ ${nal_cluster}
+ {% elsif region_granularity._parameter_value == "nal_name" %}
+ ${nal_name}
+ {% elsif region_granularity._parameter_value == "nal_id" %}
+ ${nal_id}
+ {% elsif region_granularity._parameter_value == "reporting_account_name" %}
+ ${reporting_account_name}
+ {% elsif region_granularity._parameter_value == "sfdc_account_id" %}
+ ${sfdc_account_id}
+ {% endif %}
+ ;;
+ drill_fields: [region, geocluster, sector, sub_region, micro_region, nal_cluster, nal_name, nal_id, reporting_account_name, sfdc_account_id]
+ }
+ dimension: reporting_account_name {
+ alias: [account_meta.reporting_account_name]
+ group_label: "Identifiers"
+ view_label: "Account"
+ description: "Top most non roll up “customer” account in the hierarchy"
+ sql: ${TABLE}.reporting_account_name ;;
+ link: {
+ url: "https://lookercs-sales.corp.goog/dashboards-next/82?Reporting+Account+Name={{ filterable_value | url_encode }}"
+ label: "Revenue Trends"
+ }
+ link: {
+ url: "https://lookercs-sales.corp.goog/dashboards-next/100?Reporting+Account+Name={{ filterable_value | url_encode }}"
+ label: "Account Lookup"
+ }
+ link: {
+ url: "https://vector.lightning.force.com/lightning/r/Account/{{reporting_id._value}}/view"
+ label: "View Account in Vector"
+ }
+ link: {
+ url: "https://lookercs-sales.corp.goog/dashboards/137?Reporting+Account+Name={{ filterable_value | url_encode }}"
+ label: "Product Trends"
+ }
+ # suggest_dimension: account_sort.reporting_account_name
+ }
+ dimension: reporting_id {
+ alias: [account_meta.reporting_id]
+ view_label: "Account"
+ group_label: "Identifiers"
+ description: "Sales segment (e.g. Select, Enterprise etc.,)"
+ sql: ${TABLE}.reporting_id ;;
+ link: {
+ url: "https://vector.lightning.force.com/lightning/r/Account/{{reporting_id._value}}/view"
+ label: "View Account in Vector"
+ }
+ }
+ ## The field below should be replaced once primary campaign field is available in opps
+ ## @paolarenteria @pweiler
+ dimension: is_rev_acceleration_reporting_id {
+ description: "Returns yes if the reporting ID is a part of 2022RevAcceleration campaign"
+ type: yesno
+ hidden: yes
+ sql: ${reporting_id} IN ("0014M00001h4Zl5QAE","0014M00001h6coWQAQ","0014M00001hrNJpQAM","0014M00001hPv9SQAS","0014M00001h4620QAA","0014M00001hexHTQAY","0014M00001hTUQsQAO","0014M00001hXzOLQA0","0014M00001hWckmQAC","0014M00001hrKHIQA2","0014M00001hnl40QAA","0014M00001haScQQAU","0014M00001hTXhQQAW","0014M00001hTTe5QAG","0014M00001heyWJQAY","0014M00001h46dmQAA","0014M00001hPwqcQAC","0014M00001hnnaDQAQ","0014M00001h6grgQAA","0014M00001hTVEPQA4","0014M00001hVXA6QAO","0014M00001hvN38QAE","0014M00001lGN96QAG","0014M00001hk2cUQAQ","0014M00001xjJNrQAM","0014M00001pqBnnQAE","0014M00001hO2j9QAC","0014M00001hocKHQAY","0014M00001hv9CUQAY","0014M00001haJb8QAE","0014M00001jTAiqQAG","0014M00001hRLBrQAO","0014M00001hS473QAC","0014M00001h5slEQAQ","0014M00001w4d00QAA","0014M00001hV6YnQAK","0014M00001kvbLhQAI","0014M00001hp1RcQAI","0014M00001hQXPZQA4","0014M00001lGGlpQAG","0014M00001hclk0QAA","0014M00001hcHmuQAE","0014M00001hS49OQAS","0014M00001hp46lQAA","0014M00001lz6t3QAA","0014M00001hV7OrQAK","0014M00001hqmvkQAA","0014M00001hWDtUQAW","0014M00001yR4ZYQA0","0014M00001m9GvbQAE","0014M00001hiFXAQA2","0014M00001lGGkRQAW","0014M00001hS494QAC","0014M00001lUNZ5QAO","0014M00001hNizIQAS","0014M00001hmZ7SQAU","0014M00001hmYqKQAU","0014M00001qp9JiQAI","0014M00001hNbmUQAS","0014M00001h3M3MQAU","0014M00001hbFluQAE","0014M00001hQt0xQAC","0014M00001hwZhkQAE","0014M00001oY6efQAC","0014M00001oX6ZeQAK","0014M00001txYgcQAE","0014M00001oY6FFQA0","0014M00001hqKVxQAM","0014M00001hNpMRQA0","0014M00001lV628QAC","0014M00001hvTYKQA2","0014M00001hlEpUQAU","0014M00001hvTfXQAU","0014M00001hg2E8QAI","0014M00001hV7QfQAK","0014M00001hd7wpQAA","0014M00001p4RmHQAU","0014M00001lV398QAC","0014M00001rGvG4QAK","0014M00001hM9CeQAK","0014M00001hq1ohQAA","0014M00001hmI1zQAE","0014M00001hmZVkQAM","0014M00001hfW3eQAE","0014M00001hPsFVQA0","0014M00001hLqPVQA0","0014M00001hqW50QAE","0014M00001hg2DJQAY","0014M00001hZd41QAC","0014M00001hPrJVQA0","0014M00001hg2DxQAI","0014M00001lV6HwQAK","0014M00001hQDqyQAG","0014M00001lV2wWQAS","0014M00001sco16QAA","0014M00001hmcIEQAY","0014M00001kh3n5QAA","0014M00001hQXkrQAG","0014M00001hg2DSQAY","0014M00001hlDfCQAU","0014M00001hlXzdQAE","0014M00001hlDfvQAE","0014M00001hLrGIQA0","0014M00001hWAjIQAW","0014M00001p8KKmQAM","0014M00001hWBQyQAO","0014M00001kvDNfQAM","0014M00001hqGb0QAE","0014M00001haErVQAU","0014M00001hWvn4QAC","0014M00001hqIg2QAE","0014M00001hvJiyQAE","0014M00001hPrH2QAK","0014M00001hZd6PQAS","0014M00001hZiuYQAS","0014M00001hhqZTQAY","0014M00001hvYugQAE","0014M00001hlDg0QAE","0014M00001hjwFhQAI","0014M00001hg2EeQAI","0014M00001hlDfeQAE","0014M00001hqbT7QAI","0014M00001p3l0dQAA","0014M00001qLnhsQAC","0014M00001hQ0EKQA0","0014M00001hcSaNQAU","0014M00001hZiBpQAK","0014M00001hY9cTQAS","0014M00001lV5coQAC","0014M00001hY9ckQAC","0014M00001hfsujQAA","0014M00001hSu5kQAC","0014M00001hPrKTQA0","0014M00001hf81NQAQ","0014M00001hrZ3fQAE","0014M00001hTAeKQAW","0014M00001hR92nQAC","0014M00001hg9uvQAA","0014M00001h6gvNQAQ","0014M00001hSdVuQAK","0014M00001hnj4KQAQ","0014M0000279iJYQAY","0014M00001hKdr7QAC","0014M00001hrHTRQA2","0014M00001hXTKCQA4","0014M00001hXeTBQA0","0014M00001h6pfaQAA","0014M00001hYb3yQAC","0014M00001hJjZbQAK","0014M00001hnUhYQAU","0014M00001hcRfHQAU","0014M00001hXfJIQA0","0014M00001hXSSiQAO","0014M00001hrMOqQAM","0014M00001hmULhQAM","0014M00001p6wBDQAY","0014M00001hXkfGQAS","0014M00001hPxqPQAS","0014M00001hPnvaQAC","0014M00001hr79hQAA","0014M00001hnlOHQAY","0014M00001hSwYXQA0","0014M00001hT6HZQA0","0014M00001hcFxEQAU","0014M00001hfstPQAQ","0014M00001hrZQEQA2","0014M00001hd3B9QAI","0014M00001hrHovQAE","0014M00001hk3DKQAY","0014M00001hPwzqQAC","0014M00001h6tlwQAA","0014M00001hQ4xHQAS","0014M00001hTSWbQAO","0014M00001hs1cRQAQ","0014M00001iiTRXQA2","0014M00001hurVyQAI","0014M00001hfbu9QAA","0014M00001hNlxWQAS","0014M00001hg1TeQAI","0014M00001hXczHQAS","0014M00001lV6FgQAK","0014M00001h5JKrQAM","0014M00001hfdGZQAY","0014M00001hmam5QAA","0014M00001lUNHiQAO","0014M00001hv8gRQAQ","0014M00001hfdH7QAI","0014M00001hffYOQAY","0014M00001hcou9QAA","0014M00001h5JKuQAM","0014M00001hazk8QAA","0014M00001hS6cxQAC","0014M00001hrEYQQA2","0014M00001hb3NwQAI","0014M00001hfxCiQAI","0014M00001haTt7QAE","0014M00001hrIXmQAM","0014M00001hrNXdQAM","0014M00001h5K85QAE","0014M00001lUNkeQAG","0014M00001hS251QAC","0014M00001hmDw3QAE","0014M00001hOCGRQA4","0014M0000269GsHQAU","0014M00001hmeFVQAY","0014M00001hvToGQAU","0014M00001h5NIIQA2","0014M00001lV4hYQAS","0014M00001hbX8yQAE","0014M00001rbfzkQAA","0014M00001haoeAQAQ","0014M00001hmpB8QAI","0014M00001hVsjbQAC","0014M00001hNqG1QAK","0014M00001hvTp6QAE","0014M00001lHkjcQAC","0014M00001pcphIQAQ","0014M00001h5rMSQAY","0014M00001hVlQXQA0","0014M00001hvXdTQAU","0014M00001hmeGYQAY","0014M00001hvSnIQAU","0014M00001hvTVDQA2","0014M00001h3pyaQAA","0014M00001nl7S0QAI","0014M00001hOMsMQAW","0014M00001hahlbQAA","0014M00001hQuxdQAC","0014M00001hiLcWQAU","0014M00001hhcmrQAA","0014M00001hZDE1QAO","0014M00001hZ6wxQAC","0014M00001hYMHZQA4","0014M00001htmmbQAA","0014M00001hlkiTQAQ","0014M00001hhrweQAA","0014M00001hox5IQAQ","0014M00001lUNE9QAO","0014M00001hhqauQAA","0014M00001recuuQAA","0014M00001hTnn6QAC","0014M00001h658ZQAQ","0014M00001hOTDzQAO","0014M00001hpckHQAQ","0014M00001hOTExQAO","0014M00001hq7FoQAI","0014M00001xiITqQAM","0014M00001hjY14QAE","0014M00001hpJ5YQAU","0014M00001hjbKiQAI","0014M00001hY8OaQAK","0014M00001hueOLQAY","0014M00001he6mGQAQ","0014M00001hKVFxQAO","0014M00001hpdWVQAY","0014M00001hkFfNQAU","0014M00001yR8WOQA0","0014M00001hOdgXQAS","0014M00001hjVxrQAE","0014M00001hVXp5QAG","0014M00001hXz1FQAS","0014M00001heyARQAY","0014M00001hfRvsQAE","0014M00001hkn8YQAQ","0014M00001huhBWQAY","0014M00001tQg51QAC","0014M00001hknjXQAQ","0014M00001hvBPLQA2","0014M00001hfmoMQAQ","0014M00001hm4sJQAQ","0014M00001hQygPQAS","0014M00001mI3ygQAC","0014M00001hrfZnQAI","0014M00001h5uszQAA","0014M00001hMu8kQAC","0014M00001hNCqbQAG","0014M00001hXMrCQAW","0014M00001hnxrAQAQ","0014M00001hm72jQAA","0014M00001hrthXQAQ","0014M00001hbKKTQA2","0014M00001hgzHyQAI","0014M00001hnyD5QAI","0014M00001hrhP5QAI","0014M00001hgGXeQAM","0014M00001hR356QAC","0014M00001hXS91QAG","0014M00001haalHQAQ","0014M00001hgClXQAU","0014M00001hfEMXQA2","0014M00001hgHc3QAE","0014M00001hR3viQAC","0014M00001hsYbAQAU","0014M00001hrfbKQAQ","0014M00001hhcltQAA","0014M00001hv7PqQAI","0014M00001hbH4sQAE","0014M00001hXSsyQAG","0014M00001hJocVQAS","0014M00001hmRshQAE","0014M00001hm3OtQAI","0014M00001hR0evQAC","0014M00001hf9i5QAA","0014M00001hrgwvQAA","0014M00001hZZHrQAO","0014M00001h5qZcQAI","0014M00001hm4HxQAI","0014M00001hrgy4QAA","0014M00001hbMLgQAM","0014M00001hfmoUQAQ","0014M00001h4NXjQAM","0014M00001kuQ2ZQAU","0014M00001hR1QdQAK","0014M00001hvBQUQA2","0014M00001hm2uxQAA","0014M00001h4PLFQA2","0014M00001lTxELQA0","0014M00001h4vJHQAY","0014M00001h3hA9QAI","0014M00001hci4zQAA","0014M00001hZBH5QAO","0014M00001hjzuzQAA","0014M00001haTtfQAE","0014M00001hJYHwQAO","0014M00001hXVkhQAG","0014M00001h6IIwQAM","0014M00001hbBWAQA2","0014M00001h6E1HQAU","0014M00001hScH8QAK","0014M00001hrAAWQA2","0014M00001hcXOeQAM","0014M00001hs7TvQAI","0014M00001hgig6QAA","0014M00001hlcAiQAI","0014M00001hZ1tSQAS","0014M00001hKBg6QAG","0014M00001hU8QPQA0","0014M00001hbXMNQA2","0014M00001he25WQAQ","0014M00001hNJ77QAG","0014M00001h5dYgQAI","0014M00001hmcojQAA","0014M00001hdekZQAQ","0014M00001h66SIQAY","0014M00001hdrkPQAQ","0014M00001h3frkQAA","0014M00001hM6U5QAK","0014M00001h48jdQAA","0014M00001hgY2oQAE","0014M00001hO2cyQAC","0014M00001hT2QSQA0","0014M00001hSnCYQA0","0014M00001hgxrhQAA","0014M00001hf2cPQAQ","0014M00001hYAC3QAO","0014M00001hmOh8QAE","0014M00001hKnubQAC","0014M00001heks2QAA","0014M00001hcag7QAA","0014M00001huLftQAE","0014M00001hPVvwQAG","0014M00001hZ5EBQA0","0014M00001hcclIQAQ","0014M00001hrcdCQAQ","0014M00001hrwwuQAA","0014M00001h6HLDQA2","0014M00001k44nlQAA","0014M00001hTeu8QAC","0014M00001hJoC3QAK","0014M00001h5v4VQAQ","0014M00001hXtDbQAK","0014M00001h5zW1QAI","0014M00001hObu5QAC","0014M00001hVM0TQAW","0014M00001hcTvLQAU","0014M00001hdMC3QAM","0014M00001hm2mxQAA","0014M00001hPETSQA4","0014M00001hr4WvQAI","0014M00001hr5LgQAI","0014M00001h5nFsQAI","0014M00001hO45pQAC","0014M00001hgZ7XQAU","0014M00001juDN2QAM","0014M00001hdOTAQA2","0014M00001hYiPhQAK","0014M00001hTFivQAG","0014M00001hfursQAA","0014M00001hb7rmQAA","0014M00001hs0dfQAA","0014M00001hZ8JJQA0","0014M00001hWHW9QAO","0014M00001hPAyKQAW","0014M00001h3cUDQAY","0014M00001hZvqdQAC","0014M00001hcTwVQAU","0014M00001hmfcJQAQ","0014M00001hJWX9QAO","0014M00001vn1dBQAQ","0014M00001hRzNQQA0","0014M00001heqPDQAY","0014M00001hUgXxQAK","0014M00001hcj1wQAA","0014M00001hXSEOQA4","0014M00001hNM3zQAG","0014M00001hYBvCQAW","0014M00001hreDDQAY","0014M00001hNsydQAC","0014M00001hOPRSQA4","0014M00001hPFFpQAO","0014M00001hn6ibQAA","0014M00001n6R1GQAU","0014M00001hP4SDQA0","0014M00001hNNlQQAW","0014M00001hqxTlQAI","0014M00001hOb7YQAS","0014M00001hcH3EQAU","0014M00001h4DErQAM","0014M00001hJqotQAC","0014M00001hSoawQAC","0014M00001h42bXQAQ","0014M00001hr2o1QAA","0014M00001kxTiwQAE","0014M00001hepGgQAI","0014M00001hP7F1QAK","0014M00001hPA7lQAG","0014M00001hbhp1QAA","0014M00001hO4NsQAK","0014M00001hRerkQAC","0014M00001lTijpQAC","0014M00001hcGLhQAM","0014M00001hOg0FQAS","0014M00001h49HEQAY","0014M00001hcC4uQAE","0014M00001hXTjhQAG","0014M00001huGmGQAU","0014M00001h3m1ZQAQ","0014M00001heeaDQAQ","0014M00001hS3SaQAK","0014M00001h5mNMQAY","0014M00001lTiRWQA0","0014M00001hhHqzQAE","0014M00001hTKybQAG","0014M00001hNTEFQA4","0014M00001hcxiNQAQ","0014M00001hr781QAA","0014M00001lwYwCQAU","0014M00001h3pEaQAI","0014M00001hNbAFQA0","0014M00001hvea4QAA","0014M00001h5cpbQAA","0014M00001hbYDxQAM","0014M00001hZRVSQA4","0014M00001mIRBrQAO","0014M00001hJybrQAC","0014M00001hJu1cQAC","0014M00001hXyVhQAK","0014M00001hNOV9QAO","0014M00001hSMYZQA4","0014M00001hm6OrQAI","0014M00001hU6E7QAK","0014M00001h3rwOQAQ","0014M00001h4DcxQAE","0014M00001hXHlBQAW","0014M00001h4BpLQAU","0014M00001hrTEUQA2","0014M00001hfJYEQA2","0014M00001h4YYUQA2","0014M00001hTaDPQA0","0014M00001hRaOWQA0","0014M00001hmOFjQAM","0014M00001hrNS5QAM","0014M00001hg9T5QAI","0014M00001ioTXjQAM","0014M00001hvgWPQAY","0014M00001hZqFaQAK","0014M00001hpityQAA","0014M00001hXswvQAC","0014M00001hv9fTQAQ","0014M00001hmf2TQAQ","0014M00001hJa1kQAC","0014M00001hJxrFQAS","0014M00001hYy62QAC","0014M00001hUqUEQA0","0014M00001h4QCKQA2","0014M00001hrsP0QAI","0014M00001hr42JQAQ","0014M00001hrXBdQAM","0014M00001hbcIAQAY","0014M00001h5rhmQAA","0014M00001hryO2QAI","0014M00001hStyDQAS","0014M00001hZoHaQAK","0014M00001hS6UzQAK","0014M00001hqEKlQAM","0014M00001h3TW4QAM","0014M00001hdFhzQAE","0014M00001h5cA2QAI","0014M00001hcPMuQAM","0014M00001lTiejQAC","0014M00001hSmNUQA0","0014M00001hmtR4QAI","0014M00001hJtN9QAK","0014M00001hrh7iQAA","0014M00001hfHuqQAE","0014M00001h6g2NQAQ","0014M00001hSjFFQA0","0014M00001hYzTfQAK","0014M00001hJjORQA0","0014M00001hP6FLQA0","0014M00001hmgjyQAA","0014M00001hbLbBQAU","0014M00001h4RmhQAE","0014M00001hTxzDQAS","0014M00001hYZOfQAO","0014M00001h3X2KQAU","0014M00001hhSccQAE","0014M00001hP1syQAC","0014M00001hbA34QAE","0014M00001hZr9FQAS","0014M00001hgBCDQA2","0014M00001hZYNPQA4","0014M00001hb5ipQAA","0014M00001hde39QAA","0014M00001hrBEDQA2","0014M00001h3lSlQAI","0014M00001hThShQAK","0014M00001hNmInQAK","0014M00001hqzCyQAI","0014M00001hlMfJQAU","0014M00001hcWJgQAM","0014M00001hsZHXQA2","0014M00001hrjPMQAY","0014M00001hY5uNQAS","0014M00001hgCoBQAU","0014M00001hKMLBQA4","0014M00001haFvZQAU","0014M00001hmUNGQA2","0014M00001hOHW3QAO","0014M00001hdwpSQAQ","0014M00001hbGoHQAU","0014M00001hpTiUQAU","0014M00001lTxIhQAK","0014M00001hdnfbQAA","0014M00001hrGdvQAE","0014M00001hPYsEQAW","0014M00001hOEwsQAG","0014M00001hJxpFQAS","0014M00001hrOcPQAU","0014M00001h5ySGQAY","0014M00001hKizjQAC","0014M00001hTCTLQA4","0014M00001hbbkNQAQ","0014M00001hgU2cQAE","0014M00001hcT9mQAE","0014M00001hkO33QAE","0014M00001hO0dMQAS","0014M00001hJoDIQA0","0014M00001h470qQAA","0014M00001hKbQjQAK","0014M00001hcv8mQAA","0014M00001hZEvWQAW","0014M00001hdcWjQAI","0014M00001hPLssQAG","0014M00001hRSSwQAO","0014M00001hc8xVQAQ","0014M00001hmUx7QAE","0014M00001h4R5nQAE","0014M00001hmglHQAQ","0014M00001h41gNQAQ","0014M00001hZqFLQA0","0014M00001hPJZXQA4","0014M00001hXlqjQAC","0014M00001hvhP5QAI","0014M00001h4NGeQAM","0014M00001hNSLnQAO","0014M00001hKQXhQAO","0014M00001hYNtpQAG","0014M00001htxAKQAY","0014M00001hKPYYQA4","0014M00001hZ2cnQAC","0014M00001hgOrvQAE","0014M00001hdQ3cQAE","0014M00001mm9k1QAA","0014M00001h3POyQAM","0014M00001hr5JuQAI","0014M00001hrDbhQAE","0014M00001heeYSQAY","0014M00001hb6C2QAI","0014M00001hhahBQAQ","0014M00001hW7VfQAK","0014M00001hriSNQAY","0014M00001hRvteQAC","0014M00001hZxgNQAS","0014M00001hNPQAQA4","0014M00001hP7HCQA0","0014M00001hr77pQAA","0014M00001hZdFfQAK","0014M00001hOrkhQAC","0014M00001hJX4OQAW","0014M00001hbEbcQAE","0014M00001hdmH0QAI","0014M00001hmZTkQAM","0014M00001hTtIOQA0","0014M00001hTEkgQAG","0014M00001hOcrxQAC","0014M00001hJwOQQA0","0014M00001h3OyuQAE","0014M00001h5nFnQAI","0014M00001hKQZgQAO","0014M00001hZOTGQA4","0014M00001hUoujQAC","0014M00001hSvoPQAS","0014M00001hoiQeQAI","0014M00001hqyVdQAI","0014M00001m8PSOQA2","0014M00001hav1CQAQ","0014M00001hT2SGQA0","0014M00001hgKcgQAE","0014M00001hPYs5QAG","0014M00001hZ0yfQAC","0014M00001hdhunQAA","0014M00001hbJUlQAM","0014M00001hp1mHQAQ","0014M00001h3QYiQAM","0014M00001h6GpLQAU","0014M00001h65DRQAY","0014M00001hVB5eQAG","0014M00001hg8TuQAI","0014M00001hOjtFQAS","0014M00001hd5UnQAI","0014M00001hZEwmQAG","0014M00001hs2qMQAQ","0014M00001hP0zzQAC","0014M00001hcQUSQA2","0014M00001hQgRFQA0","0014M00001hndgpQAA","0014M00001hheI2QAI","0014M00001hkpv5QAA","0014M00001hcj25QAA","0014M00001hYgSQQA0","0014M00001hmhMhQAI","0014M00001h4EhEQAU","0014M00001hYJ92QAG","0014M00001hczbMQAQ","0014M00001hc9zOQAQ","0014M00001hZ5EGQA0","0014M00001hmcoyQAA","0014M00001hgmbQQAQ","0014M00001hT0UKQA0","0014M00001hm172QAA","0014M00001h6QovQAE","0014M00001hs3ygQAA","0014M00001h4Cp9QAE","0014M00001hXWaRQAW","0014M00001hrOc9QAE","0014M00001hd9V4QAI","0014M00001h5wFlQAI","0014M00001hZH76QAG","0014M00001hsjh1QAA","0014M00001hrsiWQAQ","0014M00001hiv1dQAA","0014M00001hnsQ8QAI","0014M00001hph2DQAQ","0014M00001hS4lvQAC","0014M00001ohednQAA","0014M00001hJpstQAC","0014M00001hiqA3QAI","0014M00001hmhNeQAI","0014M00001htia7QAA","0014M00001hlxiMQAQ","0014M00001hsDhLQAU","0014M00001hRbVpQAK","0014M00001ijD9TQAU","0014M00001hXbrpQAC","0014M00001hgxMTQAY","0014M00001hrHxUQAU","0014M00001hlhDeQAI","0014M00001h3oUjQAI","0014M00001hudkXQAQ","0014M00001hP4SSQA0","0014M00001hNsx2QAC","0014M00001hvggTQAQ","0014M00001hpJuKQAU","0014M00001hvX1NQAU","0014M00001hN7JqQAK","0014M00001h45wnQAA","0014M00001hrdDrQAI","0014M00001hNLGQQA4","0014M00001hnoF3QAI","0014M00001hP5Q6QAK","0014M00001hRHEuQAO","0014M00001heCW2QAM","0014M00001hJwXjQAK","0014M00001lUObCQAW","0014M00001hZRVQQA4","0014M00001hJamZQAS","0014M00001hY6egQAC","0014M00001hmC6SQAU","0014M00001h3P0YQAU","0014M00001hbpUfQAI","0014M00001hOs4kQAC","0014M00001hUcxPQAS","0014M00001hf2VTQAY","0014M00001hPJZgQAO","0014M00001jRs6hQAC","0014M00001hbkx1QAA","0014M00001hSs6pQAC","0014M00001hd4e2QAA","0014M00001hiLuuQAE","0014M00001hi64QQAQ","0014M00001hgDMIQA2","0014M00001lUOYDQA4","0014M00001hNEc8QAG","0014M00001h3V0FQAU","0014M00001hmfpOQAQ","0014M00001hjNH9QAM","0014M00001h4Lj8QAE","0014M00001h5q2OQAQ","0014M00001hgCJzQAM","0014M00001hZzDzQAK","0014M00001hv6x3QAA","0014M00001hTIfQQAW","0014M00001hav33QAA","0014M00001hn5cJQAQ","0014M00001hcZY3QAM","0014M00001hgsvQQAQ","0014M00001hP7ZxQAK","0014M00001h5q46QAA","0014M00001h5uNNQAY","0014M00001hg9yJQAQ","0014M00001hgDLWQA2","0014M00001hN9CRQA0","0014M00001hJZ5QQAW","0014M00001h5VGRQA2","0014M00001hg9z6QAA","0014M00001h3oUsQAI","0014M00001hfurvQAA","0014M00001hmbUXQAY","0014M00001hNNl5QAG","0014M00001rbgyOQAQ","0014M00001hrtJ3QAI","0014M00001h6JIvQAM","0014M00001hJxpEQAS","0014M00001hcfgvQAA","0014M00001hgVLOQA2","0014M00001hmmX3QAI","0014M00001hmsPIQAY","0014M00001hSGuNQAW","0014M00001hZc6WQAS","0014M00001hS7VHQA0","0014M00001hKBi3QAG","0014M00001hmehIQAQ","0014M00001heitUQAQ","0014M00001h4Zt4QAE","0014M00001ha7NvQAI","0014M00001hhMoMQAU","0014M00001hZeKCQA0","0014M00001hn4rRQAQ","0014M00001hbhrcQAA","0014M00001hMdhEQAS","0014M00001hbB6xQAE","0014M00001hcsaDQAQ","0014M00001hk0jmQAA","0014M00001hLNL6QAO","0014M00001hTgVxQAK","0014M00001hZ7ffQAC","0014M00001hfrbzQAA","0014M00001hsHZKQA2","0014M00001hetdCQAQ","0014M00001heVs9QAE","0014M00001hWaQWQA0","0014M00001haig5QAA","0014M00001hJlWzQAK","0014M00001hahqfQAA","0014M00001hMuxlQAC","0014M00001mtMEJQA2","0014M00001h3Ym1QAE","0014M00001hMt5KQAS","0014M00001hRgvBQAS","0014M00001hlz2SQAQ","0014M00001hRc5LQAS","0014M00001hWdnvQAC","0014M00001h4TWoQAM","0014M00001hc7VEQAY","0014M00001k3IUJQA2","0014M00001hWebeQAC","0014M00001hWc5SQAS","0014M00001mdMP6QAM","0014M00001hTUHNQA4","0014M00001hdfhzQAA","0014M00001hj4bqQAA","0014M00001hJcFUQA0","0014M00001lV261QAC","0014M00001hJpiHQAS","0014M00001hda7zQAA","0014M00001hv1NNQAY","0014M00001hTcG8QAK","0014M00001hXalHQAS","0014M00001hV4irQAC","0014M00001hbdRYQAY","0014M00001nkw7IQAQ","0014M00001kgCFoQAM","0014M00001hO8DHQA0","0014M00001xA1myQAC","0014M00001hO7PEQA0","0014M00001hWzOiQAK","0014M00001hm59kQAA","0014M00001hJecpQAC","0014M00001hhNONQA2","0014M00001ho1VOQAY","0014M00001hTSqSQAW","0014M00001h52GDQAY","0014M00001hRE19QAG","0014M00001huDUzQAM","0014M00001hTRwMQAW","0014M00001htct2QAA","0014M00001hmuh8QAA","0014M00001hTpTjQAK","0014M00001hOfutQAC","0014M00001hsLXCQA2","0014M00001hj0xCQAQ","0014M00001hkyGHQAY","0014M00001hTc29QAC","0014M00001hs1p1QAA","0014M00001hOyQQQA0","0014M00001hYXIyQAO","0014M00001hWkxpQAC","0014M00001hQA5iQAG","0014M00001h5VHYQA2","0014M000026rYF0QAM","0014M00001hhF4NQAU","0014M00001hYPPxQAO","0014M00001m2TjUQAU","0014M00001hYFbTQAW","0014M00001hOr6GQAS","0014M00001hOsTjQAK","0014M00001he3c9QAA","0014M00001hWq6hQAC","0014M00001hbALDQA2","0014M00001ho2b5QAA","0014M00001htcsRQAQ","0014M00001htbPXQAY","0014M00001n6bCwQAI","0014M00001htnkxQAA","0014M00001hXR4rQAG","0014M00001hcdoWQAQ","0014M00001hjSJbQAM","0014M00001hbbkqQAA","0014M00001hngBLQAY","0014M00001hnGUkQAM","0014M00001hcej6QAA","0014M00001hsLXVQA2","0014M00001hTvUMQA0","0014M00001qLANbQAO","0014M00001hOr7eQAC","0014M00001hnGsLQAU","0014M00001hpmpCQAQ","0014M00001hdfitQAA","0014M00001hdmroQAA","0014M00001hZ1WPQA0","0014M00001hqcEYQAY","0014M00001hMU2IQAW","0014M00001hLV47QAG","0014M00001hM6enQAC","0014M00001hSXV7QAO","0014M00001htHlrQAE","0014M00001hoLUyQAM","0014M00001hZ1VoQAK","0014M00001hMqKtQAK","0014M00001hrc1IQAQ","0014M00001hWedJQAS","0014M00001hRguzQAC","0014M00001hWeeFQAS","0014M00001hWaODQA0","0014M00001heRpiQAE","0014M00001hJfEEQA0","0014M00001hMqK1QAK","0014M00001hWZbdQAG","0014M00001h5WVQQA2","0014M00001hRgAbQAK","0014M00001hcVjOQAU","0014M00001hMqIvQAK","0014M00001hRPr5QAG","0014M00001hqzVRQAY","0014M0000267jNgQAI","0014M00001hgV2vQAE","0014M00001hqzXRQAY","0014M00001heTO6QAM","0014M00001hTIx6QAG","0014M00001hTcIXQA0","0014M00001hTRirQAG","0014M00001hObaeQAC","0014M00001hdsAbQAI","0014M00001hj3SvQAI","0014M00001hXRSsQAO","0014M00001hOcJnQAK","0014M00001hv3jbQAA","0014M00001hOlvXQAS","0014M00001hOk54QAC","0014M00001hj5LXQAY","0014M00001hh5ASQAY","0014M00001hpPKUQA2","0014M00001hdufAQAQ","0014M00001hTdsiQAC","0014M00001hj3TsQAI","0014M00001hv2MPQAY","0014M00001hdsC0QAI","0014M00001hl4GEQAY","0014M00001lV21QQAS","0014M00001hJfipQAC","0014M00001hdwOQQAY","0014M00001hTcI3QAK","0014M00001hpRJgQAM","0014M00001hTiDnQAK","0014M00001hJpiCQAS","0014M00001hXOcJQAW","0014M00001hj7LfQAI","0014M00001hr8RCQAY","0014M00001hLJp6QAG","0014M00001hZ5tFQAS","0014M00001hqUZ5QAM","0014M00001hZ7fPQAS","0014M00001hQA5JQAW","0014M00001hYZg1QAG","0014M00001hkX8DQAU","0014M00001heLEuQAM","0014M00001hlRMFQA2","0014M00001hlCZ1QAM","0014M00001hZ6mhQAC","0014M00001hlBmGQAU","0014M00001hle4mQAA","0014M00001hdbFZQAY","0014M00001hLKqEQAW","0014M00001hV8AaQAK","0014M00001hPQFoQAO","0014M00001hV4jVQAS","0014M00001hbYj5QAE","0014M00001h3qESQAY","0014M00001hOfzVQAS","0014M00001hn3EkQAI","0014M00001h6ETNQA2","0014M00001hqozGQAQ","0014M00001hbYiQQAU","0014M00001hqtUYQAY","0014M00001h3wnZQAQ","0014M00001jaHfjQAE","0014M00001hOg0JQAS","0014M00001hr3r7QAA","0014M00001hOfzzQAC","0014M00001h42pCQAQ","0014M00001hpJ6HQAU","0014M00001k4NffQAE","0014M00001hqoyMQAQ","0014M00001tRv4SQAS","0014M00001hO4v1QAC","0014M00001hTnVLQA0","0014M00001hkLQgQAM","0014M00001lvQ11QAE","0014M00001hi0qeQAA","0014M00001lv9FLQAY","0014M00001hKsOWQA0","0014M00001hbcPBQAY","0014M00001hbcOcQAI","0014M00001h3XKSQA2","0014M00001hdeLOQAY","0014M00001hg5KtQAI","0014M00001hsI4RQAU","0014M00001hYZnHQAW","0014M00001hvHA0QAM","0014M00001hlZJUQA2","0014M00001hWOk4QAG","0014M00001h5NqhQAE","0014M00001hPuwoQAC","0014M00001hVSdMQAW","0014M00001hY8UNQA0","0014M00001hL9dxQAC","0014M00001hYxVHQA0","0014M00001h5G9uQAE","0014M00001qxDAQQA2","0014M00001rbfWJQAY","0014M00001hZLF4QAO","0014M00001hdmrSQAQ","0014M00001hR77EQAS","0014M00001hLQO2QAO","0014M00001hlY9oQAE","0014M00001hqaQfQAI","0014M00001m2mCUQAY","0014M00001hp1d4QAA","0014M00001nU9dTQAS","0014M00001hu1vvQAA","0014M00001hTUnSQAW","0014M00001hm5g7QAA","0014M00001h3H0TQAU","0014M00001h5FFvQAM","0014M00001hcyreQAA","0014M00001hiyXvQAI","0014M00001hJdvlQAC","0014M00001hqNSfQAM","0014M00001h3E0GQAU","0014M00001hlRe3QAE","0014M00001hdbnoQAA","0014M00001hljroQAA","0014M00001hlvr2QAA","0014M00001hRAVlQAO","0014M00001hlyjJQAQ","0014M00001hRF4IQAW","0014M00001hcbOvQAI","0014M00001huIgUQAU","0014M00001hUIAwQAO","0014M00001hcvB2QAI","0014M00001hNoeDQAS","0014M00001m9A9sQAE","0014M00001hcabIQAQ","0014M00001hNK34QAG","0014M00001h5XQuQAM","0014M00001hK4AmQAK","0014M00001hp0vbQAA","0014M00001hOjEjQAK","0014M00001hUwEmQAK","0014M00001hlT8JQAU","0014M00001hK81wQAC","0014M00001hh2zmQAA","0014M00001hmtK2QAI","0014M00001hsZMTQA2","0014M00001hpFwFQAU","0014M00001hYfssQAC","0014M00001hmrG0QAI","0014M00001heXYjQAM","0014M00001hrynZQAQ","0014M00001hcAvWQAU","0014M00001hs0ZXQAY","0014M00001hRF2AQAW","0014M00001hrvbUQAQ","0014M00001hTkXkQAK","0014M00001hK81XQAS","0014M00001hK2TqQAK","0014M00001hh5ArQAI","0014M00001hrvcMQAQ","0014M00001hTmyHQAS","0014M00001hmyG8QAI","0014M00001hTgW0QAK","0014M00001h4nnmQAA","0014M00001hjE37QAE","0014M00001hKASdQAO","0014M00001m2gy1QAA","0014M00001hYY8bQAG","0014M00001hrxFhQAI","0014M00001hhda3QAA","0014M00001hctWlQAI","0014M00001mm4xZQAQ","0014M00001hs4AdQAI","0014M00001hWaPrQAK","0014M00001h4tV7QAI","0014M00001hv0QLQAY","0014M00001hLEdYQAW","0014M00001hcmWVQAY","0014M00001hhJv8QAE","0014M00001hQ7E1QAK","0014M00001hs39QQAQ","0014M00001hmriKQAQ","0014M00001h4c6TQAQ","0014M00001hm7yJQAQ","0014M00001hcptaQAA","0014M00001hlScQQAU","0014M00001hmtM0QAI","0014M00001hZaddQAC","0014M00001hYSo6QAG","0014M00001hpxzUQAQ","0014M00001hhOPxQAM","0014M00001hut9vQAA","0014M00001hmvu9QAA","0014M00001hs1OpQAI","0014M00001hpv8xQAA","0014M00001hZsdzQAC","0014M00001hOqKhQAK","0014M00001hcmUeQAI","0014M00001hjTLNQA2","0014M00001hJqZoQAK","0014M00001hjdm8QAA","0014M00001hYUT7QAO","0014M00001hmuFcQAI","0014M00001hUlB9QAK","0014M00001rbfBWQAY","0014M00001hq1BuQAI","0014M00001hu9MoQAI","0014M00001hhMKkQAM","0014M00001hUTHyQAO","0014M00001hZTd5QAG","0014M00001hgPSkQAM","0014M00001hPh65QAC","0014M00001hrzEeQAI","0014M00001hPvRoQAK","0014M00001hTrNxQAK","0014M00001hlkhbQAA","0014M00001h4caWQAQ","0014M00001hZoLSQA0","0014M00001hPJX4QAO","0014M00001hTizWQAS","0014M00001qnvEhQAI","0014M00001hlUY0QAM","0014M00001he79aQAA","0014M00001hPvRDQA0","0014M00001hul0FQAQ","0014M00001hTiCBQA0","0014M00001her7LQAQ","0014M00001hYbkqQAC","0014M00001hUUzBQAW","0014M00001hpukuQAA","0014M00001hkTgrQAE","0014M00001hPmy7QAC","0014M00001hYqUaQAK","0014M00001hVdviQAC","0014M00001iqNj4QAE","0014M00001hmrGdQAI","0014M00001hgCHyQAM","0014M00001hMhtnQAC","0014M00001ihhxrQAA","0014M00001hXFvxQAG","0014M00001hujmyQAA","0014M00001hejHFQAY","0014M00001hrvcdQAA","0014M00001hmrGxQAI","0014M00001hcl0cQAA","0014M00001hZjLFQA0","0014M00001hrw9CQAQ","0014M00001k2l3PQAQ","0014M00001hlq9KQAQ","0014M00001hPFLDQA4","0014M00001hcbW1QAI","0014M00001hMaXsQAK","0014M00001nVTPkQAO","0014M00001hq8ZMQAY","0014M00001hlBuFQAU","0014M00001hLwSJQA0","0014M00001hq7GeQAI","0014M00001hWHxVQAW","0014M00001hWQVbQAO","0014M00001s9vrgQAA","0014M00001hUsYVQA0","0014M00001htrQpQAI","0014M00001hYIamQAG","0014M00001hYKNNQA4","0014M00001hYBbXQAW","0014M00001hlJacQAE","0014M00001hlBYiQAM","0014M00001hUsVxQAK","0014M00001hjEsRQAU","0014M00001hjDMeQAM","0014M00001hYv2PQAS","0014M00001hq7Z2QAI","0014M00001hWmpbQAC","0014M00001hLwQLQA0","0014M00001hjEsEQAU","0014M00001hckVwQAI","0014M00001he8mEQAQ","0014M00001hlkoBQAQ","0014M00001htrOlQAI","0014M00001uHS40QAG","0014M00001hVl12QAC","0014M00001hUsWQQA0","0014M00001hjDKAQA2","0014M00001hqbfZQAQ","0014M00001hPxSdQAK","0014M00001hYJY3QAO","0014M00001hdJHOQA2","0014M00001hjDLVQA2","0014M00001hcbW4QAI","0014M00001hVJksQAG","0014M00001hPG6RQAW","0014M00001htqaTQAQ","0014M00001lyl41QAA","0014M00001hdJHeQAM","0014M00001hYCSZQA4","0014M00001hYCTjQAO","0014M00001hjE4IQAU","0014M00001hLwPMQA0","0014M00001hUsXtQAK","0014M00001huqMbQAI","0014M00001hPG5zQAG","0014M00001hrE8jQAE","0014M00001hYa3tQAC","0014M00001hdMQcQAM","0014M00001hjEsaQAE","0014M00001hcaY6QAI","0014M00001hPO8tQAG","0014M00001hlsPOQAY","0014M00001hYJZIQA4","0014M00001hjE48QAE","0014M00001hLwRdQAK","0014M00001hRHibQAG","0014M00001hjFZMQA2","0014M00001h5wsIQAQ","0014M00001hcbWWQAY","0014M00001hlB6uQAE","0014M00001hM3uIQAS","0014M00001htqbWQAQ","0014M00001hYCSpQAO","0014M00001hVhRKQA0","0014M00001hPOwfQAG","0014M00001hlAfLQAU","0014M00001htqZ7QAI","0014M00001hPNQ5QAO","0014M00001hUuRpQAK","0014M00001hPO90QAG","0014M00001hLxFsQAK","0014M00001hPFLEQA4","0014M00001hYBbsQAG","0014M00001htrR4QAI","0014M00001hq7YCQAY","0014M00001hPG6IQAW","0014M00001lSeE7QAK","0014M00001hccWEQAY","0014M00001hNh7cQAC","0014M00001hYJXeQAO","0014M00001hPOAqQAO","0014M00001hfcl5QAA","0014M00001hKEo1QAG","0014M00001hc2cTQAQ","0014M00001jSdSDQA0","0014M00001kanETQAY","0014M00001htXKJQA2","0014M00001hdNAcQAM","0014M00001klK3JQAU","0014M00001hKEmxQAG","0014M00001hUEKqQAO","0014M00001hUFxMQAW","0014M00001hqASiQAM","0014M00001hkAMdQAM","0014M00001hQaewQAC","0014M00001hbB0kQAE","0014M00001n6bILQAY","0014M00001hQicyQAC","0014M00001hNp7wQAC","0014M00001hNoB3QAK","0014M00001hq7oCQAQ","0014M00001hY1qlQAC","0014M00001hNoD0QAK","0014M00001hrH69QAE","0014M00001hY9poQAC","0014M00001hN6UzQAK","0014M00001hUMmdQAG","0014M00001jwiP5QAI","0014M00001hPgjrQAC","0014M00001kwVP0QAM","0014M00001hb2o2QAA","0014M00001hq5fKQAQ","0014M00001hjxG2QAI","0014M00001hlrtCQAQ","0014M00001hXzACQA0","0014M00001lyy57QAA","0014M00001jbD4CQAU","0014M00001hWyjHQAS","0014M00001hKqGZQA0","0014M00001hihL7QAI","0014M00001hKJqYQAW","0014M00001hc6CrQAI","0014M00001hY1qwQAC","0014M00001hY0DZQA0","0014M00001hKIoNQAW","0014M00001htYYZQA2","0014M00001htYZZQA2","0014M00001hL8y3QAC","0014M00001p2T17QAE","0014M00001hipvpQAA","0014M00001iqTWjQAM","0014M00001hkalmQAA","0014M00001hqAtpQAE","0014M00001hY6x7QAC","0014M00001hkCHdQAM","0014M00001hirjtQAA","0014M00001hUO6mQAG","0014M00001hlzuAQAQ","0014M00001hq7pJQAQ","0014M00001hkBGOQA2","0014M00001hNioPQAS","0014M00001h5uBxQAI","0014M00001hdGA4QAM","0014M00001h42dlQAA","0014M00001hnQ6fQAE","0014M00001h3lWyQAI","0014M00001hgeR2QAI","0014M00001htuPqQAI","0014M00001hhjPzQAI","0014M00001hhwj3QAA","0014M00001hoKgCQAU","0014M00001hRPLmQAO","0014M00001hhcfgQAA","0014M00001hMkk2QAC","0014M00001hhld1QAA","0014M00001h5RhHQAU","0014M00001hVamiQAC","0014M00001hiRHLQA2","0014M00001hp5OIQAY","0014M00001hOB6EQAW","0014M00001meEuDQAU","0014M00001lHdYcQAK","0014M00001hO4nXQAS","0014M00001huiauQAA","0014M00001hjFUIQA2","0014M00001hd6LDQAY","0014M00001hWmYUQA0","0014M00001heFQqQAM","0014M00001hPls7QAC","0014M00001hiqrTQAQ","0014M00001hf6o2QAA","0014M00001hendwQAA","0014M00001hRM0nQAG","0014M00001hXoQvQAK","0014M00001hcRwmQAE","0014M00001hXuLEQA0","0014M00001h3QEXQA2","0014M00001hree3QAA","0014M00001m2U0GQAU","0014M00001hbJzbQAE") ;;
+ }
+ dimension: segment {
+ alias: [account_meta.segment]
+ view_label: "Account"
+ description: "Account Segment from Vector"
+ sql: ${TABLE}.segment ;;
+ }
+ dimension: sector {
+ alias: [account_meta.sector]
+ }
+ dimension: sfdc_account_id {
+ alias: [account_meta.sfdc_account_id]
+ label: "SFDC Account ID"
+ view_label: "Account"
+ description: "Salesforce account of the opportunity"
+ type: string
+ sql: ${TABLE}.sfdc_account_id ;;
+ link: {
+ label: "Account in Vector"
+ url: "https://vector.lightning.force.com/lightning/r/Account/{{ value }}/view"
+ }
+ }
+ dimension: sub_region {
+ alias: [account_meta.sub_region]
+ }
+ dimension: sub_industry {
+ view_label: "Account"
+ group_label: "Industry"
+ description: "Examples: Education, Construction, Electronics"
+ alias: [account_meta.sub_industry]
+ sql: ${TABLE}.sub_industry ;;
+ drill_fields: [micro_industry]
+ }
+ ##### PARAMETERS #####
+ parameter: region_granularity {
+ alias: [account_meta.region_granularity]
+ allowed_value: {
+ label: "Region"
+ value: "region"
+ }
+ allowed_value: {
+ label: "EMEA Geocluster"
+ value: "geocluster"
+ }
+ allowed_value: {
+ label: "NORTHAM Sector"
+ value: "sector"
+ }
+ allowed_value: {
+ label: "Sub Region"
+ value: "sub_region"
+ }
+ allowed_value: {
+ label: "Micro Region"
+ value: "micro_region"
+ }
+ allowed_value: {
+ label: "NAL Cluster"
+ value: "nal_cluster"
+ }
+ allowed_value: {
+ label: "NAL Name"
+ value: "nal_name"
+ }
+ allowed_value: {
+ label: "NAL ID"
+ value: "nal_id"
+ }
+ allowed_value: {
+ label: "Reporting Account Name"
+ value: "reporting_account_name"
+ }
+ allowed_value: {
+ label: "SFDC Account ID"
+ value: "sfdc_account_id"
+ }
+ }
+}
diff --git a/views/revenue/revenue.view.lkml b/views/revenue/revenue.view.lkml
index 9dfb42d..cba9b62 100644
--- a/views/revenue/revenue.view.lkml
+++ b/views/revenue/revenue.view.lkml
@@ -1,80 +1,80 @@
# Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue.view.lkml
+include: "account_from_account_revenue.view.lkml"
+include: "revenue_from_revenue.view.lkml"
-# bits from:
-# https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/account_from_account_revenue.view.lkml
view: revenue {
-
+ extends: [account_from_revenue, revenue_from_revenue]
sql_table_name: `concord-test.stagingservice_gcc.gcc_revenue_partitioned_view`;;
- dimension: billing_account_id {
- view_label: "Account"
- group_label: "Identifiers"
- description: "Billing account ID"
- sql: ${TABLE}.billing_account_id ;;
- }
+ # dimension: billing_account_id {
+ # view_label: "Account"
+ # group_label: "Identifiers"
+ # description: "Billing account ID"
+ # sql: ${TABLE}.billing_account_id ;;
+ # }
- dimension: sfdc_account_id {
- alias: [account_meta.sfdc_account_id]
- label: "SFDC Account ID"
- view_label: "Account"
- description: "Salesforce account of the opportunity"
- type: string
- sql: ${TABLE}.sfdc_account_id ;;
- link: {
- label: "Account in Vector"
- url: "https://vector.lightning.force.com/lightning/r/Account/{{ value }}/view"
- }
- }
+ # dimension: sfdc_account_id {
+ # alias: [account_meta.sfdc_account_id]
+ # label: "SFDC Account ID"
+ # view_label: "Account"
+ # description: "Salesforce account of the opportunity"
+ # type: string
+ # sql: ${TABLE}.sfdc_account_id ;;
+ # link: {
+ # label: "Account in Vector"
+ # url: "https://vector.lightning.force.com/lightning/r/Account/{{ value }}/view"
+ # }
+ # }
- dimension: currency_code {
- view_label: "Revenue"
- description: "Three letter currency code (e.g. USD) for local billing amount."
- sql: ${TABLE}.currency_code ;;
- }
+ # dimension: currency_code {
+ # view_label: "Revenue"
+ # description: "Three letter currency code (e.g. USD) for local billing amount."
+ # sql: ${TABLE}.currency_code ;;
+ # }
- dimension_group: invoice_month_start {
- type: time
- timeframes: [raw, date, week, month, quarter, year]
- view_label: "Revenue"
- sql: ${TABLE}.invoice_month_start ;;
- datatype: date
- convert_tz: no
- }
+ # dimension_group: invoice_month_start {
+ # type: time
+ # timeframes: [raw, date, week, month, quarter, year]
+ # view_label: "Revenue"
+ # sql: ${TABLE}.invoice_month_start ;;
+ # datatype: date
+ # convert_tz: no
+ # }
- dimension: product_family_l1 {
- label: "Product Family (L1)"
- group_label: "Finance Product Hierarchy"
- view_label: "Product"
- description: "Examples: Google Workspace, GCP, Maps, PSO"
- sql: ${TABLE}.product_group ;;
- drill_fields: [product_group_l2]
- }
- dimension: product_group_l2 {
- label: "Product Group (L2)"
- group_label: "Finance Product Hierarchy"
- view_label: "Product"
- description: "Examples: Marketplace Services, Compute, Support, Databases, etc."
- sql: ${TABLE}.product_group_l2 ;;
- drill_fields: [logical_product_l3]
- }
- dimension: logical_product_l3 {
- label: "Logical Product (L3)"
- group_label: "Finance Product Hierarchy"
- view_label: "Product"
- description: "Examples: Persistent Disk, VM Image Storage, GCE"
- sql: ${TABLE}.logical_product_l3 ;;
- }
+ # dimension: product_family_l1 {
+ # label: "Product Family (L1)"
+ # group_label: "Finance Product Hierarchy"
+ # view_label: "Product"
+ # description: "Examples: Google Workspace, GCP, Maps, PSO"
+ # sql: ${TABLE}.product_group ;;
+ # drill_fields: [product_group_l2]
+ # }
+ # dimension: product_group_l2 {
+ # label: "Product Group (L2)"
+ # group_label: "Finance Product Hierarchy"
+ # view_label: "Product"
+ # description: "Examples: Marketplace Services, Compute, Support, Databases, etc."
+ # sql: ${TABLE}.product_group_l2 ;;
+ # drill_fields: [logical_product_l3]
+ # }
+ # dimension: logical_product_l3 {
+ # label: "Logical Product (L3)"
+ # group_label: "Finance Product Hierarchy"
+ # view_label: "Product"
+ # description: "Examples: Persistent Disk, VM Image Storage, GCE"
+ # sql: ${TABLE}.logical_product_l3 ;;
+ # }
- 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_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 ;;
+ # }
}
diff --git a/views/revenue/revenue_from_revenue.view.lkml b/views/revenue/revenue_from_revenue.view.lkml
new file mode 100644
index 0000000..21e4606
--- /dev/null
+++ b/views/revenue/revenue_from_revenue.view.lkml
@@ -0,0 +1,908 @@
+# emulates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue_from_revenue.view.lkml
+view: revenue_from_revenue {
+ extension: required
+ ########## DIMENSIONS ############
+ dimension: currency_code {
+ view_label: "Revenue"
+ description: "Three letter currency code (e.g. USD) for local billing amount."
+ sql: ${TABLE}.currency_code ;;
+ }
+ dimension: dynamic_usage_timeframe {
+ view_label: "Revenue"
+ description: "Dynamic field that is returns usage date, dependent on `Usage Timeframe Selector`. If none selected, defaults to daily."
+ type: date
+ sql: CASE
+ WHEN {% parameter usage_timeframe_selector %} = 'Date' THEN SAFE_CAST(${usage_date} AS STRING)
+ WHEN {% parameter usage_timeframe_selector %} = 'Week' THEN ${usage_week}
+ WHEN {% parameter usage_timeframe_selector %} = 'Month' THEN CONCAT(${usage_month},"-01")
+ END ;;
+ }
+ dimension: gcp_revenue_source {
+ view_label: "Revenue"
+ label: "GCP Revenue Source"
+ description: "Used by the Northam team to filter revenue. Values can be Organic GCP (all products except for Marketplace Services), MP Standard (Marketplace Services that aren't pre-paid), or MP Prepay (Marketplace Services that are prepaid)."
+ case: {
+ when: {
+ sql: ${product_group} != "Non-Cloud" ;;
+ label: "Organic GCP"
+ }
+ when: {
+ sql: ${product_group} = "Non-Cloud" AND NOT ${is_nonmetered} ;;
+ label: "MP Standard"
+ }
+ when: {
+ sql: ${product_group} = "Non-Cloud" AND ${is_nonmetered} ;;
+ label: "MP Prepaid"
+ }
+ else: "Other Revenue"
+ }
+ }
+ dimension_group: invoice_month_start {
+ type: time
+ timeframes: [raw, date, week, month, quarter, year]
+ view_label: "Revenue"
+ sql: ${TABLE}.invoice_month_start ;;
+ datatype: date
+ convert_tz: no
+ }
+
+ dimension: is_data_analytics {
+ type: yesno
+ label: "Is Data Analytics?"
+ view_label: "Product"
+ sql: ${revenue.product_group_l2} = 'Analytics'
+ OR ${revenue.is_dataproc}
+ OR ${revenue.logical_product_l3} IN ('AI Platform', 'Confluent', 'Confluent Dev',
+ 'Confluent Staging', 'Databricks', 'Elastic', 'Elastic - Dev', 'Fivetran',
+ 'Informatica', 'MongoDB Inc.', 'Palantir') ;;
+ description: "Returns yes if this is Data & Analytics (DA) usage"
+ }
+ dimension: is_dataproc {
+ type: yesno
+ label: "Is Dataproc Node?"
+ view_label: "Product"
+ sql: ${TABLE}.is_dataproc_node ;;
+ description: "Does this usage come from a Dataproc node?"
+ }
+ dimension: is_gcp_marketplace {
+ type: yesno
+ label: "Is GCP Marketplace?"
+ view_label: "Product"
+ sql: ${TABLE}.is_gcp_marketplace ;;
+ }
+ dimension: is_gke_node {
+ type: yesno
+ label: "Is GKE Node?"
+ view_label: "Product"
+ sql: ${TABLE}.is_gke_node ;;
+ description: "Does this usage come from a GKE node?"
+ }
+ dimension: product_family_l1 {
+ label: "Product Family (L1)"
+ group_label: "Finance Product Hierarchy"
+ view_label: "Product"
+ description: "Examples: Google Workspace, GCP, Maps, PSO"
+ sql: ${TABLE}.product_group ;;
+ drill_fields: [product_group_l2]
+ }
+ dimension: product_group_l2 {
+ label: "Product Group (L2)"
+ group_label: "Finance Product Hierarchy"
+ view_label: "Product"
+ description: "Examples: Marketplace Services, Compute, Support, Databases, etc."
+ sql: ${TABLE}.product_group_l2 ;;
+ drill_fields: [logical_product_l3]
+ }
+ dimension: logical_product_l3 {
+ label: "Logical Product (L3)"
+ group_label: "Finance Product Hierarchy"
+ view_label: "Product"
+ description: "Examples: Persistent Disk, VM Image Storage, GCE"
+ sql: ${TABLE}.logical_product_l3 ;;
+ }
+ # dimension: machine_type {
+ # view_label: "Product"
+ # description: "Machine Type Classifications for Compute Engine"
+ # sql: IF(${product_line_raw} = "Compute Engine", CASE
+ # WHEN ${is_gke_node} THEN "GKE"
+ # WHEN ${is_dataproc} THEN "Dataproc"
+ # WHEN ${sku_description} LIKE '%A2 %' THEN 'A2'
+ # WHEN ${sku_description} LIKE '%E2 %' THEN 'E2'
+ # WHEN ${sku_description} LIKE '%Memory%optimized%' THEN 'M1/M2'
+ # WHEN ${sku_description} LIKE '%N2 %' THEN 'N2'
+ # WHEN ${sku_description} LIKE '%N2D%' THEN 'N2D'
+ # WHEN ${sku_description} LIKE '%Compute%optimized%' THEN 'C2'
+ # WHEN LOWER(${sku_description}) LIKE '%custom%ram%' OR ${sku_description} LIKE '%Custom%Core%' OR ${sku_description} LIKE '%N1 %' OR ${sku_description} LIKE '%v1: Cpu%' OR ${sku_description} LIKE '%v1: Ram%' OR ${sku_description} LIKE '%Instance Ram hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance RAM%' OR ${sku_description} LIKE '%Sole Tenancy Instance Ram%' OR ${sku_description} LIKE '%Instance Core hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance Core%' OR ${sku_description} LIKE 'Micro Instance%' OR ${sku_description} LIKE 'Preemptible Micro Instance%' OR ${sku_description} LIKE '%Small Instance%' THEN "N1"
+ # ELSE "Other Machine Type"
+ # END, NULL) ;;
+ # drill_fields: [sku_description]
+ # }
+ dimension: product_group {
+ group_label: "Legacy Product Hierarchy"
+ view_label: "Product"
+ description: "Groupings of Product Line into broader categories like \"Compute\" or \"Data Analytics\""
+ sql: ${TABLE}.product_group ;;
+ drill_fields: [product_line]
+ }
+ dimension: product_line {
+ group_label: "Legacy Product Hierarchy"
+ view_label: "Product"
+ description: "Product Line, but with is_gke_node = True reassigned to Kubernetes Engine and is_dataproc = True reassigned to Dataproc"
+ sql: IF(${product_line_raw} = "Compute Engine",
+ CASE
+ WHEN ${is_gke_node} THEN "Kubernetes Engine"
+ WHEN ${is_dataproc} THEN "Dataproc"
+ ELSE "Compute Engine"
+ END,
+ ${product_line_raw});;
+ drill_fields: [sku_description, ]
+ }
+ dimension: product_line_raw {
+ hidden: yes
+ group_label: "Legacy Product Hierarchy"
+ view_label: "Product"
+ sql: ${TABLE}.product_line;;
+ #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: 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_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]
+ view_label: "Revenue"
+ description: "Date on which usage was recorded"
+ sql: ${TABLE}.partition_date ;;
+ datatype: date
+ convert_tz: no
+ }
+ dimension: usd_revenue_blended {
+ hidden: yes
+ view_label: "Revenue"
+ sql: {% if filter_nonmetered._parameter_value == "true" %}
+ IF(NOT ${is_nonmetered}, ${TABLE}.usd_revenue_blended, 0)
+ {% else %}
+ ${TABLE}.usd_revenue_blended
+ {% endif %}
+ ;;
+ }
+ dimension: usd_revenue_bmod {
+ hidden: yes
+ view_label: "Revenue"
+ sql: ${TABLE}.usd_revenue_bmod ;;
+ }
+ 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"
+ sql: {% if filter_nonmetered._parameter_value == "true" %}
+ IF(NOT ${is_nonmetered}, ${TABLE}.usd_revenue_net_cn, 0)
+ {% else %}
+ ${TABLE}.usd_revenue_net_cn
+ {% 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 ;;
+ }
+ #### 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."
+ type: sum
+ sql: ${usd_revenue_net} - ${usd_revenue_cross_pa_credits};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_actuals, 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.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_bmod {
+ group_label: "Discounts, Credits & BMODS"
+ label: "Revenue (Billing Modifications)"
+ view_label: "Revenue"
+ description: "The subset of revenue that is due to a billing modification. Billing Modifications (BMods) are requested when an adjustment affecting the regular invoicing process needs to be made."
+ type: sum
+ sql: ${usd_revenue_bmod};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, usd_revenue_bmod, revenue_gross, revenue_net_cn]
+ # 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)"
+ view_label: "Revenue"
+ description: "Cross PA Credits."
+ type: sum
+ sql: ${usd_revenue_cross_pa_credits};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_cross_pa_credits, revenue_gross, revenue_net_cn]
+ # 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)"
+ view_label: "Revenue"
+ description: "Committed Usage Discount credits applied against the Gross amount."
+ type: sum
+ sql: ${usd_revenue_cud};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_cud, revenue_gross, revenue_net_cn]
+ # 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)"
+ view_label: "Revenue"
+ description: "Differences between Gross and Revenue (Sales) not due to BMods, CUD, SUD, Free Trial, or Promo, Cross PA Credits."
+ 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
+ , 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} ;;
+ }
+ measure: revenue_ft {
+ group_label: "Discounts, Credits & BMODS"
+ label: "Revenue (Free Trial)"
+ view_label: "Revenue"
+ description: "Free Trial credit applied against the Gross amount."
+ type: sum
+ sql: ${usd_revenue_ft};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_ft, revenue_gross, revenue_net_cn]
+ # 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"
+ description: "Monetised values for resource consumption, before application of credits (adjustments). Gross values are generally positive."
+ type: sum
+ sql: ${usd_revenue_gross};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_gross, revenue_net_cn]
+ # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
+ # html: @{custom_dollar_formatting} ;;
+ 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.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"
+ }
+ }
+ measure: revenue_list {
+ label: "[go/listrev] Revenue (List)"
+ view_label: "Revenue"
+ description: "Learn more at go/listrev. Amount of monetized usage calculared based on the list price of each SKU (with no discounts applied)."
+ type: sum
+ sql: ${usd_revenue_list} ;;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_list, revenue_gross, revenue_net_cn]
+ # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
+ # html: @{custom_dollar_formatting} ;;
+ link: {
+ url: "http://go/listrev"
+ label: "Learn more about List Revenue Metric"
+ }
+ 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.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"
+ }
+ }
+ measure: revenue_net_cn {
+ label: "Revenue (Sales)"
+ view_label: "Revenue"
+ description: "Channel-neutral revenue (usd_revenue_net_cn) for accounts which are SMB, Corp, or GPS. Net-to-google revenue for commercial Select/Enterprise accounts."
+ type: sum
+ sql: ${usd_revenue_blended};;
+ 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_promo {
+ group_label: "Discounts, Credits & BMODS"
+ label: "Revenue (Promo)"
+ view_label: "Revenue"
+ description: "Other promotional credits applied against the Gross amount"
+ type: sum
+ sql: ${usd_revenue_promo};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_promo, revenue_gross, revenue_net_cn]
+ # 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)"
+ view_label: "Revenue"
+ description: "Reseller Discount credits applied against the Gross amount."
+ type: sum
+ sql: ${usd_revenue_reseller};;
+ value_format_name: usd_0
+ drill_fields: [billing_account_id, revenue_reseller, revenue_gross, revenue_net_cn]
+ # 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)"
+ view_label: "Revenue"
+ description: "Sustained Usage Discount credits applied against the Gross amount."
+ type: sum
+ sql: ${usd_revenue_sud};;
+ value_format_name: usd_0
+ drill_fields: [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} ;;
+ }
+ measure: revenue_toggle {
+ group_label: "Other Revenue"
+ label: "Revenue (Toggle-able)"
+ label_from_parameter: metric_selector
+ view_label: "Revenue"
+ description: "This parameter is for dashboard building only! This allows users to select a metric type
+ from a dashboard filter. For example, the dashboard might default to using Gross Revenue, but the user
+ can use this parameter to change to using 2021 Def. Sales Revenue instead. Must be used with the
+ Metric Selector parameter to select what this metric will display"
+ type: sum
+ sql: {% if metric_selector._parameter_value == 'invoice' %} ${usd_revenue_net}
+ {% elsif metric_selector._parameter_value == 'ntg' %} ${usd_revenue_ntg}
+ {% 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]
+ value_format_name: usd_0
+ 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.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} ;;
+ }
+ #### PARAMETERS ####
+ parameter: metric_selector {
+ view_label: "Revenue"
+ description: "This parameter is for dashboard building only. This allows users to select a metric type
+ from a dashboard filter. For example, the dashboard might default to using Gross Revenue, but the user
+ can use this parameter to change to using 2021 Def. Sales Revenue instead. Must be used with the
+ Toggleable Revenue Metric, and not the normal metrics."
+ default_value: "blended"
+ type: unquoted
+ allowed_value: {
+ label: "Revenue (Sales)"
+ value: "blended"
+ }
+ allowed_value: {
+ label: "Revenue (RVP)"
+ value: "rvp"
+ }
+ allowed_value: {
+ label: "Revenue (2021 Def.)"
+ value: "net_channel_neutral"
+ }
+ allowed_value: {
+ label: "Revenue (Invoice)"
+ value: "invoice"
+ }
+ allowed_value: {
+ label: "Revenue (Gross)"
+ value: "gross"
+ }
+ allowed_value: {
+ label: "Revenue (Net-to-Google)"
+ value: "ntg"
+ }
+ }
+ parameter: filter_nonmetered {
+ view_label: "Revenue"
+ label: "Remove Prepaid Purchases?"
+ description: "Filters out Marketplace Prepaid Purchases, which can erroneously inflate forecasts. Default is to filter these out."
+ default_value: "false"
+ type: unquoted
+ allowed_value: {
+ label: "Remove"
+ value: "true"
+ }
+ allowed_value: {
+ label: "Include"
+ value: "false"
+ }
+ }
+ parameter: usage_timeframe_selector {
+ view_label: "Revenue"
+ description: "Updates the `Dynamic Usage Timeframe` field based on selection of granularity."
+ type: string
+ default_value: "Date"
+ allowed_value: {
+ value: "Date"
+ }
+ allowed_value: {
+ value: "Week"
+ }
+ allowed_value: {
+ value: "Month"
+ }
+ }
+}
