Call Detail Record: Read Your Own and Count Missed Calls
A call detail record logs each call's numbers, time, duration and status without audio. Export it to a spreadsheet and count missed inbound calls, callback gaps and busy hours.
By Tej Pandya, Founder · Updated 15 Nov 2026

Key takeaways
- A CDR is the system-written log of each call without audio. You can count missed calls from it in a spreadsheet, and the history you can retrieve is whatever your provider documents.
- You can request your own records in writing from your operator, but another person's records are archived for the government's scrutiny, not for private requesters.
- Export your call log every month and keep the file yourself. Dashboards roll over, archives expire and recordings often expire sooner than the log.
- Four spreadsheet counts show where enquiries may be lost: missed rate, callback gap, callers who may have given up after two tries, and busiest hours. Each has a pass or fail below.
In this article
- 1What does a call detail record contain, and what does it leave out?
- 2Can you get the call details of another mobile number in India?
- 3How long can you get your CDR history back?
- 4How do you read your own call detail record in 15 minutes?
- 5Which eight columns do you keep?
- 6What is your missed rate?
- 7How long did missed callers wait for a callback?
- 8Which callers rang twice and heard no answer?
- 9Which hours are busiest, and was someone there?
- 10Which six questions should you ask your provider about CDR history?
- 11How does TalkEasy log calls and report missed calls?
- 12Frequently asked questions
A call detail record shows patterns that a glance at the phone never does: a caller who rang twice within fifteen minutes and was never called back, or the hour of the day when most of your calls go unanswered. Each pattern sits in the log as plain rows, and a spreadsheet can count those rows in a few minutes.
A call detail record (CDR) is one of the cheapest sources of evidence a small business has about missed calls. It shows which callers rang, at what hour, and whether anyone rang back. If you wait until you need last quarter's data, the provider may already have archived or deleted it.
Below, you will see what you can lawfully request and what you cannot, how long history survives, and then a 15-minute check for your own export: missed rate, callback gap, repeat misses and busiest hours. You need nothing more than a spreadsheet.
What does a call detail record contain, and what does it leave out?
A call detail record is the metadata a phone system writes for each call: the calling and called numbers, start time, duration and how the call ended. It never holds the conversation. Business phone systems add routing and agent details, so the exact columns differ from one provider to the next.
Wikipedia's entry on the call detail record lists the core fields: calling and called numbers, start time and duration, and the call's disposition, such as connected or busy.
Know what the record cannot tell you:
- Why the caller rang. That needs a recording or a summary.
- What was said. The CDR holds no audio.
- Whether a missed caller was reached later. That answer sits in your outbound rows, so you must match them yourself. The check below does this.
Can you get the call details of another mobile number in India?
No. A private person cannot lawfully obtain another person's call records, and sites or software that promise it are not a route to them. The licence archives those records for the government. Your own records you can request in writing.
For operators holding a Unified Licence, condition 39.20 of the Unified Licence, the Department of Telecommunications' licence agreement (version updated to 31 March 2024), says CDR records are to be "archived for at least two years for scrutiny by the Licensor for security reasons". The Licensor is the government. The Telecommunications (Authorisation for Provision of Principal Telecommunication Services) Rules, 2026, notified on 23 June 2026 and published in the Gazette on 24 June 2026 (G.S.R. 513(E)), rename "main" services as "principal" services and replace the legacy Unified Licence regime for new authorisations. Existing Unified Licence holders and new authorisation holders may therefore sit under different instruments.
To get your own CDR, an advocate's September 2026 guide gives the author's view of the route, not a rule:
- Send a written request to the operator's nodal officer (the officer designated to handle such requests).
- Attach proof of ownership, meaning ID and address.
- State the period, the fields you want and the format.
The author expects two to eight weeks and at least one follow-up, and recommends sending the request by email and registered post, with a 30-day response expectation. Ask soon after the period you need, because records older than a year may no longer exist.
For a business line, the quicker route is your phone system's own export. If your team calls from it, tell them the log exists and what you use it for.

How long can you get your CDR history back?
Plan on about a year at most, and sometimes 90 days, depending on the provider; the table below gives each figure as of November 2026. The licence's two years is a duty owed to the government, so do not plan around it.
| Provider (own documentation page, read November 2026) | What a customer can retrieve |
|---|---|
| Smartflo, Tata Tele Business Services ("Call Detail Records" documentation) | Latest 90 days in the dashboard; up to 365 days through archived reports, retrieved month by month; Excel download; recordings directly accessible for the last 3 months |
| Acefone ("Data Retention Policy" page) | Months 1 to 3 in the dashboard with download; months 4 to 12 as archived batch files; after month 12 "permanently deleted"; recordings kept 3, 6, 9 or 12 months depending on plan |
| Operator holding a Unified Licence, condition 39.20 | Archived for at least two years for government scrutiny; this is not a customer right of access |
We publish this page, and we are not one of the providers in the table.
The Unified Licence period was one year before the December 2021 amendment, according to Communications Today. Recordings can expire sooner than the log: Smartflo keeps 3 months directly accessible and Acefone ties recordings to the plan.
Our recommendation is to export on the first of every month and store the file.
How do you read your own call detail record in 15 minutes?
Export the last 30 days to a spreadsheet, keep eight columns and run four counts: missed rate, callback gap, callers who may have given up, and busiest hours. Each takes one formula. The pass and fail marks below are our recommendation, not an industry standard, and each rests on our assumption that a caller who rings and gets no answer may be a lost enquiry.
To show the arithmetic, here are six invented rows from one day:

| Row | Direction | From | To | Start | Status |
|---|---|---|---|---|---|
| 1 | inbound | Caller A | Shop | 10:02 | answered |
| 2 | inbound | Caller B | Shop | 10:15 | missed |
| 3 | outbound | Shop | Caller B | 10:40 | answered |
| 4 | inbound | Caller C | Shop | 11:05 | missed |
| 5 | inbound | Caller C | Shop | 11:20 | missed |
| 6 | inbound | Caller D | Shop | 14:10 | answered |
The formulas assume columns A to I as set out in the first check below. Your provider may write "incoming" for inbound or "no answer" for missed, so change the words in the formulas to match your export.
Which eight columns do you keep?
Keep call ID (A), direction (B), from (C), to (D), start date and time (E), ring or answered seconds (F), duration in seconds (G) and status (H). Add column I with =HOUR(E2). Write numbers in one format, such as the last ten digits, or matching will fail.
- Pass: all eight columns are present and numbers match across rows.
- Fail: the export lacks direction or status. Ask your provider for a fuller export.
What is your missed rate?
Missed rate is missed inbound calls divided by all inbound calls: =COUNTIFS(B:B,"inbound",H:H,"missed")/COUNTIFS(B:B,"inbound"). In the six rows, 3 of 5 inbound calls were missed, which is 60%. Count busy and failed attempts separately, and leave them out of the missed count. See answer rate.
- Pass: you can state the figure for each of the last three months.
- Fail: you cannot produce it from the export.
How long did missed callers wait for a callback?
Put this in J2 and fill down; it returns hours, or "never":
=IF(AND(B2="inbound",H2="missed"),IF(COUNTIFS($B:$B,"outbound",$D:$D,C2,$E:$E,">"&E2)=0,"never",(MINIFS($E:$E,$B:$B,"outbound",$D:$D,C2,$E:$E,">"&E2)-E2)*24),"")
In the example, Caller B waited about 0.42 hours (25 minutes). Caller C shows "never".
- Pass: every missed inbound call is returned the same working day. This is our recommendation, on the assumption that a callback within the working day still keeps the enquiry open.
- Fail: any "never".
Which callers rang twice and heard no answer?
This flags a caller with two or more missed inbound calls, no answered call and no outbound call to them. Put it in K2:
=IF(AND(B2="inbound",COUNTIFS($C:$C,C2,$B:$B,"inbound",$H:$H,"missed")>=2,COUNTIFS($C:$C,C2,$H:$H,"answered")=0,COUNTIFS($D:$D,C2,$B:$B,"outbound")=0),"gave up","")
Caller C is flagged on rows 4 and 5. "Gave up" is our inference: the log shows two missed calls and no contact afterwards, not the caller's intent.
- Pass: no flags.
- Fail: any flag. Ring those numbers today.
Which hours are busiest, and was someone there?
Count inbound calls per hour with =COUNTIFS($B:$B,"inbound",$I:$I,10), changing 10 for each hour. Note your top two hours. For outbound calling windows, see best time to call customers.
- Pass: at least one person is on the line in each of your top two hours, every working day.
- Fail: either hour has a day with nobody on the line.
Which six questions should you ask your provider about CDR history?
Ask your provider, us included, six questions in writing:
- How many days sit in the dashboard?
- How many days sit in the archive?
- What is the export limit per request?
- Do recordings expire before the log?
- Who on my team can export?
- Is there a scheduled export or an API?
Pass: you have written answers to all six and a saved export for each of the last three months. Fail: any answer is missing.
How does TalkEasy log calls and report missed calls?
TalkEasy logs calls made and received through the Business Dialer and shared number automatically, with the contact, time, duration and outcome. Call Analytics reports total calls, answer rate, missed calls, average talk time, team performance and peak calling hours, in daily and monthly reports you can download.
Call Analytics shows missed calls and peak calling hours without a spreadsheet. Callback gap and repeat misses still need one.
A CDR cannot say why a customer rang. AI Call Summaries add a transcript, a short summary, the customer's intent and a suggested follow-up in the call details screen within a couple of minutes of the call ending.
As of November 2026, the Pro plan is ₹999 + GST a month and includes call recording and history, the analytics dashboard and unlimited users. Customisation and integrations are not in Pro. The Enterprise plan includes custom CRM integration and is quoted on request.
See missed calls and peak hours without a spreadsheet
Frequently asked questions
No. A call detail record holds only metadata, while a recording holds the audio. TalkEasy plays an announcement at the start of every recorded call; call recording announcement covers what to say and how to test it.
Sources
- 1.Unified Licence agreement, condition 39.20, Department of Telecommunications, Ministry of Communications, Government of India, Version updated to 31 March 2024
- 2.Gazette of India, Extraordinary, Part II Section 3(i), No. 562, 6 September 2025: draft rules notified 5 September 2025, Department of Telecommunications, 6 September 2025
- 3.Telecommunications (Authorisation for Provision of Principal Telecommunication Services) Rules, 2026, G.S.R. 513(E), Department of Telecommunications, Notified 23 June 2026, published in the Gazette of India on 24 June 2026
- 4.Call detail record, Wikipedia
- 5.DoT amends UL to increase storage time of CDR, EDR, IPDR, Communications Today, 24 December 2021
- 6.Call Details Record: How to Get Your Own CDR, Sudhir Rao, Advocate, Supreme Court of India, 17 September 2026


