I decided to create a quick and easy Pay-per-click calculator.  By experimenting with different variables, you’ll be able to see the range of possible outcomes.  There are several variables you’ll need to input:

Cost per click – this allows you to see different profitibility scenarios based on average CPC.

Total Clicks – adjust this, along with your CPC, and you’ll see a monthly spend.  I need to recreate this spreadsheet with Budget as the input, automatically showing clicks, as another way to use the sheet.

Percentage of Users Buy – Here is another place you’ll just need to make assumptions.

Average Total Purchase Amount – how much does the average user spend on this website.

See the attached Excel spreadsheet:  Pay-per-click estimation worksheet

This entry was posted on Thursday, May 29th, 2008 at 8:40 pm and is filed under Pay-Per-Click, PPC Management Related. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.