AmanPrasad
Level 3
Write the reason you're deleting this FAQ
Can anybody suggest to me , what can I improve in my services to get more orders and beat the competition?
Thank you
My profile:https://www.seoclerk.com/user/AmanPrasad
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='29358' | 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='29358' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='804489' | 1 | SELECT * FROM seoclerks.members WHERE USERID='804489' | /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=804489 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=804489 | /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=29358 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=29358
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29358' 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='29358' 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=188746 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=188746
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=188749 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=188749
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29358' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29358' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29358' AND status='1' AND (question like '%Can suggested i improve?%' OR question like '%suggested%' OR question like '%improve?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29358' AND status='1'
AND (question like '%Can suggested i improve?%' OR question like '%suggested%' OR question like '%improve?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='12847' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12847' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4169' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4169' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='12794' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12794' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17130' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17130' 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=29358%' 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=29358%'
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 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
I looked over your services and they seem to be written pretty well compared to some sellers here that complain about not getting any sales. They'll usually have 1-2 sentences briefly describing what they can offer along with a "Buy From Me Now!" statement at the end which will put off most of their potential buyers lol.
I did notice that you have a good amount of design services but you don't have many images embedded within the service descriptions. I know you can add them as a part of the thumbnail in the upper right of your service description, but not many people click on those. Instead, add them into your service descriptions so people don't have to click the thumbnails or click through to your portfolio site. Doing this will keep them on page, keep them reading, and encourage them to purchase from you because it proves you know what you're doing.
Another thing you can try is bumping your services on a regular basis. You seem to have a decent amount of services, which is good and bad when it comes to bumping, and that's because you could run out of bumps quicker but you can get more services on top of the category they're in throughout more of the day. You can buy bumps for pretty cheap or you can gain free bumps by participating in the community discussion, delivering a service on time, and various other tasks. I tend to participate in the discussion are more than most people and I've racked up hundreds of free bumps over time, but I only have one service to bump so I can only use a maximum of 2 free bumps a day since they last for 12 hours. This doesn't mean you will bump your service to the top of its category for 12 hours, it means you can bump it to the top and it will stay there as long as other people don't bump their services and push you down the page.
To avoid getting bumped down the category page, you can opt for the category featured position that will bring in a flow of sales since your service will be stuck at the top of your category for 31 days. The more competitive your category, the more people will pay for this position, so you may not see a crazy ROI here. I love the category featured position because my writing services stand out and I get a decent amount of attention from anyone looking to make a purchase from a quality content writer
You can also opt for the homepage feature but it's a bit more expensive sitting at $1,500 per month on average. This used to be a flat fee of $500 per month but it was recently changed to a bidding system and now the highest bidder gets one of the 20 homepage spots available.
I see you're now level 2, which is awesome, and that means people wills tart to trust you more
Are you sure you want to delete this post?