Time (date) sent is text?

[Anonymous]

I think I might have asked this before, but. . . in an exported .csv report, the Time sent field (which also includes the date and the day of the week) is totally text. There is no way to sort by that column in a logical manner unless you parse out the info into separate columns. You're all about metrics - how about make it so we can use the information to view metrics? And if I am missing something - there is a totally easy way to do this, I do truly apologize. Just please tell me what it is.

[Beatriz_R]

Hello @Anonymous,

Thank you for bringing this up. I tried this in my account and was able to sort the column by A-Z or Z-A and this puts it in order from earliest to latest, or latest to oldest. Does this sorting option work for you? If you are still seeing an issue, would you be able to elaborate a bit on exactly what you're seeing and trying to sort by?

[Anonymous]

Original download, date descending

Sort by total sent, just for the sake of example

 '

Sort again by Time sent

[Beatriz_R]

Hello @Anonymous,

Thank you so much for clarifying this for me, I understand now you're referring to exporting all your sent campaigns and apologize for this. I do see the same thing with that export and I have passed your feedback along to our engineers. Unfortunately, at this time there is no other workaround other than splitting the columns.

[Anonymous]

Thanks! It just seems really bizarre to me that CC is all about metrics - sort this, A/B test, show this, and yet two of the most-needed sets of data are either unusable without several steps of data massaging (text formatted date field) or not even provided (subject line). 
At least in this case I know it's not something I am doing.
:smileyface:

[JulieG118]

Agree!

[Beatriz_R]

Hello @Anonymous,

I wanted to let you know that we implemented the fix for this this past week and the 'Sent Date and Time' should now be sortable in Excel! Please continue to give us feedback on anything else you come across!

[Anonymous]

Awesome! Wow! Thank you!! Yay!  Next task - include subject line in reports... :)