Category: Tools

  • I made a Keyword Multiplier

    While revamping a PPC advertising account last week, I discovered the lack of a convenient keyword multiplier. I am sure there is some fancy pants way of combining keyword lists in a spreadsheet application, but I find no fun in writing macros for some piece of software.

    I installed the Google Adwords desktop editor because it has a built-in keyword multiplier. It sucks. The Goo’s multiplier only combines three lists at a time, and I wanted four. It also automatically removes keywords that have low Google search volume, so if you are using their tool for any other purpose it is rather useless.

    I made my own keyword multiplier, and you can use it, too. Please try it out, and let me know if you find it to be a useful keyword tool.

    Keyword Multiplier Features

    • Fast, easy and web-based
    • Apply PPC match types to result lists
    • No uploading your keywords to a third party

    Try it yourself!

  • Calculate days receivable

    The amount of time that elapses between a sale and receipt of payment for that sale provides information about the financial structure of a company, including how the company manages its receivables. Calculating days receivable, or the average number of days sales are outstanding, is easy now with this calculator:

    Days Receivable Calculator

    Days receivable = = Accounts receivable balance
    Average day’s sales = = Net sales
    365


    Efficiency ratios can indicate how efficiently a business manages its assets. Days receivable is the collect-ability of accounts receivable, answering the question “how fast can cash supply be built?” with a number of days.

    Calculating this number of days receivable helps determine if a change in receivables is a result of a change in sales. Comparing days receivable with the company’s credit terms indicates how customers obey the terms of credit.

    About the tool

    I built this tool with Flash in 2007. I rewrote it in JavaScript in 2011 since Flash is now of questionable compatibility. The reset button restores all values to defaults, and the about button launches this web page. If you have trouble or suggestions please leave comments here.