Commit graph

  • 646ff7276a Added function to get false instead of null in is_duplicate_booking Joaquin Ossa 2024-07-31 16:38:33 +02:00
  • 78ffefb145 Thanks Uri for the catch, then when id_user_guest is NULL it won't be considered a duplicate. Joaquin Ossa 2024-07-31 16:23:27 +02:00
  • 6cb06b73cd Modified how stg_core__booking was being called and some typo errors Joaquin Ossa 2024-07-31 15:32:54 +02:00
  • 00e7554300 Creation of host_booking_fees Joaquin Ossa 2024-07-31 15:16:15 +02:00
  • c4fc81d934 Included tests Joaquin Ossa 2024-07-31 12:48:57 +02:00
  • 9996368e22 I modified the model of duplicated_bookings, I saw it had some errors and data that was not being used Joaquin Ossa 2024-07-31 12:44:54 +02:00
  • 7ec5d91c6a Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2024-07-30 16:26:42 +02:00
  • 67087cc7cb pr template Pablo Martin 2024-07-30 16:24:36 +02:00
  • 65ebd8c2d2 Merged PR 2441: KPIs - Customer Segmentation based on listings Oriol Roqué Paniagua 2024-07-30 13:21:08 +00:00
  • b79df1b42e Merged PR 2433: Remove Deposit payments from Guest Payments metric Oriol Roqué Paniagua 2024-07-29 15:15:09 +00:00
  • b5e5160d67 Merged PR 2432: Exposing revenue metrics on the by deal view Oriol Roqué Paniagua 2024-07-29 14:54:50 +00:00
  • 756d1c54d5 Merged PR 2429: Business KPIs - Revenue details Oriol Roqué Paniagua 2024-07-29 13:16:19 +00:00
  • 7e9b3733c8 Merged PR 2425: Fix model documentation names Oriol Roqué Paniagua 2024-07-29 09:38:44 +00:00
  • 1b1b97380a Merged PR 2422: Ensure that guest payments models follow nomenclature Oriol Roqué Paniagua 2024-07-29 09:10:58 +00:00
  • 04eb09c318 Merged PR 2413: Adding submetrics of guest revenue by deal Oriol Roqué Paniagua 2024-07-26 10:42:48 +00:00
  • da56aa3bb8 Merged PR 2400: Creating model in reporting Joaquin Ossa 2024-07-25 09:53:29 +00:00
  • bfe224577c Creating model in reporting Joaquin Ossa 2024-07-25 11:34:07 +02:00
  • 1fc1fc4c06 Merged PR 2392: Created new model with listings with check in hero active Joaquin Ossa 2024-07-24 15:32:26 +00:00
  • e2fb73d558 Added count distinct Joaquin Ossa 2024-07-24 17:31:25 +02:00
  • d08adfd2c0 Created new model with listings with check in hero active Joaquin Ossa 2024-07-24 16:53:16 +02:00
  • fbd2bdd7f4 Merged PR 2381: Adding submetrics of guest revenue Oriol Roqué Paniagua 2024-07-23 13:50:03 +00:00
  • ee13eda5f3 Merged PR 2354: Main KPIs batch 2 exposure Oriol Roqué Paniagua 2024-07-19 09:14:30 +00:00
  • 361ad31299 Merged PR 2353: Computing and propagating APIs revenue metrics Oriol Roqué Paniagua 2024-07-19 07:30:42 +00:00
  • b16cb172b6 Merged PR 2349: Retrieve account for xero invoices, credit notes and sales denom mart Oriol Roqué Paniagua 2024-07-18 15:47:14 +00:00
  • e250763a1c Merged PR 2317: Exposing first_day_month for business kpis Oriol Roqué Paniagua 2024-07-16 09:14:38 +00:00
  • 0df5209bac Merged PR 2305: Propagates billable bookings kpis in intermediate Oriol Roqué Paniagua 2024-07-15 12:32:18 +00:00
  • 0ac9f479da Merged PR 2301: KPIs Billable Bookings 1st version Oriol Roqué Paniagua 2024-07-15 10:59:37 +00:00
  • bf473ab971 Merged PR 2292: Propagate invoicing metrics for KPIs Oriol Roqué Paniagua 2024-07-15 07:33:55 +00:00
  • 698756e0f7 Merged PR 2295: Added booking_source to reporting model core__guest_satisfaction_responses Joaquin Ossa 2024-07-15 07:08:57 +00:00
  • 93a4664332 Added booking_source to reporting model core__guest_satisfaction_responses Joaquin Ossa 2024-07-15 08:54:11 +02:00
  • 506cb8043c Merged PR 2289: Added verification_request_booking_source to int_core__guest_satisfaction_res... Joaquin Ossa 2024-07-12 13:20:23 +00:00
  • 8a639413f1 Merged PR 2290: Refactor mtd joins to improve performance Oriol Roqué Paniagua 2024-07-12 12:53:00 +00:00
  • 5f05b725b9 Removed database sources on select Joaquin Ossa 2024-07-12 13:11:56 +02:00
  • a837760382 Changed staging to intermediate Joaquin Ossa 2024-07-12 12:45:46 +02:00
  • 4d5af3ba21 Added verification_request_booking_source to int_core__guest_satisfaction_responses model Joaquin Ossa 2024-07-12 12:38:52 +02:00
  • 2130226939 Merged PR 2284: KPIs: computing invoicing metrics from Xero Oriol Roqué Paniagua 2024-07-12 10:05:49 +00:00
  • 725dadd0a3 Merged PR 2275: Created model int_core__verification_request_booking_source to have easier ac... Joaquin Ossa 2024-07-12 09:12:28 +00:00
  • cf467145d0 Fixed schema names Joaquin Ossa 2024-07-12 11:06:09 +02:00
  • 3001db919a Added models in schema for intermediate Joaquin Ossa 2024-07-12 10:11:51 +02:00
  • 2bfe3ccf3c Added the new field to int_core__bookings and to int_core__verification_requests Joaquin Ossa 2024-07-11 17:16:51 +02:00
  • 70c2c5f6bf Removed guests_id and modified query structure Joaquin Ossa 2024-07-11 16:49:24 +02:00
  • 00502b1597 Removed bookings_id so we have unique values for id_verification_request, added details as to how we classify the hosts Joaquin Ossa 2024-07-11 16:26:41 +02:00
  • db04615039 Removed bookings_id so we have unique values for id_verification_request, added details as to how we classify the hosts Joaquin Ossa 2024-07-11 16:19:33 +02:00
  • 5efd91dfbb Created model int_core__verification_request_booking_source to have easier access to host category type in different models Joaquin Ossa 2024-07-11 15:36:32 +02:00
  • 0c1535b150 Merged PR 2267: Business KPIs refactor - cleaning Oriol Roqué Paniagua 2024-07-11 09:17:44 +00:00
  • b4a7089070 Merged PR 2266: Added report to exposure.yaml Joaquin Ossa 2024-07-11 07:53:45 +00:00
  • 9a74e21783 Fixed description Joaquin Ossa 2024-07-11 09:53:01 +02:00
  • f96587dc33 Added report to exposure.yaml Joaquin Ossa 2024-07-11 09:07:22 +02:00
  • 859b0f7573 Merged PR 2264: Remove (GBP) from metric name Oriol Roqué Paniagua 2024-07-10 16:10:07 +00:00
  • 3b75d9eefb Merged PR 2257: Expose guest revenue and guest journey payment metrics Oriol Roqué Paniagua 2024-07-10 14:17:05 +00:00
  • d39bc02ae1 Merged PR 2252: Propagate guest revenue metrics to intermediate Oriol Roqué Paniagua 2024-07-10 08:52:19 +00:00
  • 20e7220ffe Merged PR 2246: KPIs refactor: naming convention and PBI sources replication Oriol Roqué Paniagua 2024-07-09 15:14:50 +00:00
  • 976ac70949 Merged PR 2245: Xero Sales Mart to reporting Pablo Martín 2024-07-09 13:43:59 +00:00
  • 1d63e187c2 model and docs Pablo Martin 2024-07-09 15:31:47 +02:00
  • ca8334f1da Merged PR 2236: Refactor of already exposed metrics: listings, deals and guest journeys Oriol Roqué Paniagua 2024-07-09 13:00:43 +00:00
  • 409ac47591 Merged PR 2232: KPI refactor - 1st step, bookings Oriol Roqué Paniagua 2024-07-08 15:58:36 +00:00
  • 62ad19ea9e Merged PR 2231: Xero Sales Mart Pablo Martín 2024-07-08 15:52:24 +00:00
  • fad85691f3 typo in docs Pablo Martin 2024-07-08 17:52:15 +02:00
  • 00b7940c25 more schema, more tests Pablo Martin 2024-07-08 17:26:10 +02:00
  • 003c7cd185 remove duplicated currency field Pablo Martin 2024-07-08 17:26:02 +02:00
  • 6fcc9fde16 schema Pablo Martin 2024-07-08 17:06:23 +02:00
  • a79288a657 add contact data Pablo Martin 2024-07-08 16:55:46 +02:00
  • 42811b6c7e propagate field in reporting layer Pablo Martin 2024-07-08 16:48:39 +02:00
  • da7b931e8e include header data Pablo Martin 2024-07-08 16:47:44 +02:00
  • ff09b2d7a4 propagate field to int Pablo Martin 2024-07-08 16:31:53 +02:00
  • 43a7ead6d3 missing field in stg Pablo Martin 2024-07-08 16:29:35 +02:00
  • 7fb5bc90d8 join credit notes Pablo Martin 2024-07-08 16:17:20 +02:00
  • 0b05f8cb62 join invoices Pablo Martin 2024-07-08 16:16:21 +02:00
  • b08695795d line item level Pablo Martin 2024-07-08 16:13:37 +02:00
  • d2b0afdca6 Merged PR 2221: Computes (paid) guest revenue metric - fixed Oriol Roqué Paniagua 2024-07-08 11:02:02 +00:00
  • e214641b9f Merged PR 2218: Fixed join on model taking id_verification instead of id_verification_request Joaquin Ossa 2024-07-05 15:41:55 +00:00
  • 03dbe60b38 Fixed join on model taking id_verification instead of id_verification_request Joaquin Ossa 2024-07-05 17:24:06 +02:00
  • 49a3c39b82 Merged PR 2217: Revert 'Computes (paid) guest revenue metric' Oriol Roqué Paniagua 2024-07-05 15:19:35 +00:00
  • 34df8a7ef9 Merged PR 2201: Fixing errors raised by texts Joaquin Ossa 2024-07-05 15:12:04 +00:00
  • d1362bb1db Merged PR 2199: Computes (paid) guest revenue metric Oriol Roqué Paniagua 2024-07-05 15:01:21 +00:00
  • 2738c8617d Fixing errors raised by texts Joaquin Ossa 2024-07-04 16:41:41 +02:00
  • 2efc1d8b65 Merged PR 2178: New model for guests satisfaction report Joaquin Ossa 2024-07-04 10:13:11 +00:00
  • 2c366414ce Merged PR 2188: Added date of adaptation Joaquin Ossa 2024-07-04 10:08:13 +00:00
  • 1781031c9d Merged PR 2195: Computes GJ with Payment and GJ Payment Rate metrics Oriol Roqué Paniagua 2024-07-04 09:54:41 +00:00
  • 205bc6534d Modified date name to stick to convention Joaquin Ossa 2024-07-04 08:24:23 +02:00
  • 6bc26a66ff Changed date name to check_in_cover_added_date and included model in reporting Joaquin Ossa 2024-07-03 17:43:27 +02:00
  • 5bd6a2c254 Changed case to coalesce Joaquin Ossa 2024-07-03 17:38:00 +02:00
  • 3b22832d8b Created model in reporting as well with schema Joaquin Ossa 2024-07-03 16:34:33 +02:00
  • fb61c69714 Changed names of types of payments for better clarity Joaquin Ossa 2024-07-03 16:23:52 +02:00
  • 3ce81dfdd1 Fixed the filter for check-in cover verification set and changed named to adopted Joaquin Ossa 2024-07-03 16:16:58 +02:00
  • 35e4735720 Added date of birth and kept age Joaquin Ossa 2024-07-03 15:18:05 +02:00
  • fedf808b6b Added date of adaptation Joaquin Ossa 2024-07-03 15:05:12 +02:00
  • 5867b53e55 Fixed indentation Joaquin Ossa 2024-07-03 15:01:07 +02:00
  • af4ab70b96 Addresed Uri's comments and also included new reports in exposures.ymal Joaquin Ossa 2024-07-03 12:29:01 +02:00
  • ed5d7828a7 Merged PR 2179: Computes aggregated metrics by deal id and exposes it to reporting Oriol Roqué Paniagua 2024-07-03 07:06:34 +00:00
  • 0cda63d1a7 New model for guests satisfaction report Joaquin Ossa 2024-07-02 14:22:04 +02:00
  • f9741d6f69 Merged PR 2172: Adding accommodation metrics by deal id Oriol Roqué Paniagua 2024-07-02 09:32:52 +00:00
  • 1a4b6b4c14 Merged PR 2171: Adding Guest Journey metrics by deal id Oriol Roqué Paniagua 2024-07-02 07:26:20 +00:00
  • 010135fb63 Merged PR 2164: Adding booking metrics by deal id for business kpis Oriol Roqué Paniagua 2024-07-01 16:00:14 +00:00
  • 28917fcc08 Merged PR 2167: Survey to Staging Pablo Martín 2024-07-01 15:02:10 +00:00
  • 64377da570 PK test Pablo Martin 2024-07-01 16:54:58 +02:00
  • 83f67a06bf model Pablo Martin 2024-07-01 16:53:54 +02:00
  • 2f133c1424 add source Pablo Martin 2024-07-01 16:50:12 +02:00
  • 915b9d5165 Merged PR 2161: Sign for bank transactions Pablo Martín 2024-07-01 12:02:25 +00:00
  • 883618add1 subquery to CTE Pablo Martin 2024-07-01 14:02:13 +02:00