| 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='29125' | 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='29125'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='850624' | 1 | SELECT * FROM seoclerks.members WHERE USERID='850624'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM categories_faq WHERE CATID='30' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
|
| SELECT * FROM seoclerks.members WHERE USERID=850624 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=850624
| /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=29125 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=29125
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29125' 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='29125' 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=188348 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=188348
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29125' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29125'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='29125' AND status='1' AND (question like '%How job%' ) -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29125' AND status='1'
AND (question like '%How job%' )
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='537044' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='537044' 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=29125%' 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=29125%'
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 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()
|
TommyCarey
Thanks for joining the marketplace and offering your services to people that need them
There are a few things that can help you increase your sales here, which are;
1. Offer multiple services
I see you're offering an SEO/backlink service, which is great, and I would suggest you branch out a bit and target SEO services, specific backlink services like web2.0s and profile backlinks, and various other types of backlinking services you can provide.
By doing this you will be able to get more eyes on your services and possibly pull in more sales.
2. Interlink all of your services
I know you only have one service for now, but when you add more, you should link to them all within the bottom of your service description. Something like "Looking for something else? Here are my other services!" and then have short titles explaining the services as well as the price for each. You don't have to link to all of your services, maybe just your top sellers or highest profitable ones, which will become even better since they're getting more traffic.
By doing this you can funnel traffic to your services and keep people browsing things you offer instead of losing them to someone else.
3. Bump your services daily
You can bump your services for free here as long as you do certain things. You can complete an order to get a free bump, participate within the community discussions area for a free bump, and various other things. A free bump will get your service(s) listed at the top of its category so it can gain more views and likely get an extra sale or two. If you bump strategically, you can get more views from specific countries, and that means bigger fish will potentially purchase from you.
4. Advertise your services
You can purchase a featured spot within your category or on the homepage. The homepage feature tends to be pretty expensive and only the top sellers get them, but the category feature is less competitive and cheaper as well. Go for the category feature and get your service stuck to the top of your category for 31 days. You will likely get some sales this way, enough to cover the cost of the featured payment and more, which is why a lot of people love it.
5. Rewrite your service description
I looked over your service description and it only had a couple of sentences. Your competitors have long descriptions with images, reviews, testimonials, samples, etc. and they are getting more sales because they took their time writing up their service descriptions.
Take your time with this and continuously tweak it so the description looks better day by day. You'll get more sales if your descriptions look great, like a piece of art, and that's because it will be easier to engage with. Think about it, would you purchase from someone that said "My service is great!" or would you purchase from someone that said 700+ words about their service and had images as well as stats to prove their work? You'd buy from the person that was a sure thing and not take a chance on the service which was lacking a description.
People will look at a service and judge it based on how it looks, not always what it says, which is why you need to think about rewriting what you currently have.
6. Increase your user level
Not many people will take a chance purchasing from a level 1 account because they aren't sure how serious you are about the whole process. I know, it sucks, but that's how things work
***Side Note***
Page Rank (PR) isn't really a thing anymore so you might want to edit that out of your service description. People who study up on what they want to purchase will know that DA is the new hot thing to search for since PR was discontinued a while back.
I hope that helps
- Tommy Hey there, Anasanchu Thanks for joining the marketplace and offering your services to people that need them :) There are a few things that can help you increase your sales here, which are; [b]1. Offer multiple services[/b] I see you're offering an SEO/backlink service, which is great, and I would suggest you branch out a bit and target SEO services, specific backlink services like web2.0s and profile backlinks, and various other types of backlinking services you can provide. By doing this you will be able to get more eyes on your services and possibly pull in more sales. [b]2. Interlink all of your services[/b] I know you only have one service for now, but when you add more, you should link to them all within the bottom of your service description. Something like "Looking for something else? Here are my other services!" and then have short titles explaining the services as well as the price for each. You don't have to link to all of your services, maybe just your top sellers or highest profitable ones, which will become even better since they're getting more traffic. By doing this you can funnel traffic to your services and keep people browsing things you offer instead of losing them to someone else. [b]3. Bump your services daily[/b] You can bump your services for free here as long as you do certain things. You can complete an order to get a free bump, participate within the community discussions area for a free bump, and various other things. A free bump will get your service(s) listed at the top of its category so it can gain more views and likely get an extra sale or two. If you bump strategically, you can get more views from specific countries, and that means bigger fish will potentially purchase from you. [b]4. Advertise your services[/b] You can purchase a featured spot within your category or on the homepage. The homepage feature tends to be pretty expensive and only the top sellers get them, but the category feature is less competitive and cheaper as well. Go for the category feature and get your service stuck to the top of your category for 31 days. You will likely get some sales this way, enough to cover the cost of the featured payment and more, which is why a lot of people love it. [b]5. Rewrite your service description[/b] I looked over your service description and it only had a couple of sentences. Your competitors have long descriptions with images, reviews, testimonials, samples, etc. and they are getting more sales because they took their time writing up their service descriptions. Take your time with this and continuously tweak it so the description looks better day by day. You'll get more sales if your descriptions look great, like a piece of art, and that's because it will be easier to engage with. Think about it, would you purchase from someone that said "My service is great!" or would you purchase from someone that said 700+ words about their service and had images as well as stats to prove their work? You'd buy from the person that was a sure thing and not take a chance on the service which was lacking a description. People will look at a service and judge it based on how it looks, not always what it says, which is why you need to think about rewriting what you currently have. [b]6. Increase your user level[/b] Not many people will take a chance purchasing from a level 1 account because they aren't sure how serious you are about the whole process. I know, it sucks, but that's how things work :( [u][b]***Side Note*** [/b][/u] Page Rank (PR) isn't really a thing anymore so you might want to edit that out of your service description. People who study up on what they want to purchase will know that DA is the new hot thing to search for since PR was discontinued a while back. I hope that helps :) - Tommy
Are you sure you want to delete this post?