Write the reason you're deleting this FAQ
Finding local SEO or Web Design clients isn't always an easy thing to do. You can cold call hundreds of businesses each day and hopefully get a few new clients, but the amount of time that it would take to do that would cut into your time that you would need to do the actual work. So I've come up with a few ways to find some new SEO or Web Design clients that are local.
We all know that businesses are more willing to sign up with a local company than someone overseas or a company that is a few hundred miles away. I've had plenty of clients want to have a sit down with me, but it's just not reasonable because they are a few states away. If they were to sign a 1 year contract and start paying me thousands a month I would have absolutely no problem flying out to them to talk, but that's not how it normally happens. It's usually tire kickers that want you to fly out and waste your time.
Local clients are a goldmine, and you should always treat them like kings or queens because they will spread the word about your services. Now I'm not telling you to give them everything for free or even a steep discount. But you should always over deliver your services and make sure they know you did! If you go above and beyond the call of SEO or Web Design, you'll have a client for a long time 
Now then, how exactly do you target local clients and get them to sign up?
Disclaimer: If you're not willing to invest a good amount of time into this to try it out, then quite reading here.
Ok, so let's start...
The Manual Way
1) Go to YellowPages.com and instead of searching for a specific business in the search bar, add a keywords like "restaurant" and enter the town you want to target.
2) Go through the first page and look for any businesses that aren't a franchise. This is mainly because the people who own the franchise already pay a marketing fee to their corporate office and they can't sign a contract with you. Each page will have 30 results and a lot of them will have their websites listed. Right click on "Website" in the business's listing and click "Open in new tab".
3) Go through the first 30 and open as many as you can then you'll need to go through each of these and fill out their "Contact Us" forms. You'll write up a pretty basic and non specific post to send them because if you did a unique one for each website you'd be doing this for 10 hours a day lol. Put your "contact us" message into a .txt file so you can just copy/paste it into all of the "contact us" forms. A pretty good message I like to use is something along the lines of....
Hey there,
I was browsing local businesses and came across your website. I'm looking to build my company's portfolio and I give steep discounts to local businesses just like yours. And when I say "steep discounts" I mean it's around 75% off.
I looked through your website and there are a few design features that definitely need to be updated to 2017 standards and we can do that for you. We also offer extremely affordable SEO (search engine optimization) campaigns to help bring people into your business if that's something you'd also be interested in.
If you want to go through what can be done about your website, please give me a call at (insert number here). You can also contact me via email at [email protected]
Thanks
(Insert your signature here)

Something like this is pretty easy to do, I've had it built for $40 and that was for a database that I was paying $80 a month to access. I had to have the scraper log into my account, scrape loads of details based on my criteria and then send it to an excel or .txt file.
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='21798' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='21798' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='19821' | 1 | SELECT * FROM seoclerks.members WHERE USERID='19821' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=19821 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=19821 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=21798 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=21798
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='21798' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='21798' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=117632 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=117632
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=142680 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=142680
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=169347 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=169347
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='21798' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='21798' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='21798' AND status='1' AND (question like '%Finding local SEO Web Design clients.%' OR question like '%Finding%' OR question like '%local%' OR question like '%Design%' OR question like '%clients.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='21798' AND status='1'
AND (question like '%Finding local SEO Web Design clients.%' OR question like '%Finding%' OR question like '%local%' OR question like '%Design%' OR question like '%clients.%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='498' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='498' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2875' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2875' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='14567' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='14567' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=21798%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=21798%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='301993.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='301993.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='585810.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
centurion
Have a wonderful day.
Thanks for giving some important idea. There are some more ideas we can use. Like I am from Bangladesh. For getting local clients from Bangladesh I shall follow this steps.
Firstly I shall find out all classified website and will publish my service news to classified website.
Secondly I shall do local group and pages of social media community or groups and will publish my service news to social media with hashtag.
Thirdly I shall do social media bookmark or backlink where I will list all services by place name.
Fourthly I shall find out service related bl Hello Have a wonderful day. Thanks for giving some important idea. There are some more ideas we can use. Like I am from Bangladesh. For getting local clients from Bangladesh I shall follow this steps. Firstly I shall find out all classified website and will publish my service news to classified website. Secondly I shall do local group and pages of social media community or groups and will publish my service news to social media with hashtag. Thirdly I shall do social media bookmark or backlink where I will list all services by place name. Fourthly I shall find out service related bl
Are you sure you want to delete this post?