YazidAgung
Level 1
Write the reason you're deleting this FAQ
I already joined with Seoclerks 2 weeks ago, but there is no interested person, please tell me how to be more attractive to clients, so they are interested to my services.
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='29312' | 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='29312' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='858633' | 1 | SELECT * FROM seoclerks.members WHERE USERID='858633' | /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=858633 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=858633 | /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=29312 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=29312
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29312' 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='29312' 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=188725 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=188725
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=188647 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=188647
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29312' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29312' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29312' AND status='1' AND (question like '%How attract attention clients, graphic designers level 1 me%' OR question like '%attract%' OR question like '%attention%' OR question like '%clients,%' OR question like '%graphic%' OR question like '%designers%' OR question like '%level%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29312' AND status='1'
AND (question like '%How attract attention clients, graphic designers level 1 me%' OR question like '%attract%' OR question like '%attention%' OR question like '%clients,%' OR question like '%graphic%' OR question like '%designers%' OR question like '%level%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='4987' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3250' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1895' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1895' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2077' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2537' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2537' 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=29312%' 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=29312%'
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='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 |
TommyCarey
I looked over your services a bit and here is what I think would help you out...
Your thumbnails
All of the thumbnails for your services are the exact same. One thing that a lot of top sellers here do is make custom thumbnails for each of their services in order to keep them as unique as possible from one another. This also helps when someone will go to a sellers profile to look for a specific service, they will find the image of that service, and click through without really having to look for it.
Your Descriptions
All of your descriptions lack images, besides one of them, and that's not a good thing especially if you're selling a graphic design service. You'll want to add in plenty of examples to show people before they buy so they know for sure you can do what they are requesting of you. Go check out some of the top sellers here and you'll notice they have dozens of examples of previous work they've done and they sometimes have links to their own portfolios so someone can check out loads of pages filled with examples. If you have a bunch of examples you can add them to your service descriptions or make a portfolio site and link to them. Just be sure you're not selling on that site because you could get your account suspended here from trying to take sales off of this marketplace and do work with them personally. If you don't want to set up a portfolio site you can use something like Flickr and link to your profile so people can see your previous work.
Your Pricing
You'll want to start as low as you possibly can without killing your motivation. I see your services are priced between $1 and $2 so I would suggest making the $2 services a $1 service since that's not a big difference. The difference a single dollar makes is huge and you could potentially pull in a few more clients by simply charging $1 less lol.
After you've accumulated a decent amount of sales and reviews you can then increase your pricing and the clients will keep coming in. This is what I did with my writing service even though I knew I was going to be at $25+ per 500 words. I priced my original service at $8 or $10 in the beginning and started to get a few sales. After I got ten sales I increased the pricing to $15 per 500 words and then to $20 per 500 words when I hit 35 sales. Right now I'm sitting at $25 per 500 words and I'm still getting sales because I have taken my time to set up my service and write an amazing description that is formatted perfectly, has reviews, has quotes, and has strategically priced add-ons
Show Some Reviews (when you get them)
Like I mentioned above, you'll want to show some reviews within your services so people know you've had sales and people liked what you did for them. This is the most basic form of social proof you can use and it works extremely well. As soon as I added a few positive reviews to my service description I was getting more sales. Now, I'm charging more than a $1 article so my "flood" of sales is more like a stream of select individuals who prefer high quality content over spun content from someone that doesn't speak their native language. If you do this, you too can have a steady stream of customers purchasing from you whenever they need something your services can provide
Are you sure you want to delete this post?