Counting Keywords Site-Wide

Feel free to talk about everything related to our Joomla Products
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Sun Feb 09, 2014 1:52 am
I'm using the Sporter template with Joomla 2.5 plus K2.

I've got enough articles that I'm thinking about selling contextual links across the site. It would be helpful for me to price the links if I knew how many times a keyword/phrase appeared on the site. For example, "basketball" will appear more times than "Chicago Bulls" and should be a little more valuable.

I've been searching to find a way to find out how many times a keyword appears across the entire website, and am coming up empty handed. There's plenty of stuff for counting them in a specific article, but I have thousands of articles so that's just not practical for me.

Does anyone have any suggestions for how I can accomplish this?
User avatar
Senior Boarder

GK User
Sun Feb 09, 2014 1:20 pm
Hello,

The only idea which I have - export the #__content table to SQL file and then count the occurences - or write a script which will do it for you.
User avatar
Administrator

teitbite
Sun Feb 09, 2014 1:27 pm
Hi

Sorry to interrupt, but i think a finder component does that already. I remember just adding a plugin for another view. Please see the options in joomla panel of this component.
User avatar
Moderator


cron