Use Google Trends API from myself, the Client, to Automate Some Manual Php Tasks in Part 2 and 3 easily.
And Deal with only 1st part below yourself without my help.
Pre-requisite: You need strong Php knowledge first
You need DEMO the first part successfully before you can be awarded whole project to be inclusive of 2nd and 3rd parts.
For 2nd and 3rd parts, you can customize from the API I sent you, so I need not type in keyword each time, individually.
1st Part: Set up a webpage whereby based on a list o main search keywords or search terms entered by user (separated by commas in-between them) into a fieldbox, ten most related search keywords in Google will all appear and be fed into a csv file. Csv file will be required in the 3rd Part. "No API's will be provided by me for the 1st part. So you need to research how to do it on your own."
So Desired Output Expected(on csv) for 1st part: Ten Most Related Keywords in Google for Each Main keyword, in the whole list of keywords uploaded
Only if 1st Part Demo is Successful: Will award the project to the user.
2nd Part: Almost same as 1st Part, in that once the same list of main search keywords or search terms entered by user (separated by commas in-between them) is entered into a fieldbox, then their corresponding Search Volume Data as a percent of Total Google Searches performed in Google, ie Google Trends Data pertaining to each keyword, will appear in a CSV file. So whereas earlier on, the ten related keywords appear, but now the Google Trends time series data appear instead, for each main keyword in the list of keywords uploaded. Codes : I will provide you a working API file, which is already retrieving Google Trends data for individual keywords, to customize it to apply to multiple keywords all at once "in a BATCH", since we upload a long list here (Reason: I am lazy to type in keywords one by one; who would have the time to do that one by one anyway?) So you are lucky in that you can use this code I send to you, except automate it to apply to bulk list all at once, to save my time from otherwie typing in each keyword one by one.
So Desired Output Expected(on csv) for 2nd part: Google Trends Data pertaining to Each Main keyword, in the whole list of keywords uploaded
3rd Part: Use the Csv file derived from Output to 1st Part, with the corresponding ten most related keywords contained therein for each main keyword, and apply to codes in the 2nd Part you just completed above, ie getting Google Trends Data, to getting the Google Trends Data for each of the most related keywords now instead of to the main keyword (as before).
So Desired Output Expected(on csv) for 3rd part: Google Trends Data pertaining to Each Related Keyword, found in the whole list of related keywords you outputted in Part 1.
Last Step: Integrate the 3 parts together into one, to enable a seamless flow, ie Starting from a list of main keywords uploaded in bulk concurrently into a fieldbox or textbox, will derive the ten most related keywords to each of the main keywords, the Google Trends Data to Each Main Keyword, and the Google Trends Data to Each of the related keywords.
Output these data into MySQL database's tables, for my retrieval. I will need such data for studies.
Let Google Trends Data be retrieved over the fixed period from Jan 2004 to current date.
Pre-requisite: You need Demonstrate 1st Part successfully before I will award whole project inclusive of 2nd and 3rd parts as well together to you.
Also: Please bid with the understanding that milestone uploaded are not released until project completes in entirety, ie 3rd part is done as well.
Milestone: You agree that milestones are only uploaded once you have successfully demonstrated 1st part above successfully.
8 freelancers are bidding on average $120 for this job
I can help you with this sir. If you are bored typing (something i am also from time to time) a voice to text conversion is not that difficult. Best regards.