Developer forum

Forum » Templates » Tag Cloud DW statistics

Tag Cloud DW statistics

E-mail notifications
Dmitrij Jazel
Reply
Posted on 22/02/2012 11:22:12
Hi All,

I wanted to know if it is possible to set up a Tag Cloud so that it could use statistics of the DW to define the popularity.
Could anyone have some tips, hints or any other useful information regarding the subject?

Much appreciated :)
Dmitrij

Replies

 
Nicolai Høeg Pedersen
Posted on 22/02/2012 13:19:40
Reply
What should the tag cloud show? page names, keywords or what?

You can have a look in Statv2Session, Statv2Page and Statv2Object for relevant data. Be aware of performance - do caching!

 
Dmitrij Jazel
Posted on 22/02/2012 15:01:23
Reply
Hello Nicolai,

Thanks for info :)
I would love if it could get page names of most popular things, pages/products/product groups etc...
Lets say, if I want to use this Plugin: http://cssglobe.com/post/4581/tag-clouds-styling-and-adding-sort-options (as an example)
Than I would have to get an generated ul with links to the popular thing, and be able to extract an popularity indicator.
I guess that would be enough, the rest is just styling and sorting. But the main problem here is to get that list somehow.

So far I think it is the most precise as I can get. I will check on Statv2Session, Statv2Page and Statv2Object and will keep caching in mind and will come back with the results...
 
Dmitrij Jazel
Posted on 29/02/2012 11:43:02
Reply
Hello Again,

Well but I can see that Statv2Session/page/object are tables in the db.
In my case, I am using stardard eCom solution. So I am a bit in doubt how can you pull data from tables (unless using custom modules).
I need to have some kind of method set up to access the database, so I could use some ajax to get it etc...

Any suggestions?

Dmitrij
 
Dmitrij Jazel
Posted on 27/03/2013 09:04:00
Reply

Hej Nicolaj,

Now I have to continue discussion here, cause I have a question that is the same as this topic, and the task is the same.

But this time I have a possibility to use DataLists module to extract information from Database.

As in the example you mentioned above, I should look at Statv2Session, Statv2Page and Statv2Object, I did that, but I think I could use some help on how to read all that - so that I could end up with a dataset same as here:

(take a look at the attachment)

Please keep in mind that I will have to differentiate all the statistics for different websites. Right now there are 4 websites under same solutions. Only one of them wants to use this feature, but it wants to see only pages generated under that website, and no other.

 

Or maybe today we can have some other options to solve this one?

 

Any suggestions?

Dmitrij

 

stats.png
 
Nicolai Høeg Pedersen
Posted on 02/04/2013 15:35:59
Reply
This post has been marked as an answer

Use this SQL in datalists and change the where to fit your needs (Statv2SessionAreaID is the website ID):

 

SELECT Count(Statv2Session.Statv2SessionID) AS CountOfStatv2SessionID, Statv2Page.Statv2PagePageID, [Page].PageMenuText
FROM [Page] RIGHT JOIN Statv2Page ON [Page].PageID = Statv2Page.Statv2PagePageID INNER JOIN Statv2Session ON Statv2Page.Statv2PageSessionID = Statv2Session.Statv2SessionID
WHERE Statv2Session.Statv2SessionAreaID=1 AND Statv2Session.Statv2SessionYear=2012
GROUP BY Statv2Page.Statv2PagePageID, [Page].PageMenuText
ORDER BY Count(Statv2Session.Statv2SessionID) DESC

BR Nicolai

Votes for this answer: 1
 
Dmitrij Jazel
Posted on 02/04/2013 15:38:04
Reply

Hej Nicolai,

That's awesome :-)

Thanks alot for the info :-)

//Dmitrij

 

You must be logged in to post in the forum