Week 5:
Strategy, Earningmodels & Social
Media Planning (DS-4)
Lisanne Bosch
Date: September, 28, 2021
Made by: Lisanne Bosch
Date: September 21, 2021
,SEO revenue model assignment
The calculation model for SEO is drawn up on the basis of the 20 best keywords. These 20
keywords are the best as they score best on search volume, trends and competition.
The calculation model uses CTR, this CTR is based on research conducted by Optimus Online.
Based on this, a complete calculation model can be set up. Below is the top 10 click through
rate.
Position CTR
1 32,5%
2 17,6%
3 11,4%
4 8,1%
5 6,1%
6 4,4%
7 3,5%
8 3,1%
9 2,6%
10 2,4%
Tabel 1: Top 10 CTR (Optimus Online, 2020).
The calculation model now consists of the keywords and search volumes. The expected
positions are added to this. The position is determined on the basis of, among other things, the
Alexa score of the competitor. In addition, competition was considered when determining the
position. The quality of the websites is also taken into account.
The CTR number website is then added to the calculation model. This figure is calculated by
multiplying search volume by the CTR percentage.
Commission affiliate is then added to the calculation model. The commission affiliate is
calculated with the figures that can be found in Paul willems video about ROI analysis for
affiliate websites. The figures are:
Affiliate CTR Number: 12%
CR Affiliate: 6%
Average revenue: €50
Average Commission: 6%
Based on these figures, CTR number website is multiplied by all the above data. From this
follows the commission affiliate. This results in the following calculation model:
, Keywords Search volume Position CTR% Website CTR Number website Commision affiliate
Alexa voice 5000 5 6,1% 305 € 6,59 CTR number Affiliate: 12%
Alexa voice assistant 5000 3 11,4% 570 € 12,31 CR affiliate: 6%
Automated bathroom 50 6 4,4% 2,2 € 0,05 Average revenue: € 50,00
Bathroom speaker 5000 4 8,1% 405 € 8,75 Av. Commission: 6%
Bathroom tech 500 6 4,4% 22 € 0,48
Grohe smart rain 50 4 8,1% 4,05 € 0,09
Home automation 50000 3 11,4% 5700 € 123,12
Philips Hue light 50000 6 4,4% 2200 € 47,52
Shower speaker 50000 5 6,1% 3050 € 65,88
Smart bath taps 500 4 8,1% 40,5 € 0,87
Smart bathroom fan 500 6 4,4% 22 € 0,48
Smart bathroom faucet 500 5 6,1% 30,5 € 0,66
Smart bathroom gadgets 500 6 4,4% 22 € 0,48
Smart bathroom ideas 500 8 3,1% 15,5 € 0,33
Smart bathroom light 500 5 6,1% 30,5 € 0,66
Smart bathroom mirror 5000 4 8,1% 405 € 8,75
Smart bathtub 5000 3 11,4% 570 € 12,31
Smart home 500000 9 2,6% 13000 € 280,80
Smart shower head 5000 7 3,5% 175 € 3,78
Smart shower 5000 6 4,4% 220 € 4,75
26789 € 578,65
Tabel 2: Calculation model SEO
Based on the calculation model above, the following things can be established:
1. A number 1 position is impossible to achieve due to the large amount of competition.
2. An estimated number of visitors of 26,789. These are a lot of visitors, which is mainly
due to the popular search terms. However, there is also a lot of competition for this.
3. The commission affiliate comes in at €578.66,-.
SEA revenue model assignment
The following calculation model relates to Search Engine Advertising (SEA). The entire
calculation model is shown below.
First, the 20 best keywords are again displayed. Next, the tool is used: ''get search volume and
forecast'' within the keyword planner of Google. The following data is extracted from this tool:
Clicks, CPC and Costs. Based on this data, the transaction costs, revenues and then the ROI
can be calculated.
The calculation model below uses the same variables as in Paul willems video about ROI
analysis for affiliate websites.
CTR number Affiliate: 12%
CR affiliate: 6%
Average revenue: € 50,00
Av. Commission: 6%
Sum: Sum: Average:
€ 3.187,65 € 129,99 2%
Keywords Clicks CPC Costs Transactions Earnings ROI
Alexa voice 1,39 € 3,07 € 4,28 0 € - 0%
Alexa voice assistant 0 0 0 0 € - 0%
Automated bathroom 0 0 0 0 € - 0%
Bathroom speaker 110,55 € 2,80 € 310,00 1 € 2,388 1%
Bathroom tech 12,08 € 25,66 € 310,00 0 € - 0%
Grohe smart rain 0 0 0 0 € - 0%
Home automation 1674,46 € 0,19 € 310,00 12 € 36,168 12%
Philips Hue light 870 € 0,36 € 310,00 6 € 18,792 6%
Shower speaker 560 € 0,56 € 310,00 4 € 12,096 4%
Smart bath taps 0,06 € 1,82 € 0,12 0 € - 0%
Smart bathroom fan 29,8 € 1,95 € 57,96 0 € - 0%
Smart bathroom faucet 65,26 € 4,75 € 310,00 0 € - 0%
Smart bathroom gadgets 14,89 € 0,98 € 14,64 0 € - 0%
Smart bathroom ideas 0 0 0 0 € - 0%
Smart bathroom light 4,12 € 1,41 € 5,81 0 € - 0%
Smart bathroom mirror 163,61 € 1,89 € 310,00 1 € 3,534 1%
Smart bathtub 2,11 € 2,30 € 4,84 0 € - 0%
Smart home 2320,75 € 0,13 € 310,00 17 € 50,128 16%
Smart shower head 50,74 € 6,11 € 310,00 0 € - 0%
Smart shower 318,81 € 0,97 € 310,00 2 € 6,886 2%
Strategy, Earningmodels & Social
Media Planning (DS-4)
Lisanne Bosch
Date: September, 28, 2021
Made by: Lisanne Bosch
Date: September 21, 2021
,SEO revenue model assignment
The calculation model for SEO is drawn up on the basis of the 20 best keywords. These 20
keywords are the best as they score best on search volume, trends and competition.
The calculation model uses CTR, this CTR is based on research conducted by Optimus Online.
Based on this, a complete calculation model can be set up. Below is the top 10 click through
rate.
Position CTR
1 32,5%
2 17,6%
3 11,4%
4 8,1%
5 6,1%
6 4,4%
7 3,5%
8 3,1%
9 2,6%
10 2,4%
Tabel 1: Top 10 CTR (Optimus Online, 2020).
The calculation model now consists of the keywords and search volumes. The expected
positions are added to this. The position is determined on the basis of, among other things, the
Alexa score of the competitor. In addition, competition was considered when determining the
position. The quality of the websites is also taken into account.
The CTR number website is then added to the calculation model. This figure is calculated by
multiplying search volume by the CTR percentage.
Commission affiliate is then added to the calculation model. The commission affiliate is
calculated with the figures that can be found in Paul willems video about ROI analysis for
affiliate websites. The figures are:
Affiliate CTR Number: 12%
CR Affiliate: 6%
Average revenue: €50
Average Commission: 6%
Based on these figures, CTR number website is multiplied by all the above data. From this
follows the commission affiliate. This results in the following calculation model:
, Keywords Search volume Position CTR% Website CTR Number website Commision affiliate
Alexa voice 5000 5 6,1% 305 € 6,59 CTR number Affiliate: 12%
Alexa voice assistant 5000 3 11,4% 570 € 12,31 CR affiliate: 6%
Automated bathroom 50 6 4,4% 2,2 € 0,05 Average revenue: € 50,00
Bathroom speaker 5000 4 8,1% 405 € 8,75 Av. Commission: 6%
Bathroom tech 500 6 4,4% 22 € 0,48
Grohe smart rain 50 4 8,1% 4,05 € 0,09
Home automation 50000 3 11,4% 5700 € 123,12
Philips Hue light 50000 6 4,4% 2200 € 47,52
Shower speaker 50000 5 6,1% 3050 € 65,88
Smart bath taps 500 4 8,1% 40,5 € 0,87
Smart bathroom fan 500 6 4,4% 22 € 0,48
Smart bathroom faucet 500 5 6,1% 30,5 € 0,66
Smart bathroom gadgets 500 6 4,4% 22 € 0,48
Smart bathroom ideas 500 8 3,1% 15,5 € 0,33
Smart bathroom light 500 5 6,1% 30,5 € 0,66
Smart bathroom mirror 5000 4 8,1% 405 € 8,75
Smart bathtub 5000 3 11,4% 570 € 12,31
Smart home 500000 9 2,6% 13000 € 280,80
Smart shower head 5000 7 3,5% 175 € 3,78
Smart shower 5000 6 4,4% 220 € 4,75
26789 € 578,65
Tabel 2: Calculation model SEO
Based on the calculation model above, the following things can be established:
1. A number 1 position is impossible to achieve due to the large amount of competition.
2. An estimated number of visitors of 26,789. These are a lot of visitors, which is mainly
due to the popular search terms. However, there is also a lot of competition for this.
3. The commission affiliate comes in at €578.66,-.
SEA revenue model assignment
The following calculation model relates to Search Engine Advertising (SEA). The entire
calculation model is shown below.
First, the 20 best keywords are again displayed. Next, the tool is used: ''get search volume and
forecast'' within the keyword planner of Google. The following data is extracted from this tool:
Clicks, CPC and Costs. Based on this data, the transaction costs, revenues and then the ROI
can be calculated.
The calculation model below uses the same variables as in Paul willems video about ROI
analysis for affiliate websites.
CTR number Affiliate: 12%
CR affiliate: 6%
Average revenue: € 50,00
Av. Commission: 6%
Sum: Sum: Average:
€ 3.187,65 € 129,99 2%
Keywords Clicks CPC Costs Transactions Earnings ROI
Alexa voice 1,39 € 3,07 € 4,28 0 € - 0%
Alexa voice assistant 0 0 0 0 € - 0%
Automated bathroom 0 0 0 0 € - 0%
Bathroom speaker 110,55 € 2,80 € 310,00 1 € 2,388 1%
Bathroom tech 12,08 € 25,66 € 310,00 0 € - 0%
Grohe smart rain 0 0 0 0 € - 0%
Home automation 1674,46 € 0,19 € 310,00 12 € 36,168 12%
Philips Hue light 870 € 0,36 € 310,00 6 € 18,792 6%
Shower speaker 560 € 0,56 € 310,00 4 € 12,096 4%
Smart bath taps 0,06 € 1,82 € 0,12 0 € - 0%
Smart bathroom fan 29,8 € 1,95 € 57,96 0 € - 0%
Smart bathroom faucet 65,26 € 4,75 € 310,00 0 € - 0%
Smart bathroom gadgets 14,89 € 0,98 € 14,64 0 € - 0%
Smart bathroom ideas 0 0 0 0 € - 0%
Smart bathroom light 4,12 € 1,41 € 5,81 0 € - 0%
Smart bathroom mirror 163,61 € 1,89 € 310,00 1 € 3,534 1%
Smart bathtub 2,11 € 2,30 € 4,84 0 € - 0%
Smart home 2320,75 € 0,13 € 310,00 17 € 50,128 16%
Smart shower head 50,74 € 6,11 € 310,00 0 € - 0%
Smart shower 318,81 € 0,97 € 310,00 2 € 6,886 2%
