Calculator - How to Estimate SEO ROI From Content Marketing
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABC
1
To customize this spreadsheet, go to File > Make a copy
2
**ONLY EDIT THE NUMBERS IN RED**
3
GOALS
4
How many Linking Root Domains (LRDs) are needed to match your closest competitor? Use MozBar to find this metric; see example image at this URL: www.siegemedia.com/image/roi-mozbar [Chapter 3, page 15]4,739
5
How many LRDs do you generate per piece of content on average? This could include blog posts, eBooks, tools, guides, webinars, etc. [Chapter 3, page 16]4For detailed instructions how to use this calculator, download the guide at:
6
How many pieces of content do you create per month on average? [Chapter 3, page 16]8http://siegemedia.com/roi
7
Number of LRDs per month (from content marketing)32
8
How many LRDs per month do you get for all other reasons? This could include links to product pages, homepage links for TV ad you ran, traditional link building, etc. [Chapter 3, page 16]10
9
Combined Number of LRDs per month42
10
What is your estimated link attrition rate (percentage of links you lose over time)? [Chapter 3, page 17]5%
11
Adjusted LRDs Per Month =40
12
Number of Months to Reach LRD Goal =119
13
Number of Years to Reach LRD Goal =9.9
14
15
EXPENSES
16
What are your content marketing expenses each month? (ex. content research, creation and promotion) [Chp. 4, page 21]$12,500
17
What are your SEO expenses each month? (ex. traditional link building, on-page website improvements for organic search, etc) [Chp. 4, page 22]$21,664
18
Average Total Monthly Expenses$34,164
19
*Optional* If you’re creating a new web business, how much will the first, fully-completed version of your website cost?
This should include research, idea validation, prototyping, UX, design and development. [Chp. 4, page 23]
$300,000
20
Cost Per LRD = $856
21
22
REVENUE
23
What is your target traffic value, as based on SEMRush's "Traffic Cost" metric? Use SEMRush to find this metric; see example image at this URL: www.siegemedia.com/image/roi-semrush. [Chp. 5, page 27]$968,000
24
Number of months it would take to reach target goal of LRDs (assuming no revenue for first 12 months).113
25
Average Traffic Value Increase Per Month$8,584
26
27
BREAKEVEN
28
Months until monthly revenue exceeds monthly expenses 10
29
Years until monthly revenue exceeds monthly expenses 0.8
30
Months until total revenue exceeds total expenses 21
31
Years until total revenue exceeds total expenses 1.8
32
Loading...
 
 
 
Insert Your Numbers on This Sheet
Profit and ROI Timeline