At a glance
Real-time count of DPDLocal compensation claims that are open and unsettled. Each claim represents a damaged, lost, mis-delivered, or significantly-delayed consignment where the merchant is seeking financial recovery from DPDLocal under the carrier’s liability terms. Cash trapped + customer trust at risk.
| What it counts | COUNT(claims WHERE status IN [open, under_review, awaiting_evidence]). Claims are filed via DPDLocal’s claims portal or the API claims endpoint; each has a unique reference and status. |
| Claim categories | DAMAGED, LOST_IN_NETWORK, MIS_DELIVERED, NON_DELIVERY, INVALID_REFUSAL_FROM_CARRIER. DPDLocal’s standard contract excludes consequential loss, claims are limited to declared parcel value plus reasonable carriage charge. |
| Excluded statuses | settled, denied, withdrawn, paid. Each terminal status removes the claim from this count. Settled claims feed Claim Resolution Time and historical reporting. |
| Time window | RT (real-time, not windowed). The card always shows the current open count. |
| Alert trigger | >0 unresolved >7d. Claims open longer than 7 days carry escalating cash trap and CS workload. |
| Operational reality | DPDLocal’s typical resolution SLA is 14 days; complex damage claims (especially with insurance involvement) commonly stretch to 28 to 45 days. Expect a steady-state open count of 0.05 to 0.15% of monthly consignments on a healthy account. |
| Roles | owner, operations, finance |
Calculation
Calculated automatically from your DPDLocal data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK premium-electronics DTC retailer ships ~3,000 DPDLocal NextDay parcels per month, AOV £180. Reading taken at 09:00 GMT on 12 Mar 26.| Claim status | Count | Avg open age | Avg claim value |
|---|---|---|---|
open (filed, awaiting initial DPD review) | 6 | 4 days | £148 |
under_review | 3 | 9 days | £210 |
awaiting_evidence (CS chasing customer photos) | 2 | 12 days | £165 |
| Total open (this card) | 11 | 6.4 days avg | £175 avg |
under_review and awaiting_evidence rows) are >7 days old. Three things to notice:
- The 5 ageing claims are roughly £880 of cash trapped. At 11 open claims with average value £175 the total open exposure is ~£1,925; the >7d cohort is the actionable subset because the 14-day resolution SLA is at risk.
awaiting_evidenceis on the merchant, not DPD. Two claims are stalled because the customer has not yet sent damage photos via the CS workflow. A nudge email and a 7-day deadline-or-withdraw policy clears these. Pair with Open Claims Without Jira Ticket to surface CS-coverage gaps.- Premium-electronics merchants run claim rates 2 to 5 times higher than average. High-AOV, fragile goods see more DAMAGED claims. The threshold should reflect category baseline; 11 open is healthy for this merchant, would be elevated for a fashion DTC at the same volume.
Sibling cards merchants should reference together
| Card | Why pair it with Open Claims |
|---|---|
| Open Claim Value | Sums the £ value of the open count. Finance reads this; CS reads the count. |
| Open Claims by Age | Histogram view; flags the >14d “abandoned” tail. |
| Claim Resolution Time | Settled-claims median days. Tells you whether DPD is hitting their resolution SLA. |
| Open Claims Without Jira Ticket | Coverage check. CS gap = customer wait + brand harm. |
| Claim Value as % of DPDLocal Revenue | Margin impact for the carrier-relationship review. |
| Exception Rate | Upstream cause; DAMAGED and LOST_IN_NETWORK exceptions feed the claim funnel. |
Reconciling against the vendor’s own dashboard
Where to look in DPDLocal’s own dashboard: MyDPD Business Portal → Claims. Each claim has a status (open, under_review, awaiting_evidence, settled, denied, withdrawn). Filter on the open statuses to compare against this card’s count.
Why our number may legitimately differ from MyDPD:
| Reason | Direction | Why |
|---|---|---|
| Settlement-event lag | Either | DPDLocal updates claim status via the API typically within 4 hours of the internal status change; manual updates by claims handlers can take longer. The card may slightly lead or lag the portal during status flips. |
| Status-set scope | Either | DPDLocal occasionally introduces interim statuses (e.g. escalated_to_insurance); if the connector’s open-set list lags an API change, the card may misclassify a claim as closed or open. |
| Ageing partial-settlements | Card stricter | A partially-settled claim where DPDLocal has paid the carriage charge but is still negotiating goods value sits as partial_settled in some realms; this card treats it as open. |
| Card | Expected relationship |
|---|---|
| Jira ticket count for delivery issues | Each open DPDLocal claim should normally have a CS ticket. The xc card flags gaps. |