Information Technology Reference
In-Depth Information
•
n
egative keywords that have nothing to do with your business
j
• igsaw puzzles of guardsmen at buckingham palace
s
• kil logo
n
•
ew geographic targeting opportunities
p
• lastering tool stores in liverpool
o
• ffers makita power tools nottingham
m
• akita balta planer wood abbey uk
this list is by no means complete but just serves to tell you that something as
simple and nontechnical as skimming a list will create value for you.
next, let's create a scatter plot of our data to get a visual presentation of the
data distribution, essentially confirming that it does indeed follow the long tail. Follow
these steps:
1.
mark your search phrase and visits columns (in our example, that means all
8,834 rows). do not include the header or the total at the bottom, but only the
raw data itself.
329
2.
insert a scatter chart in excel (or another spreadsheet), based on the data
selected, which should result in a long tail graph (see Figure 13.4).
Search Phrase
Figure 13.4
Search phrases scatter plot
