NesimSEO
Level 3
Write the reason you're deleting this FAQ
hey there fellow seoclerks peps! I hope you all are having a great day/night and that your striving to your goals daily more and more.
Now long story short. I wanted to start this discussion and share my story. Just a brief introduction but hey I am sure you can make the most out of it 
Anyways,
So my story begins around DEC 2014 when I stumbled upon the seoclerks website.
I was only buying backlinks for my past businesses I had. But I was doing even that wrongly. Until I finally found what the heck is the deal. MY SERP increases with these seoclerks backlinks but suddenly all falls down without ever reaching your primary goal. And so I started programming. LIKE A LOT! I was even working for MONDO IT for a whole YEAR!
Anyhow,
I was building my seoclerks profile for years since I bought so many backlinks your head would spin. I am constantly buying something. Now around end of the February 2020. I started Selling On Seoclerks.
And so On my 1st day of posting my gig I have received a sale. BUT! I've learned that the product that I am selling is not good enough (For me I Mean) and so I had to change something. I was throwing my head against the wall for the past years but THANK GOD I HAVE FINALLY FIGURED IT OUT!
My sales really started improving A LOT! I am buying promotions where ever I can. I MEAN IT! I was even trying facebook ads already. But since maybe people order 7-10 or even 15 days after they have clicked on my ad, my fb ad manager doesnt track a sale. Therefore I had to stop doing the fb ads until I find better and more profitable way of promoting SEOCLERKS Services.
I am also currently building my own website to drive organic traffic from google to my seoclerks account. here is the website: NesimSEOBacklinks
Of course it is only in development mode. Many things are not done. I literally started building it couple of days ago. Anyways.
In march 2020 I started getting the hang of getting sales. Keeping in mind that I was charging $49 Per GIG THEN!
YES! $49 And I was still getting some Amazing sales. Then I've found out that people are more likely to click and buy cheaper things. And they buy cheaper things much more often. Because think about it. Would you rather spend $100 On just a single gig or let's say $30 on 3x gigs and spend $10 on a 4th one? That way your getting bigger chance of actually receiving serious value from your orders.
Now the game changed for me when I decreased the price from $49 to only $18. People started buying like crazy. The only problem I see is that out of all people that order from you (let's say 10 so we can calculate easier) only 2 out of 10 of the people that buy your service would CONSIDER Reviewing your service! SO you must keep that in mind. Especially if your delivering SEO gigs like me. Because they need to wait for some great serp improvements even after the order is completed and so therefore most people are scared and they WAIT,WAIT and WAIT to get back to you IF YOU have really helped them out.
NOW!
I am only trying to send the best possible value of course, sometimes you just can't help a particular website. Because it has been heavily spammed before. And so it would take so much time before that website would be able to see some results...
Anyways. My only advice to you IS KEEP GRINDING! I have seen how many people constantly ASK how to promote their gigs. And so here is the opportunity. Make an fb page, twitter profile, instagram account + website for seoclerks. I personally think that once all of your resources start getting some real traction (ranks good) then google would send you ton of the organic traffic to your offers MAXIMIZING Your revenue to the roof!
Feel free to ask anything literally!
I would love to help IF I CAN!
Are you sure you want to delete this post?
Are you sure you want to delete this post?
You are very welcome my friend. If it deserves a like then HIT IT :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
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='30540' | 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='30540' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='283037' | 1 | SELECT * FROM seoclerks.members WHERE USERID='283037' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='42' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=283037 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=283037 | /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=30540 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=30540
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='30540' 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='30540' 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=191399 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=191399
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=191402 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=191402
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=191408 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=191408
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=191415 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=191415
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=191454 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=191454
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=191390 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=191390
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=191400 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=191400
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=191393 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=191393
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=191401 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=191401
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='30540' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='30540' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='30540' AND status='1' AND (question like '%How I Started SEOCLERKS! I Valuable READING!%' OR question like '%Started%' OR question like '%SEOCLERKS!%' OR question like '%Valuable%' OR question like '%READING!%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='30540' AND status='1'
AND (question like '%How I Started SEOCLERKS! I Valuable READING!%' OR question like '%Started%' OR question like '%SEOCLERKS!%' OR question like '%Valuable%' OR question like '%READING!%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='272' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='27286' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='27286' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='21438' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='21438' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='19824' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19824' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' 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=30540%' 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=30540%'
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='922019.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='922019.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='283037.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='283037.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='938015.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='938015.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='805244.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='805244.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='471524.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='471524.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 |
SEOmaster$
Are you sure you want to delete this post?