Investigate impact of missing "order end date" and backfill if needed
Problem
This is a follow-up from #5302 (comment 1438587141).
We are still seeing ~58K orders that don't have an end date
as we fixed that missing order data moving forward within this issue.
We need to understand the impact for the missing order data and potentially backfill it.
Proposal
- Investigate missing order data and its impact for customers
- Backfill the missing order data
Result
We have high data consistency and made sure the missing data didn't impact customers badly.
Order data review
The following is a breakdown of Orders that are missing end date
(last updated on 2023-09-14).
# |
Use case | Order count |
---|---|---|
1 |
Orders without BillingAccount | |
1.1 |
|
|
1.2 |
|
|
2 |
Orders with a BillingAccount | |
2.1 |
|
Edited by Tatyana Golubeva