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)
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.