Data, SQL and cloud data project
$250-750 USD
Оплачується при отриманні
The attached data set shows Google search results data for a number of iphone6 related search terms. Each search term show the Google search results, the page, title and description from the result. Each day I’ve got the same scrape of data so we’ve got a few weeks of historical data from before the iphone 6 launch and after. My goal is to show which websites have moved the most dramatically up the search results, which pages are appearing the highest and over what time period has each page risen up the search results.
To do this, I’m going to upload (daily) each CSV file that contains the iPhone search results data to a database or Google cloud, then query it (SQL) query to understand the above. The output will be data that I can then manipulate using Excel.
Optional
Would it be possible to automate and visualise this process entirely? Could we create an automated query that gathers this information each and every day and visualises the data into graphs using Google graphs as a Dashboard output? This would be amazing. Could we brand it and create some great design?
ID Проекту: #6707862
Про проект
10 фрілансерів(-и) готові виконати цю роботу у середньому за $599
Thanks for invitation , would like to see the excel sheet so that we can make the confirm the work will be waiting for response thanks