data-dwh-dbt-project

counterweight/data-dwh-dbt-project

Fork 0

Commit graph

0bf8cac41a Merged PR 4918: Adds Integration Type from Hubspot Deals Oriol Roqué Paniagua 2025-04-04 08:40:38 +00:00
0cec376e49 Merged PR 4912: Update to listing count in new dash overview Joaquin Ossa 2025-04-04 07:07:24 +00:00
5a5bdd82d5 Merged PR 4916: Deprecation of Churn Models Oriol Roqué Paniagua 2025-04-03 15:58:44 +00:00
82d6870aba Fixed weekly model Joaquin 2025-04-03 17:44:09 +02:00
9cb3b9d1dc Fixed schema Joaquin 2025-04-03 16:27:39 +02:00
87cd8e1ae4 fixed schema Joaquin 2025-04-03 16:26:46 +02:00
2637d68398 Addressed comments Joaquin 2025-04-03 16:23:58 +02:00
82829db3d2 Update to listing count in new dash overview Joaquin 2025-04-03 16:00:43 +02:00
f6d25f681f Merged PR 4907: KPIs Refactor Stage 2 - Decouple AM - Churn/Account Margin Oriol Roqué Paniagua 2025-04-03 13:00:04 +00:00
901d39a045 change fetch size Pablo Martin 2025-04-03 13:50:42 +02:00
a14de4fe3a Merged PR 4894: Refactor growth score by deal to stop depending on cross models Oriol Roqué Paniagua 2025-04-03 07:06:49 +00:00
5f92cf8948 Merged PR 4898: Small adaptations to KPIs Outlier detector test Oriol Roqué Paniagua 2025-04-03 07:04:35 +00:00
80f14c7b72 Refactor growth score by deal to stop depending on cross models uri 2025-04-02 16:57:19 +02:00
913f001465 add file inventory Pablo Martin 2025-04-02 16:10:12 +02:00
0fd9b2ce06 Merged PR 4887: Adds audit helper + finishes KPIs Refactor Stage 1 Oriol Roqué Paniagua 2025-04-02 14:03:33 +00:00
38ee399156 more stuff in readme Pablo Martin 2025-04-02 15:54:41 +02:00
db0d97d2e8 wip Pablo Martin 2025-04-02 15:00:22 +02:00
4bef83f432 Merged PR 4888: Add FDW sync step Pablo Martín 2025-04-02 13:24:52 +00:00
b17e2a22ac add fdw sync step Pablo Martin 2025-04-02 15:02:02 +02:00
ced7373fa9 Merged PR 4865: New dash created bookings models Joaquin Ossa 2025-04-02 12:30:02 +00:00
4c011d7063 Changed loop Joaquin 2025-04-02 12:55:04 +02:00
e8da311463 Readded schema Joaquin 2025-04-02 12:07:39 +02:00
ab179577b1 removed macro and kept all logic inside the model Joaquin 2025-04-02 12:01:57 +02:00
78e2474a87 Update reporting model Joaquin 2025-04-02 08:22:21 +02:00
60dfae5cf4 Addressed comments Joaquin 2025-04-01 19:51:30 +02:00
264ce4e203 Fixed model aggregations Joaquin 2025-04-01 14:24:14 +02:00
2a797ce0e8 New dash bookings agg models Joaquin 2025-04-01 09:14:30 +02:00
fb2b2def52 New created bookings with services model Joaquin 2025-03-31 14:53:20 +02:00
ce723b335e Merged PR 4878: Adds Monthly/MTD and Aggregated/Metric models for Total and Retained Revenue Oriol Roqué Paniagua 2025-04-02 08:53:49 +00:00
0b75afbe39 Merged PR 4882: Fix Business Targets Oriol Roqué Paniagua 2025-04-02 07:32:11 +00:00
547069ede0 Adds Monthly/MTD and Aggregated/Metric models for Total and Retained Revenue uri 2025-04-01 17:27:37 +02:00
7a09fd344d Merged PR 4875: Adding total_listings_with_active_product_bundle_with_paid_service Joaquin Ossa 2025-04-01 14:04:32 +00:00
adcb8d2231 Merged PR 4874: Daily model for Total and Retained Revenue Oriol Roqué Paniagua 2025-04-01 13:44:30 +00:00
9750fa9e14 Adding total_listings_with_active_product_bundle_with_paid_service Joaquin 2025-04-01 15:37:41 +02:00
57626f266a Merged PR 4864: Removes incrementality in booking view to service Oriol Roqué Paniagua 2025-04-01 06:51:40 +00:00
c6d8e10dd5 Merged PR 4852: removed test of not_null Joaquin Ossa 2025-03-31 10:40:48 +00:00
b4a4925bc1 removed test of not_null Joaquin 2025-03-31 12:10:26 +02:00
b709938d71 remove unnecessary steps of master CI pipeline Pablo Martin 2025-03-28 15:51:58 +01:00
e844762c23 Merged PR 4839: Fixed weekly and monthly granularity Joaquin Ossa 2025-03-28 11:02:23 +00:00
454d7648f6 Fixed weekly and monthly granularity Joaquin 2025-03-28 11:53:32 +01:00
e4fb1af349 Merged PR 4833: Added current deal lifecycle to new dash overview Joaquin Ossa 2025-03-28 08:20:58 +00:00
b138e0c626 Added boolean Joaquin 2025-03-28 09:02:12 +01:00
14f44e6949 Merged PR 4825: New_dash_agg_metrics update Joaquin Ossa 2025-03-27 16:57:14 +00:00
3833f3e92d Added current deal lifecycle to new dash overview Joaquin 2025-03-27 17:56:36 +01:00
354acc6d37 Fixed schema Joaquin 2025-03-27 17:06:54 +01:00
7696585a6b third fix Joaquin 2025-03-27 16:41:11 +01:00
684c233ff9 second fix Joaquin 2025-03-27 16:30:22 +01:00
d353e852cd Fixing model Joaquin 2025-03-27 14:38:53 +01:00
c902ae2dff Commit wip test Joaquin 2025-03-27 14:27:38 +01:00
8c3a32d62e Merged PR 4817: Aggregated models for New Dash improvement Joaquin Ossa 2025-03-27 11:42:38 +00:00
6287b57171 Addressed comments Joaquin 2025-03-27 12:31:52 +01:00
83dd419e19 Aggregated models Joaquin 2025-03-27 11:40:08 +01:00
9d99fd6088 commit wip Joaquin 2025-03-27 11:17:18 +01:00
6dcc32b907 Commit wip Joaquin 2025-03-26 19:00:47 +01:00
d0bc64b868 commit wip Joaquin 2025-03-26 18:56:57 +01:00
2e984aa61b fixed tests Joaquin 2025-03-26 15:42:26 +01:00
18988eadde Committing for testing Joaquin 2025-03-26 15:10:50 +01:00
f7504393c4 Merged PR 4819: New Dash Listings Services model Joaquin Ossa 2025-03-27 10:33:08 +00:00
c60bfc6ccb Addressed comments Joaquin 2025-03-27 11:24:17 +01:00
3f08229256 New Dash Listings with services Joaquin 2025-03-26 17:01:23 +01:00
87517f6a92 Listings offered services Joaquin 2025-03-26 08:41:51 +01:00
525c12dc83 Commit wip Joaquin 2025-03-25 16:47:26 +01:00
3d84678380 Merged PR 4780: Improved New Dash Services usage Joaquin Ossa 2025-03-26 09:24:39 +00:00
d229845b00 changes tested Joaquin 2025-03-26 10:19:49 +01:00
50650776fc last check Joaquin 2025-03-26 10:17:41 +01:00
20a277037d Addressed comment Joaquin 2025-03-26 10:10:51 +01:00
90581ea142 Addressed comments Joaquin 2025-03-25 17:29:55 +01:00
20a8958679 Commit wip Joaquin 2025-03-25 17:11:02 +01:00
2c5301c158 commit wip Joaquin 2025-03-25 12:25:47 +01:00
721f3e4e9e Addressed comments Joaquin 2025-03-24 16:27:37 +01:00
1ebd1c5ccb Created new kpi daily model for new dash users Joaquin 2025-03-24 13:00:24 +01:00
c0a1e90fae Improved New Dash Services usage Joaquin 2025-03-21 17:07:56 +01:00
12e0f55b08 Merged PR 4779: Add run step to CI PR Pablo Martín 2025-03-25 09:05:23 +00:00
5008cb1082 remove silly test changes Pablo Martin 2025-03-24 16:32:38 +01:00
ddc38ef513 only direct downstream, not all downstream Pablo Martin 2025-03-24 16:27:15 +01:00
5b6f0a6bc4 trigger a lot of runs Pablo Martin 2025-03-24 14:59:06 +01:00
18173f7ffd typo Pablo Martin 2025-03-24 14:21:05 +01:00
db66bb6d97 replace hardcodes Pablo Martin 2025-03-24 14:17:02 +01:00
e311431fbb also run downstream Pablo Martin 2025-03-24 12:22:43 +01:00
fae7572777 Merged PR 4782: Dashboard, Pricing and Services from Hubspot Oriol Roqué Paniagua 2025-03-24 11:20:03 +00:00
f6c1043038 fix identation Pablo Martin 2025-03-24 12:16:59 +01:00
73f40ff1a5 continue Pablo Martin 2025-03-24 12:11:23 +01:00
8a4ec6c257 typo Pablo Martin 2025-03-24 12:01:53 +01:00
75b85073ae typo in macro Pablo Martin 2025-03-24 11:58:15 +01:00
f2e447ba60 running on pointer database Pablo Martin 2025-03-24 11:55:53 +01:00
c59600d9f2 another silly change to trigger build Pablo Martin 2025-03-24 11:34:13 +01:00
8938545d3a add silly change to test ci Pablo Martin 2025-03-21 16:58:46 +01:00
8666b88953 add run step Pablo Martin 2025-03-21 16:53:22 +01:00
5860f5b9f6 revert accidental commit, woooops Pablo Martin 2025-03-21 16:53:01 +01:00
0bf35bf71a Merge branch 'master' of ssh.dev.azure.com:v3/guardhog/Data/data-dwh-dbt-project Pablo Martin 2025-03-21 16:52:42 +01:00
286a5b5890 add run step Pablo Martin 2025-03-21 16:52:39 +01:00
780ac25a9a Merged PR 4777: Fix YTD on Revenue Churn Rate. Increase precision with 1 decimal Oriol Roqué Paniagua 2025-03-21 15:15:21 +00:00
dcb1d670a8 add master pipeline Pablo Martin 2025-03-21 15:54:49 +01:00
a98d8fe41f change yaml name Pablo Martin 2025-03-21 15:52:48 +01:00
7acf509b03 Merged PR 4771: Only state modified in CI Pablo Martín 2025-03-21 14:33:34 +00:00
2779a73d10 remove list step Pablo Martin 2025-03-21 15:24:32 +01:00
dc51c503d0 a couple of small changes Pablo Martin 2025-03-21 15:20:37 +01:00
30ab85bd24 typo, disable run on every commit Pablo Martin 2025-03-21 15:14:53 +01:00
682cf592a6 typo Pablo Martin 2025-03-21 15:09:47 +01:00
eedc5931c7 restrict list Pablo Martin 2025-03-21 15:02:47 +01:00