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

  • Status Completed
  • Budget $15 - $25 USD / hour
  • Total Bids 5

Project Description

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)

Get free quotes for a project like this
Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online