NwWork
Level 3
Write the reason you're deleting this FAQ
Hi I am new here on SEOCLERKS but a professional offline, have recently joined but I have been working on Fiverr for more than one year now. I would like to know the methods and tips you know that you use to rank your service higher and get your buyers. Also how to create more than one service per day?
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='28729' | 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='28729' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='808033' | 1 | SELECT * FROM seoclerks.members WHERE USERID='808033' | /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=808033 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=808033 | /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=28729 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=28729
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28729' 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='28729' 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=187491 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=187491
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=187498 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=187498
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28729' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28729' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28729' AND status='1' AND (question like '%How service day SEOCLERKS?%' OR question like '%service%' OR question like '%SEOCLERKS?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28729' AND status='1'
AND (question like '%How service day SEOCLERKS?%' OR question like '%service%' OR question like '%SEOCLERKS?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='750' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1159' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' 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='2921' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2921' 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=28729%' 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=28729%'
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='808033.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='808033.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
Welcome!
There are plenty of ways to boost your service views and sales. Since you've been on other marketplaces, you likely know a lot of what I'm about to say, but I hope I can touch on something you're not familiar with
Enticing Titles:
This is pretty basic, you need to make your service titles enticing enough to get click-throughs. You can't clickbait people on a marketplace, as you likely know because it won't increase your sales. If you're click baiting you will actually lose sales and people won't trust you in the long run.
If you offer an SEO service then mention it's revamped for 2019 to help the best for right now. If you offer a writing service then shown in your description that you know how to type and structure your writing.
Service Formatting:
This is a big one that doesn't seem like it will actually help but you'll definitely notice an increase in your sales if you just take your time at it. Formatting your service description isn't that difficult, you just need to use some titles, sections, bold characters, italics, some quotes, and even some images to help show people what your service is all about.
If you're just typing up a wall of text you will realize that no one will make it all the way through the content. This is because people get readers fatigue and don't want to continue but if you break it down with formatting, people won't get fatigued because it will feel like they're taking mental breaks while reading.
Featuring Your Service:
One of the easiest ways, combined with the above two mentioned, is to feature your service here in order to get the most views possible. There are two different options, both having their own benefits, in order to feature your services. You can choose from a homepage feature or a category feature.
Homepage feature - You will be placing your desired service on the homepage of this marketplace and it will get the maximum amount of views. This is a tough feature to get because it sells out rather quickly, even with a bid system in place, but it's definitely something you should check out if you want to get the biggest bang for your buck.
Category feature - This placing will put your service at the top of the category it is in. You could be the only service featured or you could be one of 10 shown. It really depends on how saturated your categories are and if it's worth advertising in (it usually is lol).
Pricing is KEY:
When I started my writing service here I had it priced at $10 per 500 words and I would get some orders, but not as many as if I were to price it at $5. I started at $10 to filter out some buyers and target only on the people who wanted high quality content. If you check out my pricing it is now $18 per 500 words.
Why do I charge more now than when I started?
That's simple, it's because I charged $10 for my initial orders and got a bunch of reviews. When I hit 40 orders, a bunch of reviews, and had return customers I started to increase my pricing. I went from $10 to $12, then to $15, and finally, I'm at $18 for 500 words and I get plenty of clients due to all my return buyers and my positive reviews telling others that I do great work
This little trick is pretty simple if you haven't figured it out already, but you're going to charge lower than your competitors in order to gain the reviews and then you will increase your prices when you feel more comfortable. If you have 100 positive reviews, and your service is 2x or 3x the average, you will still get orders because of all the people praising your amazing talents
I hope that helps
- Tommy Carey Hey NwWork, Welcome! There are plenty of ways to boost your service views and sales. Since you've been on other marketplaces, you likely know a lot of what I'm about to say, but I hope I can touch on something you're not familiar with :) [size=150][u][b]Enticing Titles:[/b][/u][/size] This is pretty basic, you need to make your service titles enticing enough to get click-throughs. You can't clickbait people on a marketplace, as you likely know because it won't increase your sales. If you're click baiting you will actually lose sales and people won't trust you in the long run. If you offer an SEO service then mention it's revamped for 2019 to help the best for right now. If you offer a writing service then shown in your description that you know how to type and structure your writing. [size=150][u][b]Service Formatting:[/b][/u][/size] This is a big one that doesn't seem like it will actually help but you'll definitely notice an increase in your sales if you just take your time at it. Formatting your service description isn't that difficult, you just need to use some titles, sections, bold characters, italics, some quotes, and even some images to help show people what your service is all about. If you're just typing up a wall of text you will realize that no one will make it all the way through the content. This is because people get readers fatigue and don't want to continue but if you break it down with formatting, people won't get fatigued because it will feel like they're taking mental breaks while reading. [size=150][u][b]Featuring Your Service:[/b][/u][/size] One of the easiest ways, combined with the above two mentioned, is to feature your service here in order to get the most views possible. There are two different options, both having their own benefits, in order to feature your services. You can choose from a homepage feature or a category feature. [b]Homepage feature -[/b] You will be placing your desired service on the homepage of this marketplace and it will get the maximum amount of views. This is a tough feature to get because it sells out rather quickly, even with a bid system in place, but it's definitely something you should check out if you want to get the biggest bang for your buck. [b]Category feature -[/b] This placing will put your service at the top of the category it is in. You could be the only service featured or you could be one of 10 shown. It really depends on how saturated your categories are and if it's worth advertising in (it usually is lol). [size=150][u][b]Pricing is KEY:[/b][/u][/size] When I started my writing service here I had it priced at $10 per 500 words and I would get some orders, but not as many as if I were to price it at $5. I started at $10 to filter out some buyers and target only on the people who wanted high quality content. If you check out my pricing it is now $18 per 500 words. [b]Why do I charge more now than when I started?[/b] That's simple, it's because I charged $10 for my initial orders and got a bunch of reviews. When I hit 40 orders, a bunch of reviews, and had return customers I started to increase my pricing. I went from $10 to $12, then to $15, and finally, I'm at $18 for 500 words and I get plenty of clients due to all my return buyers and my positive reviews telling others that I do great work :) This little trick is pretty simple if you haven't figured it out already, but you're going to charge lower than your competitors in order to gain the reviews and then you will increase your prices when you feel more comfortable. If you have 100 positive reviews, and your service is 2x or 3x the average, you will still get orders because of all the people praising your amazing talents :) I hope that helps :) - Tommy Carey
Are you sure you want to delete this post?