Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Like Amazon: people who clicked....

Quote Reply
Like Amazon: people who clicked....
Hi Andy,

How about:
Like on Amazon - display a list of links to "people who clicked on this story (link) also clicked on (top 5 or 10 stories/links) and hence a related links overview but defined by user behavior. ?

Klaus

http://www.ameinfo.com

Last edited by:

yogi: Dec 15, 2002, 12:18 AM
Quote Reply
Re: [klauslovgreen] What would you like to see? In reply to
I like your idea!

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [klauslovgreen] What would you like to see? In reply to
In fact, I liked your idea so much that I made a plugin for this.

For any given link, the plugin calculates which other links have been visited by the users that have visited this given link. It also calculates the number of visits to the other links. You will be able to use a tag like

<%Plugins::VisitorRelations::get_visitor_relations($ID,5)%>

to get an loop of related links, ordered by their number of hits (not the hits they get on their own, but the hits they get from people also visiting the given link).

The plugin needs some testing first, but I'll keep you informed!

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] What would you like to see? In reply to
Hi Yogi,

That's great news - let me know if you need someone to help you do the testing. From my view I am interested in people clicking on detailed pages only as I am using LinksSQL as a publishing tool and hence would like to display which detailed pages are the most visited :-) - any chance of making the plugin trace detailed pages and/or links?

Cheers
Klaus

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] What would you like to see? In reply to
If you link to your detailed pages in the following way:

jump.cgi?Detailed=1234

then Links SQL will keep track of the detailed page views, and the VisitorRelations plugin will work perfectly.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] What would you like to see? In reply to
Hi Yogi,

Thins is I don't run in static mode so the detailed pages are generated on the fly using page.cgi - any ideas?


Klaus

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] What would you like to see? In reply to
Yes, I have an idea Wink

If you run everything in dynamic mode, then you can just put a 'template global' on the 'detailed.html' template, which acts like 'jump.cgi' in that it records which page is displayed.

Use this global, called 'track_detailed' (this is basically the same code as in jump.cgi):
Code:
sub {
my $id = shift;
my $ip = $ENV{REMOTE_HOST} || $ENV{REMOTE_ADDR} || 'None';
my $click_db = $DB->table ('ClickTrack');
my $rows = $click_db->count ( { LinkID => $id, IP => $ip, ClickType => 'Hits' } );
if (! $rows) {
$DB->table('Links')->update ( { Hits => \"Hits + 1" }, { ID => $id }, { GT_SQL_SKIP_INDEX => 1 } );
$click_db->insert ( { LinkID => $id, IP => $ip, ClickType => 'Hits', Created => \"NOW()"} );
}
return;
}
and call it as
Code:
<%track_detailed($ID)%>
on your detailed.html template.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Last edited by:

yogi: Dec 15, 2002, 2:40 AM
Quote Reply
Re: [yogi] What would you like to see? In reply to
Did as you mentioned but get an error:

Unable to compile 'track_detailed':

Sounds great though as it will also herve the purpose of counting hits on details pages - hope you can advise on the problem?

Thanks
Klaus

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] What would you like to see? In reply to
My mistake, sorry. I corrected the global in the above post, and I hope it works now.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] What would you like to see? In reply to
Hi again,

Now I get:
GT::SQL::Driver::MYSQL::sth=HASH(0x84a60ec)

Frown

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] What would you like to see? In reply to
Uhh sorry.

I added a 'return' statement, and it should now really work (it does work on my testing installation).

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] What would you like to see? In reply to
That did the trick :-) thanks a lot!

Klaus

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] What would you like to see? In reply to
Check out the detailed_page plugin for how to track different hits.

You need to edit the ENUM field in ClickTrack and you can start to track different types of hits.

On http://identitydots.com I track the difference between searched hits (using search.cgi to find a domain name) and "direct hits" someone typing in a domain name and being redirected to my parking page.

Modified the ClickTrack table, and my cgi inserts the hits.

Also, CLickTrack *NEVER* gets deleted/purged unless you use static build, or repair tables. You might want to add a piece of code to purge the database table if you only use dynamic pages and never "build" a static site.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] What would you like to see? In reply to
Thanks pugdog :-)

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] Like Amazon: people who clicked.... In reply to
Hi,
is this plugin still, available. I can't find it!
Does it work with glinks 3+ ?

Thanks
Matthias

Matthias
gpaed.de

Last edited by:

Matthias70: Jan 6, 2008, 4:40 AM
Quote Reply
Re: [Matthias70] Like Amazon: people who clicked.... In reply to
anyone?!?

Matthias
gpaed.de
Quote Reply
Re: [Matthias70] Like Amazon: people who clicked.... In reply to
Hi Andy,
seems that this plugin does not exist anymore.
What about a new "people who clicked"-plugin?

Thanks
Matthias

Matthias
gpaed.de
Quote Reply
Re: [Matthias70] Like Amazon: people who clicked.... In reply to
Hi,

Mmm.. I'll have a look at it maybe this week. Not 100% sure how the other one worked (i.e if it just logged the linkID for the user, and then put it into a table - or if it was done another way).

Bit busy at the moment with some custom work, but I'll see what I can do (its my birthday on Wednesday, so not sure I'll be up to working much on Thursday, as I'll probably be recovering Smile)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Like Amazon: people who clicked.... In reply to
Hi Andy,
there’s no hurry Smile

Thanks
Matthias

Matthias
gpaed.de
Quote Reply
Re: [Matthias70] Like Amazon: people who clicked.... In reply to
Hi,

I've started work on this plugin now.

I'm trying to get my head around a few things, i.e how to get the "related" links, based on a give linkID

I've got the basic tracking in place (which adds the entry into a new table, ready to use) - but I'm having trouble working out the next bit.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Like Amazon: people who clicked.... In reply to
Hi,

Is anyone willing to let me test this plugin on their site, to get some "real" data? I'm getting there on my dev install, but I only have a few test users, and a few links - so a "real" test isn't going to be very good/accurate.

The test won't affect anyones site - they will just see the site normally (just need to get some real data, so I can populate a new table - and then work out how to approach it from there).

TIA

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Like Amazon: people who clicked.... In reply to
Hi Andy,
I will test it...

Matthias

Matthias
gpaed.de
Quote Reply
Re: [Andy] Like Amazon: people who clicked.... In reply to
I can. If local site isn't problem (non-english).

Regards

UnReal Network
Quote Reply
Re: [Matthias70] Like Amazon: people who clicked.... In reply to
Hi,

Thanks guys. I'm just working on a bit more coding today. Gonna take a different approach to it I think (I was trying to do it an over complicated way Pirate)

I'll let you both know via email when I'm ready to do a real test :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!