I would like to hire someone to verify that the contact information for the professionals (mostly attorneys) listed on the attached Excel spreadsheet I have is accurate. I’ll also being using this assignment as a small test for "a lot" more similar work depending on how this project goes.
The attached spreadsheet (small sampling) also has columns for you to mark with an “X” to quickly provide me with the extra amount information I’ll need on all the listed professionals.
1. For each person listed on the spreadsheet, I need you to verify the person is still at the firm by finding their name on their firm’s website and “visually” verifying. The easiest way to find the firm’s website s by Googling.
a. If you don’t see the person’s name on the firm’s website, still verify the “mailing address” and “website address” is correct (because I’ll most likely add a new name to that spot later from that firm), then please just add the “X” to the appropriated column indicating that they were not seen on the firm’s website.
2. Verify their mailing address is correct
a. Chances are the most accurate mailing address is the one found on their firm’s website. Don’t assume Yelp, [login to view URL], Google+, or the resources mentioned below have a more accurate mailing address because often, attorneys forget to update those sites but, they usually remember to update their firm’s website.
b. Also, sometimes a law firm has multiple office addresses and sometimes in different cities listed on their website. When you see this, try to first verify that the address next to their name (on the Excel spreadsheet) still exists for the same city and update if necessary before trying to replace it with a completely new address in a new city where they are currently work from the majority of their time.
3. Be sure to update the firm name if it has changed. Law firm names often change as attorneys get promoted or leave the firm.
4. Add the law firm’s verified website and email address next to their names or indicate they could not be found and/or verified by putting an “X” in the appropriate column. You’ll notice some of the names in the attached spreadsheet already have email addresses next to them. You still need to verify those. If you can’t, just leave them there (don’t erase them) and then be sure to mark the appropriate column to indicate that you weren’t able to verify the mail address.
5. As you’re visiting the firm’s website to verify a contact. Take a quick guess and indicate in the appropriate column whether you feel that firm has More or Less than 20 Attorneys (or in some cases mediators, or other professionals) working there. Just take a quick guess.
6. You notice lines 4-9 in the Excel spreadsheet are contacts I’ve verified myself to show you how I would like the rest of the spreadsheet to be completed. You’ll notice that once I’ve verified a contact and finished with it, I BOLD the fonts for that line and move on to the next. Please do the same to stay accurate. When you’re done, they should all be BOLD.
In addition to some of your methods that you probably already use to quickly verify contact information for this kind of work, below are two additional resources that you will find helpful by searching under the attorneys’ names. Most of the time, the attorneys on this Excel spreadsheet, will belong to one or both organizations.
The State Bar of California - [login to view URL]
San Diego County Bar Association - [login to view URL]
Let me know if you have any questions. Also, "automated responses" to this project that obviously indicate that you didn't read what we need to have done or viewed the attached Excel spreadsheet sample will be ignored.