Need a good word smith, SEO aware who is very good with excel especially vlookup
- or -
Post a project like this2764
$$$
- Posted:
- Proposals: 4
- Remote
- #1277205
- Awarded
Description
Experience Level: Expert
Need a good word smith, SEO aware who is very good with excel especially vlookup, random select and concatenation
Mission
Hundreds of web pages selling the same type of products need unique
Title, Description and H1 tags plus a paragraph of detail
How it works
I send you a series of spreadsheets which will list the URL and existing meta tags
Let's imagine you are working on TITLE TAGS maximum 55 characters
There could be 20 pages that share this title
A beautiful collection of stunning butterflies
so identify the words that could be changed but still maintain the meaning
So in this case its the words in square bracelets
A [beautiful] [collection] of [stunning] butterflies
So create a lookup table of alternative words on a second tab on the spreadsheet
and with a formula like this
="A "&vlookup(randomselect(1,10),adjectives,2,false)&" "&vlookup(randomselect(11,21),adjectives,2,false)&" of "&vlookup(randomselect(22,30),adjectives,2,false)&" butterflies"
you can see that you would instantly have a variety of the titles with the same message but no duplicate content
I need a price per 100 (there are 53,000 instances to be addressed)
and please if you don't instantly understand what I have explained then the job is NOT for you.
Mission
Hundreds of web pages selling the same type of products need unique
Title, Description and H1 tags plus a paragraph of detail
How it works
I send you a series of spreadsheets which will list the URL and existing meta tags
Let's imagine you are working on TITLE TAGS maximum 55 characters
There could be 20 pages that share this title
A beautiful collection of stunning butterflies
so identify the words that could be changed but still maintain the meaning
So in this case its the words in square bracelets
A [beautiful] [collection] of [stunning] butterflies
So create a lookup table of alternative words on a second tab on the spreadsheet
and with a formula like this
="A "&vlookup(randomselect(1,10),adjectives,2,false)&" "&vlookup(randomselect(11,21),adjectives,2,false)&" of "&vlookup(randomselect(22,30),adjectives,2,false)&" butterflies"
you can see that you would instantly have a variety of the titles with the same message but no duplicate content
I need a price per 100 (there are 53,000 instances to be addressed)
and please if you don't instantly understand what I have explained then the job is NOT for you.
Clive B.
99% (170)Projects Completed
125
Freelancers worked with
136
Projects awarded
52%
Last project
11 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Clive,
Whats the website?
AnthonyClive B.08 Sep 2016Thank you for your interest
Interested as why that is important?Fuell08 Sep 2016Hi Clive,
Just to get better insight. As you can see from your responses, its quite a specialist think you are asking for... Of the 3 proposals you have received NONE have ever been awarded any work or have recommendations. I doubt any are in the UK either, although one says they are (common trick for PPH).
Im in Nottingham and would love to discuss this further BUT just to clarify, I asked for the URL so I can check out the site which will ofcourse be needed if I am going to optimise it (if I was to be chosen).
thanks, Anthony
141235
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies