Re: [PyCS-devel] Search referral extractions?

[Phillip P. <pp...@my...>]

Ah, yes, there are some interesting rules about what gets shown and
what doesn't.  When I moved it all over to SQL I tried to replicate
what Georg had done before, but I'm not sure if I got it quite right.

> Quick note (not much research..)
> 
> I was surprised to see that there are a number of
> search entries not listed in the search word hit:
> 
> http://www.pycs.net/system/searches.py?usernum=24&group=default&order=time

... which does this query:

"SELECT hit_time, referrer, hit_count, search_engine, search_term FROM
pycs_referrers WHERE usernum=%d AND usergroup=%s AND
is_search_engine='t' ORDER BY "+order_criteria+" DESC LIMIT 100",
(usernum, group)

(order_criteria is either 'hit_time', 'hit_count' or 'referrer').

> Which were in the exhaustive referral list:
> http://www.pycs.net/system/referers.py?usernum=24&group=default&order=time&full=1

... which does this query:

"SELECT hit_time, referrer, hit_count FROM pycs_referrers WHERE
usernum=%d AND usergroup=%s "+search_criteria+" ORDER BY
"+order_criteria+" DESC LIMIT 100", (usernum, group)

(order_criteria is as above, and search_criteria is blank for full=1
or when there are less than 30 search engine hits, otherwise "AND
is_search_engine='f'")

> At first I thought it was due to obscure search engine
> results, but now see that google referrals are also
> missed.   
>
> Folks DO come to my site for more than Rutabagas! ;-)

Interesting... I can't see why you would be missing Google results
unless the counter isn't properly setting is_search_engine when it
gets them.  Hmm.  Can you point out one for me where there's a result
on the referrers page but not on the searches page?

> p.s. Thanks Phil for the Adsense option.  Getting much
> results from my count-on-one-hand hits/day?

I've earned $9.20 this month from AdSense, from ads shown on your
blog, my blog, and the Topic Exchange.  Not sure how many came via
your ads :)

Cheers,
Phil