New AOL search analysis tool for marketers

Discussion in 'All Other Search Engines' started by SEM Punch, Aug 31, 2006.

0
  1. #1
    I have put together a tool that is mining all of the AOL data for data that is particularly interesting for marketers:
    http://www.sempunch.com/aol-searches/

    (Sorry, cannot post the link yet b/c of permissions)

    Main features are:

    1. CTR by rank - for any given query you type in, the result set is
    aggregated and a click through rate by position is calculated
    2. CTR by page - same thing as above, just broken down by page

    Check it out and let me know what you think or what else you would like to see.
    Cheers!
     
    SEM Punch, Aug 31, 2006 IP
    GuyFromChicago likes this.
  2. Tyler Banfield

    Tyler Banfield Well-Known Member

    Messages:
    3,027
    Likes Received:
    173
    Best Answers:
    0
    Trophy Points:
    160
    #2
    A little slow for my taste ;)
     
    Tyler Banfield, Aug 31, 2006 IP
  3. SEM Punch

    SEM Punch Peon

    Messages:
    5
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yeah, the aggregations suck up a lot of CPU. I am thinking about perhaps partinioning the tabel/index to speed up the queries.
     
    SEM Punch, Aug 31, 2006 IP
  4. Tyler Banfield

    Tyler Banfield Well-Known Member

    Messages:
    3,027
    Likes Received:
    173
    Best Answers:
    0
    Trophy Points:
    160
    #4
    That sounds like a good idea. You've got a nice tool, just speed it up and you'll be good to go!
     
    Tyler Banfield, Aug 31, 2006 IP
  5. clenard

    clenard Active Member

    Messages:
    458
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    95
    #5
    Very nice! Yeah, it's slow but 36 million records isn't a small search... :)

    I keep getting a pop up error message though, might want to look into that?

    Thanks for the link though! :)
     
    clenard, Aug 31, 2006 IP
  6. SEM Punch

    SEM Punch Peon

    Messages:
    5
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Do you mind pasing the text of the pop up error? I don't get one. Also which browser do you use?

    Thanks for the hint!
     
    SEM Punch, Aug 31, 2006 IP
  7. Steve Myers

    Steve Myers Active Member

    Messages:
    724
    Likes Received:
    49
    Best Answers:
    0
    Trophy Points:
    90
    #7
    [​IMG]
     
    Steve Myers, Aug 31, 2006 IP
  8. SEM Punch

    SEM Punch Peon

    Messages:
    5
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Thanks for pointing this out. It is fixed now :)
     
    SEM Punch, Aug 31, 2006 IP
  9. ktmonline

    ktmonline Well-Known Member

    Messages:
    701
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    110
    #9
    great thankx this was so good of you
     
    ktmonline, Sep 3, 2006 IP
  10. poseidon

    poseidon Banned

    Messages:
    4,356
    Likes Received:
    246
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Have to say it's a pretty good tool indeed in terms of looks :)
     
    poseidon, Sep 3, 2006 IP