I Can't Stop

February 16, 2005 4:40pm 7 Comments Edit

I can't stop looking at my stats. I've made it too easy to get at them. Now, instead of blogging, I just sit here and push the "Show" button with the form set to "Top Referring Pages".

Check out my top 10 search phrases:

    < ?php
    global $wpdb;

    $searches = $wpdb->get_results("SELECT *, count(search_refer) AS `Count` FROM {$wpdb->searches}, {$wpdb->visitors}, {$wpdb->refer} WHERE search_refer = referer_id AND search_refer = referer AND referer_string<>'' GROUP BY search_refer ORDER BY `Count` DESC LIMIT 10");

    foreach($searches as $search)
    {
    echo "
  • {$search->Count} × {$search->search_phrase}
    • ";
    }
    ?>

This list updates dynamically using PHP code in my post via EzStatic, fetching data from the BAStats tables. Sweet!

7 Responses to I Can't Stop

  1. Pankaj Narula from pnarula.com 1969-12-31 19:00:00

    I know the feeling. I am doing the same. Thanks for the great work. Is putting some graphics in scope..

    Pankaj

  2. valerie from spoken-for.org 1969-12-31 19:00:00
    Local Search: cemetery photos 1365 232%
    Google Search: spoken for 1 0%
    Google Search: valerie 1 0%
    Local Search: 1 0%

    um, okay lol

  3. Owen from www.asymptomatic.net 1969-12-31 19:00:00

    I think there's a glitch in the Local Search returns routine. I can't imagine that somone sat and reloaded the search page of your site on the term "cemetery photos" 1300+ times.

    As if the first set of results wasn't good enough, and they expected the subsequent 1364 to look different.

  4. VesperDEM from www.daveschalkboard 1969-12-31 19:00:00

    I would hope that there is a glitch. I really can't imagine someone doing 2515 local searches for "coppermine photo gall" on my site. :)

  5. valerie from spoken-for.org 1969-12-31 19:00:00

    I don't even have search available, you have to do it manually if you know what you're doing. I did that particular search once so as to find some other entries to link to in this entry.

  6. Owen from www.asymptomatic.net 1969-12-31 19:00:00

    Yeah, I found the glitch. Actually, someone mentioned it yesterday, but I didn't understand where they were talking about.

    I'll have something new up soon. It has pretty graphs. They're now bar graphs. They look darn sweet, too.

  7. valerie from spoken-for.org 1969-12-31 19:00:00

    cool :)

1366
Feed for this Entry