counterweight/data-dwh-dbt-project
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions

Commit graph

  • aaba27a0ea Merged PR 3500: Fix missing test Oriol Roqué Paniagua 2024-11-11 16:37:58 +00:00
  • 9ba0edb82d Merged PR 3482: Adapts date dimension skeleton for Main KPIs Oriol Roqué Paniagua 2024-11-11 15:57:37 +00:00
  • 88083fc846 Addressed comments Joaquin Ossa 2024-11-11 16:22:13 +01:00
  • eec21fe5da Commit saved model Joaquin Ossa 2024-11-09 15:21:20 +01:00
  • 98ba74481a daily model for guest products Joaquin Ossa 2024-11-08 15:25:11 +01:00
  • 2f80642f6c Merged PR 3472: Remove unused models and schema entries for deals and accommodations Oriol Roqué Paniagua 2024-11-08 12:05:40 +00:00
  • 5e1b418570 Merged PR 3469: Switches Listing and Deal metrics Oriol Roqué Paniagua 2024-11-08 11:11:04 +00:00
  • 335ba9a29b Merged PR 3461: Creates models for listing metrics Oriol Roqué Paniagua 2024-11-07 16:56:43 +00:00
  • dada9c289a Merged PR 3454: Guest payments models for Guest KPIs Joaquin Ossa 2024-11-07 12:10:14 +00:00
  • 34ccd894de renamed test entity Joaquin Ossa 2024-11-07 12:56:49 +01:00
  • 38c7cc10df Merged PR 3455: Cleans old Xero KPIs models Oriol Roqué Paniagua 2024-11-07 11:48:15 +00:00
  • 11e1804db0 mtd and weekly agg guest payments Joaquin Ossa 2024-11-07 12:15:52 +01:00
  • c89c72aace commit agg_monthly_guest_payments Joaquin Ossa 2024-11-07 12:09:20 +01:00
  • 50b09c56a1 wip agg Joaquin Ossa 2024-11-07 12:06:14 +01:00
  • dba28897d6 wip agg Joaquin Ossa 2024-11-07 09:11:24 +01:00
  • cf553cfcb1 monthly and weekly metric models Joaquin Ossa 2024-11-07 08:45:17 +01:00
  • 8c23f91242 Merged PR 3451: Adds Deal Daily Lifecycle and metrics Oriol Roqué Paniagua 2024-11-07 10:49:06 +00:00
  • 9ef9a57c03 Merged PR 3443: Switch of Xero metrics New KPIs flow - Invoiced Revenue and Host Resolutions Oriol Roqué Paniagua 2024-11-07 07:48:38 +00:00
  • dc4f5098a1 Merged PR 3440: New metrics for payments from guest journeys Joaquin Ossa 2024-11-06 16:28:55 +00:00
  • 678caa35d7 Removed unnecessary join Joaquin Ossa 2024-11-06 16:27:19 +01:00
  • f33bc3a2ca removed new metrics Joaquin Ossa 2024-11-06 16:24:57 +01:00
  • b9968c7a72 added new metrics for not cancelled bookings Joaquin Ossa 2024-11-06 12:34:33 +01:00
  • f5addc7f4c wip Joaquin Ossa 2024-11-06 11:28:50 +01:00
  • 9fecfeb91b Merged PR 3439: Weekly aggregated model Joaquin Ossa 2024-11-06 11:11:07 +00:00
  • fd94c19694 Merged PR 3433: Change lifecycle daily to just handle last available day Oriol Roqué Paniagua 2024-11-06 11:10:31 +00:00
  • 41a9b55436 saved Joaquin Ossa 2024-11-06 11:48:38 +01:00
  • 51fabf9efb Changed test Joaquin Ossa 2024-11-06 11:47:47 +01:00
  • 8c7b4bcf94 Merged PR 3437: Revert 'Weekly aggregated guest journey metrics' Joaquin Ossa 2024-11-06 10:27:37 +00:00
  • 50b87c9d8f Revert "Merged PR 3430: Weekly aggregated guest journey metrics Joaquin Ossa 2024-11-06 10:25:04 +00:00
  • 60204b53e8 Merged PR 3430: Weekly aggregated guest journey metrics Joaquin Ossa 2024-11-06 10:17:46 +00:00
  • 4a2c478d8f update schema Joaquin Ossa 2024-11-06 11:11:06 +01:00
  • 1cd9f88a45 Merged PR 3434: update assert_dimension_completeness test Joaquin Ossa 2024-11-06 07:59:44 +00:00
  • 406499a7e0 Merge branch 'models/kpis_test_update' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project into models/kpis_test_update Joaquin 2024-11-06 08:35:50 +01:00
  • 079eaac870 Update invoice models Joaquin 2024-11-06 08:35:30 +01:00
  • ca510f91a7 update assert_dimension_completeness test Joaquin 2024-11-05 16:45:59 +01:00
  • f5311fa954 Merged PR 3431: Adds Invoicing metrics Oriol Roqué Paniagua 2024-11-05 16:57:23 +00:00
  • 0bffa5a862 update assert_dimension_completeness test Joaquin 2024-11-05 16:45:59 +01:00
  • 7e786649cc Weekly aggregated model Joaquin 2024-11-05 16:04:41 +01:00
  • d8a064fd06 commit wip Joaquin 2024-11-05 15:50:23 +01:00
  • 4076f016bd Merged PR 3424: aggregated to agg Joaquin Ossa 2024-11-05 13:46:45 +00:00
  • 76529fe457 Merged PR 3427: Weekly dimension Joaquin Ossa 2024-11-05 13:46:29 +00:00
  • c29a47240f Weekly dimension Joaquin 2024-11-05 13:28:12 +01:00
  • d76b8ac205 fixed int_monthly_12m_window_contribution_by_deal Joaquin 2024-11-05 12:53:27 +01:00
  • abd4a4e8f2 fixed int_monthly_growth_score_by_deal Joaquin 2024-11-05 12:49:50 +01:00
  • 5bcfd7cb9c Revert cross models Joaquin 2024-11-05 12:37:31 +01:00
  • 092e37d58c aggregated to agg Joaquin 2024-11-05 12:17:26 +01:00
  • c21b05f9cf Merged PR 3420: Remove previous KPIs computation for Bookings, Guest Journeys and Guest Payments Oriol Roqué Paniagua 2024-11-05 10:12:00 +00:00
  • f601b69c7d Merged PR 3418: CSAT score Joaquin Ossa 2024-11-05 09:39:19 +00:00
  • 57bc62b21d Merge branch 'models/23372_csat_guest_kpis' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project into models/23372_csat_guest_kpis Joaquin 2024-11-05 10:36:33 +01:00
  • 2593632411 final changes Joaquin 2024-11-05 10:24:17 +01:00
  • eb8e59f8c5 Addressed comments Joaquin 2024-11-04 18:15:13 +01:00
  • ee2cb2e40e CSAT score Joaquin 2024-11-04 16:51:24 +01:00
  • 84b7f2569c final changes Joaquin 2024-11-05 10:24:17 +01:00
  • b31a6ba194 Merged PR 3419: Adds Host Resolutions metrics in new KPIs Oriol Roqué Paniagua 2024-11-05 07:45:41 +00:00
  • 5d642d2c77 Addressed comments Joaquin 2024-11-04 18:15:13 +01:00
  • 392006b71c CSAT score Joaquin 2024-11-04 16:51:24 +01:00
  • 9b0c7161e3 Merged PR 3413: Exposes New KPIs of Bookings, Guest Journeys and Guest Payments Oriol Roqué Paniagua 2024-11-04 14:52:38 +00:00
  • aeaf78df16 Merged PR 3411: Guest journey metrics attributed to check-in date Joaquin Ossa 2024-11-04 14:51:35 +00:00
  • d952613fd3 Fixed names Joaquin 2024-11-04 15:28:31 +01:00
  • 64c3c6d1f0 Addressed comments Joaquin 2024-11-04 14:29:26 +01:00
  • 21858d4d59 updated test Joaquin 2024-11-04 11:05:28 +01:00
  • 7d3d11ea7f modified names Joaquin 2024-11-02 18:32:38 +01:00
  • 19337a9918 save all guest journey check in attributed models Joaquin 2024-11-02 11:28:22 +01:00
  • 3e5fd5a761 save models wip Joaquin 2024-10-31 18:12:44 +01:00
  • 231411ce93 Merged PR 3394: Guest KPIs daily metrics models Joaquin Ossa 2024-10-31 16:45:58 +00:00
  • ea11c656d0 Merged PR 3400: Adding new claim NewDashVersion as an indicator for User Host Oriol Roqué Paniagua 2024-10-31 16:40:48 +00:00
  • 201e2c989c Addressed comments Joaquin 2024-10-31 16:45:44 +01:00
  • 813e710020 Update it to 1 model and added metrics including cancelled bookings Joaquin 2024-10-31 15:24:16 +01:00
  • 36a1428b23 Created models for new guest kpis Joaquin 2024-10-31 11:44:26 +01:00
  • 36432024b5 commit new models for guest kpis Joaquin 2024-10-31 11:20:44 +01:00
  • 6ae900530c save wip of started GJ Joaquin 2024-10-30 19:29:15 +01:00
  • 03797827a4 Merged PR 3396: Changes claims and logic to consider user is in new dash Oriol Roqué Paniagua 2024-10-31 15:45:28 +00:00
  • bf2310301a Merged PR 3391: Adds Check-Out, Cancelled and Billable Bookings Oriol Roqué Paniagua 2024-10-31 14:31:19 +00:00
  • 3ecbcb2c49 Merged PR 3387: Adds Guest Payments metrics Oriol Roqué Paniagua 2024-10-31 09:03:15 +00:00
  • 9585b759a4 Merged PR 3385: Adds Guest Journey with Payment metric Oriol Roqué Paniagua 2024-10-30 16:43:50 +00:00
  • 0aac0fcb61 Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2024-10-30 14:52:25 +01:00
  • fa97027aa4 add missing condition in where Pablo Martin 2024-10-30 14:52:21 +01:00
  • 22d5b75931 Merged PR 3379: Fixes null on dates Oriol Roqué Paniagua 2024-10-30 13:33:11 +00:00
  • 8ddb695947 Merged PR 3377: Adds GJ Created, Started and Completed in new KPIs flow Oriol Roqué Paniagua 2024-10-30 11:45:45 +00:00
  • 86719b6a10 Merged PR 3371: Update Host takes risk waivers logic Pablo Martín 2024-10-30 10:16:16 +00:00
  • 875f91be26 Merged PR 3329: First version of KPIs refactored - created bookings Oriol Roqué Paniagua 2024-10-30 08:55:19 +00:00
  • 450975301a Merged PR 3373: Setting current KPIs models for deprecation Oriol Roqué Paniagua 2024-10-30 08:54:59 +00:00
  • 233d0f76ca finish Pablo Martin 2024-10-29 14:50:52 +01:00
  • eb94c321ec apply changes on the right file Pablo Martin 2024-10-29 14:50:17 +01:00
  • b7aeb8fcd8 add another cte to cover payments that don't fall into the other ctes Pablo Martin 2024-10-29 14:42:30 +01:00
  • 3f99cdc181 refactor into guest driven and host driven Pablo Martin 2024-10-29 14:18:48 +01:00
  • 578ef9b0f3 wip Pablo Martin 2024-10-29 10:23:59 +01:00
  • 2d2d3a3e0e add per service CTEs Pablo Martin 2024-10-28 15:14:27 +01:00
  • 76ec2c7436 waiver is a tax subject service Pablo Martin 2024-10-28 11:10:19 +01:00
  • 5c1f6f88f2 Merged PR 3279: Remove unused code: additive contribution to churn and its metrics Oriol Roqué Paniagua 2024-10-24 12:47:38 +00:00
  • 689ea53c11 Merged PR 3290: Update exposure of top losers - now account managers overview Oriol Roqué Paniagua 2024-10-22 14:14:58 +00:00
  • f426825c47 Merged PR 3286: Rename of categories for top losers/winners Oriol Roqué Paniagua 2024-10-22 13:06:58 +00:00
  • 6a90eb30f9 Merged PR 3272: Expose Churn Rates into Main KPIs Oriol Roqué Paniagua 2024-10-22 08:08:03 +00:00
  • f230eb3af5 Merged PR 3247: Enriches monthly_growth_by_deal model for top losers reporting Oriol Roqué Paniagua 2024-10-18 13:17:52 +00:00
  • 5735251c67 Merged PR 3239: Decommission Verification Payments V1 Oriol Roqué Paniagua 2024-10-18 09:59:29 +00:00
  • b9ca7c5e8c Merged PR 3235: Ensure values to be treated as decimals Oriol Roqué Paniagua 2024-10-18 08:14:24 +00:00
  • d475285461 Merged PR 3221: Adapted lifecycle logic for deals to include offboardings Oriol Roqué Paniagua 2024-10-17 09:41:37 +00:00
  • 3faf03c139 Merged PR 3207: Cast as dates and timestamps for hubspot deals in staging Oriol Roqué Paniagua 2024-10-16 14:57:36 +00:00
  • 91cac6a441 Merged PR 3205: Deprecate edeposit__guesty_verifications Pablo Martín 2024-10-16 14:56:12 +00:00
  • 7f2ca34301 deprecate model and remove docs Pablo Martin 2024-10-16 16:21:35 +02:00