Identifying Popular Links Portal Wide

After having my DNN sites up and running for almost a year I was very curious to see exactly how many clicks I had on the various tracked links. I started to look around and was getting tired of clicking "Edit:" on each link to view the information. So I created this simple query to quickly pull the links in the "Most clicked" order.

This is a very primitive query that gets the module name, link, click count and last click time. For documents loaded in the documents module you will only get the file id of the file, but it at least helps to illustrate the activity.

SELECT m.ModuleTitle, t.url, t.Clicks, t.LastClick
FROM URLTracking t
    INNER JOIN Modules m
        ON (t.ModuleId = m.ModuleID)
WHERE t.PortalId = 0
    AND TrackClicks = 1
ORDER BY t.Clicks DESC

You will need to edit the PortalId portion of the where clause to ensure that you reference the correct portal.

Posted by IowaComputerGurus on Wednesday, June 06, 2007

Tags: DotNetNuke, SQL

Comments

While DNN's ability to track links is good for reporting purposes, it does not help your SEO efforts.

So I guess now it becomes a question of priority.

By Tom Kraak on Sunday, June 10, 2007 at 3:16 PM

That is a very valid point since my guess is that most robots do not follow the links..

By mitchel.sellers@gmail.com on Sunday, June 10, 2007 at 5:14 PM

It can help your SEO efforts if you want "dynamic links" that will prevent spiders from following the link and thus bleeding your PageRank.

By bonder on Friday, June 22, 2007 at 4:10 AM

simple note to this sql: augment the table names to match your dnn table name qualifier...

By drew on Saturday, July 07, 2007 at 12:27 AM

Hello,

This query is great, but FileID are not very interesting. Can't you join the table to obtain the name of the file ???

DV FX

By Déclic Vidéo FX on Sunday, July 08, 2007 at 8:21 AM

DV FX,

I'll look into that....give me a bit of time to look into it.

By mitchel.sellers@gmail.com on Monday, July 09, 2007 at 8:45 AM

Name (required)

Email (required)

Website

Enter the code shown above:

Notify me of followup comments via e-mail

Content provided in this blog is provided "AS-IS" and the information should be used at your own discretion. The thoughts and opinions expressed are the personal thoughts of Mitchel Sellers and do not reflect the opinions of his employer.

Subscribe To Blog RSS
Subscribe To Blog Updates by E-Mail *
Add to Technorati Favorites

Click here for advertising information.

Content in this blog is copyright protected. Re-publishing on other websites is allowed as long as proper credit and backlink to the article is provided. Any other re-publishing or distribution of this content is prohibited without written permission from Mitchel Sellers.