Sheet1 - SEOmoz

Document Sample
Sheet1 - SEOmoz Powered By Docstoc
					          Term/Phrase               KW Discovery # OVSrch # WTSrch # Average count
                                             56767   372990     4032   144596.3333
                                             70988    70988      215          47397
                                             57865    57865      361          38697
                                              1148     1148       35            777
                                             41437    41437      170   27681.33333
                                              3760     3760      123   2547.666667
                                             46551    46551      921          31341
                                             14631    14631       24           9762
                                             13276    13276      169           8907
                                             14370    14370       73   9604.333333
                                              8864     8864      401           6043
                                              8155     8155      125   5478.333333
                                              7952     7952       36   5313.333333
                                              3057     3057      167   2093.666667
                                               702      702       26   476.6666667
                                              4010     4010      129   2716.333333
                                               107      107       45   86.33333333
                                               332      332       47            237
                                               430      430       36   298.6666667
                                               477      477       33            329
                                              3038     3038      427   2167.666667
                                              3635     3635      445   2571.666667
                                              9496     9496      203   6398.333333
                                              6077     6077      177   4110.333333
                                              3330     3330      217   2292.333333
                                              5583     5583      213           3793
                                              7943     7943      269           5385
                                              3949     3949      251   2716.333333
                                              1994     1994      106   1364.666667
                                              4238     4238      148   2874.666667
                                              1550     1550       74           1058
                                              2532     2532      222           1762
                                             22634    22634      336   15201.33333

Total / Day
Total / Month

           Assumptions                                  Values
% of traffic clicking on 1st result                         15%
Standard Site Conversion Rate                             1.50%
Average Revenue per Conversion                           $10.00
Numbers are for site in 1st position for keywords
All numbers are rough estimates

KW Discovery # - Number of Searches for Term at KeywordDiscovery (take the estimated search number in the “Analyze” por
OVSrch # - Number of Searches for Term at Overture
WTSrch # - Number of Predicted Searches for Term at Wordtracker (using the Compressed Search feature), multipled by the
Average Count – the Average Count of KeywordDiscovery, Overture, and Wordtracker's search counts
Adwords Estimator – Adwords Traffic Estimator's Estimated Clicks per Day
KW Dif - Keyword Difficulty Score from SEOmoz Tool (not figured into calculations, but useful to predict time until position #1 a
Rel. % - Your Personal Estimation of the Relevance of a Particular Keyword Phrase to your Site (used in calculating conversion
Daily Vis. Pos. 1 - A Measure of the Number of Visitors you will get by being in Position #1 at Yahoo!, MSN & Google
Cnv. % - The Conversion Rate for a Particular Term
# Cnv. - The Number of Conversions for a Term
Avg. Rev. / Cnv. - The Average Revenue Earned Per Conversion for this Term (can be tweaked if terms can be tied to produc
Total Rev. - The Total Daily Revenue you Should Expect for this Term
               Adwords Estimator # KW Dif Rel. % Daily Vis. Pos. 1 Cnv. % # Cnv. Avg. Rev. / Cnv.             Total Rev.
                                15          50%               1205 0.75%    9.04          $10.00              $   90.36
                                 2          40%                188 0.60%    1.13          $10.00              $   11.27
                                 4          35%                167 0.53%    0.88          $10.00              $     8.77
                                 7         100%                  5 1.50%    0.08          $10.00              $     0.81
                                22         100%                113 1.50%    1.70          $10.00              $   16.95
                                 8         100%                 18 1.50%    0.27          $10.00              $     2.75
                                 3          50%                182 0.75%    1.36          $10.00              $   13.63
                                 9          50%                 37 0.75%    0.28          $10.00              $     2.79
                                12          40%                 45 0.60%    0.27          $10.00              $     2.69
                                 5          40%                 40 0.60%    0.24          $10.00              $     2.41
                                 7          35%                 52 0.53%    0.27          $10.00              $     2.70
                                11          30%                 29 0.45%    0.13          $10.00              $     1.31
                                 8          35%                 22 0.53%    0.12          $10.00              $     1.15
                                19          90%                 20 1.35%    0.27          $10.00              $     2.69
                                13         100%                  4 1.50%    0.05          $10.00              $     0.55
                                 8          90%                 19 1.35%    0.26          $10.00              $     2.62
                                 4          90%                  4 1.35%    0.05          $10.00              $     0.49
                                 6          90%                  4 1.35%    0.06          $10.00              $     0.58
                                 2         100%                  4 1.50%    0.06          $10.00              $     0.56
                                16          85%                  4 1.28%    0.05          $10.00              $     0.46
                                 4          65%                 39 0.98%    0.38          $10.00              $     3.84
                                 2          90%                 42 1.35%    0.57          $10.00              $     5.69
                                12          30%                 38 0.45%    0.17          $10.00              $     1.72
                                15          35%                 28 0.53%    0.15          $10.00              $     1.47
                                 7          45%                 24 0.68%    0.16          $10.00              $     1.64
                                 2          45%                 29 0.68%    0.20          $10.00              $     1.99
                                 8          45%                 39 0.68%    0.27          $10.00              $     2.66
                                 6          45%                 28 0.68%    0.19          $10.00              $     1.92
                                14          45%                 13 0.68%    0.09          $10.00              $     0.86
                                12          45%                 21 0.68%    0.14          $10.00              $     1.44
                                18          50%                  9 0.75%    0.07          $10.00              $     0.70
                                 6          70%                 23 1.05%    0.24          $10.00              $     2.39
                                 4          45%                 80 0.68%    0.54          $10.00              $     5.40

                                                                    2577            19.73                     $ 197.27
                                                                   77301           591.80                     $ 5,917.95




timated search number in the “Analyze” portion of the report, and multiply this number by the number of days in whatever month Overture is

mpressed Search feature), multipled by the number of days in whatever month Overture is reporting data for
cker's search counts

 but useful to predict time until position #1 achieved)
 to your Site (used in calculating conversion rate)
ition #1 at Yahoo!, MSN & Google


n be tweaked if terms can be tied to product prices)
whatever month Overture is reporting data for (e.g. February would be x 28; September x 30, August x 31)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:8/10/2011
language:English
pages:5