h5ldasanayake
Level 1
Write the reason you're deleting this FAQ
i am new seller on seoclerks.com. how can i promote my service and get more order on my graphic design service. I have successfully completed several orders on this month. My goal is to make $100 a month. Is this possible? Thank You.
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='29530' | 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='29530' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='861131' | 1 | SELECT * FROM seoclerks.members WHERE USERID='861131' | /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=861131 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=861131 | /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=29530 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=29530
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29530' 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='29530' 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=189027 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=189027
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=189031 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=189031
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29530' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29530' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29530' AND status='1' AND (question like '%How i promote service order graphic design service.%' OR question like '%promote%' OR question like '%service%' OR question like '%order%' OR question like '%graphic%' OR question like '%design%' OR question like '%service.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29530' AND status='1'
AND (question like '%How i promote service order graphic design service.%' OR question like '%promote%' OR question like '%service%' OR question like '%order%' OR question like '%graphic%' OR question like '%design%' OR question like '%service.%')
-- 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='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1303' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1303' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' 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=29530%' 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=29530%'
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='861131.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='861131.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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
TommyCarey
I see you've had some sale already, which is awesome, and I definitely think you could make more than $100 per month here
There are some designers making $1,000+ part-time here from their recurring customers.
Your services look awesome and I'm sure you'll build your profits as time goes on, so be sure to keep the quality of your work top-notch and your clients will be happy.
As for generating more sales here, there are a few ways to do that.
Category features
You can advertise your services through a category feature and get seen much more than if you were to get found through searches. If you purchase a category featured spot you will see your service stick to the top of its category for 31 days and it will get a good amount of traffic. Since your services are set up well and you have some sales already, I don't see why you wouldn't get a great ROI (return on investment).
I've used the category feature for my own services plenty of times and have never been disappointed. I simply pay the one-time fee and my service gets stuck to the top of its category. I don't have to worry about bumping my service or getting lucky by being found through a search. I sit back, wait for messages to come in, and I work on any orders that are waiting for me when I log on each day
Homepage Feature
This is exactly the same as the category feature except you're listed on the homepage and have a much better chance of pulling in loads of orders. The only downside to this is it's much more expensive, around $1,500 a month, and that's out of the price range for most freelancers who are trying to build up their careers.
Free and Paid Bumps
I love these because you can get them for free. Bumps are what you can use to push your service to the top of its category but your listing will gradually fall off the top spots as other freelancers bump their services. This works like a paid feature spot, except your service doesn't stick to the top, and you can only do this every 12 hours. If you were to purchase enough bumps to push your service to the top of the page every 12 hours for an entire month, it would cost $60, or you could buy the category featured spot for $50 and never worry about your listing dropping off of the top for 31 days
Social Media
You can also advertise your own affiliate link, that is aimed at your services, in order to get more sales and boost your account level. You can join Facebook groups and share the affiliate URL to your service whenever someone is looking for design work, logo work, image editing, etc. This way you're sending them to your services and still getting credit for a purchase if they leave your page and order from someone else
I hope that helps you out a bit
Thanks,
Tommy Carey
https://www.seoclerks.com/user/TommyCarey Hey there, h5ldasanayake I see you've had some sale already, which is awesome, and I definitely think you could make more than $100 per month here :) There are some designers making $1,000+ part-time here from their recurring customers. Your services look awesome and I'm sure you'll build your profits as time goes on, so be sure to keep the quality of your work top-notch and your clients will be happy. As for generating more sales here, there are a few ways to do that. [size=150][u][b]Category features[/b][/u][/size] You can advertise your services through a category feature and get seen much more than if you were to get found through searches. If you purchase a category featured spot you will see your service stick to the top of its category for 31 days and it will get a good amount of traffic. Since your services are set up well and you have some sales already, I don't see why you wouldn't get a great ROI (return on investment). I've used the category feature for my own services plenty of times and have never been disappointed. I simply pay the one-time fee and my service gets stuck to the top of its category. I don't have to worry about bumping my service or getting lucky by being found through a search. I sit back, wait for messages to come in, and I work on any orders that are waiting for me when I log on each day :) [size=150][u][b]Homepage Feature[/b][/u][/size] This is exactly the same as the category feature except you're listed on the homepage and have a much better chance of pulling in loads of orders. The only downside to this is it's much more expensive, around $1,500 a month, and that's out of the price range for most freelancers who are trying to build up their careers. [u][size=150][b]Free and Paid Bumps[/b][/size][/u] I love these because you can get them for free. Bumps are what you can use to push your service to the top of its category but your listing will gradually fall off the top spots as other freelancers bump their services. This works like a paid feature spot, except your service doesn't stick to the top, and you can only do this every 12 hours. If you were to purchase enough bumps to push your service to the top of the page every 12 hours for an entire month, it would cost $60, or you could buy the category featured spot for $50 and never worry about your listing dropping off of the top for 31 days :) [u][size=150][b]Social Media[/b][/size][/u] You can also advertise your own affiliate link, that is aimed at your services, in order to get more sales and boost your account level. You can join Facebook groups and share the affiliate URL to your service whenever someone is looking for design work, logo work, image editing, etc. This way you're sending them to your services and still getting credit for a purchase if they leave your page and order from someone else :) You'll create an affiliate income stream, boost your account level over time, and generate more sales for yourself :D It's a win/win/win lol. I hope that helps you out a bit :) Thanks, Tommy Carey [url=https://www.seoclerks.com/user/TommyCarey]https://www.seoclerks.com/user/TommyCarey[/url]
Are you sure you want to delete this post?