acumen
Level 1
Write the reason you're deleting this FAQ
Is there a way by which I start getting at least a couple of orders every day, if yes, what should I do to achieve this...
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='29282' | 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='29282' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='566495' | 1 | SELECT * FROM seoclerks.members WHERE USERID='566495' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=566495 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=566495 | /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=29282 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=29282
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29282' 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='29282' 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=188614 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=188614
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=188617 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=188617
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29282' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29282' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29282' AND status='1' AND (question like '%Getting Orders Everyday Seoclerk%' OR question like '%Getting%' OR question like '%Orders%' OR question like '%Everyday%' OR question like '%Seoclerk%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29282' AND status='1'
AND (question like '%Getting Orders Everyday Seoclerk%' OR question like '%Getting%' OR question like '%Orders%' OR question like '%Everyday%' OR question like '%Seoclerk%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='1643' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1643' 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 seoclerks.members WHERE USERID='498' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='498' 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=29282%' 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=29282%'
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='566495.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='566495.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 see you're already level 2, which will help you get more sales from day to day, but as you likely know already it is an uphill battle to get a full stream of sales to fill up your workweek.
You seem to be on the right track, but here are some suggestions that I know will help you out.
A list of what you're already doing, which will help:
1. Formatting your service descriptions well
You'd be amazed at how many people aren't doing this, but I looked over roughly 10 of your services and it looks like you've taken your time on them in order to keep people attention. So, good job on that
2. Interlinking your services
From the services I look through, I saw that most of them were interlinked, but not all of them. Be sure to pick your top 5 services and link them at the bottom of all your service descriptions. Give quick snippets of what they are and how much they cost to entice people to click through.
What you could be doing to help boost your sales:
1. Use testimonials as social proof
This will almost always help boost your sales because you're showing potential buyers how many people already purchased and loved the results. You can use something like Gyazo or another screen capture service, or you can simply press CTRL+PRT SCR and then paste that into MS Paint and cut out the testimonials. You'll then upload or embed the tutorial images into your service description and show people right away that others have purchased and had a good experience. Sure, there are plenty of testimonials on your services, but they're below the service descriptions, and that means you might be losing sales when people aren't interested. Show the testimonials in the middle of your descriptions and it will keep people on board until they get all the way down the page
2. Expand out of the LinkBuilding and Web2.0 categories
It looks like all of your services are listed within two specific categories. This isn't necessarily a bad thing, but it's also not a good thing, and that's because you're limiting yourself to the potential traffic you could be getting to your services. If you were to spread your services across 4-5 categories, then interlink the top sellers, you'd pull in more traffic to each service than you already are. This will definitely help boost your sales
3. Advertise your services
This is a paid option, but it tends to pay for itself within the first week if you've done everything right, and that's why I recommend trying it out. All you'd be doing is featuring your main service, the one that has the best sales, and get in stuck at the top of your specific category. I would suggest choosing a service you have listed in the "Link Building" category since that likely gets more traffic than the "Web 2.0" category. If you have your services interlinked, you have them formatted just right, and you have social proof in the form of reviews showing on your services, then I don't see why this wouldn't bring in daily sales
You can always try to get a homepage feature, but those are much more expensive, so I suggest testing out the category feature first to see how things go. If you start to notice a spike in sales because of the featured position then a homepage feature may not be a bad thing to put a bid on in the future
Are you sure you want to delete this post?