PHP script to analyse Search Query data

Completed Posted Apr 12, 2015 Paid on delivery
Completed Paid on delivery

Hi,

I have a mysql database with about 135'000 rows for search data. I'd like to have PHP script (or other) that analyses the data and creates valuable analysis for the search queries. I'd like to know, what have been searched for, what are the top searches, are there any trends in what is being searched for, and other interesting things.

I've attached a selection of the data 1000 of 135'000 search queries. The data needs some basic clean up and amendments (misspelling, double spaces, character formats(fix letters æ, ø, å), some double searches by same user, unfinished searches)

The data includes; unique identifier, search query, timestamp, user_IP

The data is historic searches, and new date is not being generated anymore. So this is a one-off analysis.

Mysql database access can be given, or data can be supplied as csv or xml file.

Delivery: Is a working html/php page or similar that analyses the data in the database in a way that make is possible for me to make some conclusions regarding what topics our website visitors are looking for, and that we probably should write something about.

This should be a fairly quick job, only a few hours for the right person. Who can help me? I'd like the work done today.

Data Processing HTML MySQL PHP Statistical Analysis

Project ID: #7471604

About the project

4 proposals Remote project Active Apr 12, 2015

Awarded to:

brendanmullan90

Hi there my name is Brendan and i am an expert in Web Development. I have read through your project description and can do this job for you. PHP and MySql are are my strongest languages and over the years i have worked More

$35 USD in 1 day
(1 Review)
0.6

4 freelancers are bidding on average $35 for this job

NayaPakistan

A proposal has not yet been provided

$40 USD in 1 day
(125 Reviews)
5.6
talbo22

Right man for the job. This shouldnt take much time at all and could be done today. Take a look at recommandations.

$30 USD in 1 day
(7 Reviews)
2.7