Understanding query logs

dmoore1 · Post by **dmoore1** » Wed Jun 17, 2015 11:30 am

I cannot find any explanation of the fields in the query log. We get:
Date IP What Query IndexCount Url RankOrder RankProx RankDFreq RankWFreq Lead Proximity Suffixes BestBetGroup BestBet ForwardedBy

Some of the entries in Index count, which I am assuming is the number of searches on a term are way to large to be real. Can someone help or point me to a post. I could not find any related posts when I searched.

Post by **mark** » Wed Jun 17, 2015 12:41 pm

Sorry, the docs for that are lacking. Here's a summary:

Field: Description
Date: Date and time of query
IP: IP of client performing query
What: What type of log is this. Query=A search, Click=Click on a search result or Best Bet
Query: User's query
IndexCount: Number of results for query
Url: Clicked URL for What=Click
RankOrder: Rank knob: Word ordering
RankProx: Rank knob: Word proximity
RankDFreq: Rank knob: Database Frequency
RankWFreq: Rank knob: Document Frequency
Lead Proximity: Rank knob: Position in text
Suffixes: Word Forms: 0=Exact, 1=Plurals, 2=Any, 3=Custom
BestBetGroup: The name of the Best Bet group if it was a Best Bet click
BestBet: The Keywords of the Best Bet if it was a Best Bet click
ForwardedBy: IP addresses of proxies used by client. Comma separated.

Post by **mark** » Wed Jun 17, 2015 12:45 pm

p.s.
For the rank knobs the values are:
0=off, 250=low, 500=medium, 750=high, 1000=max

dmoore1 · Post by **dmoore1** » Wed Jun 17, 2015 12:59 pm

Thanks for the info ... priceless. Is there documentation anywhere? Also, should I assume, then, that a word will appear every time it is search, so the count is "1" each time?

If there are no entries in the URL field, does that mean no one clicked through after getting the search results?

Thanks again.

Post by **mark** » Wed Jun 17, 2015 1:11 pm

Every appliance has docs online in the admin interface. Click Docs on the menu. But, as I said, the query log field documentation is lacking.

Not sure what you're saying about the count. For a given search there will be one entry in the query log indicating the typed query in Query and the number of results the user got for that query in IndexCount.

URL will only be filled in if What=Click, indicating that a user clicked on one of the items in the search results. URL will always be empty when What=Query.

dmoore1 · Post by **dmoore1** » Wed Jun 17, 2015 1:17 pm

Your answer for my unclear first question was what I was looking for.

Now, if there are no "click"s in the "What" column, then no one has clicked through on anything?

Post by **mark** » Wed Jun 17, 2015 1:19 pm

Correct. Try the search yourself and click on one of the results. You should see a Click for your IP and query.

dmoore1 · Post by **dmoore1** » Wed Jun 17, 2015 1:56 pm