/aol_query_log_analysis

This project aims to analyze different aspects of the AOL query log

Primary LanguageJavaMIT LicenseMIT

AOL Query Log Analysis

This project aims to analyze different aspects of the AOL query log and extract insightful information that may help to approach other research problems in information retrieval. For all the experimented conducted here, we have considered only the top 1000 user search logs who has the most number of search queries with clicks.

Table of Contents

Named Entity [Person-Location-Organization] Analysis

For Named-Entity analysis, we have considered the top 1000 user search logs who has the most number of search queries with clicks. Description of the segment of query log we used for the experiment is given below.

Data Statistics

Particulars Count
Number of users 1000
Total number of queries 318,023
Total unique queries 177,857
Total queries where person entity found 37,381
Total queries where location entity found 19,945
Total queries where organization entity found 22,730

We have used Stanford Named Entity Recognizer (NER) for this analysis. Full result of the named entity analysis can be found here. In the following section, we are showing the results for individual entities.

Person Entity in User Queries

In the following figure, we are presenting the statistics of the user queries where name entities are used.

From the graph, we can see 383 and 346 users mentioned about named entities in their 10%-20% and 20%-30% queries respectively.

Location Entity in User Queries

In the following figure, we are presenting the statistics of the user queries where location entities are used.

From the graph, we can see 574 and 302 users mentioned about named entities in their 0%-10% and 10%-20% queries respectively.

Organization Entity in User Queries

In the following figure, we are presenting the statistics of the user queries where organization entities are used.

From the graph, we can see 425 and 430 users mentioned about named entities in their 0%-10% and 10%-20% queries respectively.

POSTag [Part-of-Speech tag] Analysis

We have used Stanford Log Linear Part-of-Speech Tagger for this analysis. Full result of the POSTagging analysis can be found here.

AOL Query Topic Analysis

We have done topic analysis on the user queries using our Hierarchical Privacy Preserving Information Retrieval project.

Queries and their two most likely topics

Full result of this analysis is available here.

Top 500 queries and their five most likely topics

Language Model based Topic Inference: Full result of this analysis is available here.
Retrieval based Topic Inference: Full result of this analysis is available here.

Top 500 topics and their corresponding queries (unique queries only)

Full result of this analysis is available here.

AOL Query-CoverQuery Topic Analysis

We have done analysis on topical relationship between true user query and fake cover queries using our Hierarchical Privacy Preserving Information Retrieval project. Full result of this analysis is available here.

To understand the result, i am explaining few snippets from the full result.

Example 1:

If total number of cover queries need to be generated is 2 (one from sibling topic, one from non-sibling same level topic), then Our Hierarchical Privacy Preserving Information Retrieval model generates cover queries as provided below. Cover queries are in stemmed form.

Query: blood sugar chart [2006-03-01 13:15:43], Best Topic: Cooking<-Home<-Top[6.385665314335517E-20], Second Best Topic: Consumer_Information<-Home<-Top[3.03048523392194E-20]
-----------------------------------------------------------
Cover Query#1 : provid tip [Gardening<-Home<-Top], Cover Query#2 : afternoon [Running<-Sports<-Top]
Query: michigan sex offender [2006-03-02 07:32:33], Best Topic: Employment<-Environment<-Science<-Top[1.0823161549721215E-21], Second Best Topic: Education<-Guns<-Recreation<-Top[1.0823161549721215E-21]
-----------------------------------------------------------
Cover Query#1 : 945 [Climate_Change<-Environment<-Science<-Top], Cover Query#2 : strategi strategi equival web game is [Button_Men<-Dice<-Games<-Top]

Example 2:

Our Hierarchical Privacy Preserving Information Retrieval model sometimes can't generate cover queries from sibling topics because of not having rich language models organized in a hierarchical manner. Cover queries are in stemmed form.

Query: eta eta sigma wmu [2006-03-02 14:05:10], Best Topic: Regional<-Top[2.5244324176014525E-34], Second Best Topic: Health<-Top[2.211274978455956E-34]
-----------------------------------------------------------
Cover Query#1 : front page world [News<-Top]

Example 3:

If our Hierarchical Privacy Preserving Information Retrieval model identifies sequentially edited queries, it handles them accordingly. One example is given below. Cover queries are in stemmed form.

Query: homewood suites [2006-04-08 16:49:13], Best Topic: Hotels_and_Motels<-Hospitality<-Business<-Top[1.484658648795777E-13], Second Best Topic: Contests<-Writers_Resources<-Arts<-Top[1.484658648795777E-13]
-----------------------------------------------------------
Cover Query#1 : driver [Associations<-Hospitality<-Business<-Top], Cover Query#2 : solutionskong productspet partner [Pet_Supplies<-Consumer_Goods_and_Services<-Business<-Top]
___________________________________________________________
Query: country inn & suites [2006-04-08 16:52:11], Best Topic: Hospitality<-Business<-Top[2.0443749428323496E-20], Second Best Topic: Hotels_and_Motels<-Hospitality<-Business<-Top[1.202573495783735E-21]
*****current query is sequentially edited from previous query*****
-----------------------------------------------------------
Cover Query#1 : 2007 upgrad england' rise star marriott courtyard [Hospitality<-Business<-Top], Cover Query#2 : luggag tagscustom [Consumer_Goods_and_Services<-Business<-Top]

Definition of Sequentially Edited Query: If current user query topic is the parent or children of the previous query topic, then the current user query is sequentially edited.

Action Transition Analysis

In this section we are presenting our analysis for action transition in sequence of queries submitted in a search session by 9000 users (ranked from 1001 to 10000) extracted from AOL dataset. Important facts are mentioned below.

  1. We have defined 8 actions in query sequence submitted by a user. They are initial_state, up1 step, up2 step, down1 step, down2 step, in same state, same parent (SP), same grand parent (SG) and others. Transitions mean different actions taken by users in terms of the DMOZ hierarchy tree which we are using for users' intent classification.
  2. Two consecutive queries belong to the same session if the interval between is less than 60 minutes. Total sessions considered = 264,498 and total queries extracted (over 9000 users) = 8,54,975

Action Transition Matrix

Particulars initial_state up1 up2 down1 down2 same_state SP SG others
initial_state 0 0 0 78 11461 0 0 0 245700
up1 0 0 0 62 0 110 3 9 184
up2 0 0 0 0 1 0 0 0 2
down1 0 31 0 1 1 135 34 26 203
down2 0 1 0 237 0 2964 78 278 7560
same_state 0 125 2 108 1 58852 2421 7405 38209
SP 0 32 0 1 0 2478 1556 833 3425
SG 0 23 0 5 0 7326 869 6870 15128
others 0 431 3 184 2 111366 9723 38202 246946

AOL Data description

500k User Session Collection
----------------------------------------------
This collection is distributed for NON-COMMERCIAL RESEARCH USE ONLY. 
Any application of this collection for commercial purposes is STRICTLY PROHIBITED.

Brief description:

This collection consists of ~20M web queries collected from ~650k users over three months.
The data is sorted by anonymous user ID and sequentially arranged. 

The goal of this collection is to provide real query log data that is based on real users. It could be used for personalization, query reformulation or other types of search research. 

The data set includes {AnonID, Query, QueryTime, ItemRank, ClickURL}.
        AnonID - an anonymous user ID number.
        Query  - the query issued by the user, case shifted with
                 most punctuation removed.
        QueryTime - the time at which the query was submitted for search.
        ItemRank  - if the user clicked on a search result, the rank of the
                    item on which they clicked is listed. 
        ClickURL  - if the user clicked on a search result, the domain portion of 
                    the URL in the clicked result is listed.

Each line in the data represents one of two types of events:
        1. A query that was NOT followed by the user clicking on a result item.
        2. A click through on an item in the result list returned from a query.
In the first case (query only) there is data in only the first three columns/fields -- namely AnonID, Query, and QueryTime (see above). 
In the second case (click through), there is data in all five columns.  For click through events, the query that preceded the click through is included.  Note that if a user clicked on more than one result in the list returned from a single query, there will be TWO lines in the data to represent the two events.  Also note that if the user requested the next "page" or results for some query, this appears as a subsequent identical query with a later time stamp.

CAVEAT EMPTOR -- SEXUALLY EXPLICIT DATA!  Please be aware that these queries are not filtered to remove any content.  Pornography is prevalent on the Web and unfiltered search engine logs contain queries by users who are looking for pornographic material.  There are queries in this collection that use SEXUALLY EXPLICIT LANGUAGE.  This collection of data is intended for use by mature adults who are not easily offended by the use of pornographic search terms.  If you are offended by sexually explicit language you should not read through this data.  Also be aware that in some states it may be illegal to expose a minor to this data.  Please understand that the data represents REAL WORLD USERS, un-edited and randomly sampled, and that AOL is not the author of this data.

Basic Collection Statistics
Dates:
  01 March, 2006 - 31 May, 2006

Normalized queries:
  36,389,567 lines of data
  21,011,340 instances of new queries (w/ or w/o click-through)
   7,887,022 requests for "next page" of results
  19,442,629 user click-through events
  16,946,938 queries w/o user click-through
  10,154,742 unique (normalized) queries
     657,426 unique user ID's


Please reference the following publication when using this collection:

G. Pass, A. Chowdhury, C. Torgeson,  "A Picture of Search"  The First 
International Conference on Scalable Information Systems, Hong Kong, June, 
2006.

Copyright (2006) AOL