I built a Google sheets template that will automatically workout the clicks, sales, and revenue opportunity for each keyword you put in. All you have to do is add the keywords. Cool, right?
But wait, have you ever had this problem?
If you’re working for a new company or have a new client, you’ll probably be doing some opportunity forecasting for them. But when you’re looking for keywords, do you assume that the maximum available clicks is based on you ranking in position 1…even if you’re never likely to rank in position 1?
Yeah, it’s not the best solution, but no one’s got time to go through each keyword and check and workout what’s a “realistic” ranking for you, right?
Fear not friend, that’s where this method and template comes in. In this breakdown we will:
1️⃣ Automatically calculate your total and incremental opportunity available to you per keyword
2️⃣ Base that opportunity off where it’s likely you could rank, and do those checks automatically
3️⃣ Organise it in a cute little pivot table that you can use to wow your colleagues, amaze your clients, and confuse your neighbours
And here’s the template.