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

Budget $15 - $25 USD / hour
Bids 5
Average Bid $29

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)

Post a Project Like This

This project was awarded to

About the Freelancer

Looking to make some money?

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

Bids on this Project

  • logicalthinker Profile Picture


    Kolkata,  India

    A science graduate with post graduate diploma in computer application (DOEACC A Level) and about 8.5 years of IT experience specifically on developing PHP and Mysql based web sites.

    PHP, Javascript, AJAX, and SQL

  • dinastalb Profile Picture


    Orlando,  United States

    We are rated as the top 3% of Freelancers in the world! We Explore designs, economies that tap into the global commons, which will distribute capacity, embrace paradox and reshape the future. This saying has always influenced our designs and this is why this phrase has been always in our mind. To generate superior thinking that develops designs that really work for my customers' perspectives in order to achieve a commercial success. Designing for great organizations and successful businesses looks great in our portfolio, but it also makes us believe that we should continue to develop your next high-end projects. All our work is proudly made in USA, and we are a green business that supports and has staff from the following business types; minority-owned business, women-own business, young entrepreneurs, and startups. You choose our services because we make sure we stick around to get you launched not simple started. The rest will be written in history!

    PHP, C Programming, Javascript, and Website Design

  • meet2amitvw Profile Picture


    Ranip,  India

    Please check MY Repeat Hire rate as i believe in long term business relationships. Technical Details. =============== I have more than 10 years of experience in wide range of web & mobile designing and development services. We work as a committed full-time Freelancing team. I have expertise in all aspects of website design and development (including mobile) and have been involved in several small and large projects from the start to finish. Over the last 8 years, We have delivered hundreds of projects related to array of Web-Based Application, Mobile Based Application, Website Design, Software Architecture, API Development, Social Media Development, E-commerce Development, Social Media Integration, CMS Development etc. using the advanced and most appropriate web technologies. I work specially in PHP platform to bring the best possible end product. I have great experience in Open Source Content Management System like Drupal, Magento, Joomla, WordPress, .NET and MVC Object Oriented Framework such as Codelgniter, Zend, CakePHP, Qcodo, and PRADOTM for the startup and small businesses. Our other areas of expertise include E-commerce website and app with payment gateway integration; API Development with RestFul API (Protocol), OAuth1.0/2.0 (Facebook, Google, LinkedIn), SAML/SSO, OpenID, XML (SOAP) & WSDL; Mobile Development for iOS and Android; Social Media API like Facebook, Twitter, Google Analytics & Google Adwords Apps; Payment API like PayPal,, Wepay. I also provide Software Design & Testing Service using various model-based approaches. Our core competency lies in complete end-end management of a new website development project, and I am seeking opportunities to build websites from the ground up for you or your business. I have the ability and confidence to bring innovation to your business that allows your company/organization to be a step ahead with the end products designed and developed by our small team as a freelancer at the professional standards. If you are a small or large business in need of new website or app or require any kind of digital resource, Please feel free to get in touch without wasting any single minute. I would love to work with you.

    PHP, Perl, ASP, and C Programming

  • hemsingh1 Profile Picture


    New Delhi,  India

    An advanced IT programmer with strong programming skills in PHP, Mysql, Html, CSS, C, MS Excel, Macros (VBA), MS Access & SQL Our core niche is: - Wordpress custom theme development and setup - Wordpress plugin development - PHP customization and sites based on PHP - CSS, HTML5 and Javascript customization and development - MS Excel & Macros (VBA) - Excel based Dashboard powered by variety of formulas, Pivot table & Powerpivot - Complex Data crunching & Manipulation - Data Modelling I also specialize in web development and various CMS like Wordpress, Joomla, ecommerce suites like Prestashop and Magento. I aim and strive to deliver my work with superior quality and always on time. Please don't forget to post a review after I deliver your work. I will try my best to resolve the problems if any.

    C Programming, JSP, Javascript, and Visual Basic