The object of this task is to collect outreach contacts that has written articles touching on how tipping is done (when, how, how much, etc.) in certain locations (ex. Stockholm)
The freelancer will use Google and SEO-tools to identify articles (URL, title) talking about tipping (ex. "[login to view URL]") and then collect the writers firstname and e-mail and some additional SEO-details for each URL.
Note that articles does not need to be 100% about tipping at the location. It can be mentioned as part of a travel guide or similar, both works as long as their is a writer/person connected to the article.
Information will be used in outreach purposes.
List of locations is provided in example spreadsheet. (60 locations)
Tools and skills most likely available to the Freelancer:
- Ahrefs/Majest or similar
- Mailhunter, Clearbit, Ninja outreach or similar
- Google scraping
- Automation of certain SEO-task
For each destionation listed, as many URL's/articles and contacts as possible. Some locations will have a larger amount of articles written then others. For efficancy, the freelancer will probably focus on the more common locations (Volume) where number of articles is probably higher.
Goal is 1000+ articles and contacts depending on level of automation.
Google Spreadsheet/s with:
- Article URL
- Article title
- URL domain DR and number of links
- Writer first name
- Writer email
- Only personal emails
- NO generic (info, contact etc.)
- Personal blogs/websites prefered over "big brands", but not a must
Example data and instructions:
Video example: [login to view URL] / [login to view URL]
Example spreadsheet: [login to view URL]
Continous quality control will be performed by third party and any errors will be reported and be required to be fixed within budget.
Work sample (required):
1) Freelancer MUST submit an example with 3 example URL's and contacts for the destionation of: Stockholm - please use example spreadsheet (copy it) and share your work sample in a viewable Google Spreadsheet (Excel will not be accepted) for your offer.
2) Also, freelancer must give an estimate on how many contacts they can identify for common locations such as USA, New York and UK, London.
Failing to compy with this work sample will result in offert not accepted imidiately.