NDR Communication report

The NDR Communication Reporting Schema provides an event-level view of the complete NDR shipment. It captures detailed information for every NDR notification, customer response, courier instruction, feedback entry, call log, recording, and related communication event.

Overview
The NDR Communication Reporting Schema provides an event-level view of the complete NDR shipment and all the milestones associated with it. It captures detailed information for every NDR notification, customer response, courier instruction, feedback entry, call log, recording, and related communication event.

Purpose
This schema is designed to help teams access detailed raw data for operational review and shipment-level investigation. It allows users to understand each step taken during the NDR process, including how customers responded, what instructions were shared with couriers, and what actions were recorded.

Why It Matters
For operations teams, detailed NDR visibility is essential to identify communication gaps, validate actions, review escalations, and troubleshoot shipment-specific issues. This schema helps users analyze the complete chain of events instead of only viewing final shipment outcomes.

About This Document
This document lists the available filters and columns in the NDR Communication Reporting Schema, along with descriptions for each field. Use it as a reference while configuring or reviewing detailed NDR communication reports. We will first explain the logic behind filters and then the columns (related descriptions) which are given below:


Filters


Filter GroupFilter LabelColumn applied onFilter TooltipFilter TypeMandatory?ValuesLimitations
Delivery TypeDelivery TypeDelivery TypeIndicates whether the shipment is forward shipment or reverse pickup shipmentMulti-select DropdownTRUEDefault- Forward
Date RangeCreated AtCreated AtTimestamp for when the shipment was created in ClickPost (in the configured timezone)Date RangeTRUEDefault - Last 7 DaysMax date range of 3 months, future date cannot be selected
Order DateOrder TimestampTimestamp when the order was placed by the customer (if not explicitly passed, same as Created At timestamp)Date RangeFALSEMax date range of 3 months, future date cannot be selected
Pickup DatePickup TimestampTimestamp when the shipment was picked up from the pickup locationDate RangeFALSEMax date range of 3 months, future date cannot be selected
Delivery DateDelivery TimestampTimestamp when the shipment was delivered successfullyDate RangeFALSEMax date range of 3 months, future date cannot be selected
RTO Mark DateRTO Mark TimestampTimestamp when the Return to Origin process was marked, indicating the start of the return logistics cycleDate RangeFALSEMax date range of 3 months, future date cannot be selected
RTO Delivered DateRTO Delivered TimestampTimestamp when the Return to Origin shipment was successfully delivered back to the original sender or warehouseDate RangeFALSEMax date range of 3 months, future date cannot be selected
Latest Tracking UpdateTracking Update TimestampTimestamp of the most recent update in the ClickPost system of the tracking status of the shipment (in the configured timezone)Date RangeFALSEMax date range of 3 months, future date cannot be selected
First NDR DateFirst NDR TimestampTimestamp corresponding to the first delivery failureDate RangeFALSE
NDR DateNDR TimestampTimestamp corresponding to this delivery failureDate RangeFALSE
NDR Feedback DateNDR Feedback TimestampTimestamp when this NDR feedback was receivedDate RangeFALSE
CarrierCarrier PartnerCarrier Partner NameName of the logistics partner responsible for the shipment deliveryMulti-select DropdownFALSEList of carrier partner names for the enterprise
Carrier Partner AccountCarrier Partner Account NameName of the account associated with the carrier partnerMulti-select DropdownFALSEList of carrier partner account names for the enterprise
TrackingStatusLatest StatusCurrent status of the shipment in ClickPost's logistics management system, indicating progress and latest updatesMulti-select DropdownFALSEList of uber statuses
Stuck Shipment?Stuck Shipment?Indicates whether the shipment is not progressing through the expected lifecycle stages (no tracking updates since the last 3 days)Boolean DropdownFALSEYes, No
SLA Breached?SLA Breached?Indicates whether SLA committed by carrier partner has been breached or not (blank in case SLA is not available)Boolean DropdownFALSEYes, No
Pickup DetailsPickup PincodePickup PincodePostal code of the pickup locationMulti-select DropdownFALSE
Pickup CityPickup CityCity of the pickup locationMulti-select DropdownFALSEList of cities
Drop DetailsDrop PincodeDrop PincodePostal code of the delivery locationMulti-select DropdownFALSEList of pincodes
Drop CityDrop CityCity of the delivery locationMulti-select DropdownFALSEList of cities
Invoice DetailsPayment ModePayment ModeMode of payment (Cash on Delivery or Prepaid)Multi-select DropdownFALSECOD, Prepaid
Invoice ValueInvoice ValueMonetary amount associated with the invoiceValue RangeFALSE
NDRNDR CountNDR CountThe particular failed delivery count for which the information is displayedMulti-select DropdownFALSE0, 1, 2, 3, 4, 5+
Current NDR Escalation StatusCurrent NDR Escalation StatusThe current status of the NDR case basis the feedback receivedMulti-select DropdownFALSEnew, processed, mailed, final
NDR ReasonNDR ReasonReason for this unsuccessful attempt to deliver the shipment, indicating the cause of the failureMulti-select DropdownFALSEList of NDR reason
NDR NotificationNotification Level CountNotification Level CountThe particular NDR notification level for which the information is displayedMulti-select DropdownFALSE0, 1, 2, 3, 4, 5+
Notification Triggered ChannelNotification Triggered ChannelThe channel through which the notification was triggeredMulti-select DropdownFALSEWhatsapp, sms,email, AI agent, IVRS
NDR FeedbackNDR Feedback CountNDR Feedback CountThe count of this particular customer/operational feedback received for this NDR caseMulti-select DropdownFALSE0, 1, 2, 3, 4, 5+
NDR Feedback SourceNDR Feedback SourceThe channel from which the NDR feedback was receivedMulti-select DropdownFALSESMS, Email, Whatsapp , Whatsapp bot, IVRS , AI Agent, Brand, Bulk action, Tracking Page, System generated
NDR FeedbackNDR FeedbackThe operational or customer feedback received (Reattempt/RTO)Multi-select DropdownFALSERTO, Reattempt
NDR Reason ConfirmationNDR Reason ConfirmationIndicates if the customer agrees with the couriers mentioned failure reasonBoolean DropdownFALSETrue, False
NDR InstructionInstruction Adhered?Instruction Adhered?Indicates whether the delivered instruction was followed by the carrier partner or notBoolean DropdownFALSEYes,no

Columns



Field GroupField NameField DescriptionSample ValueData typeMandatory Field?
Order DetailsTracking Info IDUnique identifier for tracking the shipment (internal)FALSE
Order DetailsAWBAir Waybill number, unique identifier for each carrier used to track the shipmentAWB-K8F3L9Q2X7MStringTRUE
Order DetailsOrder IDUnique identifier of an order (can be same for multiple shipments)ORD-7K2LM9P4Q8XStringFALSE
Order DetailsReference No.Unique identifier of a shipment in ClickPostREF-9S2LG7C8P1EStringFALSE
Order DetailsDelivery TypeIndicates whether the shipment is forward shipment or reverse pickup shipmentForward/ReverseEnumFALSE
Order DetailsCreated AtTimestamp for when the shipment was created in ClickPost (in the configured timezone)2025-01-05 10:15Date (UTC)FALSE
Order DetailsOrder TimestampTimestamp when the order was placed by the customer (if not explicitly passed, same as Created At timestamp)2025-01-04 9:12Date (IST)FALSE
Order DetailsCarrier Partner IDUnique identifier for the carrier partnerDelhiveryStringFALSE
Order DetailsCarrier Partner Account IDUnique identifier for the carrier partner accountDelhivery SurfaceStringFALSE
Order DetailsCarrier Partner NameName of the logistics partner responsible for the shipment deliveryShiprocketStringFALSE
Order DetailsCarrier Partner Account NameName of the account associated with the carrier partnerShopifyStringFALSE
Order DetailsCarrier Partner via AggregatorCarrier used to ship the product via an aggregator2StringFALSE
Order DetailsChannel NameName of the channel through which the order is received1StringFALSE
Product DetailsNumber of ItemsTotal number of items in the shipmentSKU-A12X9IntegerFALSE
Product DetailsNumber of BoxesNumber of boxes in the shipmentWireless MouseIntegerFALSE
Product DetailsProduct SKU CodesComma separated SKU codes for the items in the shipmentINV-10021StringFALSE
Product DetailsItem NamesComma separated item names in the shipment2025-01-05StringFALSE
Invoice DetailsInvoice NumberUnique identifier for the invoice1299.5StringFALSE
Invoice DetailsInvoice DateDate when the invoice was issuedINRDate (IST)FALSE
Invoice DetailsInvoice ValueMonetary amount associated with the invoicePrepaidStringFALSE
Invoice DetailsCurrency CodeCurrency used for the invoice value0StringFALSE
Invoice DetailsPayment ModeMode of payment (Cash on Delivery or Prepaid)COD/PrepaidEnumFALSE
Invoice DetailsCOD ValueAmount to be collected upon delivery45IntegerFALSE
Invoice DetailsPricing ZonePricing zone associated with the shipment, determined on the basis of the uploaded pincode mappingRahul SharmaStringFALSE
Invoice DetailsShipping CostCost associated with shipping the order, including carrier fees and surchargesWarehouseStringFALSE
Pickup DetailsPickup NameName of the pickup location or the contact name associated with the pickup location560001StringFALSE
Pickup DetailsPickUp Address TypeType of pickup address such as residential or commercialBengaluruStringFALSE
Pickup DetailsPickup PincodePostal code of the pickup locationBangalore UrbanStringFALSE
Pickup DetailsPickup CityCity of the pickup locationKarnatakaStringFALSE
Pickup DetailsPickup DistrictDistrict of the pickup locationIndiaStringFALSE
Pickup DetailsPickup StateState of the pickup locationABC LogisticsStringFALSE
Pickup DetailsPickup CountryCountry of the pickup locationVEND001StringFALSE
Pickup DetailsPickup OrganisationName of the organization responsible for pickup coordinationWH-BLR-01StringFALSE
Pickup DetailsPickup Vendor CodeHub code of the pickup location (not supported for all carriers)TIN9834521StringFALSE
Pickup DetailsFrom WarehouseOrigin warehouse of the shipmentArjun MehtaStringFALSE
Pickup DetailsTaxpayer Identification Number (TIN)Taxpayer Identification Number (TIN) of the pickup organisationHomeStringFALSE
Drop DetailsDrop NameContact name associated with the drop location, typically the customer name560034StringFALSE
Drop DetailsDrop Address TypeType of delivery address such as residential or commercialBengaluruStringFALSE
Drop DetailsDrop PincodePostal code of the delivery locationBangalore UrbanIntegerFALSE
Drop DetailsDrop CityCity of the delivery locationKarnatakaStringFALSE
Drop DetailsDrop DistrictDistrict of the delivery locationIndiaStringFALSE
Drop DetailsDrop StateState of the delivery locationTechNova Pvt LtdStringFALSE
Drop DetailsDrop CountryCountry of the delivery locationLocalStringFALSE
Drop DetailsDrop OrganisationOrganisation where the shipment is droppedIn TransitStringFALSE
Drop DetailsShipment ZonePickup and drop pincode zone mapping based on the selected config (Order Creation or AWB Generation APIs, Uploaded Pincode Zones, or Clickpost Zone)2025-02-10 10:15StringFALSE
TrackingLatest StatusCurrent status of the shipment in ClickPost's logistics management system, indicating progress and latest updatesPackage departed facilityStringFALSE
TrackingLatest Timestamp (Carrier)Timestamp of lastest status update received from the carrierBengaluru HubDate (IST)FALSE
TrackingLatest RemarkLatest note from the carrier regarding the shipment status, providing insights into the current progress2025-02-10 10:20StringFALSE
TrackingLatest LocationLatest geographic position of the shipment2025-02-10 10:21StringFALSE
TrackingUpdated TimestampTimestamp of the most recent update in the ClickPost system of any data related to the shipment (in the configured timezone)2025-02-08 9:10Date (UTC)FALSE
TrackingTracking Update TimestampTimestamp of the most recent update in the ClickPost system of the tracking status of the shipment (in the configured timezone)2025-02-11 15:20Date (UTC)FALSE
TrackingPickup TimestampTimestamp when the shipment was picked up from the pickup location2025-02-11 15:20Date (IST)FALSE
TrackingDelivery TimestampTimestamp when the shipment was delivered successfully3 DaysDate (IST)FALSE
TrackingStuck Shipment?Indicates whether the shipment is not progressing through the expected lifecycle stages (no tracking updates since the last 3 days)NoStringFALSE
TrackingCommitted SLA by CarrierService Level Agreement timeframe committed by the carrier for shipment delivery0StringFALSE
TrackingSLA Breached?Indicates whether SLA committed by carrier partner has been breached or not (blank in case SLA is not available)RTO-AWB-1001StringFALSE
TrackingAgeing from SLA BreachDuration since the Service Level Agreement (SLA) was breached, indicating how long a shipment has been delayed beyond agreed terms2025-02-15 10:10StringFALSE
TrackingRTO AWBReturn to Origin Air Waybill number (if different from the original AWB)2025-02-20 11:20StringFALSE
TrackingRTO Mark TimestampTimestamp when the Return to Origin process was marked, indicating the start of the return logistics cycle0Date (IST)FALSE
TrackingRTO Delivered TimestampTimestamp when the Return to Origin shipment was successfully delivered back to the original sender or warehouseNDR-10021Date (IST)FALSE
NDR Case DetailsNDR CountThe particular failed delivery count for which the information is displayed3StringFALSE
NDR Case DetailsNDR Case IDThe NDR case ID for this NDR count3223StringTRUE
NDR Case DetailsNDR TimestampTimestamp corresponding to this delivery failure2025-02-11 10:12Date (IST)FALSE
NDR Case DetailsFirst NDR TimestampTimestamp corresponding to the first delivery failure2025-02-11 10:12Date (IST)FALSE
NDR Case DetailsNDR ReasonReason for this unsuccessful attempt to deliver the shipment, indicating the cause of the failureCustomer Not AvailableEnumFALSE
NDR Case DetailsNDR RemarkNotes regarding this unsuccessful attempt to deliver the shipment, including reasons for failure and any relevant commentsCustomer not at homeStringFALSE
NDR Notification DetailsNotification Level CountThe particular NDR notification level for which the information is displayed1IntegerFALSE
NDR Notification DetailsNotification IDThe notification ID associated to this notification394893432StringTRUE
NDR Notification DetailsNotification Triggered TimestampTimestamp when this notification was triggered2025-02-11 10:15Date (UTC)FALSE
NDR Notification DetailsNotification Triggered ChannelThe channel through which the notification was triggeredWhatsappEnumFALSE
NDR Notification DetailsNotification Triggered Successfully?Indicates whether the notifcation was triggered succesfully or notYesBooleanFALSE
NDR Notification DetailsNotification Trigger Failure ReasonThe reason for the notification trigger failure (in case notification was not triggered successfully)Phone no not validStringFALSE
NDR Notification DetailsNotification Delivered Successfully?Indicates whether the notifcation was delivered succesfully to the customer or not (only available for specific channels such as WhatsApp)YesBooleanFALSE
NDR Notification DetailsNotification Delivered TimestampTimestamp when the notification was delivered to the customer (only available for specific channels such as WhatsApp)2025-02-11 12:30Date (UTC)FALSE
NDR Notification DetailsNotification Read Successfully?Indicates whether the notifcation was read by the customer or not (only available for specific channels such as WhatsApp)YesBooleanFALSE
NDR Notification DetailsNotification Read TimestampTimestamp when the notification was read by the customer (only available for specific channels such as WhatsApp)2025-02-11 12:30Date (UTC)FALSE
NDR Feedback DetailsNDR Feedback IDThe feedback ID associated with this feedback, and mapped to the most relevant notification (if available)NDRFB-701StringTRUE
NDR Feedback DetailsNDR Feedback CountThe count of this particular customer/operational feedback received for this NDR case1IntegerFALSE
NDR Feedback DetailsNDR FeedbackThe operational or customer feedback received (Reattempt/RTO)Reattempt / RTOStringFALSE
NDR Feedback DetailsNDR Feedback TimestampTimestamp when this NDR feedback was received2025-02-11 11:10Date (UTC)FALSE
NDR Feedback DetailsNDR Feedback TypeIndicates whether the feedback was received from the operations team or the customerOperation/CustomerEnumFALSE
NDR Feedback DetailsNDR Feedback SourceThe channel from which the NDR feedback was receivedWA Bot/AI Agent/UnknownEnumFALSE
NDR Feedback DetailsNDR Raw feedback SourceThe raw feedback source prior to grouping which was receivedkwikchatStringFALSE
NDR Feedback DetailsActioned byIndicates which operation agent has given this feedback[email protected]StringFALSE
NDR Feedback DetailsCurrent NDR Escalation StatusThe current status of the NDR case basis the feedback receivedNew/Processed/Mailed/FinalEnumFALSE
NDR Feedback DetailsPreferred Delivery DateThe preferred date for the next delivery attempt basis the received feedback2025-02-12Date (IST)FALSE
NDR Feedback DetailsUpdated AddressThe updated address for the next delivery attempt basis the received feedbackFlat 302, Green ResidencyStringFALSE
NDR Feedback DetailsUpdated LandmarkThe updated landmark for the next delivery attempt basis the received feedbackNear Metro StationStringFALSE
NDR Feedback DetailsUpdated Drop PincodeThe updated pincode for the next delivery attempt basis the received feedback560037IntegerFALSE
NDR Feedback DetailsUpdated Phone NumberThe updated phone number for the next delivery attempt basis the received feedback9876543210StringFALSE
NDR Feedback DetailsNDR Feedback CommentThe remarks associated with the received feedbackPlease deliver tomorrowStringFALSE
NDR Feedback DetailsNDR Feedback IntentThe customer intent of the received feedbackCourier partner did not call meStringFALSE
NDR Feedback DetailsNDR Reason ConfirmationIndicates if the customer agrees with the couriers mentioned failure reasonNoBooleanFALSE
NDR Feedback DetailsCustomer Picked Call?Indicates if customer picked up the call when a feedback is received either through C2C or agent inputYesBooleanFALSE
NDR Instruction DetailsInstruction Sent Successfully?Indicates whether the instruction was sent to the carrier partner or not, post our validation checksYesBooleanFALSE
NDR Instruction DetailsInstruction Sent TimestampTimestamp when the instruction was sent to the carrier partner2025-02-11 11:15Date (UTC)FALSE
NDR Instruction DetailsInstruction Sent ChannelThe channel through which the instruction was sent to the carrier partner (API/Reports/Both)API/Reports/BothEnumFALSE
NDR Instruction DetailsInstruction Delivered Successfully via API?Indicates whether the instruction was successfully passed via API to the carrier partnerYesBooleanFALSE
NDR Instruction DetailsNDR Instruction API Trigger LogThe trigger log for the NDR Instruction APIcurl -X POST -H 'JWTToken: eyJ0eXAiOiJKVCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJzdWJqZWN0LXN1YmplY3QiLCJhdWQiOlsiYXVkaWVuY2UxIiwiYXVWVuY2UyIl0sImlzcyI6InVybjovL2FwaWdlZS1lZGdlLUpXVC1wb2xpY3ktdGVzdCIsImV4cCI6M3Nzk4NiwiaWF0IjoxNzc2NjkxNTg2LCJqdGkiOiI4NjgzZTE1ZS1kZDdhLTQ0M2ItOGY4Yy0wYTg2N2U5MDkzYTQifQ.UUw5kRb-79XePJljVf-WhRmt3rDS1UEP21V7Oy43fdE' -H 'Content-Type: application/json' -d '{"profile":{"LoginID":"DEL9372","Api_type":"S","LicenceKey":"xxxxsoiprjngnonitfkqptqj"},"altreq":{"AWBNo":"77750830","PreferDate":"/Date(1776796200000)/","AltInstRequestType":"ED"}}' 'https://apigateway.bluedart.com/in/transportation/cust-instruction-update/v1/CustALTInstructionUpdate'StringFALSE
NDR Instruction DetailsNDR Instruction API Response LogThe response log for the NDR Instruction API{"httpStatusCode":200,"responseContent":"{"CustALTInstructionUpdateResult":{"AWBNo":"77750830","IsError":true,"status":[{"StatusCode":"RequestFailure","StatusInformation":"Waybill is flagged for RTO"}]}}","curl":"curl -X POST -H 'JWTToken: eyJ0eXAiOiJKV1QiLCJhbGciOiUzI1NiJ9.eyJzdWIiOiJzdWJWN0LXN1YmplY3QiLCJhdWQiOlsiYXVkaWVuY2UxIiwiYXVkaWY2UyIl0sImlzcyI6InVyovL2FwaWdlZS1lZGdlLUpXVC1wb2xpY3ktdGVzdCIsImV4cCI6MTc3Njc3Nzk4NiwiaWF0IjoxNzc2NNTg2LCJqdGkiOiI4NjgzZTE1ZS1kZDdhLTQ0M2ItOGY4Yy0wYTg2N2U5MDkzYTQifQ.UUw5kRb-79XePJljVf-WhRmt3rDS1UEP21V7Oy4fdE' -H 'Content-Type: application/json' -d '{"profile":{"LoginID":"DEL072","Api_type":"S","LicenceKey":"quxxxxxsoiprjngnonitfkqptqj"},"altreq":{"AWBNo":"77750830","PreferDate":"/Date(1776796200000)/","AltInstRequestType":"ED"}}' 'https://apigateway.bluedart.com/in/transportation/cust-instruction-update/v1/CustALTInstructionUpdate'"}StringFALSE
NDR Instruction DetailsNDR Instruction API Response CategoryThe API outcome grouping of response log for the NDR Instruction APISHIPMENT_IN_RTO_LOCK_STAGEEnumFALSE
NDR Instruction DetailsInstruction Adhered?Indicates whether the delivered instruction was followed by the carrier partner or notYesBooleanFALSE
NDR Instruction DetailsInstruction Adhered TimestampTimestamp when the instruction was followed by the carrier partner2025-02-11 12:10Date (UTC)FALSE
NDR AI AgentAI Call OutcomeThe outcome of the AI agent callCompletedStringFALSE
NDR AI AgentAI Call Connected?Indicates whether the AI agent was able to successfully connect with the receiver or notTRUEBooleanFALSE
NDR AI AgentAI Call Triggered FromThe phone number from which the AI agent called91 7482879279IntegerFALSE
NDR AI AgentAI Call SummaryThe summary of the AI agent callThe agent called Richa regarding her undelivered order from May 5. Richa confirmed she was unavailable during the delivery attempt. The agent acknowledged a possible error and attempted to reschedule delivery for the next day, but Richa requested delivery today.StringFALSE
NDR AI AgentAI Call DurationThe duration (in seconds) of the AI agent call79IntegerFALSE
NDR AI AgentAI Call Recording LinkThe recording link of the AI agent callhttps://media.plivo.com/v1/Account/MAYZG0ODDHNDA4YT/Recording/92c77c77-faaa-4a99-b8e0-1fad256.mp3StringFALSE
NDR Call DetailsAgent Allocation TimestampTimestamp when the NDR case was allocated to the agent2025-02-11 12:20Date (UTC)FALSE
NDR Call DetailsAgent Name/CodeThe agent allocated to the NDR caseAGT-101StringFALSE
NDR Call DetailsAuto Delivered without Calling?Indicates whether the shipment was delivered automatically without callingYesBooleanFALSE
NDR Call DetailsMarked as Follow-up?Indicates whether the agent marked the NDR case as a follow-up or notYesBooleanFALSE

Did this page help you?