HawlettServices
Level 1
Write the reason you're deleting this FAQ
just started at SEO clerks and still not happy with buyers and there worth , orders are coming slow with less income just striking. At low price rates , help me how to boost sales and income .
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='29290' | 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='29290' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='805545' | 1 | SELECT * FROM seoclerks.members WHERE USERID='805545' | /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=805545 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=805545 | /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=29290 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=29290
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29290' 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='29290' 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=188621 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=188621
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=188618 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=188618
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29290' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29290' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29290' AND status='1' AND (question like '%new seller , orders knock gig $ 4 dollars %' OR question like '%seller%' OR question like '%orders%' OR question like '%knock%' OR question like '%dollars%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29290' AND status='1'
AND (question like '%new seller , orders knock gig $ 4 dollars %' OR question like '%seller%' OR question like '%orders%' OR question like '%knock%' OR question like '%dollars%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1220' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1220' 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='3046' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3046' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' 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=29290%' 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=29290%'
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 and everything seems to be set up just right. You're using the right titles, formatting your descriptions well, and using add-ons to get upsells in order to generate additional revenue for yourself and make your customers happy.
A Few Suggestions:
1. Interlink Your Services
This is where you link to your main services, or all of them, at the bottom of each service description. This will allow you to share traffic between your services and make it easier for people to see what you offer. I would suggest putting a quick snippet of information, maybe just the title of the service, and the price for it so people can click through and know what they're about to land on. Many top sellers here are doing this and it works quite well to get additional sales and show people what you offer.
2. Use Testimonials
What you should do is use your customers' reviews of your services and place them within the service description. I like to place mine in the middle of the descriptions to keep people attentive so they continue all the way down the page. Sure, the reviews show up on all of your services, but they're at the very bottom of the page, and people don't always get that far down before losing interest. If you were to put some images/screenshots of your reviews, you could keep people interested, and they will likely purchase more often.
3. Free or Paid Bumps
You can earn free bumps or buy a set of them for a few dollars. These allow you to push your service to the top of the category it's listed in and get some additional traffic. You can earn these bumps by participating in the discussions area, delivering a service on time, and various other actions that you commonly would do as a seller.
4. Paid Promotions
You can spend some money on a featured position, homepage or category, and increase the views on your services. This will get your service placed at the top of the category or placed on the homepage for 31 days and has a great ROI. I like starting out with the category featured promotion because it's cheaper and less competitive. The category feature also puts you in front of people who are actively looking for what you offer. The homepage feature will skyrocket the views on your service and bring in plenty of sales, but it's much more expensive, so I would recommend trying that out after you've accumulated plenty of positive reviews from the category feature promotion bringing in sales.
I hope that info helps you out a bit
- Tommy Hey there! I looked over your services and everything seems to be set up just right. You're using the right titles, formatting your descriptions well, and using add-ons to get upsells in order to generate additional revenue for yourself and make your customers happy. [u]A Few Suggestions:[/u] [size=150][b]1. Interlink Your Services[/b][/size] This is where you link to your main services, or all of them, at the bottom of each service description. This will allow you to share traffic between your services and make it easier for people to see what you offer. I would suggest putting a quick snippet of information, maybe just the title of the service, and the price for it so people can click through and know what they're about to land on. Many top sellers here are doing this and it works quite well to get additional sales and show people what you offer. [size=150][b]2. Use Testimonials[/b][/size] What you should do is use your customers' reviews of your services and place them within the service description. I like to place mine in the middle of the descriptions to keep people attentive so they continue all the way down the page. Sure, the reviews show up on all of your services, but they're at the very bottom of the page, and people don't always get that far down before losing interest. If you were to put some images/screenshots of your reviews, you could keep people interested, and they will likely purchase more often. [size=150][b]3. Free or Paid Bumps[/b][/size] You can earn free bumps or buy a set of them for a few dollars. These allow you to push your service to the top of the category it's listed in and get some additional traffic. You can earn these bumps by participating in the discussions area, delivering a service on time, and various other actions that you commonly would do as a seller. [size=150][b]4. Paid Promotions[/b][/size] You can spend some money on a featured position, homepage or category, and increase the views on your services. This will get your service placed at the top of the category or placed on the homepage for 31 days and has a great ROI. I like starting out with the category featured promotion because it's cheaper and less competitive. The category feature also puts you in front of people who are actively looking for what you offer. The homepage feature will skyrocket the views on your service and bring in plenty of sales, but it's much more expensive, so I would recommend trying that out after you've accumulated plenty of positive reviews from the category feature promotion bringing in sales. I hope that info helps you out a bit :) - Tommy
Are you sure you want to delete this post?