Need helping pulling keywords from Google Analytics (MILLIONS!) and finding most often used keywords

Closed

I have an auto parts e-commerce store which has had millions of visitors over the years. I need someone to pull out every keyword used and put it into my MySQL database by keyword to specific landing page URL. I'm assuming that the Google Analytics API is the best way to go about this (does the API have to be paid for? if so, how much?)

Then, I need all of the search phrases to be parsed, to get the 20% most common present keywords from them.

So we may have:

1995 Honda Civic Tail Light

2005 Toyota Camry Tail Lamp

2008 Honda CR-V Rear Light

So your report would show me that the most commonly used words are: Tail|Light ("|" used as delimiter)

Skills: PHP, Software Architecture

See more: used keywords, cr auto, lamp software, how much is google analytics, api analytics, most, Honda, helping, google analytics api, analytics php api, google api store, google analytics landing page, used parts, google analytics php, php google search api, google analytics php api, php google analytics api, tail keywords, google search api php, commerce analytics, php mysql landing page, mysql analytics, analytics database, google keyword api php, php keywords url

Project ID: #5021331

Awarded to:

meet2amitvw

Let me work for you. see my recent work (regarding api related project) for the technical expertise along with reviews & feedback on my profile page. let's discuss and get started.

$25 USD / hour
(63 Reviews)
6.9

3 freelancers are bidding on average $19/hour for this job

dinastalb

Hello, I am John Profit. I work with my partners Marlen and Van at Netronian Inc., in Orlando, Florida. We have great experience with Magento. 80% of our developed websites are Magento websites. We are the masters More

$75 USD / hour
(12 Reviews)
5.9
hemsingh1

Hi, Expert here. Ready to Start. Thanks Please visit my demo site http://mydealstm.com/renewchurch/ or http://mydealstm.com/northstarwebdesign/and many more

$16 USD / hour
(2 Reviews)
1.1
tirno212

hi i am ready to start work immediatelly, please give me a chance to work with you , waiting for your kind reply...

$15 USD / hour
(1 Review)
0.0
logicalthinker

Hi! I have been working with PHP/Mysql for the last 7 and 1/2 years.Also I have worked on a similar system where I had to extract Google Analytics data using the API so I hope I will be able to give you expected res More

$16 USD / hour
(0 Reviews)
0.0