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