seattle
Level 1
Write the reason you're deleting this FAQ
We were using a click worker firm in Pennsylvania to type in a set of keywords and then hit a clients website and then we would have them do a scavenger hunt to keep them on the site for 70 seconds tripping the Google meter. We would do this 20-40 times a day for a week or so until the sites were ranked well and occasional maintenance.
Problem is our manager passed away about three weeks ago. Were looking for a crowd manager that is familiar with this SEO tactic that can manage campaigns for us and we have LOT of them.
We are a software development firm that does not want to go through the scams. The inquiries on these key words have to be from specific cities usually. Someone we can do nation wide but we have tried several people that claim they can do this and then go and have 100 Indians Google it using VPN's. This does NOT work anymore. The inquiries have to come from actual IP addresses in the states and actual mobile phones.
What is the process for hiring a qualified person here? Give me instructions to use your website.
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| 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='20930' | 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='20930' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='541089' | 1 | SELECT * FROM seoclerks.members WHERE USERID='541089' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='36' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='36' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM categories_faq WHERE CATID='30' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=541089 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=541089 | /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=20930 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=20930
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20930' 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='20930' 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=113675 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=113675
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=113762 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=113762
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=169203 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=169203
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20930' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20930' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='20930' AND status='1' AND (question like '%We click workers typing Key words ranking%' OR question like '%click%' OR question like '%workers%' OR question like '%typing%' OR question like '%words%' OR question like '%ranking%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20930' AND status='1'
AND (question like '%We click workers typing Key words ranking%' OR question like '%click%' OR question like '%workers%' OR question like '%typing%' OR question like '%words%' OR question like '%ranking%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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 seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='147' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='297' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='297' 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=20930%' 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=20930%'
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='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.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 |
idealmike
And I can see how Google has countered it by looking at the IP address and location and the previous search history as well. Looking to see whether or not those people have previously searched for similar items on the same day/week or not. As those that have would be deemed more genuine searchers and visitors over those that haven't. And like most things, they soon "cotton on" to it.
I'm sorry to hear about your manager passing away. My commiseration to you. However, in response to your question "What is the process for hiring a qualified person here?". There are several things you can do.
The first is to create a WTB (Want To Buy). There you can list out exactly what it is you're looking for and how much you'll pay for it. Be sure to put the keywords in the skills field. That way, anyone who has those skills will get a notification about it and then can bid on that WTB.
I wrote a guide a while back that shows How to Bid on People's WTB's and WTT's Be Hired and Get Work as a Freelancer. Which shows how to bid on someone else's WTB but will show you how it all works in case you've never used that part of the site here before.
The other thing you can do is take a look through the list of freelancers and see if there is anyone with the skills required that may be able to do the work for you. It's a bit of a long shot but you'll basically have to message them and ask them if they are up for the work.
Okay well that's basically what you need to know. Let us know if you need any more help or have anymore questions.
Best regards,
Mike. Oh so SERP CTR does work then! I was saying a while back (and have several times) that the CTR plays a massive, MASSIVE role in SERP ranking today. It's not necessarily the sites with the most highest authority backlinks, or social signals or any of that malarkey that ranks a site today (although it obviously does help) but it's the CTR (how many people are clicking on YOUR site in the SERPs) that actually matters. And I've been saying this for a while now. I came across a service that offered it and claimed to rank you site using nothing but an army of people who are paid/employed to search for the keywords you want to rank for and then click on your site in the SERPS. I guess a scavenger hunt would solidify the genuinity of those searchers as would naturally happen when someone searches for something online and then finds a website and clicks all through that sites different posts and pages and the like. And I can see how Google has countered it by looking at the IP address and location and the previous search history as well. Looking to see whether or not those people have previously searched for similar items on the same day/week or not. As those that have would be deemed more genuine searchers and visitors over those that haven't. And like most things, they soon "cotton on" to it. I'm sorry to hear about your manager passing away. My commiseration to you. However, in response to your question "What is the process for hiring a qualified person here?". There are several things you can do. The first is to [url=https://www.seoclerks.com/newwant]create a WTB[/url] (Want To Buy). There you can list out exactly what it is you're looking for and how much you'll pay for it. Be sure to put the keywords in the skills field. That way, anyone who has those skills will get a notification about it and then can bid on that WTB. I wrote a guide a while back that shows [url=https://www.seoclerks.com/faq/10152/How-to-Bid-on-People-s-WTB-s-and-WTT-s-Be-Hired-and-Get-Work-as-a]How to Bid on People's WTB's and WTT's Be Hired and Get Work as a Freelancer[/url]. Which shows how to bid on someone else's WTB but will show you how it all works in case you've never used that part of the site here before. The other thing you can do is take a look through the [url=https://www.seoclerks.com/freelancers]list of freelancers[/url] and see if there is anyone with the skills required that may be able to do the work for you. It's a bit of a long shot but you'll basically have to message them and ask them if they are up for the work. Okay well that's basically what you need to know. Let us know if you need any more help or have anymore questions. Best regards, Mike.
Are you sure you want to delete this post?