Google WebMaster report about EduTechWiki April 2011
Last night I submited a little last-minute piece about EduTechWiki to EdMedia 2011 and finished a more difficult design/research piece as co-author that we started writing well before. The submitted article on Mediawikis aks the very simple question how MediaWikis should be configured for educational and other academic purposes. But today I thought that I might have a look at data that show how EduTechWiki is seen by the Google search engine. I'll probably write another post about Google's Analytics view.
EduTechWiki pages get undeserved high search page rankings. Of the 623 pages included in the statistics, the average is 7.4. I mean, I am proud enough about the beast as a whole but I am talking about individual pages here....
Method:
- I downloaded the .cvs files from Google webmaster tools
- I declared all values marked "<10" as missing.
- Period: March 11-April 10 2010 (unfortunately the free version only allows to get statistcs for the last month)
The following histogram shows a skewed distribution. Median of a typical position in a search page is 6.2.
Read on for some more details ...
Click through (CTR) is what I would call "normal", i.e. typically one out of five person will actually click on the link.
Looking further, I wondered whether one could identify emerging clusters looking at three variables only:
- Average position: ... in Google search pages that show a page.
- Impressions: how many times the page was viewed
- Click-though rate (CTR): how many times in % a person click on the link when it showed on the search page
Then, since some pages may never show up, I looked the other way round. What kind of queries are popular and lead to one of our pages. Clusters don't relate to page contents as far as I can tell from having a look at the raw data. But it's interesting to see that less popular subjects get a better click-through rate. Now so-called web site reference specialists will start spamming low profile pages. Actually my really big pleasure from these data is that I beat these guys without even doing anything to show up high in google searches. I do hate most of these reference people, since they pay people to manually spam my wikis and since they pollute the web with fake web sites. Look, it's simple: If you want to get high search rankings, produce two things: (1) relevant contents or good products and services, then (2) wait some month. If you sell socks for example, please write a really good tutorial on various socks. It's that simple.
Notes about the clustering technique:
- I used the SPSS 19 two-step cluster method with likelihood distances. I set cluster number to five because I like it "by five". Otherwise, I could have gotten a better model fit :)
- Also, the last figure has a conceptual mistake I am too lazy to fix. The example search queries I added in the description don't represent cluster centers. I just grabbed the first ones I have seen near the top of the SPSS data file.
Here are the top 50 search queries. Number 1 "Madeline Hunter" is irrelevant, since there are several of these :)
Query | Impressions | Change | Clicks | Change | CTR | Change | Avg. position | Change | |
madeline hunter | 4500.00 | 0.80 | 200.00 | 0.82 | 0.04 | 8.30 | 0.90 | ||
desktop virtual reality | 3000.00 | 6.50 | 1000.00 | 5.67 | 0.33 | -4.00 | 1.30 | -0.30 | |
tweenlite | 2500.00 | 7.30 | 0.40 | ||||||
theory of reasoned action | 2000.00 | -0.33 | 90.00 | 0.50 | 0.04 | 3.00 | 9.70 | 1.00 | |
uml wiki | 2000.00 | 2.33 | 22.00 | 0.01 | 1.00 | 7.80 | 1.00 | ||
immersive virtual reality | 1600.00 | 8.41 | 200.00 | 8.09 | 0.12 | -0.40 | 7.20 | 0.30 | |
concept map maker | 1300.00 | 0.30 | 70.00 | 1.00 | 0.05 | 2.00 | 5.40 | 2.00 | |
flow theory | 1000.00 | -0.23 | 90.00 | 0.09 | 2.00 | 4.70 | |||
incidental learning | 900.00 | 0.29 | 250.00 | 0.25 | 0.28 | -0.80 | 1.10 | ||
self efficacy theory | 900.00 | -0.10 | 170.00 | 0.19 | 2.00 | 4.30 | 0.40 | ||
xpath tutorial | 900.00 | 2.60 | 50.00 | 1.27 | 0.06 | -3.00 | 7.90 | 3.00 | |
ims wiki | 900.00 | 0.50 | 5.70 | 0.20 | |||||
backwards design | 700.00 | -0.22 | 250.00 | -0.22 | 0.36 | 0.20 | 1.10 | ||
gagne's nine events of instruction | 700.00 | -0.22 | 150.00 | 0.36 | 0.21 | 9.00 | 3.70 | 0.60 | |
guided discovery | 700.00 | 0.17 | 110.00 | 0.22 | 0.16 | 0.70 | 2.30 | 0.80 | |
dtd tutorial | 700.00 | 22.00 | 0.37 | 0.03 | 0.90 | 8.30 | |||
ple | 700.00 | 16.00 | -0.27 | 0.02 | -0.90 | 7.70 | 0.50 | ||
3ds wiki | 700.00 | -0.46 | 9.10 | -0.40 | |||||
xslt tutorial | 600.00 | 4.45 | 50.00 | 0.67 | 0.08 | -20.00 | 8.90 | 2.00 | |
nintendo wii wikipedia | 600.00 | 7.50 | |||||||
learner autonomy | 500.00 | 1.00 | 12.00 | 0.02 | 2.00 | 10.00 | 1.00 | ||
world wide web wiki | 500.00 | 0.56 | 6.90 | 0.50 | |||||
dublin wiki | 500.00 | -0.29 | 9.20 | -0.50 | |||||
wiki uml | 500.00 | 0.56 | 7.90 | 1.00 | |||||
desktop virtual reality websites | 400.00 | 70.00 | 0.18 | 20.00 | 2.50 | ||||
self-efficacy theory | 400.00 | -0.20 | 60.00 | -0.33 | 0.15 | -3.00 | 4.40 | 0.60 | |
flash presentation tutorial | 400.00 | -0.20 | 50.00 | -0.29 | 0.12 | -2.00 | 5.10 | -0.80 | |
computer mediated communication | 400.00 | -0.33 | 35.00 | 0.59 | 0.09 | 5.00 | 10.00 | ||
instructional design models | 400.00 | -0.33 | 30.00 | -0.14 | 0.08 | 2.00 | 7.00 | 2.00 | |
backward design | 400.00 | 0.25 | 22.00 | 0.06 | -1.00 | 8.00 | -2.00 | ||
advance organizers | 400.00 | 2.64 | 16.00 | 0.04 | 4.00 | 9.40 | -2.00 | ||
kepler wiki | 400.00 | 4.71 | 8.40 | 2.00 | |||||
human information processing | 320.00 | 150.00 | 0.36 | 0.47 | 10.00 | 2.00 | |||
task environment | 320.00 | -0.47 | 70.00 | 0.17 | 0.22 | 10.00 | 4.70 | 1.00 | |
pedagogical strategies | 320.00 | 0.60 | 35.00 | 1.19 | 0.11 | 3.00 | 4.80 | 3.00 | |
cognitive strategies | 320.00 | 0.60 | 30.00 | 0.36 | 0.09 | -2.00 | 7.50 | 0.50 | |
cognitive flexibility | 320.00 | -0.36 | 30.00 | 0.09 | 3.00 | 3.40 | 0.30 | ||
openscad | 320.00 | 0.88 | 22.00 | 0.83 | 0.07 | -0.20 | 8.20 | 1.00 | |
advance organizer | 320.00 | 0.60 | 22.00 | 0.07 | 7.00 | 6.10 | 0.80 | ||
graphviz tutorial | 320.00 | -0.20 | 22.00 | 0.07 | 1.00 | 8.30 | -1.00 | ||
atkins and murphy's model of reflection 1994 | 320.00 | 0.28 | 16.00 | 0.33 | 0.05 | 0.20 | 5.40 | 0.80 | |
autonomy wiki | 320.00 | 0.28 | 5.70 | 1.00 | |||||
as3 textfield | 320.00 | 8.60 | 0.20 | ||||||
ims content package | 320.00 | 0.28 | 8.50 | ||||||
tween lite | 320.00 | -0.20 | 6.90 | -0.10 | |||||
backward design model | 320.00 | 0.28 | -1.00 | -5.00 | 7.70 | 2.00 | |||
levels of learning | 250.00 | -0.38 | 50.00 | 0.67 | 0.20 | 10.00 | 3.40 | 2.00 | |
cognitive load | 250.00 | -0.22 | 22.00 | 0.09 | 2.00 | 4.80 | -0.20 | ||
zone of proximal development definition | 250.00 | 2.57 | 22.00 | 0.09 | 9.00 | 5.90 | 0.30 | ||
rapman | 250.00 | 3.17 | 16.00 | 0.06 | 6.00 | 9.90 | -0.60 | ||
anchored instruction | 250.00 | 2.57 | 12.00 | 0.05 | 5.00 | 10.00 | 0.50 | ||
flash keyboard | 250.00 | 2.57 | 12.00 | 0.05 | 5.00 | 5.60 | 3.00 | ||
flash shape tween | 250.00 | 1.27 | 9.60 | -0.20 | |||||
tweenlite oncomplete | 250.00 | -0.22 | 7.50 | -0.30 | |||||
webtop | 250.00 | 0.25 | 18.00 | 2.00 | |||||
guided discovery learning | 200.00 | 90.00 | 0.29 | 0.45 | 10.00 | 2.80 | 0.10 | ||
as3 drag and drop | 200.00 | 90.00 | 0.45 | 2.20 | 1.00 | ||||
joomla configuration.php | 200.00 | -0.38 | 70.00 | -0.22 | 0.35 | 7.00 | 5.60 | ||
curriculum planning | 200.00 | 60.00 | 0.30 | 6.10 | -0.70 | ||||
instructional design model | 200.00 | 0.18 | 60.00 | 0.71 | 0.30 | 9.00 | 3.20 | 0.30 | |
who is recommended to use desktop virtual reality | 200.00 | 60.00 | 0.30 | 30.00 | 2.40 | ||||
cognitive flexibility definition | 200.00 | 50.00 | 0.43 | 0.25 | 8.00 | 2.60 | 0.70 | ||
programmed instruction | 200.00 | -0.50 | 50.00 | -0.17 | 0.25 | 10.00 | 3.60 | -0.20 | |
engagement theory | 200.00 | 50.00 | -0.17 | 0.25 | -5.00 | 3.70 | |||
flash button tutorial | 200.00 | -0.38 | 50.00 | 0.43 | 0.25 | 10.00 | 6.80 | 0.70 | |
desktop virtual reality url | 200.00 | 50.00 | 0.25 | 30.00 | 1.90 | ||||
social cognitive theory definition | 200.00 | 35.00 | 0.18 | 5.70 | -0.40 | ||||
mastery learning | 200.00 | 0.18 | 35.00 | 0.18 | -3.00 | 8.70 | -2.00 | ||
kemp model | 200.00 | 1.22 | 30.00 | 0.15 | -20.00 | 1.10 | |||
scaffolding psychology | 200.00 | -0.20 | 22.00 | -0.27 | 0.11 | -1.00 | 3.30 | ||
svg | 200.00 | 2.33 | 19.00 | -9.00 | |||||
reflection wiki | 200.00 | 0.33 | 7.70 | 0.10 | |||||
ims cp | 200.00 | 5.67 | 8.50 | -2.00 | |||||
uml class diagram | 200.00 | 1.22 | 22.00 | 2.00 | |||||
dhtml wiki | 200.00 | 4.90 | |||||||
dtd wiki | 200.00 | 0.18 | 5.30 | 1.00 | |||||
concept learning | 170.00 | 50.00 | 0.29 | 2.30 | |||||
theory u | 170.00 | -0.32 | 35.00 | -0.30 | 0.21 | 0.60 | 8.50 | 0.40 | |
cognitive constructivism | 170.00 | 22.00 | 0.13 | 6.40 | 3.00 | ||||
under construction template | 170.00 | 3.86 | 22.00 | 0.13 | 10.00 | 13.00 | 5.00 | ||
history of networking | 170.00 | -0.47 | 16.00 | -0.27 | 0.09 | 3.00 | 7.80 | 2.00 | |
models of reflection | 170.00 | 0.89 | 12.00 | 0.07 | 7.00 | 9.70 | -1.00 | ||
teleteaching | 170.00 | 1.83 | 5.10 | -0.70 | |||||
class diagram wiki | 170.00 | 0.55 | 4.80 | -0.20 | |||||
johns model of reflection | 170.00 | 0.89 | 9.00 | 2.00 | |||||
objectivism wiki | 170.00 | 0.13 | 8.40 | -1.00 | |||||
as3 docs | 170.00 | 0.55 | 8.90 | ||||||
as3 event listener | 150.00 | 90.00 | 0.29 | 0.60 | 10.00 | 1.00 | |||
actionscript 3 button tutorial | 150.00 | 0.67 | 60.00 | 0.40 | -30.00 | 1.70 | -0.20 | ||
meshlab tutorial | 150.00 | -0.12 | 50.00 | 0.33 | 4.00 | 3.50 | 4.00 | ||
flash shortcuts | 150.00 | 0.36 | 50.00 | 0.43 | 0.33 | 2.00 | 2.40 | 0.20 | |
cognitive strategy instruction | 150.00 | -0.12 | 50.00 | 0.43 | 0.33 | 10.00 | 4.30 | 2.00 | |
professional identity | 150.00 | 0.67 | 35.00 | 0.59 | 0.23 | -1.00 | 4.80 | 3.00 | |
bpmn tutorial | 150.00 | -0.25 | 30.00 | -0.14 | 0.20 | 3.00 | 7.70 | 5.00 | |
uml activity diagram | 150.00 | 2.00 | 30.00 | 0.36 | 0.20 | -20.00 | 11.00 | -1.00 | |
technology acceptance model | 150.00 | 0.36 | 30.00 | 0.36 | 0.20 | 9.10 | 1.00 | ||
radical constructivism | 150.00 | -0.12 | 22.00 | -0.27 | 0.15 | -3.00 | 6.20 | ||
madeline hunter model | 150.00 | -0.12 | 22.00 | 0.15 | 2.00 | 6.00 | 2.00 | ||
advanced organizer | 150.00 | -0.12 | 16.00 | -0.27 | 0.11 | -2.00 | 4.50 | 0.70 | |
bandura's self efficacy theory | 150.00 | 5.82 | 16.00 | 0.11 | 10.00 | 5.10 | 7.00 | ||
johns model of reflection 2004 | 150.00 | 0.36 | 12.00 | 0.08 | 8.00 | 3.70 | |||
android os wiki | 150.00 | -0.70 | 12.00 | -0.25 | 0.08 | 5.00 | 3.60 | 1.00 | |
uml diagrams wiki | 150.00 | 1.14 | 5.50 | 0.50 | |||||
johns model of reflection 1994 | 150.00 | 11.50 | 10.00 | -2.00 | |||||
conference management software | 150.00 | 0.36 | 24.00 | 20.00 | |||||
graphviz | 150.00 | 0.36 | 11.00 | 7.00 | |||||
class diagram | 150.00 | 0.67 | 29.00 | 10.00 | |||||
rolfe et al 2001 | 150.00 | 1.14 | 6.70 | 0.50 | |||||
wiki ims | 150.00 | 0.67 | 5.30 | 1.00 | |||||
dan schneider wiki | 150.00 | 0.67 | 7.00 | 0.50 | |||||
what is webtop | 150.00 | 7.50 | |||||||
cbt wiki | 150.00 | 1.50 | 6.50 | -0.40 | |||||
teaching styles list | 110.00 | 60.00 | 0.55 | 50.00 | 1.10 | ||||
teacher empowerment | 110.00 | -0.45 | 50.00 | -0.17 | 0.45 | 20.00 | 2.60 | 0.10 | |
exploratory learning | 110.00 | -0.27 | 50.00 | 0.45 | 10.00 | 2.20 | 0.30 | ||
cognitive flexibility theory | 110.00 | -0.27 | 35.00 | 0.17 | 0.32 | 10.00 | 3.30 | 0.50 | |
personal learning environment | 110.00 | -0.35 | 35.00 | -0.30 | 0.32 | 2.00 | 4.40 | 0.20 | |
flash button | 110.00 | -0.27 | 30.00 | 0.36 | 0.27 | 10.00 | 12.00 | 3.00 | |
5e learning cycle | 110.00 | 0.83 | 30.00 | 1.50 | 0.27 | 7.00 | 3.40 | 2.00 | |
experience sampling method | 110.00 | 0.57 | 22.00 | 0.20 | -10.00 | 3.30 | |||
backwards by design | 110.00 | 16.00 | 0.15 | 10.00 | 5.20 | 1.00 | |||
social constructivist theory | 110.00 | 12.00 | 0.11 | 10.00 | 6.70 | 2.00 | |||
theory of planned behaviour | 110.00 | 2.67 | 12.00 | 0.11 | 10.00 | 13.00 | -2.00 | ||
telepresence virtual reality | 110.00 | 12.00 | 0.11 | 10.00 | 2.50 | ||||
flash motion tween | 110.00 | 9.80 | |||||||
textfield as3 | 110.00 | 0.57 | 9.00 | 1.00 | |||||
webtop application | 110.00 | 4.00 | 6.60 | 4.00 | |||||
video disk | 110.00 | 8.00 | -0.60 | ||||||
kepler workflow | 110.00 | 0.22 | 8.70 | -0.40 | |||||
x3d | 110.00 | 8.17 | 10.00 | 20.00 | |||||
storytelling wiki | 110.00 | 0.83 | 8.50 | ||||||
theory of flow | 110.00 | 6.20 | 0.30 | ||||||
wiki xsd | 110.00 | 8.30 | -1.00 | ||||||
elgg wiki | 110.00 | 8.40 | -0.40 | ||||||
backward | 110.00 | 2.67 | 14.00 | 9.00 | |||||
tweenlite as3 | 110.00 | 7.40 | 0.50 | ||||||
openscad tutorial | 90.00 | 70.00 | 0.78 | 1.10 | |||||
as3 button | 90.00 | -0.18 | 50.00 | 0.56 | 10.00 | 7.60 | -0.50 | ||
case based learning | 90.00 | -0.47 | 50.00 | -0.17 | 0.56 | 20.00 | 3.80 | ||
drag and drop as3 | 90.00 | -0.18 | 35.00 | -0.30 | 0.39 | -7.00 | 3.40 | 0.30 | |
critical constructivism | 90.00 | 0.29 | 30.00 | 0.33 | -10.00 | 2.00 | -0.10 | ||
incidental learning definition | 90.00 | 3.09 | 30.00 | 0.33 | 30.00 | 2.90 | |||
inverse kinematics tutorial | 90.00 | -0.40 | 30.00 | 0.33 | 10.00 | 2.60 | 1.00 | ||
pedagogical theory | 90.00 | -0.18 | 30.00 | -0.14 | 0.33 | 2.00 | 2.30 | -0.10 | |
repertory grid technique | 90.00 | 0.50 | 30.00 | 0.36 | 0.33 | -3.00 | 3.30 | 0.40 | |
methodology structure | 90.00 | 1.57 | 30.00 | 0.87 | 0.33 | -10.00 | 2.20 | ||
community of inquiry | 90.00 | -0.18 | 30.00 | 0.36 | 0.33 | 10.00 | 5.40 | -0.40 | |
student management system | 90.00 | 22.00 | -0.37 | 0.24 | -10.00 | 7.00 | 1.00 | ||
skeinforge | 90.00 | 0.50 | 22.00 | 0.24 | 20.00 | 7.00 | 0.80 | ||
pedagogical strategy | 90.00 | 16.00 | 0.18 | 3.20 | 0.80 | ||||
frame by frame animation | 90.00 | 12.00 | 0.13 | 10.00 | 6.40 | 1.00 | |||
constructivism definition | 90.00 | 6.50 | 12.00 | 0.13 | 10.00 | 10.00 | -1.00 | ||
intelligent tutoring systems | 90.00 | -0.40 | 12.00 | 0.13 | 10.00 | 8.90 | -0.20 | ||
tweenlite tint | 90.00 | -0.40 | 6.20 | -1.00 | |||||
keyboard wiki | 90.00 | 0.29 | 8.30 | 2.00 | |||||
reload editor | 90.00 | 6.70 | 0.30 | ||||||
rolfe reflective model | 90.00 | 4.62 | 9.80 | -0.30 | |||||
xml schema wiki | 90.00 | 0.29 | 6.40 | 0.20 | |||||
information architecture | 90.00 | 16.00 | |||||||
mslq | 90.00 | -0.18 | 11.00 | -0.30 | |||||
prototyping | 90.00 | 16.00 | |||||||
tweenlite delay | 90.00 | 5.80 | 0.90 | ||||||
pageflakes | 90.00 | 10.00 | |||||||
schon reflective cycle | 90.00 | 2.00 | 6.80 | 0.50 |
Finally a screenshot of the keywords that reflect EduTechWiki according to Google. I actually like these.
