With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
Attached text file is designed to be imported into a spreadsheet. The spreadsheet has 2522 rows of keywords. Approximately half have a location associated with them (Utah, New York City, San Francisco, etc) I want all the unique locations separated from the non-location-specific keywords and put together.
Here is how to do it. Column A (Ad Group) contain numerous locations (Utah, Montana, etc). Separate those out into separate groups (at the bottom of the spreadsheet). That is just cut and paste.
Then in Column B look at each keyword. Embedded in many of them (particularly the ones in the bottom half of the rows) is a location code. These are US-based searches and the people are using 2-letter designations for the US states or cities.(MD= Maryland, MT=Montana, SF=San Francisco) or 3-letter designations for cities (NYC=New York City) or in some cases the entire name of the state (Hawaii, for instance). Separate out each of those into a unique group at the bottom of the spreadsheet....
Sign in or Register to see more