Archive for the ‘Cool Tools’ Category

Quick tip: Cheap unlimited cellphone plan

Tuesday, February 26th, 2008

I’m with T-mobile, so your mileage may vary.

Step 1: Sign up for T-mobile’s MyFaves plan. This allows you unlimited calling to five telephone numbers. These numbers may be in-network or out-of-network. In other words, they can be any five phone numbers.

Step 2: Sign-up for a free Google Grand Central Account and phone number. Grand Central allows you to receive calls at any phone via one number. It’s basically a free hosted PBX system with some nice extras.

Step 3: Forward all your inbound Grand Central calls to your MyFaves phone. In the Grand Central settings have all your inbound calls routed to your cell.

Step 4: Add your Grand Central number to your MyFaves plan as a “fave”. Any calls to and from your Grand Central number will fall under your MyFaves unlimited calling plan. With Grand Central you can make outbound calls by clicking a link in Grand Central, which will initiate the call and then will ring your phone to connect you.

Step 5: Give your Grand Central number to friends and family. Any calls to your Grand Central number will forward to your cellphone and will be calculated as unlimited calls.

Step 6: Profit!! (Well, not profit, but savings.)

Using AdWords for Keyword Monitoring

Friday, February 22nd, 2008

Keyword monitoringOne thing that’s difficult in search engine marketing is finding good data on search traffic: how often a keyword phrase is searched, how one keyword phrase compares to another in total search volume, how well your competitor is doing relative to you, etc. There’s no real way to get this from the search engines in any usable form as this is essentially their secret sauce. Google has a service called Google Trends where you can compare the relative strength of one keyword to another, but, as far as I know, Google does not provide the public with exact data on the number of searches for say, “hot tamale” or “Chris Sivori” (that’s me).

However, if you’re willing to risk a little money, you can use AdWords to monitor particular search phrases. For example, a while back I started an AdWords campaign to monitor searches for both “chris sivori” and “sivori”. I was curious as to how many times my name popped up in a search. Obviously, it wouldn’t be that often as I’m far from notable, but this made it an even more compelling idea as I would be likely to know whoever would be searching.

Here’s what you do to start monitoring your desired search terms:

  1. Create your campaign. Create an AdWords campaign and uninteresting ads (remember, you don’t necessarily want clickthroughs) for the search terms you want to monitor. Be advised, that popular search terms could result in you losing some money.
  2. Set an acceptable budget. Set your daily budget low enough to where if you suddenly get tons of clickthroughs you won’t lose a lot of money. My daily budget is $1.00 (the lowest you can budget), so the worst I can lose is $30 a month. Usually, it comes out to around $2.00 or so a month.
  3. Check the results. After a few days, log in to your AdWords account and view the impressions for every keyword your tracking. In this case, an impression is any time your ad appears. If your ad bid is competitive it is likely to appear for every instance of a search for your keyword phrases, so the number of impressions will give you a good idea of the total search volume for the keyword phrases you would like to track.

Keyword monitoring with this method will obviously work best with unpopular phrases. Obviously, if you wanted to track a popular keyword, you could spend a lot of money and burn through impressions pretty quickly without necessarily getting an idea of the total search volume. Another complication is that Google seems to mess with the default bids to keep people from using AdWords purely for this purpose. I’ve noticed that two equally inconsequential keyword phrases can have wildly different default bids. If I remember correctly, Google has a certain threshold for bids if the keyword is unlikely to be searched to prevent people from placing a bunch of five cent bids on long-tail keywords.

Other applications of this method:

  1. Track the competition. Imagine you’re working for the McCain campaign, for example, and you want to stay abreast of interest in Mike Huckabee. You could place an ad luring Huckabee supporters to your site from searches for “mike huckabee”, “huckabee”, etc. while also using the impressions data to gauge changes in interest in this candidate. If you monitored your AdWords impressions, you might be able to see a sudden peak in searches, which might indicate growing interest. If you used this method with geographically targeted PPC ads, you could monitor interest levels over time in various battleground states, for instance.
  2. See who’s clicking the ads. If you Google Analytics and add campaign tracking variables to the URL’s in your ads, you should be able to tie a particular ad clickthrough to a specific IP address, which will allow you to further drill down into the source of your clickthroughs and will provide information as to the time of day and specific information about the user including browser type, OS, screen resolution, ISP, company name, etc.
  3. Reverse stalking. Monitoring your own name can be useful in certain situations. If your name is Google-able, you might see a pick up in searches following job interviews, client meetings, conferences, etc. It can be eye opening to see how many times someone Googles you. I welcome the transparency, although I hope I never do anything I have to worry about showing up online.

Got any other ideas? Suggestions? Leave a comment and let me know.

Google Calendar as memory

Friday, December 28th, 2007

I’ve been attending to my finances in my typical feast or famine fashion. I sat down and looked through my records after ignoring everything for a few weeks… checked my accounts, analyzed earning / spending and tried to see where I can cut costs. I have two checking accounts (one business and one personal), two savings accounts, and a handful of different brokerage accounts (partly due to having a few different 401k plans over the years and partly from chasing after the lowest commissions). As a result, the process can get complicated.

One thing I discovered is that I had some additional charges on my cellphone bill due to receiving a bunch of text messages from a few people I’ve been following in Twitter. (This was a case of poetic justice as I unfairly maligned Twitter in the past.)

To avoid future surprises, I signed up for a bulk messaging package ($5 a month). Then I called to have the plan applied retroactively so I could save forty bucks on my past bill. Many people would not have done this, but I enjoy negotiating.

The whole point of this is that I found another nice use for Google Calendar. Normally after such a conversation, I might make a note of who I talked to and what was the outcome, so I could safely forget all about it. This time I dropped an entry into Google Calendar and included all the relevant information. If I need to reference the event down the line, I can use Google Calendar’s search function. As Ron Popeil might say, “Set it and forget it.”

You don’t need GPS

Saturday, December 1st, 2007

If I made a list of all the things I wanted for Christmas, it would include two items. A new laptop and a GPS receiver. Unfortunately, the laptop is a little more necessary.

There was some good news last week that made everything better. Google released a really cool update to Google Maps. Now that Google has released a new version of Google Maps for mobile devices (with My Location), I can do 70% of what I would do with a standard GPS receiver (Garmin, TomTom, etc.) on my Blackberry, which, unlike most other gadgets, I always have with me. Using this new version of Google Maps I can determine my position to within a few hundred meters; close enough for things like driving directions and finding the nearest Starbucks. The Google Maps application does this by using your cellphone to figure out where you are in relation to the nearest cell towers. It works very similar to GPS in that instead of determining position by triangulation against orbital satellites, it just asks your phone where the nearest cell towers are and figures it out from there.

Google was nice enough to put together an informative video about how it works:

Cheap and easy way to go paperless

Saturday, September 15th, 2007

I read a good entry over at Signal V. Noise about how to go paperless by using an expensive duplex scanner from Fujitsu. While I still think this is a great way to do it, and I may even buy one of those scanners, a while back I came up with an easier and far cheaper way to scan my mail and documents into a digital form and have been using it for a while.

Most offices, like mine, have fax machines or fax copiers. I also have a fax to email service through my toll-free provider, Ring Central, where your fax documents are scanned and emailed to you as PDF attachments. If I ever want to archive a paper document into a digital form, I just fax it to myself and save the PDF to my computer. I also leave a copy in my gmail account where I can access the file from anywhere.

The only downside I have discovered is that the faxed PDF is not transformed into indexable text via OCR (optical character recognition) during the scanning process. I compensate for this shortcoming by giving each document a readily comprehensible file name. If you fax each document at a high enough resolution you may be able to perform OCR on the output, however the descriptive file naming used in conjunction with Google Desktop Search has worked well for me.

Tumblelogs with tumblr

Wednesday, April 25th, 2007

Tumblelogs are a good way to annotate and clip items from the Internet. Now, with a service called tumblr you can make a scrapbook like blog of interesting videos, photos, quotes, and links from your journeys around the web. Tumblr automatically pulls down your del.icio.us items and posts those, too, if you’d like to keep everything centralized. Check out the letterneversent tumblelog for an example.

Cool stuff you can do with Google Spreadsheets

Wednesday, April 25th, 2007

I’ve been using Google Docs for a while now. I love the concept of easy online document management and collaboration. I’ve tried to set up wiki-based solutions, content management systems, etc. for collaboration in the past, but Google Docs does exactly what I need it to do. It just works.

The only problem I’ve add is getting anyone else to use it. For some reason, no matter what I do, the people I work with find it too difficult to use. I’ll share a document with a coworker and they’ll never use it or open it. So, I’ve stuck to using it for tasks of my own or for people who work for me.

I use the word processing app, formerly known as Writely, from time to time, but I use Google Spreadsheets the most. I’m always finding new things I can do with it and since it’s online I can access it from any computer.

Here are some of the things I use it for:

  • Timesheets: I have a few freelancers I work with on a regular basis. It used to be that they would write down their hours over a few weeks and then submit an invoice at the end of the billing period. Now I just have them add their hours directly into a spreadsheet. It autoformats the various columns, calculates total hours and pay, and allows me to stay on top of our progress on various projects.
  • Asset logging: At work we often have to purchase equipment for our centers. I use Google Spreadsheets to keep track of all the various information related to company equipment: serial numbers, assignments, etc.
  • Invoice tracking: If you have invoices that need to be paid or invoices that you need to submit to your clients, an online spreadsheet is a good way to keep track of them. Just list the invoices with invoice numbers, amounts, and the date submitted and you’ll have an easier time following up on them.
  • Task / change requests: When you work on a project with other people you’ll often need to keep track of change requests or suggested revisions.

What kind of things do you do in spreadsheets?

My review of SimulScribe (voicemail transcription service)

Saturday, March 10th, 2007

voice mail transcriptionPrice: $9.99 per month for 40 messages. $.25 each additional message.

I hate listening to voice mail. It’s one of those things that you can’t really just take in at a ‘glance’ because speech is a linear way to deliver information. If you have an email you can speed up your reading by skipping over words or sentences to get a taste for what you’re reading. Luckily, there are now services to transcribe your voicemail and convert to email or text message. I’m trying one right now called SimulScribe.

Set up process

For SimulScribe, the set up is painless. You create an account then you receive an email with instructions based on your mobile provider for enabling selective call forwarding that forwards your calls to SimulScribe if you fail to answer the telephone. This works the exact same way your voicemail normally works. It’s simply rerouted to SimulScribe.

Using the service: Callers

On the caller’s end they receive your voicemail greeting after about six rings. SimulScribe includes a tagline for their service with instructions to speak slowly. The tagline can be removed in the account settings, however removing this tagline adds $.05 to each transcribed message. If I had few missed calls per month, I would probably remove this and pay the extra five cents.

Checking your voicemail

Each account has a voicemail number you can dial to listen to your voicemail as you normally would. On most phones, you can set up your voicemail speed dial key to use this new number, so that your process remains the same. As soon as a message is left, you can listen to it in your voicemail, even if the call has not yet been transcribed. You can also review a record of your voicemail messages at the SimulScribe website.

Receiving the call transcription

Once the call has been transcribed, you will receive a transcription message via SMS (text message) on your cell phone or by email on your mobile device or computer. The email transcript of the message will include an attached .wav file recording for review.

In two tests, I placed a call for 26 seconds and another call for 60 seconds, the limit for a voicemail message. For the 26 second message, the transcript was received within 5 minutes. For the 60 second message, the transcript was received within 15 minutes. This seems too long and the wait could be due to heavy usage, however this system was tested on the weekend, which is generally a slow time for call traffic. For important calls, I might end up calling voicemail, otherwise I’m fine with a delay of 5-10 minutes, especially considering how much quicker it is to read your voicemail than to actually listen to it.

Accuracy

In two tests, the transcription system was pretty accurate. It has trouble with acronyms and seldom used words, but the transcripts are more than enough to convey the meaning and content of the messages. SimulScribe also allows you to have the message re-transcribed by simply replying to the original transcript email.

In one of the tests, I read from the Gettysburg Address (Bliss copy version. Lincoln had several versions.):

Hi Chris,

Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.

Now we are engaged in a great civil war, testing whether that nation, or any nation so conceived and so dedicated, can long endure. We are met on a great battle-field of that war. We have come to dedicate a portion of that field, as a final resting place for those who here gave their lives that that nation might live. It is altogether fitting and proper that we should do this.

But, in a larger sense, we can not dedicate — we can not consecrate — we can not hallow — this ground. The brave men, living and dead, who struggled here, have consecrated it, far above our poor power to add or detract. The world will little note, nor long remember what we say here, but it can never forget what they did here. It is for us the living, rather, to be dedicated (Call ended with SimulScribe ‘Goodbye’ message)

This was the transcribed result:

Hi Chris. (phonetic ‘Four score’) and seven years ago. Our fathers is brought forth on this continent and (phonetic ‘new nation’) conceived in liberty and dedicated to the proposition that all men are created equal. Now we are engaged in a great civil war. Testing whether that nation or any nation so conceived and so dedicated can long endure. We are met on a great battle field of that war. We have come to dedicate a portion of that field as a final resting place for those who here, gave their lives,that that nation might live is altogether fitting a proper that we should do this. But in a larger sense, we cannot dedicate. We cannot concentrate. We cannot hollow this ground. The brave man, living in dead and struggled here have (phonetic ‘concentrated’) it. Far above our poor power to add or detract. The world will little note nor long remember what we say here, but I can’t what they did here. It is for us to living rather to be dedicated…

As someone who has a tendency to mumble over certain words and blend words together, the result is very good. Attached is a recording of my call.

Integration with home or office phone systems

To transcribe your home calls, contact your phone service provider and ask if “Call Forward No Answer” is available on your line. This feature is available on 80%-90% of landline phones in the US. If the feature is available, set up “Call Forward No Answer” to your SimulScribe number.

If your office phone system can send voicemail as an attached recording via email (approximately 50% of office phone systems have this feature including ours), have the email sent directly from the office phone system to “insert SimulScribe number”@my.simulscribe.com. SimulScribe will then transcribe the message and send it to the locations that you have specified in your user profile.

Conclusion

SimulScribe is very cool. If you hate voicemail, or have a lot of meetings at work where you can’t talk on the phone, it’s perfect. They have a free week trial if you want to test it out.

How to open .wav voicemail attachments on the Blackberry

Thursday, December 7th, 2006

My voice mail at work is set up so when I get a message it’s sent to my email as an attachment. When I get back to my desk I just play the file on my computer to hear the message. No need to navigate the voice mail system via the telephone. It’s easy.

The only problem with this is if I’m on my Blackberry I can’t just open the .wav file from the email and listen to the message, although I can open other attachments. Wav files just don’t work that way in Blackberry OS 4.1. The Blackberry 8800 will have this ability supposedly, but the 8700 does not. Since I’d much rather open the recorded file on the handheld than call my corporate voice mail, this is not fun.

Ironically, you can play .wav files from the web browser. So, we can use a workaround. If you want to be able to get your voice mail .wav files to play on the Blackberry do the following:

  1. Create an Outlook rule or email filter to automatically forward the email from your voice mail system to your Gmail account.
  2. Go into your Blackberry Browser options and set the Emulation to “Microsoft IE”. You have to do this to get the normal Gmail interface, otherwise Gmail will try to serve you the mobile version of Gmail.
  3. Now when you receive a voice mail notification on your Blackberry, open up the browser and log in to your web mail.
  4. Open the notification message and use the link to download the attachment. It should start playing in the media player as soon as it downloads completely.

Advertisement:

Face Voicemail challenges with the help of a professional Answering Service. Never miss a call again when you have the help of a Call Center Service. Keep your busy life organized with an Answering Service to field all of your calls.

Assassinating comment spam

Tuesday, May 23rd, 2006

After I logged in to discover 152 friendly (”Great site! Ci@lis!”) spam comments from Cialis and online poker sites, I had to move to a new solution for fighting comment spam. It seems the spammers circumvented my previous solution and implemented it into whatever scripts and tools they use to troll the vast blog geography. Luckily, due to the open source nature of Wordpress there were several available solutions for preventing automated comment spam through the use of ‘captcha‘ images. There was one Wordpress plugin, SecureImage, that stood out due to its simple drop-in functionality. You just throw the plugin into your Wordpress plugin directory and activate it. You must also have the ImageMagick module installed on your server, which is usually the case. If not, it’s an easy install. I had to make one change to the plugin script since it was not detecting the presence of ImageMagick’s convert utility. If you have the same problem, simply comment out the section where the script checks for the location of convert. To see the captcha script in action, try to leave a comment.