pixcelplus
Level 1
Write the reason you're deleting this FAQ
started at SEO clerks and still not happy with buyers and there worth , orders are not coming. At low price rates , help me how to boost sales and income .
Thanks
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?
This information is So Useful :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Thank you very much, You too :)
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='29322' | 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='29322' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='778833' | 1 | SELECT * FROM seoclerks.members WHERE USERID='778833' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=778833 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=778833 | /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=29322 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=29322
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29322' 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='29322' 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=188717 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=188717
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=188727 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=188727
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=188906 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=188906
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=188649 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=188649
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=188670 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=188670
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=188671 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=188671
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=188672 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=188672
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=188673 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=188673
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29322' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29322' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29322' AND status='1' AND (question like '%New seller , orders Order 1 Month !! Give %' OR question like '%seller%' OR question like '%orders%' OR question like '%Order%' OR question like '%Month%' OR question like '%Give%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29322' AND status='1'
AND (question like '%New seller , orders Order 1 Month !! Give %' OR question like '%seller%' OR question like '%orders%' OR question like '%Order%' OR question like '%Month%' OR question like '%Give%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='7' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7' 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='3545' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3545' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2513' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2513' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2800' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2800' 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=29322%' 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=29322%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='804489.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='804489.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='778833.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='778833.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='844576.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='844576.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 |
TommyCarey
Starting out in any marketplace isn't easy, especially one that is flooded with services, and that means you'll need to stand out from the crowd a bit more in order to get noticed and pull in some sales. Below are a few things you can do right away to bring in some additional traffic to your service(s).
1. Advertise your service(s)
When you go to the page where you can manage your services you will see links like "Feature" and "Category Feature" which are nice ways of saying "This is how you advertise your service!" lol. When you click on the "Feature" link it will take you to a page where you can bid on a placement that will put you on the homepage. This is pretty expensive and might be out of reach for you, but it's definitely something to think about later on when you build up your services a bit more. The "Category Feature" is what I tend to suggest to a lot of sellers here because it has a great ROI due to the people finding your services are already looking for something related to them. If you were to be on the homepage you would get a lot of views, but not everyone would be looking for what you're selling, and that means you'll have inflated numbers.
I would suggest starting out with the category featured advertising spot and work your way up to the homepage featured spot if possible. Both the homepage featured spot and the category featured spot are for 31 days and you don't have to worry about boosting.
2. Boost your services
You can boost your service every 12 hours and you can gain free boosts by participating in the community discussion area, delivering a service on time, and various other simple acts around the marketplace. Your boosted post will go up to the top of it's category and gradually fall back down the listings until you decide to boost it again. The more popular the category you're in, the quicker your service will drop back down, so be sure your services are listed in a category that gets traffic but isn't the host spots of the marketplace.
3. Have a variety of services
You currently have 2 services up and running, but they're not services that many people will be looking to purchase, and that could be why your orders aren't coming in quickly. Not many people need data entry work because everything is automated nowadays and not many people need a basic image. I would suggest looking into how to do some basic SEO services, basic design services, some social media services, etc. and elaborate on what you can do for an affordable price.
The more information you have for your potential customers the more likely you'll get a sale. Hey Pixcelplus, Starting out in any marketplace isn't easy, especially one that is flooded with services, and that means you'll need to stand out from the crowd a bit more in order to get noticed and pull in some sales. Below are a few things you can do right away to bring in some additional traffic to your service(s). 1. Advertise your service(s) When you go to the page where you can manage your services you will see links like "Feature" and "Category Feature" which are nice ways of saying "This is how you advertise your service!" lol. When you click on the "Feature" link it will take you to a page where you can bid on a placement that will put you on the homepage. This is pretty expensive and might be out of reach for you, but it's definitely something to think about later on when you build up your services a bit more. The "Category Feature" is what I tend to suggest to a lot of sellers here because it has a great ROI due to the people finding your services are already looking for something related to them. If you were to be on the homepage you would get a lot of views, but not everyone would be looking for what you're selling, and that means you'll have inflated numbers. I would suggest starting out with the category featured advertising spot and work your way up to the homepage featured spot if possible. Both the homepage featured spot and the category featured spot are for 31 days and you don't have to worry about boosting. 2. Boost your services You can boost your service every 12 hours and you can gain free boosts by participating in the community discussion area, delivering a service on time, and various other simple acts around the marketplace. Your boosted post will go up to the top of it's category and gradually fall back down the listings until you decide to boost it again. The more popular the category you're in, the quicker your service will drop back down, so be sure your services are listed in a category that gets traffic but isn't the host spots of the marketplace. 3. Have a variety of services You currently have 2 services up and running, but they're not services that many people will be looking to purchase, and that could be why your orders aren't coming in quickly. Not many people need data entry work because everything is automated nowadays and not many people need a basic image. I would suggest looking into how to do some basic SEO services, basic design services, some social media services, etc. and elaborate on what you can do for an affordable price. The more information you have for your potential customers the more likely you'll get a sale.
Are you sure you want to delete this post?