this task is at the intersection of keyword research and data entry.
We would like you to deliver the following in an excel/CSV table:
- 100 keywords/search phrases with a CPC > 5€ and search volume between 1000 and 7000 monthly.
- 4 companies that advertise for each of these keywords. Collect firstname, lastname of their CEO and the domain name.
So the full table should consist of 400 rows. (keyword-firstname-lastname-domain).
- near-duplicate keywords should be avoided, e.g. keywords that describe the same service
- avoid listing the same company more than once
- you don't need to research emails or phone numbers
- german keywords only
- a typo rate of up to 4% is accepted
A potential process would look like that:
1.) use a tool like semrush or similiar to get a list of keywords that fit our criteria
2.) use a VPN and a browser plugin to simulate you being in germany
3.) do a search query for every keyword
4.) go to the website of 4 advertisers for that keyword. If possible avoid clicking the ad, as triggering 400 paid clicks might be considered impolite from the search engines point of view :)
5) use the search function of your browser to find "imprint" or "impressum" or "kontakt" - this will be an area where you find legal information about the company and there also will be the name of the CEO
6) copy first and lastname of CEO to the spreadsheet. If there is more than one, pick any you like. also add the domain name to the sheet
7) the cycle is hereby completed
[This is a test project]
We welcome your bids and look forward to work with you! Please include a note in your message how you intend to find keywords.
Please see how our profil for reviews and how we strive to provide you with a great work environment.
You have already explain the requirement pretty well, and I have use Smerush and Spyfu earlier so I can understand what you need. We are ready to start work on.
14 freelancers are bidding on average $166 for this job
Plz give this project.. As a new freelancer I will ensure ur project properly.. Let's come out new thought!!! Relevant Skills and Experience Writter, online marketer,, youtuber, data entry
By selecting me for this project I assure you that your project will be impressive as I have experience to doing this work too. And as I also have that skills which you are required for this project.