SMS/MMS Messaging Detail Records (xDR)

This dataset provides detailed records of SMS and MMS messaging events, including sender and recipient addresses, timestamps, routing information, delivery status, message size, and classification as A2P or P2P. It enables comprehensive analysis of messaging traffic, delivery performance, and network operations for telecommunications providers and messaging platforms.

  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Message delivery performance analysis and reporting

Sample rows

preview · 8 of 700 rows · all 14 columns
message_idstringmessage_typestringmessage_size_bytesintegermessage_content_typestringsender_addressstringrecipient_addressstringtimestamp_sentdatetimetimestamp_delivereddatetimesmsc_idstringdelivery_statusstringa2p_p2p_classificationstringmessage_subjectstringerror_codestringoperator_idstring
MSG-000001ASMS145blank+14155550101+4477009001112024-06-04T09:12:37Z2024-06-04T09:12:45ZSMSC-101deliveredP2PblankblankOP-UK-01
MSG-000002BSMS160blankPromoBot2024+4930123456782024-06-04T11:28:22Z2024-06-04T11:28:40ZSMSC-102deliveredA2PblankblankOP-DE-02
MSG-000003CSMS62blank+33123456789+141555502022024-06-04T08:54:10Z2024-06-04T08:54:11ZSMSC-103deliveredP2PblankblankOP-US-03
MSG-000004DSMS1blankAppID123456+4477009002222024-06-04T13:19:41Z2024-06-04T13:19:54ZSMSC-104pendingA2PblankblankOP-UK-04
MSG-000005ESMS70blank+442079460000+331234567892024-06-03T21:53:32Z2024-06-03T21:53:34ZSMSC-105failedP2PblankERR-NETWORKTIMEOUTOP-FR-05
MSG-000006FSMS128blankXtremeAlertsShopID7892024-06-03T16:07:12ZblankSMSC-106pendingA2Pblankblankblank
MSG-000007GSMS159blank+393351234567+4416329601232024-06-04T10:45:01Z2024-06-04T10:45:21ZSMSC-107deliveredP2PblankblankOP-UK-07
MSG-000008HSMS0blankVerifyApp+4420794601112024-06-04T06:44:08Z2024-06-04T06:44:10ZSMSC-108deliveredA2PblankblankOP-UK-08

What the 700 rows show

from the 700-row sample

SMS (message type) stands out: mean message_size_bytes is 102.4, against 1,808,958 for the rest.

  • 128median message_size_bytes
  • 2a2p p2p classifications
  • 4delivery statuses
Mean message_size_bytes by message_type700 rows
01M2M102.4SMS573 rows1.8MMMS127 rows
message_size_bytes700 rows, in bands of 2M
033567066915502906M12Mmessage_size_bytes →

Median 128, from 0 to 10,485,760.

message_content_type127 rows with a value · 573 left blank
  1. image/jpeg43
  2. image/png31
  3. video/mp419
  4. application/pdf19
  5. image/gif15
14 columns by typefrom the column list below
  • string 11
  • integer 1
  • datetime 2

Columns

14 columns in three groups
blueprint · 14 columns
columntypedescriptionexample
Text 11 columns
message_idstringUnique identifier for each SMS/MMS message event recorduniqueMSG-000001A
sender_addressstringOriginating address (phone number or application ID) of the message sender+14155550101
recipient_addressstringDestination address (phone number or application ID) of the message recipient+447700900111
message_typestringType of message sent: SMS or MMSSMS · MMSSMS
smsc_idstringIdentifier for the SMSC (Short Message Service Center) that routed the messageSMSC-101
delivery_statusstringStatus of message delivery (e.g., delivered, failed, pending, rejected)delivered · failed · pending · rejecteddelivered
a2p_p2p_classificationstringClassification of message as Application-to-Person (A2P) or Person-to-Person (P2P)A2P · P2PP2P
message_subjectstringSubject of the MMS message (if applicable)optionalExclusive Offer
message_content_typestringMIME type of the message content (e.g., text/plain, image/jpeg) for MMS5 types · optionalimage/jpeg
error_codestringError code if delivery failed (optional)optionalERR-NETWORKTIMEOUT
operator_idstringIdentifier for the mobile network operator handling the messageoptionalOP-UK-01
Numbers 1 column
message_size_bytesintegerSize of the message in bytes0 or more145
Dates and times 2 columns
timestamp_sentdatetimeDate and time when the message was sent from the sender2024-06-04T09:12:37Z
timestamp_delivereddatetimeDate and time when the message was delivered to the recipient (if available)optional2024-06-04T09:12:45Z

Use it for

  • median message…128700 rowsmean message size byt…102.4SMS1.8MMMS

    A telecommunications dashboard

    Message_size_bytes by message_type and a breakdown of message_content_type. Excel, Power BI or Tableau.

  • Why do the 573 SMS rows have a mean message_size_bytes of 102.4?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable messages with sender_address, recipient_address and message_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 14 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset700 rows14 columns
Yours1,000 rows14 columnssender_address: UK only

blueprint · smsmms-messaging-detail-records-xdr

Behind this dataset

Same schema. As many rows as you need.

These 700 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Message ID unique per SMS/MMS
  • Sender (originating) and recipient (destination) MSISDN
  • Timestamp: submission, delivery attempt, final delivery/failure
  • SMSC (Short Message Service Center) identifier for routing
  • Delivery status: delivered, failed, pending, expired
  • Message type: SMS (160 chars), concatenated SMS, MMS with size (KB)
  • A2P vs. P2P classification: enterprise SMS, OTP, marketing, person-to-person
  • International SMS and roaming surcharges
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
smsmms-messaging-detail-records-xdr

More in Telecommunications

Browse all
Also in TelecommunicationsDNS Query Performance and Resolution TimesNetwork Outage Incident LogsRadio Access Network (RAN) Key Performance Indicators (KPIs)All 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.