To understand the impact SEO has on your gross revenue,
I created an excel that tracks all of the KPIs you should evaluate throughout the course of a 5 month SEO campaign. You can download the excel file by clicking the image below. Adjust it to match the timeframe of your SEO campaign.
How does this excel help you?
This excel shows non-marketers in your company how SEO is responsible for the marketing department’s decrease in CAC (cost of customer acquisition) and increase in user retention.
If you are just starting out with SEO, fill in the column all the way to the right instead of the current column.
The goal of this excel is to help you (as the founder of your first startup) or VPs & other decision makers, quickly review how SEO is helping make you money every month.
If you are the SEO in a large company, VPs & non-marketing decision makers rarely understand exactly what you do & why it should matter. I’ve found that tying these numbers ($ or %) to the amount of traffic coming in from SEO campaigns often leads the VPs to realize you are a revenue generating machine.
When you send this to the VPs they’re able to quickly see that SEO is a long-game and you plan to show them monthly improvements in a language they understand (dollar symbols in excel).
If you would like to download this excel click anywhere on the image below:
If you were wondering where I find the data to fill in this excel, the answer is:
My Favorite SEO Tools
Easy tools that anyone can learn to use easily:
- 24-7 Press Release makes it incredibly easy to distribute your story to multiple news outlets via their platform. This is great for White Hat link building.
- I base the majority of my SEO strategies off of the data I find in SpyFu
- HotJar provides some of the easiest to read & understand user analysis based on your web traffic
Tools that my non-tech friends tend to hate:
- Screaming Frog SEO Spider
This post was brought to you by Adi Soozin of MD9.co. If you enjoyed this post and would like to see more like this, consider using the affiliate links we include in these posts. They allow us to occasionally earn a commission if you decide to make a purchase. This is at no extra cost to you and it supports this website, as well as the composition of future posts, which means we can spend more time writing content. I genuinely recommend everything linked to via this website.
That’s all for now. To stay up to date with my latest posts & guides, follow me on LinkedIn or join the email list via the chatbot in the bottom right corner.