Display the latest new search terms used by visitors to reach the website along with the date and the page linked to. Keywords: third-party-plugin
I wrote a little plugin, that takes care of both #47 (latest links) and #48 (latest searches). It's called latest referrers.
The data is queried from the db on the fly, since archiving of the latest referrers doesn't make much sense...
You can download the plugin on github:
Feedback of any kind is very welcome!
I just took a small look on your plugin. The way how you select the latest search terms seems not to be exact. You are grouping by referer_name, keyword and visit_entry_idaction_url - I would see the latest search terms independent from referer and/or target. A search term simply is new if it wasn't used before.
You're right, I guess I went from "latest searches" to "latest new searches" too quickly...
I group by all the values for "latest searches", because if somebody come to a website trough google/foo and yahoo/foo, i want to see both in "latest searches".
The example above is also interesting for "latest new searches". At the moment neither of the searches will show up, because the check for new searches is, whether the group has count 1, in the example it has count 2. An alternative would be selecting "where not exists (select ... where a.idaction < b.idaction)": that would give us the first occurences of a searchterm, but it would be quite a performance hog. What do you think? Is this little inaccuracy worth the performance?
(The update and a german translation are available on github)
EZdesign, is the plugin working fine in Piwik 1.0?
If yes, I will move it to 'third party plugins' so that more users could find it. Thanks
Yes, there are no issues I know of.
If there will be some in the future, you will be able to find them on github:
Maybe you'd like to publish your plugin there?
In any case, keep up the good work and we hope you enjoy Piwik 2!