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 10:16 AM

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 12: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 Thursday, June 21, 2007 at 11:10 PM

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

By drew on Friday, July 06, 2007 at 7:27 PM

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 3: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 3:45 AM
Click here to post a comment

RSS Feeds/Syndication

Categories

Archive

Donate

Show your appreciation for the content/modules made available by MitchelSellers.com by making a donation. Donations are used to assist with dedicating time to creating free content.