Welcome, Guest. Please Login or Register
Textvertising
  You can click http://www.textvertising.co.uk to return to our home page at any time.
  HomeHelpSearchLoginRegister Textvertising Website  
 
Page Index Toggle Pages: 1
Send Topic Print
(Read 1370 times)
David
Guest




Re: Inbound Reports by Keyword/Subkeyword
Reply #4 - May 13th, 2009, 3:12pm
 
Ah, yes that was exactly what I wanted!

Cheers. Smiley
Back to top
 
 
IP Logged
 
Textvertising Administrator
YaBB Administrator
*****
Offline

Webmaster
Posts: 33
Preston, UK
Gender: male
Re: Inbound Reports by Keyword/Subkeyword
Reply #3 - May 13th, 2009, 3:10pm
 
Yes, thats an easy one...

Just create some blank columns to the right of the cells that contain the message.

Then go to "Data > Text To Columns" on the Excel main menu at the top.

Select "Delimited"
Select a "Space" as the delimiter by ticking the box.

This will then split the column up by the space.

The next column along will then show the "sub keyword" and you can filter by this.

Does that help?
Back to top
 

The Forum Administrator.
WWW Textvertising Administrator robbie.82055  
IP Logged
 
David
Guest




Re: Inbound Reports by Keyword/Subkeyword
Reply #2 - May 13th, 2009, 3:07pm
 
Yeah I got to that, I have the numbers in Excel but cant split the message into subkeywords?

I know this isnt a Textvertising issue, but can you help?
Back to top
 
 
IP Logged
 
Textvertising Administrator
YaBB Administrator
*****
Offline

Webmaster
Posts: 33
Preston, UK
Gender: male
Re: Inbound Reports by Keyword/Subkeyword
Reply #1 - May 13th, 2009, 3:05pm
 
Yes this can be done.

You need to login and look under REPORTS then click "Show Inbound SMS and Generate Reports".

Once loaded, at the bottom you hve the option to download these into a "CSV" file for excel . This file will contain the date, the number, the message, time and network.
Back to top
 

The Forum Administrator.
WWW Textvertising Administrator robbie.82055  
IP Logged
 
David
Guest




Inbound Reports by Keyword/Subkeyword
May 13th, 2009, 3:03pm
 
I need a report that shows all the inbound SMS received so that I can sort it by date for one of our clients...

Can this be done? Undecided
Back to top
 
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Print