Skip to main content
AT&T Community Forums
Lilchris2006

Teacher

 • 

14 Messages

Thu, Sep 8, 2011 9:13 PM

Total voice/sms usage?

Is there a simple way to find out how many minutes and text message I have sent a certain number?

I added the alias to my ATT address book if thats a step in the right direction.

 

Unless there is a way to do it on my iphone then that would work too.

Responses

Accepted Solution

Official Solution

jamileh

Former Community Manager

 • 

5.2K Messages

9 years ago

 

I know exactly what you want to do because I do this (I'm a data junkie). I used to have to copy/paste all the billing records into Excel but we recently changed this process to make it A LOT easier.

 

Here's what I do:

 

  • Login to att.com
  • click on "View Billed Usage" 
  • Select the billing period you want to look at
  • click on "Download Call Details" 
  • Select XLS or CSV format (XLS is a bigger but prettier file, CSV is a straight text dump. Both will open in Excel. I prefer CSV because there isn't any formatting to get in the way of sorting/filtering)
  • Click submit and wait for the file to download 
  • Geek out while sorting and filtering data (Ok, maybe it's just me that geeks out)

billing_viewbilledusage.JPG

 

billing_downloadcalldetails.JPG

 

billing_filetype.JPG

--------------

As of May 1st, I am no longer serving as the Community Manager for AT&T. This account will no longer be able to accept private messages.

Did a post have a solution that worked for you? Help other people find solutions faster by marking posts that helped you as an "Accepted Solution". Learn about accepted solutions here.

I am an AT&T employee and the postings on this site are my own and don’t necessarily represent AT&T’s position, strategies or opinions.
youngjm

Master

 • 

7.1K Messages

9 years ago

Use the online account here on the site. You can see your usage.
_____________________

For service or support questions including existing order status, call:
Customer Support: 1-800-331-0500

Information on iPhone unlocking can be found here by copying this link into your browser:
https://www.att.com/deviceunlock/client/en_US/
youngjm

Master

 • 

7.1K Messages

9 years ago

On the iPhone, download the ATT app
_____________________

For service or support questions including existing order status, call:
Customer Support: 1-800-331-0500

Information on iPhone unlocking can be found here by copying this link into your browser:
https://www.att.com/deviceunlock/client/en_US/
RicoLX

Professor

 • 

7.8K Messages

9 years ago

Uep, the ATT app should gibe you some features to tract activity. Theres an android app just the same

Teacher

 • 

14 Messages

9 years ago

Sorry guess I named the title poorly, let me be a little more specific. Smiley Wink

 

For example I want to see how long I have talked with my friend at number 978-555-5555 for the month of July.

Same thing for how many text messages have been sent to and from that number.

 

 

RicoLX

Professor

 • 

7.8K Messages

9 years ago

Other than the detailed minutes logged online, I dont think they provide a summary by phone number level of detail.Now if you had the means to capture the detail yourself into text file, you could then import it into a spreadsheet or database table and do your own summaries.

Teacher

 • 

14 Messages

9 years ago

Yea I do not mind figuring that out in Excel myself, problem is I have no clue on how to export the call list.

 

Wild Banchi

Master

 • 

10.2K Messages

9 years ago

On an Android phone (and possibly with the iPhone, too, if it holds the total amount of text messages exchanged between users), you can see how many text messages were sent and received between yourself and another person by keeping track of the starting date of the month and the ending date. For example, I exchanged 272 text messages with a friend of mine last month and in my messaging application, it shows up as their name, along with (0/272) right by the side. That's one way of keeping track.

As far as calls go, you'll just have to add up the times and combine them into one total time amount. That is, if there is no other simple way to do this.

:cathappy: Remember that Wild Banchi... 1993-2010 :cathappy:



Stephono

Scholar

 • 

94 Messages

9 years ago

Yes and no lol

Now with a iphone there is a total talk time in the settings. Now it is avalible on select android devices.

RicoLX

Professor

 • 

7.8K Messages

9 years ago

A fellow data junkie! 😄 thats exactly what I was talking about. The procedure you just posted is much easier!
jamileh

Former Community Manager

 • 

5.2K Messages

9 years ago

I literally clapped my hands when I saw that we had an fully functional procedure for this. I spend WAY too much time in Excel. 🙂

--------------

As of May 1st, I am no longer serving as the Community Manager for AT&T. This account will no longer be able to accept private messages.

Did a post have a solution that worked for you? Help other people find solutions faster by marking posts that helped you as an "Accepted Solution". Learn about accepted solutions here.

I am an AT&T employee and the postings on this site are my own and don’t necessarily represent AT&T’s position, strategies or opinions.
Ann154

Master

 • 

4.1K Messages

9 years ago

I have never needed to use it, but "other" carriers have had this option for a while (years?)
Probably from mobile, maybe. :)
RicoLX

Professor

 • 

7.8K Messages

9 years ago

Its a neat tool to have at your disposal. Atts coming around!

Teacher

 • 

14 Messages

9 years ago

Thank you that's exactly what I was looking for. Smiley Happy


I was going to Wireless > Usage and Recent History so I couldn't find it.

mmcginty

Mentor

 • 

28 Messages

9 years ago


Ann154 wrote:
I have never needed to use it, but "other" carriers have had this option for a while (years?)


 


The CSV export feature has been part of the AT&T wireless site since at least July 2005 -- I know this for sure because I have imported my data every month since then, some 127408 voice call records in all.  I've been importing SMS records since the beginning of 2008, 901128 text message records total.

 

Unfortunately, the format of that CSV, as downloaded from the AT&T site, is impossible to import into a database table, as is.  I had to write a rather involved script to convert it, which involve weeding-out all the blank lines and other useless junk, and identifying the lines of text that contain data.  I also had to save it in 2 tables, one for voice, one for text, because the two have disparate sets of fields.

 

The most amazing thing is they have, on two occasions, made changes to their CSV output format, *without* making it any less useless!  It literally blows my mind to try to imagine what it's designers had in mind for this content, but one thing is certain: it was not, "this will be easily imported into relational database tables," they couldn't possibly have cared about that in the least.  (My nickname for this abomination of a format, btw, is "NOT CSV".)

 

In any case, Once the data is imported into tables anything that might be desired can be done with it; having it in tables makes it easily possible to derive stats across phone lines and/or months-to-years.  I've considered publishing my script on a few occasions... (if anyone was interested in it, the prospect of publishing it would become more compelling, I'm certain of it.)  🙂

Get started...

Ask a new question